My Oracle Support Banner

Purchase Order Screen And DSDreceipt Subscription Gives Error "ORA-06502... DEAL_ORD_LIB_SQL.FIND_ITEMS_FOR_DEAL" (Doc ID 2793135.1)

Last updated on JULY 20, 2021

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 19.2 and later
Information in this document applies to any platform.


PO Screen and DSDreceipt subscription trigger error:

"ORA-06502: PL/SQL: numeric or value error returned by program unit DEAL_ORD_LIB_SQL.FIND_ITEMS_FOR_DEAL"

Steps to reproduce:

Scenario 1:
1. Select a supplier with no deals in MFCS.
2. Create a PO for that supplier and approve it.
3. While in the screen force deals recalculation online and the error is thrown.

Scenario 2:
1. Select a supplier with no deals in MFCS.
2. Create a DSD receipt for that supplier in SIM.
3. Check that DSD receipt failed to integrate MFCS with the described error.




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.