My Oracle Support Banner

Program Error In Cs_charge_details_pvt.Get_conversion_rate Leads To ORA-06502 (Doc ID 1141586.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Teleservice - Version 12.0.4 to 12.1.3 [Release 12 to 12.1]
Information in this document applies to any platform.


On 12.0.4, 12.1.1, 12.1.3 versions - Debrief :

When attempting to create expense Debrief for a foreign currency, the Debrief Posting Program fails with:


Service Billing Engine calling cs_charge_details_pub.Create_Charge_Details API ended with an error.
(API_NAME=CS_Service_Billing_Engine_PVT: Create_Charges).

API Error (CS_CHARGE_DETAILS_PVT.Create_Charge_Details): &TEXT.

ORA-06502: PL/SQL: numeric or value error: character string buffer too small in Package  CS_CHARGE_DETAILS_PVT Procedure Validate_Charge_Details

The execution of procedure Validate_Charge_Details failed because of the following unexpected errors: ORA-06502: PL/SQL: numeric or value error: character string buffer too small.

Steps to Reproduce
The issue can be reproduced at will with the following steps:

  1. Create SR with task
  2. Enter expense Debrief for the Task - with
    SAC = Expense
    Item = Expense
    UOM = USD
    Amount = 100
    Currency = EUR
  3. Set Debrief status to 'Working', save then set status to 'Completed' and save again to submit the CSF: Debrief Update program
  4. The program ends in warning with the error in the log as mentioned above.


To view full details, 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 a vibrant support community of peers and Oracle experts.