PRC: Generate Draft Invoice Errors with ORA-06502 in the Call Currency Conversion API

(Doc ID 277135.1)

Last updated on AUGUST 01, 2016

Applies to:

Oracle Project Billing - Version 11.5.9 and later
Information in this document applies to any platform.
*** Checked for relevance on 20-Mar-2015 ***

ConcurrentProgram:PAIGEN_SINGLE - PRC: Generate Draft Invoices for a Single Project


Symptoms

PRC: Generate Draft Invoices errors with the following:

Call Currency Conversion API.
ORACLE error during DRAFT INVOICE GENERATION (cursor=504 code=-6502: ORA-06502:
PL/SQL: numeric or value error: character string buffer too)
Leaving paifrd()Error during Draft Invoice Generation. Module paifrd returned
failure
Error during Draft Invoice Generation. Module paiagr returned failure
Error during Draft Invoice Generation. Module paigop returned failure

The following error is in the log file uploaded:

About to Fetch CRDLs for Updating the invoice_eligibility_flag

...Call Currency Conversion API.
ORACLE error during DRAFT INVOICE GENERATION (cursor=504 code=-6502: ORA-06502: PL/SQL: numeric or
value error: character string buffer too)
PAI_ORACLE_ERROR
ERROR
cursor=504 code=-6502: ORA-06502: PL/SQL: numeric or value error: character string buffer too

and at the bottom of the log file:

22-JUN-2004 09:53:08 GET_DEFAULT_TAX_INFO: calling get default tax info
22-JUN-2004 09:53:09 GET_DEFAULT_TAX_INFO: Error in MARK_CUST_REV_DIST_LINES ORA-20001: Please set
the Receivables system options for this operating unit and ensure that the MO: Operating Unit
profile option is correctly set with an operating unit that is set up in Receivables.

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