PAICGEN: Generate intercompany invoices errors with, cursor=25 Code=-1 Ora-00001 PA_DRAFT_INVOICE_DETAILS_U2 (Doc ID 1102682.1)

Last updated on NOVEMBER 09, 2015

Applies to:

Oracle Project Billing - Version 11.5.10.2 to 12.1.3 [Release 11.5.10 to 12.1]
Oracle Project Costing - Version 11.5.10.2 to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.
PAICGEN
PA_DRAFT_INVOICE_DETAILS_U2
ORA-00001
unique constraint


Symptoms

While running the PAICGEN_SINGLE module: PRC: Generate Intercompany Invoices for a Single Project, errors occur with:

ORACLE error during DRAFT INVOICE GENERATION (cursor=25 code=-1: ORA-00001: unique constraint (PA.PA_DRAFT_INVOICE_DETAILS_U2) violated)
PAI_ORACLE_ERROR
ERROR
cursor=25 code=-1: ORA-00001: unique constraint (PA.PA_DRAFT_INVOICE_DETAILS_U2) violated
Unable to complete Invoice detail process.
ORA-00001: unique constraint (PA.PA_DRAFT_INVOICE_DETAILS_U2) violated
ORA-06512: at "APPS.PA_INVOICE_DETAIL_PROCESS", line 2324
ORA-06512: at line 1

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