ReIM Invoice Cannot Be Resolved Using Online Match - Dirty Lock On SHIPSKU
(Doc ID 2885579.1)
Last updated on APRIL 11, 2024
Applies to:
Oracle Retail Invoice Matching Cloud Service - Version NA and laterInformation in this document applies to any platform.
Symptoms
ReIM Invoice Cannot be Resolved Using Online Match with below error:
sql_lib.create_msg message:@0DIRTY_RECORDS@1SHIPSKU@2REIM_ONLINE_MATCH_SQL.DIRTY_LOCK_CHECKS
ORA-06510: PL/SQL: unhandled user-defined exception
Steps To Recreate:
1. Create a PO with multiple items. ship all items; but, receive zero units for one of the item.
Invoice is created as:
1. Same units as the PO (including the item with the missing receipt)
2. The missing item has cost discrepancy on the invoice.
Attempt to resolve and it will not resolve. It matches all of the lines except the one with the zero receipt which has both cost and qty discrepancy.
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 |