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.

Symptoms

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:

Error

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.

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