My Oracle Support Banner

Dirty Records Error Upon Resolving the Discrepancies (Doc ID 2918639.1)

Last updated on JANUARY 04, 2023

Applies to:

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

Symptoms

Cannot resolve invoices in Discrepancy Review List or Detail Match. When the "Resolve" pop-up screen appears and the user selects a reason code and hit apply, nothing happens. There is no error message, but invoice remains unmatched.

Also below error could be noted in the LOGGER_LOGS

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

ORA-06510: PL/SQL: unhandled user-defined exception
"

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


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