R12: 'MASS ADDITIONS CREATE' ERRORS OUT: AP.PLSQL.AP_MASS_ADDITIONS_CREATE_PKG.MASS_ADDITIONS_CREATE ORA-20001 (Doc ID 2145964.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Payables - Version 12.1.3 and later
Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version:

After upgrade to RDBMS 12.1.0.2, Mass Editions Create runs for a long (2 hours+) and then completes in error:
-------------
"Concurrent Manager encountered an error while attempting to start your immediate concurrent program &PROGRAM. Routine &ROUTINE received a return code of failure.

Contact your support representative.
Concurrent Request for "Mass Additions Create" has completed with error."

FND log file shows error:
-------------------------------
AP.PLSQL.AP_MASS_ADDITIONS_CREATE_PKG.MASS_ADDITIONS_CREATE Total Non-Discount Records Inserted into FA Temp Table: 124
AP.PLSQL.AP_MASS_ADDITIONS_CREATE_PKG.MASS_ADDITIONS_CREATE Calling Project API for Inserting PA Adjustments
AP.PLSQL.AP_MASS_ADDITIONS_CREATE_PKG.MASS_ADDITIONS_CREATE ORA-20001:

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run APMACR module: Mass Additions Create. The process completes in error status.

2. FND log shows error:
AP.PLSQL.AP_MASS_ADDITIONS_CREATE_PKG.MASS_ADDITIONS_CREATE Total Non-Discount Records Inserted into FA Temp Table: 124
AP.PLSQL.AP_MASS_ADDITIONS_CREATE_PKG.MASS_ADDITIONS_CREATE Calling Project API for Inserting PA Adjustments
AP.PLSQL.AP_MASS_ADDITIONS_CREATE_PKG.MASS_ADDITIONS_CREATE ORA-20001:


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