My Oracle Support Banner

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 later
Information in this document applies to any platform.


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:

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

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 


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.