Oracle EBS:PO入库(收货)价格不随Blanket更改
作者:admin 日期:2010-05-10
这个可真是差点出了大麻烦啊,呵呵。
事故描述:
1月下交期,2月调价,1月所下的PO没有交完货的情况下，在原PO上作更改PO交期。结果没想到的是：系统在入库时点会PO的价格重新获取差刷新一次，导致系统上的PO单位价与传真给供应商的PO上的单价有差异，财务对帐的异也有些产生。
解决方案：
问题 : POXPOEPO: Able to Update Unit Price After PO Has Been Received and Invoiced
https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&doctype=PROBLEM&id=397599.1
原因：Profile "PO: Allow Retroactive Pricing of POs" was not set to 'Never'.
设定：
Bug 5560982: ABLE TO CHANGE UNIT PRICE AFTER RECEVING PO
--------------------------------------------------------------------------------
Bug 属性
--------------------------------------------------------------------------------
类型 B - Defect 已在产品版本中修复 -
严重性 2 - Severe Loss of Service 产品版本 11.5.10.2
状态 92 - Closed, Not a Bug 平台 212 - IBM AIX on POWER Systems (64-bit)
创建时间 22-Sep-2006 平台版本 5L
更新时间 31-Oct-2006 基本 Bug -
数据库版本 9.2.0.7.0
影响平台 Generic
产品来源 oracle
相反：要修改价格的话
此方案转自:来源:http://dgstonehuang.blog.163.com/blog/static/4693088820091024103334393/
设置如下：
1.在收货参数里设置“Retroactive Price Adjustment Account”，赋予调整PO价格的会计分录；
2.修改PO里Profile参数：PO: Allow Retroactive Pricing of POS，有3个选项，Never-->不允许修改、OPEN RELEASES-->还没收货（部分收+全收）仅核准状态、ALL RELEASES-->表示收货后可以修改价格。
要值得注意的是：
1。这个成PAC成本有所影响,在标准成本制下可以使用。
2.要注意产生的会计科目 Retroactive Price Adjustment Account
https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&doctype=PROBLEM&id=339536.1
https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&doctype=PROBLEM&id=273918.1
---补丁
PO Price Changes When Need-By Date Is Changed [ID 379511.1]
--------------------------------------------------------------------------------
修改时间 10-JUN-2009 类型 PROBLEM 状态 PUBLISHED
In this Document
Symptoms
Cause
Solution
References
--------------------------------------------------------------------------------
Applies to:
oracle Purchasing - Version: 11.5.10
This problem can occur on any platform.
POXPOEPO.fmb
Symptoms
When the user changes the need-by date in a purchase order that has been received or billed and is associated to a global blanket purchase agreement or a quotation, the price changes.
Steps to Reproduce the Issue:
------------------------------
1. Create a quotation for an item.
2. Create a standard PO referencing the quotation. Approve and receive partially.
3. Change the price on the quotation.
4. Open the PO and change the need by date on the PO, the price changes to the new quotation price.
Note: Only when accrual option is "at receipt" the price should not change after the line has been partially/fully received
This issue also happens when updating the need-by-date in the release
Cause
The prevent_price_update flag was not checked before calling the
functions to reprice the po line/shipment.
This is explained in the following bug:
Bug 5040211/4355088 PRICE CHANGE WHEN UPDATING NEED-BY:
Solution
To implement the solution, execute the following steps:
1. Download and review the readme and pre-requisites for Patch 5040211. (The fix is also included in Procurement Rollup Patch 3 and higher - see NOTE:222339.1 "Procurement Family Patch Release History" for information on the latest Procurement rollup patches.)
2. Ensure that you have taken a backup of your system before applying the recommended patch.
3. Apply the patch in a test environment.
4. Confirm the following file versions:
forms/US/POXPOEPO.fmb 115.445.11510.23
resource/POXPOPOS.pld 115.232.11510.8
resource/POXPOPOL.pld 115.228.11510.17
resource/POXPIPOS.pld 115.67.11510.3
patch/115/sql/POXPOL4B.pls-115.24.11510.2
5. Retest the issue.
6. If the issue is resolved, migrate the solution as appropriate to other environments.
References
BUG:5040211 - Price Change When Updating Need-By-Date
事故描述:
1月下交期,2月调价,1月所下的PO没有交完货的情况下，在原PO上作更改PO交期。结果没想到的是：系统在入库时点会PO的价格重新获取差刷新一次，导致系统上的PO单位价与传真给供应商的PO上的单价有差异，财务对帐的异也有些产生。
解决方案：
问题 : POXPOEPO: Able to Update Unit Price After PO Has Been Received and Invoiced
https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&doctype=PROBLEM&id=397599.1
原因：Profile "PO: Allow Retroactive Pricing of POs" was not set to 'Never'.
设定：
Bug 5560982: ABLE TO CHANGE UNIT PRICE AFTER RECEVING PO
--------------------------------------------------------------------------------
Bug 属性
--------------------------------------------------------------------------------
类型 B - Defect 已在产品版本中修复 -
严重性 2 - Severe Loss of Service 产品版本 11.5.10.2
状态 92 - Closed, Not a Bug 平台 212 - IBM AIX on POWER Systems (64-bit)
创建时间 22-Sep-2006 平台版本 5L
更新时间 31-Oct-2006 基本 Bug -
数据库版本 9.2.0.7.0
影响平台 Generic
产品来源 oracle
相反：要修改价格的话
此方案转自:来源:http://dgstonehuang.blog.163.com/blog/static/4693088820091024103334393/
设置如下：
1.在收货参数里设置“Retroactive Price Adjustment Account”，赋予调整PO价格的会计分录；
2.修改PO里Profile参数：PO: Allow Retroactive Pricing of POS，有3个选项，Never-->不允许修改、OPEN RELEASES-->还没收货（部分收+全收）仅核准状态、ALL RELEASES-->表示收货后可以修改价格。
要值得注意的是：
1。这个成PAC成本有所影响,在标准成本制下可以使用。
2.要注意产生的会计科目 Retroactive Price Adjustment Account
https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&doctype=PROBLEM&id=339536.1
https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&doctype=PROBLEM&id=273918.1
---补丁
PO Price Changes When Need-By Date Is Changed [ID 379511.1]
--------------------------------------------------------------------------------
修改时间 10-JUN-2009 类型 PROBLEM 状态 PUBLISHED
In this Document
Symptoms
Cause
Solution
References
--------------------------------------------------------------------------------
Applies to:
oracle Purchasing - Version: 11.5.10
This problem can occur on any platform.
POXPOEPO.fmb
Symptoms
When the user changes the need-by date in a purchase order that has been received or billed and is associated to a global blanket purchase agreement or a quotation, the price changes.
Steps to Reproduce the Issue:
------------------------------
1. Create a quotation for an item.
2. Create a standard PO referencing the quotation. Approve and receive partially.
3. Change the price on the quotation.
4. Open the PO and change the need by date on the PO, the price changes to the new quotation price.
Note: Only when accrual option is "at receipt" the price should not change after the line has been partially/fully received
This issue also happens when updating the need-by-date in the release
Cause
The prevent_price_update flag was not checked before calling the
functions to reprice the po line/shipment.
This is explained in the following bug:
Bug 5040211/4355088 PRICE CHANGE WHEN UPDATING NEED-BY:
Solution
To implement the solution, execute the following steps:
1. Download and review the readme and pre-requisites for Patch 5040211. (The fix is also included in Procurement Rollup Patch 3 and higher - see NOTE:222339.1 "Procurement Family Patch Release History" for information on the latest Procurement rollup patches.)
2. Ensure that you have taken a backup of your system before applying the recommended patch.
3. Apply the patch in a test environment.
4. Confirm the following file versions:
forms/US/POXPOEPO.fmb 115.445.11510.23
resource/POXPOPOS.pld 115.232.11510.8
resource/POXPOPOL.pld 115.228.11510.17
resource/POXPIPOS.pld 115.67.11510.3
patch/115/sql/POXPOL4B.pls-115.24.11510.2
5. Retest the issue.
6. If the issue is resolved, migrate the solution as appropriate to other environments.
References
BUG:5040211 - Price Change When Updating Need-By-Date
[本日志由 admin 于 2010-10-13 05:18 PM 编辑]
上一篇: 《少有人走的路》读后感
下一篇: Oracle PL/SQL:IF语句的使用
文章来自: 本站原创
引用通告: 查看所有引用 | 我要引用此文章
Tags: 入库(收货)价格 
相关日志:
评论: 0 | 引用: 0 | 查看次数: 14297
发表评论
