Error "DIRTY_RECORDS@1SHIPSKU@2REIM_ONLINE_MATCH_SQL.DIRTY_LOCK_CHECKS ORA-06510: PL/SQL: unhandled user-defined exception" When Resolving Invoice For Item Not Received (Doc ID 2890805.1)

Last updated on AUGUST 19, 2022

Applies to:

Symptoms

Unable to resolve invoice for item not received with below error in LOGGER_LOGS table:

Error:

DIRTY_RECORDS@1SHIPSKU@2REIM_ONLINE_MATCH_SQL.DIRTY_LOCK_CHECKS ORA-06510: PL/SQL: unhandled user-defined exception

Steps To Recreate:
1) Create Purchase Order(PO) with multiple items.
2) Ship PO - all items per PO.
3) Receive PO - fully received all items except leaving one item as NOT received.
4) Create invoice for all items per PO.
5) Run reimediinjector batch.
6) Run reimautomatch batch.
7) Login to Retail Invoice Matching UI
8) Resolve invoice by indicating that receipt qty of 0 is correct (i.e., Invoice QTY is Higher / Wrong).

After clicking [Apply], it goes back to "Detail Match - Item View" but it is not resolved.

There is no error message displayed in the Invoice Matching screen but LOGGER_LOGS table will show the following error:
@0DIRTY_RECORDS@1SHIPSKU@2REIM_ONLINE_MATCH_SQL.DIRTY_LOCK_CHECKS ORA-06510: PL/SQL: unhandled user-defined exception

Cause

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