Claim Chargeback Settlement An unexpected error happened when creating Chargeback in AR through AR Chargeback Cover API (Doc ID 317318.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Trade Management - Version 11.5.10 and later
Information in this document applies to any platform.
***Checked for relevance on 10c-Jul-2014***


Symptoms

DED type claim will not close when a settlement method of chargeback is used.  When clicking on confirm to settle, the form returns you to the claim with a status of open.

ORA-01400: cannot insert NULL into ("AR"."RA_CUST_TRX_LINE_GL_DIST_ALL"."CODE_COMBINATION_ID") in Package ARP_CHARGEBACK_COVER Procedure create_chargeback 
An unexpected error happened when creating Chargeback in AR through AR Chargeback Cover API. 

Error

An error has occured during Approval of Claim "DED10444".
Error Log: 1: OZF_Claim_Approval_PVT.Update_Claim_Status: update_status = APPROVED
2: OZF_Claim_Approval_PVT.Update_Claim_StatusCLOSEDAPPROVED
3: OZF_CLAIM_SETTLEMENT_PVT.Complete_Settlement : start
4: OZF_CLAIM_SETTLEMENT_PVT.Create_Payment_for_Completion : start
5: OZF_Claim_Accrual_PVT.Adjust_Fund_Utilization: start
6: OZF_Claim_Accrual_PVT.Adjust_Fund_Utilization: end
7: OZF_CLAIM_SETTLEMENT_PVT.Create_Payment_for_Completion : end
8: OZF_CLAIM_SETTLEMENT_PVT.Complete_Settlement: end
9: OZF_Claim_Line_PVT.Update_Line_Fm_Claim: start
10: OZF_Claim_Line_PVT.Update_Line_Fm_Claim: end
11: OZF_CLAIM_SETTLEMENT_PVT.Settle_Claim : start
12: OZF_CLAIM_SETTLEMENT_PVT.Create_Payment_for_Settlement : start
13: OZF_AR_PAYMENT_PVT.Create_AR_Payment: start
14: Create Payment for ==> DED10444
15: OZF_AR_PAYMENT_PVT.Pay_by_Chargeback: start
16: OZF_AR_PAYMENT_PVT.Close_Claim: start
17: OZF_Settlement_Doc_PVT.Update_Claim_From_Settlement: start
18: OZF_Claim_Accrual_PVT.Adjust_Fund_Utilization: start
19: OZF_Claim_Accrual_PVT.Adjust_Fund_Utilization: end
20: OZF_CLAIM_SETTLEMENT_PVT.Raise_Business_Event : start
21: OZF_CLAIM_SETTLEMENT_PVT.Raise_Business_Event : event =
oracle.apps.ozf.claim.paymentPaid
22: OZF_CLAIM_SETTLEMENT_PVT.Raise_Business_Event: end
23: OZF_Settlement_Doc_PVT.Update_Claim_From_Settlement: end
24: OZF_AR_PAYMENT_PVT.Close_Claim: end
25: OZF_AR_PAYMENT_PVT.Create_AR_Chargeback: start
26: OZF_AR_PAYMENT_PVT.Create_AR_Chargeback: chargeback amount=100
27: claim_id = 19010
28: l_amount_remaining=0
29: l_acctd_amount_remaining=0
30: l_currency_code=USD
31: ORA-01400: cannot insert NULL into ("AR"."RA_CUST_TRX_LINE_GL_DIST_ALL"."CODE_COMBINATION_ID") in Package ARP_CHARGEBACK_COVER Procedure create_chargeback
32: An unexpected error happened when creating Chargeback in AR through AR Chargeback Cover API.

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