R12: PAICGEN Cursor=24 code=0: ORA-01403: no data found

(Doc ID 2307656.1)

Last updated on SEPTEMBER 14, 2017

Applies to:

Oracle Project Billing - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

When running PRC: : Generate Intercompany Invoices for a Range of Projects the following error is encountered:

Leaving paicam() with error
ORACLE error during DRAFT INVOICE GENERATION (cursor=24 code=0: ORA-01403: no data found )
...allocating 30500 bytes of memory to hold set of 500 expenditure item IDs

ORA-01403: no data found

Leaving paicexp()Error during Draft Invoice Generation. Module paicexp returned failure
Error during Draft Invoice Generation. Module paicgop returned failure
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+
APP-FND-01564: ORACLE error 1008 in afpprq

Cause: afpprq failed due to .

The SQL statement being executed at the time of the error was: SELECT ACTION_TYPE, DECODE(STATUS_S_FLAG, 'Y', 1, 0), DECODE(STATUS_W_FLAG, 'Y', 1, 0), DECODE(STATUS_F_FLAG, 'Y', 1, 0), PROGRAM_APPLICATION_ID, PROGRAM_ID, ARGUMENTS, NUMBER_OF_COPIES, SEQUENCE FROM FND_CONC_PP_ACTIONS WHERE CONCURRENT_REQUEST_ID= :reqid AND NVL(COMPLETED,'N') = 'N' ORDER BY DECODE(ACTION_TYPE, 6, 100, ACTION_TYPE) DESC, SEQUENCE and was executed from the file &ERRFILE.
/u01/app/gebs/nebs1t/fs2/EBSapps/appl/pa/12.0.0/bin/PAICGEN
Program was terminated by signal 11

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