R12: PAIGEN - Generate Invoice Gets Error NO_PRVDR_GL_DATE or NO_PA_DATE if AR Period is Not Open (Doc ID 207470.1)

Last updated on MARCH 29, 2017

Applies to:

Oracle Project Billing - Version 11.5.10.2 to 12.2.1 [Release 11.5.10 to 12.2]
Information in this document applies to any platform.
Executable:PAIGEN - PRC: Generate Draft Invoices for a Range of Projects
ConcurrentProgram:PAIGEN_SINGLE - PRC: Generate Draft Invoices for a Single Project


Symptoms

When running PAIGEN PRC: Generate Draft Invoices for a Single Project or PRC: Generate Draft Invoices for a Range of Projects the following error occurs:

Error - Get GL-PA Dates and Periods API
Return Code : NO_PRVDR_GL_DATE
Could not create a valid GL date for provider
Error Code : NO_PA_DATE
No open Project Accounting period
ORACLE error during DRAFT INVOICE GENERATION (cursor=0 code=0: ORA- 01403: no data found)
PAI_ORACLE_ERROR
cursor=0 code=0: ORA-01403: no data found
c_get_gl_date NOTFOUND
x_error_code is [NO_PRVDR_GL_DATE]

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