PAIGEN PRC: Generate Draft Invoices For A Single Project and PAICGEN PRC: Generate Intercompany Invoices Processes Finish with ORA-1422 and ORA-1403 (Doc ID 1373772.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Project Billing - Version 11.5.10.2 and later
Information in this document applies to any platform.
ConcurrentProgram:PAIGEN_SINGLE - PRC: Generate Draft Invoices for a Single Project
Executable:PAIGEN - PRC: Generate Draft Invoices for a Range of Projects
Executable:PAICGEN - PRC: Generate Intercompany Invoices for a Range of Projects
ConcurrentProgram:PAICGEN_SINGLE - PRC: Generate Intercompany Invoices for a Single Project

***Checked for relevance on 09-JAN-2014***

Symptoms

PAIGEN_SINGLE module: PRC: Generate Draft Invoices for a Single Project errors with the following in the log file:

...Call Currency Conversion API.
return stat...ORA-01422: exact fetch returns more than requested number of rowsORACLE error during DRAFT INVOICE GENERATION (cursor=504 code=0: ORA-01403: no data found
)
PAI_ORACLE_ERROR
ERROR
cursor=504 code=0: ORA-01403: no data found
...
19-SEP-2011 03:21:29 GET_DEFAULT_TAX_INFO: calling get default tax info
19-SEP-2011 03:21:30 GET_DEFAULT_TAX_INFO: Error in MARK_CUST_REV_DIST_LINES ORA-01422: exact fetch returns more than requested number of rows
19-SEP-2011 03:21:30 GET_DEFAULT_TAX_INFO: ORA-01422: exact fetch returns more than requested number of rows

When reviewing the trace file for this process, the following is seen:

BINDS #28:
Bind#0
oacdty=23 mxl=32(16) mxlc=00 mal=00 scl=00 pre=00
oacflg=03 fl2=1206001 frm=00 csi=00 siz=32 off=0
kxsbbbfp=b73dff38 bln=32 avl=16 flg=05
value=
Dump of memory from 0xB73DFF38 to 0xB73DFF48
B73DFF30 AC7A24A9 C44B5073 [.$z.sPK.]
B73DFF40 AC1040E0 D1030B6E [.@..n...]

PAICGEN module: PRC: Generate Intercompany Invoices for a Range of Projects errors with the following in the log file:

ORACLE error during DRAFT INVOICE GENERATION (cursor=25 code=-1422: ORA-01422: exact fetch returns more than requested number of rows
ORA-)
Unable to complete Invoice detail process.
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "APPS.PA_INVOICE_DETAIL_PROCESS", line 2476
ORA-06512: at line 1

Upon review of the trace, there is an ORA-00001 which is followed by the ORA-1422. When reviewing the bind variables for the errored statement, the following is seen:

Bind#7
oacdty=02 mxl=22(22) mxlc=00 mal=500 scl=00 pre=00
oacflg=40 fl2=1000000 frm=00 csi=00 siz=24 off=0
kxsbbbfp=b736a828 bln=22 avl=04 flg=05
value=###
An invalid number has been seen.Memory contents are :
Dump of memory from 0xB736A828 to 0xB736A82C
B736A820 B73F1DC2

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