Error : 'CST_RETRO_PRC_IN_LCM_SHIP' 'User-Defined Exception' While Trying Change The PO Unit Price For An Approved Purchase Order
(Doc ID 2882690.1)
Last updated on JULY 12, 2022
Applies to:
Oracle Purchasing - Version 12.2.6 and laterInformation in this document applies to any platform.
Symptoms
On : 12.2.6 version, Production
After enabling Retroactive Price Update for modifying the price of an approved PO line, the purchase order is not getting approved and is stuck in pre-approved status.
FND Debug Log shows below errors:
ERROR
-----------------------
po.plsql.PO_RETROACTIVE_PRICING_PVT.Retro_Invoice_Release.100 Call RCV_AccrualAccounting_GRP.Create_AccountingEvents()
po.plsql.RCV_AccrualAcct_GRP.Create_AccountingEvents.begin Create_AccountingEvents <<
po.plsql.PO_RETROACTIVE_PRICING_PVT.Retro_Invoice_Release.090 Before Calling Create_AccountingEvents()
po.plsql.PO_RETROACTIVE_PRICING_PVT.Retro_Invoice_Release.100 Call RCV_AccrualAccounting_GRP.Create_AccountingEvents()
po.plsql.RCV_AccrualAcct_GRP.Create_AccountingEvents.0 Inv Org is Discrete Org. Proceeding further...
po.plsql.PO_RETROACTIVE_PRICING_PVT.Retro_Invoice_Release.105 l_return_status = E
po.plsql.PO_RETROACTIVE_PRICING_PVT.Retro_Invoice_Release.105 x_msg_count = 1
po.plsql.PO_RETROACTIVE_PRICING_PVT.Retro_Invoice_Release.105 x_msg_data = BOM?CST_RETRO_PRC_IN_LCM_SHIP?
po.plsql.PO_RETROACTIVE_PRICING_PVT.Retro_Invoice_Release.105.EXCEPTION ;SQLERRM = User-Defined Exception
-----------------------
po.plsql.PO_RETROACTIVE_PRICING_PVT.Retro_Invoice_Release.100 Call RCV_AccrualAccounting_GRP.Create_AccountingEvents()
po.plsql.RCV_AccrualAcct_GRP.Create_AccountingEvents.begin Create_AccountingEvents <<
po.plsql.PO_RETROACTIVE_PRICING_PVT.Retro_Invoice_Release.090 Before Calling Create_AccountingEvents()
po.plsql.PO_RETROACTIVE_PRICING_PVT.Retro_Invoice_Release.100 Call RCV_AccrualAccounting_GRP.Create_AccountingEvents()
po.plsql.RCV_AccrualAcct_GRP.Create_AccountingEvents.0 Inv Org is Discrete Org. Proceeding further...
po.plsql.PO_RETROACTIVE_PRICING_PVT.Retro_Invoice_Release.105 l_return_status = E
po.plsql.PO_RETROACTIVE_PRICING_PVT.Retro_Invoice_Release.105 x_msg_count = 1
po.plsql.PO_RETROACTIVE_PRICING_PVT.Retro_Invoice_Release.105 x_msg_data = BOM?CST_RETRO_PRC_IN_LCM_SHIP?
po.plsql.PO_RETROACTIVE_PRICING_PVT.Retro_Invoice_Release.105.EXCEPTION ;SQLERRM = User-Defined Exception
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to Purchasing Respsonbility
2. Purchase Order Summary
3. Query the Purchase Order
4. Go to Lines > Modify the price
5. Submit the PO for approval
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |