My Oracle Support Banner

Item Remains in UNMTCH Status Even After Resolving The Discrepancy Through Summary Match Screen (Doc ID 2894089.1)

Last updated on JANUARY 02, 2024

Applies to:

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

Symptoms

Detail Matching is not happening when supplier pack size is greater than one.

ERROR
-------------
sql_lib.create_msg message:@0DIRTY_RECORDS@1SHIPSKU@2REIM_ONLINE_MATCH_SQL.DIRTY_LOCK_CHECKS

Steps to Recreate:

  1. Choose an item with supplier pack size of 6.
  2. Create a Purchase Order (PO) for above item for 3 cases (18 EA).
  3. Receive the PO for 10 quantity in EA.
  4. Create an invoice by defaulting item details from PO (3 qty in terms of case).
  5. Try to resolve the quantity discrepancy.
  6. Notice that nothing happens after resolution and the item still appears in Detail Matching screen.
  7. Notice below error in LOGGER_LOGS table.
    sql_lib.create_msg message:@0DIRTY_RECORDS@1SHIPSKU@2REIM_ONLINE_MATCH_SQL.DIRTY_LOCK_CHECKS

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.