The "PRC: Generate Draft Invoices For A Single Project" Concurrent process Ends With Error ORA-06502 (Doc ID 2147437.1)

Last updated on JUNE 29, 2017

Applies to:

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

Symptoms

On : 12.2.5 version, Brazil Consulting Localizations

When attempting to run the concurrent program "PAIGEN_SINGLE: PRC: Generate Draft Invoices for a Single Project", the following error occurs.

Call PA_MCB_INVOICE_PKG.Convert_Line_event_amount.
 x_return_status :
...Inserting line # 1 of invoice # 1 for $500
ORACLE error during DRAFT INVOICE GENERATION (cursor=29 code=-6502: ORA-06502: PL/SQL: numeric or value error: character string buffer too)

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
+---------------------------------------------------------------------------+
2016/05/19 12:14:51 Entering pa_billing.CHECK_SPF_AMOUNTS billing_funds_check_fc_flag :
2016/05/19 12:14:52 Entering pa_billing.CHECK_SPF_AMOUNTS billing_funds_check_fc_flag :
2016/05/19 12:14:52 Event_Convert_amount_bulk: first .....
2016/05/19 12:14:52 Event_Convert_amount_bulk: two .....
2016/05/19 12:14:52 Event_Convert_amount_bulk: three .....
2016/05/19 12:14:52 Event_Convert_amount_bulk: three three .....
2016/05/19 12:14:52 Event_Convert_amount_bulk: four .....
2016/05/19 12:14:52 Event_Convert_amount_bulk: five .....
2016/05/19 12:14:53 GET_DEFAULT_TAX_INFO: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
+---------------------------------------------------------------------------+
End of log messages from FND_FILE


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