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 MARCH 08, 2017

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 -> 5395445

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms