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

Last updated on APRIL 04, 2025

Applies to:

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

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