R12.2.4:PA>PJB: PRC: Generate Draft Invoices Error: (cursor=320 code=0: ORA-01403: no data found) (Doc ID 2133407.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Project Billing - Version 12.2.4 and later
Information in this document applies to any platform.
PAIGEN
ORA-01403
no data found
paisql.lpc

Symptoms


PRC: Generate Draft Invoices Error: (cursor=320 code=0: ORA-01403: no data found)

Log file shows error "ORA-01403: no data found"

Entering paiupf()

Call Convert APIreturn stat...
.... Before execute update.
.... After execute update.
Entering paibih()
PEvent_Num=0,Execute the PLSQL Blk to find Auto Evt is not billed or not
return stat...return stat...ORA-01403: no data foundORACLE error during DRAFT INVOICE GENERATION (cursor=320 code=0: ORA-01403: no data found
)

Leaving paiewd()Error during Draft Invoice Generation. Module paiewd returned failure
Error during Draft Invoice Generation. Module paiagr returned failure
Error during Draft Invoice Generation. Module paigop returned failure

 





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