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

Last updated on AUGUST 01, 2017

Applies to:

Oracle Project Billing - Version 12.0.6 to 12.0.6 [Release 12.0]
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 $-27676.22
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

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