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 FEBRUARY 16, 2023
Applies to:
Oracle Retail Merchandising Foundation Cloud Service - Version 19.2 and laterInformation in this document applies to any platform.
Symptoms
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.
Changes
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 |
| Changes |
| Cause |
| Solution |
| References |