The Mass Additions Create Program Completes In Error: ORA-30926 Unable To Get A Stable Set Of Rows In The Source Tables While Performing The Operation Update Invoice Distributions Which Are Transferred To Asset (Doc ID 1965416.1)

Last updated on SEPTEMBER 09, 2016

Applies to:

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

Symptoms

The 'Mass Additions Create' concurrent request completes in error. The log file shows the following message

Message
ORA-30926: unable to get a stable set of rows in the source tables occurred in
->AP_MASS_ADDITIONS_CREATE_PKG.MASS_ADDITIONS_CREATE
with parameters (P_acctg_date: 2014/12/31 00:00:00,P_bt_code: XXXX CORP)
while performing the following operation:
Update Invoice Distributions which are transferred to Asset
ORA-30926: unable to get a stable set of rows in the source tables occurred in
->AP_MASS_ADDITIONS_CREATE_PKG.MASS_ADDITIONS_CREATE
with parameters (P_acctg_date: 2014/12/31 00:00:00,P_bt_code: XXXX CORP)
while performing the following operation:
Upd

The solution from Note 1491176.1 has been applied.

Steps to reproduce
1. Run the 'Mass Additions Create' concurrent request
2. Completes in Error.


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