Program Error In Cs_charge_details_pvt.Get_conversion_rate Leads To ORA-06502
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 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:
- Create SR with task
- Enter expense Debrief for the Task - with
SAC = Expense
Item = Expense
UOM = USD
Amount = 100
Currency = EUR
- Set Debrief status to 'Working', save then set status to 'Completed' and save again to submit the CSF: Debrief Update program
- The program ends in warning with the error in the log as mentioned above.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms