My Oracle Support Banner

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 NOVEMBER 11, 2017

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

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.