My Oracle Support Banner

R12: PAIGEN: PRC: Generate Draft Invoices For A Single Project Returns An Error (Doc ID 2374955.1)

Last updated on MARCH 22, 2018

Applies to:

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

Symptoms

When running PAIGEN_SINGLE: PRC: Generate Draft Invoices for a Single Project, the following error is encountered:

Leaving paitrncons......()Current system time is 12-MAR-2018 09:20:16

..... Federal: After Calling the paitrcons() .....
No Need to Calling Invoice By Bill Transaction API ...ORACLE error during DRAFT INVOICE GENERATION (cursor=14 code=-1407: ORA-01407: cannot update ("PA"."PA_DRAFT_INVOICE_ITEMS"."DRAFT_INVOICE)

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

Additionally the following error is also encountered:

No Need to Calling Invoice By Bill Transaction API ...ORACLE error during DRAFT INVOICE GENERATION (cursor=14 code=-1: ORA-00001: unique constraint (PA.PA_DRAFT_INVOICE_ITEMS_U1) violated



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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.