My Oracle Support Banner

R12 PAIGEN:DRAFT INVOICE GENERATION (CURSOR=29 CODE=-1422: ORA-01422) (Doc ID 973036.1)

Last updated on MAY 24, 2019

Applies to:

Oracle Project Billing - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms



Running the PAIGEN PRC: Generate Draft Invoices encounters error: GET_DEFAULT_TAX_INFO: ORA-01422
Error: Leaving paibih()

x_return_status :
...Inserting line # 1 of invoice # 1 for $
ORACLE error during DRAFT INVOICE GENERATION (cursor=29 code=-1422: ORA-01422: exact fetch returns more than requested number of rows
ORA-)

Leaving paiiil()Error during Draft Invoice Generation. Module paiiil returned failure
Error during Draft Invoice Generation. Module paiend returned failure
Error during Draft Invoice Generation. Module paigaa returned failure
Error during Draft Invoice Generation. Module paiend returned failure
Error during Draft Invoice Generation. Module paigop returned failure
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
2009/11/28 05:25:42 GET_DEFAULT_TAX_INFO: ORA-01422: exact fetch returns more than requested number of rows
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+

Changes

Applied <patch 9149338>

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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