My Oracle Support Banner

When Applying Payables Generic Datafix (GDF) Patch 13405297, Encounter Exception ORA-30926: unable to get a stable set of rows (Doc ID 1456661.1)

Last updated on JULY 21, 2020

Applies to:

Oracle Payables - Version 12.0.0 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.

Symptoms

 After applying Generic Datafix (GDF) <Patch 13405297>:R12.AP.B to address the issue of duplicate supplier contacts for millions of records, the fix script ap_upg_dup_supContact_fix.sql is erroring out with these messages:

Encountered an Exception ORA-30926: unable to get a stable set of rows in the source tables at : po_vendor_contact_merge while performing : Updating po_reqexpress_lines_all
Error calling cust_vendor_contact_merge
Number of records for which fix was attempted ->

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.