My Oracle Support Banner

Unable To Resolve Discrepancy For Invoice (Doc ID 2913354.1)

Last updated on AUGUST 06, 2024

Applies to:

Oracle Retail Invoice Matching Cloud Service - Version 19.3 and later
Information in this document applies to any platform.

Symptoms

Unable to resolve discrepancy for an item when there are other items in the same same PO which are shipped but not received.

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

Steps to Recreate:

  1. Create a Purchase Order (PO) with multiple items.
  2. Ship all items in the PO.
  3. Receive only one item.
  4. Cancel unreceived items in the PO.
  5. Create an invoice for all items in the PO and with quantity discrepancy for received item.
  6. Try to resolve the discrepancy for received item. Notice that resolved item is still visible in UI.
  7. LOGGER_LOGS table shows the following error:
    0DIRTY_RECORDS@1SHIPSKU@2REIM_ONLINE_MATCH_SQL.DIRTY_LOCK_CHECKS ORA-06510:
    PL/SQL: unhandled user-defined exception

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


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