Deductions With Offer Code On Header Errors Out During Approval Process (Doc ID 2245209.1)

Last updated on JULY 25, 2017

Applies to:

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

Symptoms

On : 12.2.3 version, CLAIMS

If Deduction has an Offer Code selected, then it raises error when submitted for approval

ERROR
-----------------------
ORA-20002: 3240: Error '-6502 - ORA-06502: PL/SQL: numeric or value error: character string buffer too small ' in 'PLSQL' API 'ams_gen_approval_pvt.ntf_requestor_of_error' ORA-06512: at "APPS.WF_NOTIFICATION", line 5758 ORA-06512: at line 6 .

Error stack after enabling FND Debugs - 

1: OZF_Claim_Approval_PVT.Update_Claim_StatusOPENERROR
2: New1: l_claim.pre_auth_deduction_number:
3: New1: l_claim.customer_ref_number
4: Length of l_claim.customer_ref_number
5: New1: l_claim.offer_id
6: New1: l_claim.payment_method
7: l_claim.offer_id :249683
8: l_old_offer_id :249683
9: New1: l_claim.settled_from11
10: l_claim.offer_id1 :249683
11: l_old_offer_id1 :249683
12: New1: l_claim.settled_from22
13: COUNT=1
14: OZF_Claim_Line_PVT.Delete_Claim_Line_Tbl: start
15: l_object_version22:1
16: l_object_version33:1
17: OZF_Claim_Line_PVT.Delete_Claim_Line: start
18: OZF_Claim_Accrual_PVT.Delete_Line_Util_Tbl: start
19: OZF_Claim_Accrual_PVT.Delete_Line_Util: start
20: OZF_Claim_Accrual_PVT.Delete_Line_Util: update funds_utilized
21: OZF_Claim_Accrual_PVT. Update_Fund_Utils: start
22: l_line_util_rec.claim_line_id: 193979
23: l_source_object_class:
24: Currencies at Update_Fund_Utils API...
25: p_asso_amount = 20
26: l_line_util_rec.amount =
27: l_line_util_rec.claim_line_id = 193979
28: l_currency_rec.association_currency_code = USD
29: l_currency_rec.claim_currency_code = USD
30: l_currency_rec.transaction_currency_code = USD
31: l_currency_rec.functional_currency_code = USD
32: l_currency_rec.universal_currency_code = USD
33: l_fu_fund_currency = USD
34: l_fu_req_currency = USD
35: l_line_util_rec.utilization_id = 13546
36: l_fu_amt_rem : -20
37: l_fu_acctd_amt_rem : -20
38: l_fu_plan_amt_rem : -20
39: l_fu_univ_amt_rem : -20
40: l_fu_req_amt_rem : -20
41: l_line_util_rec.utilization_id : 13546
42: OZF_Claim_Accrual_PVT. Update_Fund_Utils: end
43: OZF_Claim_Accrual_PVT.Delete_Line_Util: delete
44: OZF_Claim_Accrual_PVT.Delete_Line_Util: end
45: OZF_Claim_Accrual_PVT.Delete_Line_Util_Tbl: end
46: OZF_Claim_Line_PVT.Delete_Claim_Line: delete
47: 193979: delete : p_claim_line_id
48: 1: delete : p_object_version
49: OZF_Claim_Line_PVT.Delete_Claim_Line: end
50: OZF_Claim_Line_PVT.Delete_Claim_Line_Tbl: end
51: Caim Line Does not Exists :
52: Before Asso API l_claim.claim_id :195677
53: Before Asso API l_claim.offer_id :249683
54: Before Asso API l_claim.amount :20
55: Before Asso API l_claim.acctd_amount :20
56: Before Asso API l_claim.payment_method :CREDIT_MEMO
57: Before Asso API l_claim.claim_class :DEDUCTION
58: Before Asso API l_claim.cust_account_id :1290
59: Before Asso API l_claim.cust_billto_acct_site_id :1424
60: Start :Create_Claim_Association
61: Claim Customer Account ID:1290
62: Accrual Customer Account ID:1290
63: l_prorate_earnings_flag:T
64: OZF_Claim_Line_PVT.Create_Claim_Line: start
65: OZF_CLAIM_SETTLEMENT_VAL_PVT.Default_Claim_Line : start
66: OZF_CLAIM_SETTLEMENT_VAL_PVT.Default_Claim_Line : end
67: OZF_Claim_Line_PVT.Create_Claim_Line: validate
68: OZF_Claim_Line_PVT.Validate_Claim_Line: start
69: OZF_Claim_Line_PVT.Validate_Claim_Line: check items
70: OZF_Claim_Line_PVT.Validate_Claim_Line: check record
71: OZF_Claim_Line_PVT.Validate_Claim_Line: end
72: The program could not update a claim line because the absolute value of
summation of the Claim Currency Amount of the claim lines is not less than
the absolute value of Amount Remaining of claim.

Changes

 

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