My Oracle Support Banner

R12:AP: 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 FEBRUARY 19, 2019

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 XXX)
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 XXXX)
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.