Not Able To Initiate Payment For A Processed Chargeback (Doc ID 1471337.1)

Last updated on SEPTEMBER 02, 2016

Applies to:

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

Symptoms

Unable to initiate payment for a processed chargeback. We are using a fully accrued budget and amount got utilized also by corresponding Sales Order and Budget amount got updated.
 But still we are not able to initiate payment for a batch.

Error Notification
==============

Errors happened during payment initialization for batch 144

Errro Message: 86: Insufficient funds available to settle Chargeback Claim
85: -------------------------------------------------
84: l_total_amount_utilized = 0
83: l_batch_settlement_flag = F
82: l_batch_product_amount = 280
81: -------------After Ending batch loop ------------
80: Product id : 4004
79: Product Amount : 280
78: Fund_id : 10041
77: Customer Account Id : 4040
76: OZF_Claim_Accrual_PVT.Create_Claim_Existing_Accruals: start
75: Invokes Create_Claim_For_Accruals
74: Close Claim Flag is F
73: Autopay Flag is T
72: Payment method is CREDIT_MEMO
71: OZF_Claim_Accrual_PVT.Validate_Cust_Trade_Profile: end
70: The program failed to create claim in autopay because the Site_use_id is missing for customer Organization-1-Test (1060) . Please enter a Site_use_id for customer Organization-1-Test (1060) .
69: OZF_Claim_Accrual_PVT.Validate_Cust_Trade_Profile: start
68: OZF_Claim_Accrual_PVT.Get_Cust_Trade_Profile: end
67: OZF_Claim_Accrual_PVT.Get_Cust_Trade_Profile: start
66: OZF_Claim_Accrual_PVT.Pay_Claim_For_Accruals: start
65: Existing accruals of chargeback budget should be used.
64: OZF_RESALE_COMMON_PVT.Update_Batch_Calculations: End
63: diputed line:0 tolerance line0
62: OZF_RESALE_COMMON_PVT.Update_Batch_Calculations: Start
61: OZF_RESALE_COMMON_PVT.Insert_Resale_Line_Mapping: End
60: OZF_RESALE_COMMON_PVT.Insert_Resale_Line_Mapping: Start
59: line_id is 4005
58: OZF_RESALE_COMMON_PVT.Create_Sales_Transaction: End
57: OZF_SALES_TRANSACTIONS_PVT.create_transaction: End
56: insert done8010
55: error_flag: N
54: common_amount: 350
53: common_currency_code: USD
52: error_flag: N
51: common_quantity: 14
50: common_code: EA
49: error_flag: N
48: primary_quantity: 14
47: primary_uom_code: EA
46: start conversion
45: OZF_SALES_TRANSACTIONS_PVT.Validate_transaction: End
44: line_id: 4005
43: header_id: 4005
42: sold_from_party_id: 6041
41: IN IS:
40: OZF_SALES_TRANSACTIONS_PVT.Validate_transaction: Start
39: uom_code:EA
38: quantity:14
37: transaction_date:14-JUN-2012
36: inventory_item_id:4004
35: OZF_SALES_TRANSACTIONS_PVT.create_transaction: Start
34: OZF_RESALE_COMMON_PVT.Create_Sales_Transaction: Start
33: OZF_RESALE_COMMON_PVT.Insert_resale_line: End
32: line INSERT successful id:4005
31: before line INSERT:4005
30: before line INSERT: header id4005
29: OZF_RESALE_COMMON_PVT.Insert_resale_line: Start
28: header_id is 4005
27: OZF_RESALE_COMMON_PVT.Insert_resale_header: End
26: before INSERT: header_id4005
25: OZF_RESALE_COMMON_PVT.Insert_resale_header: Start
24: Current line_int_id:7003
23: DATE ORDERED: 14-JUN-2012
22: SOLD_FROM_ACCT: 4040
21: ORDER NUMBER: l
20: PROCESS ORDER:
19: Create Accruals On Chargeback Claims: F
18: OZF_RESALE_COMMON_PVT.Derive_Orig_Parties: End
17: OZF_RESALE_COMMON_PVT.Derive_End_Cust_Party: End
16: OZF_RESALE_COMMON_PVT.Derive_End_Cust_Party: Start
15: OZF_RESALE_COMMON_PVT.Derive_Ship_To_Party: End
14: OZF_RESALE_COMMON_PVT.Derive_Ship_To_Party: Start
13: OZF_RESALE_COMMON_PVT.Derive_Bill_To_Party: End
12: OZF_RESALE_COMMON_PVT.Derive_Bill_To_Party: Start
11: OZF_RESALE_COMMON_PVT.Derive_Orig_Parties: Start
10: Chargeback Budget: 10041
9: Batch Type CHARGEBACK
8: compare to PENDING_PAYMENT
7: status PENDING_PAYMENT
6: OZF_CHARGEBACK_PVT.Initiate_Payment: Start
5: IN: Initiate_Payment_chargeback Funcmode: RUN
4: Batch Type CHARGEBACK
3: IN Get_Batch_Type Funcmode: RUN
2: Batch ID 7003
1: IN: Check_Duplicates Funcmode: RUN

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