R12:AP: Mass Addition Program Error "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"
(Doc ID 3001472.1)
Last updated on JANUARY 31, 2024
Applies to:
Oracle Payables - Version 12.2.1 and laterInformation in this document applies to any platform.
Symptoms
When attempting to run the Mass Additions Create process, the following error occurs:
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: 2023/11/30 00:00:00,P_bt_code: <Asset Book Code>)
while performing the following operation:
Update Invoice Distributions which are transferred to Asset
->AP_MASS_ADDITIONS_CREATE_PKG.MASS_ADDITIONS_CREATE
with parameters (P_acctg_date: 2023/11/30 00:00:00,P_bt_code: <Asset Book Code>)
while performing the following operation:
Update Invoice Distributions which are transferred to Asset
The issue can be reproduced by following the below steps:
1. Using Payables Manager responsibility
2. Navigate to Other > Requests
3. Click on Single Request
4. Enter Request Name: Mass Additions Create
5. Enter Parameters
6. Click Ok
7. Click on Submit
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 |