PAIGEN, Generate Draft Invoices Cursor=32 Code=-1: ORA-00001: Unique Constraint (Doc ID 1903339.1)

Last updated on DECEMBER 11, 2024

Applies to:

Symptoms

PAIGEN module: PRC: Generate Draft Invoices for a Range of Projects
.....

.....

Invoice Processing Parameter List
========================================================

------------ < List Of Parameters > ----------------------


Single Project ID ---------------------> <project_id>
From Project Number ------------------->
To Project Number --------------------->
Bill Through Date ---------------------> 2014/04/24
Invoice Date --------------------------> 2014/04/24
Invoice Generation Option -------------> INCLUDE_RETN_INVOICES
Project Type ID -----------------------> 0
Project Org ID ------------------------> 0
Customer ID ---------------------------> 0
LOC Customer ID -----------------------> 0
Agreement ID --------------------------> 0
Multi Currency Flag -------------------> No
Exclude New Transactions --------------> No
Delete unapproved invoices only -------> No
Delete PWP Linked invoices ------------> No
Bill Group ------------------->
.....
.....

Insert into PA_DRAFT_INVOICE_ITEMS

Pproject_currency_code=USD len=3
Pproject_bill_amount=24.98 len=5
Pprojfunc_currency_code=USD len=3
Pprojfunc_bill_amount=24.98 len=5
Pfunding_currency_code=USD len=3
Pfunding_bill_amount=24.98 len=5
Pinvproc_currency_code=USD len=3
Pbill_trans_currency_code= len=0
Pbill_trans_bill_amount=0 len=1
Pfunding_rate_type= len=0
Pfunding_rate_date= len=0
Pfunding_exchange_rate= len=0
Pamount=24.98 len=5
Ptext=01 Admin.Administrator I. 0.50 Hours len=109
Pline_type=STANDARD len=8
Xtax_exempt_flag=S len=1
Xtax_exempt_reason_code= len=0
Xtax_exempt_certificate_no= len=0
Ptranslated_text= len=1
Pinv_rate_type= len=0
Pinv_rate_date= len=0
Pfunding_exchange_rate= len=0
Pinv_exchange_rate= len=0
ORACLE error during DRAFT INVOICE GENERATION (cursor=32 code=-1: ORA-00001: unique constraint (PA.PA_DRAFT_INVOICE_ITEMS_U1) violated
)
PAI_ORACLE_ERROR
ERROR
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
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

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.