PAIGEN: PRC: Generate Draft Invoices For A Single Project Errors: ORACLE error during DRAFT INVOICE GENERATION, ORA-01407: cannot update ("PA"."PA_DRAFT_INVOICE_ITEMS"."DRAFT_INVOICE), ORA-00001: unique constraint (PA.PA_DRAFT_INVOICE_ITEMS_U1) violated (Doc ID 2374955.1)

Last updated on JANUARY 04, 2024

Applies to:

Symptoms

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

ERROR:

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

and

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

Changes

Cause

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