R12 PAIGEN: PRC: Generate Draft Invoices completed with error (Doc ID 1905056.1)

Last updated on JANUARY 06, 2017

Applies to:

Oracle Project Billing - Version 12.1.3 to 12.2.4 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

When attempting to run the PAIGEN PRC: Generate Draft Invoices for a Single Project the following error occurs.

ORACLE error during DRAFT INVOICE GENERATION (cursor=32 code=-1: ORA-00001:unique constraint (PA.PA_DRAFT_INVOICE_ITEMS_U1) violated
Leaving paiiil()Error during Draft Invoice Generation. Module paiiil returned
failure
Error during Draft Invoice Generation. Module paigil returned failure

May also have following PAIGEN error:

ORACLE error during DRAFT INVOICE GENERATION (cursor=32 code=-1400: ORA-01400: cannot insert NULL into ("PA"."PA_DRAFT_INVOICE_ITEMS"."AMO)
PAI_ORACLE_ERROR
ERROR
cursor=32 code=-1400: ORA-01400: cannot insert NULL into ("PA"."PA_DRAFT_INVOICE_ITEMS"."AMO

Leaving paiiil()Error during Draft Invoice Generation. Module paiiil returned failure
PA_IGEN_ERROR
MODULE
paiiil
Error during Draft Invoice Generation. Module paigil returned failure
PA_IGEN_ERROR
MODULE
paigil
Error during Draft Invoice Generation. Module paiagr returned failure
PA_IGEN_ERROR
MODULE
paiagr
Error during Draft Invoice Generation. Module paigop returned failure
PA_IGEN_ERROR
MODULE
paigop
 

 

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