Claims Settlement Issue: Error When Approving Claim in Trade Management for Foreign Currency and Settled with Chargeback

(Doc ID 1681213.1)

Last updated on SEPTEMBER 29, 2017

Applies to:

Oracle Trade Management - Version 12.1.3 and later
Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Trade Management

Attempting to request approval on a claim, in Trade Management, and receive the following error:

ERROR
-----------------------
An error has occured during Approval of Claim "DED34862".
Error Log: 1: SYSPARAM: Post to GL is T
2: Source Table : OZF_CLAIMS_ALL
3: An error occurred when creating Chargeback in AR through AR Chargeback Cover API.


Steps to Reproduce:
Responsibility:  Trade Management
1. Approve a Claim for CAD currency that is being settled with a Chargeback
2. Error appears

FND DEBUG LOG shows out of balance by a penny (.01) and looks something like this:

ar.plsql.ARP_BALANCE_CHK.CHECK_RECP_BALANCE GL_DATE : 28-FEB-2014
ar.plsql.ARP_BALANCE_CHK.CHECK_RECP_BALANCE Sum_amount_dr :602.94
ar.plsql.ARP_BALANCE_CHK.CHECK_RECP_BALANCE Sum_amount_cr :602.94
ar.plsql.ARP_BALANCE_CHK.CHECK_RECP_BALANCE Sum_acctd_amount_dr : 576.29
ar.plsql.ARP_BALANCE_CHK.CHECK_RECP_BALANCE Sum_acctd_amount_cr : 576.3
ar.plsql.ARP_BALANCE_CHK.CHECK_RECP_BALANCE CC_flag : Y
ar.plsql.ARP_BALANCE_CHK.CHECK_RECP_BALANCE ARP_BALANCE_CHK.CHECK_RECP_BALANCE - OUT_OF_BALANCE
ar.plsql.ARP_BALANCE_CHK.Check_Precision .begin ARP_BALANCE_CHK.Check_Precision (+)
ar.plsql.ARP_BALANCE_CHK.Check_Precision p_amount 576.29
ar.plsql.ARP_BALANCE_CHK.Check_Precision p_actual_amount 576.29
ar.plsql.ARP_BALANCE_CHK.Check_Precision p_FunctionalCurrency 576.29
ar.plsql.ARP_BALANCE_CHK.Check_Precision Application amount precision matches with FND currency precision
ar.plsql.ARP_BALANCE_CHK.Check_Precision .end ARP_BALANCE_CHK.Check_Precision (-)
ar.plsql.ARP_BALANCE_CHK.Check_Precision .begin ARP_BALANCE_CHK.Check_Precision (+)
ar.plsql.ARP_BALANCE_CHK.Check_Precision p_amount 576.3
ar.plsql.ARP_BALANCE_CHK.Check_Precision p_actual_amount 576.3
ar.plsql.ARP_BALANCE_CHK.Check_Precision p_FunctionalCurrency 576.3
ar.plsql.ARP_BALANCE_CHK.Check_Precision Application amount precision matches with FND currency precision
ar.plsql.ARP_BALANCE_CHK.Check_Precision .end ARP_BALANCE_CHK.Check_Precision (-)
wf.plsql.WF_NOTIFICATION.Denormalize_Notification() subject(An Error has occured during Approval of Claim "DED60928")
wf.plsql.WF_NOTIFICATION.Denormalize_Notification() END
wf.plsql.WF_DIRECTORY.GetRoleInfo2 BEGIN
wf.plsql.WF_DIRECTORY.GetRoleInfo2 END
fnd.plsql.APP_EXCEPTION.RAISE_EXCEPTION.dict_auto_log This action has been blocked to avoid inaccurate accounting entries. Please contact Oracle Support Services
ar.plsql.arp_global.init_global EXCEPTION: arp_process_application.activity_application
ar.plsql.arp_chargeback_cover.create_chargeback.begin create_chargeback: 20001 error  at arp_chargeback_cover.create_chargeback()+

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