Claim Settlement Fetcher Error: "ORA-01403: no data found in Package AR_RECEIPT_API_PUB Procedure Apply" (Doc ID 1553194.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.

Symptoms

When settling deductions (DED) with Credit Memo-Onaccount, following error has occurs in the Claim Settlement Fetcher concurrent program.

Error

(87) APPLY : ORA-01403: no data found
(88) ORA-01403: no data found in Package AR_RECEIPT_API_PUB Procedure Apply
(89) An unexpected error occurred when applying application on receipt through AR Receipt API.

Claim Settlement Fetcher Log File

-------------- DED40371 --------------
claim amount settled = 33
claim amount remaining = 0
Credit/Debit Memo total amount = -33
Credit/Debit Memo line amount = -33
Credit/Debit Memo tax amount = 0
Credit/Debit Memo freight amount = 0
  ----
Difference Amount = 0
Recalculated Settlement Amount = -33
l_deduction_type RECEIPT_DED
Before Pay_by_Credit_Memo
DED40371 --> Failed.
(1) l_claim_class:DEDUCTION
(2) x_settlement_doc_tbl(j).payment_method:CREDIT_MEMO
(3) x_settlement_doc_tbl(j).settlement_type_id:1030
(4) l_claim_class:DEDUCTION
(5) p_payment_method:CREDIT_MEMO
(6) p_settlement_type_id:1030
(7) x_settlement_type:MEET COMP DISCOUNT
(8) OZF_Settlement_Doc_PVT.Get_Settlement_Trx_Type: end
(9) x_settlement_doc_tbl(j).settlement_type:MEET COMP DISCOUNT
(10) Non-Invoice Deduction
(11) OZF_AR_PAYMENT_PVT.Pay_by_Credit_Memo: start
(12) OZF_AR_PAYMENT_PVT.Close_Claim: start
(13) OZF_Settlement_Doc_PVT.Update_Claim_From_Settlement: start
(14) OZF_Claim_Accrual_PVT.Adjust_Fund_Utilization: start
(15) OZF_Claim_Accrual_PVT.Adjust_Fund_Utilization: end
(16) Original Fund Paid Amount = 62392.93
(17) Updated Fund Paid Amount = 62425.35
(18) OZF_Funds_PVT.Update_Fund: start
(19) OZF_Funds_PVT.Update_Fundin else
(20) OZF_Funds_PVT.Update_Fund: validate
(21) OZF_Funds_PVT.Update_Fund: convert currrency
(22) SQL statement: SELECT 1 FROM DUAL WHERE EXISTS (SELECT 1 FROM AMS_USER_STATUSES_VL WHERE USER_STATUS_ID = :b1)
(23) SQL statement: SELECT 1 FROM DUAL WHERE EXISTS (SELECT 1 FROM AMS_CATEGORIES_VL WHERE CATEGORY_ID = :b1)
(24) OZF_Funds_PVT.Update_Fund: check inter-entity
(25) OZF_Funds_PVT.Update_Fund: update
(26) OZF_Funds_PVT.Update_Fund: get_category
(27) OZF_Funds_PVT.Update_Fundbefore update status0
(28) OZF_Funds_PVT.Update_Fund p_fund_rec.exchange_rate_date9:
(29) l_use_fund_staging_tables: F
(30) Going to update mode of update_rollup_amount as l_use_fund_staging_tables is :F
(31) Private API: update_rollup_amount start
(32) update_rollup_amount: end
(33) p_event_type is :UPDATE Fund Id is :17663
(34) Item Key is :17663_06102012141119
(35) OZF_Funds_PVT.Update_Fund: end
(36) Now updating objfundsum_id: 7890
(37) OZF_OBJFUNDSUM_PVT.UPDATE_objfundsum: start
(38) OZF_OBJFUNDSUM_PVT.UPDATE_objfundsum: validate
(39) OZF_OBJFUNDSUM_PVT.UPDATE_objfundsum: update object fund summary Table
(40) OZF_OBJFUNDSUM_PVT.UPDATE_objfundsum: end
(41) Check_Create_history: Start
(42) Check_Create_history: End
(43) Create_History: Start
(44) Create_claims_history: Start
(45) Validate_claims_history: Start
(46) Validate_claims_history: End
(47) Create_claims_history: End
(48) Private API: Create_Claim_Line_Histstart
(49) Private API: Validate_Claim_Line_Hist
(50) Private API: Validate_Claim_Line_Histstart
(51) SQL statement: SELECT 1 FROM DUAL WHERE EXISTS (SELECT 1 FROM OZF_CLAIM_LINES_HIST_ALL WHERE CLAIM_LINE_HISTORY_ID = :b1 AND CLAIM_LINE_HISTORY_ID <> :b2)
(52) Private API: Validate_dm_model_rec
(53) Private API: Validate_Claim_Line_Histend
(54) Private API: Calling create table handler
(55) Private API: Create_Claim_Line_Histend
(56) Create_History: End
(57) OZF_CLAIM_SETTLEMENT_PVT.Raise_Business_Event : start
(58) OZF_CLAIM_SETTLEMENT_PVT.Raise_Business_Event : event = oracle.apps.ozf.claim.paymentPaid
(59) OZF_CLAIM_SETTLEMENT_PVT.Raise_Business_Event: end
(60) OZF_Settlement_Doc_PVT.Update_Claim_From_Settlement: end
(61) OZF_AR_PAYMENT_PVT.Close_Claim: end
(62) Receipt Deduction -> 1. Apply creit memo on receipt
(63) OZF_AR_PAYMENT_PVT.Apply_on_Receipt: start
(64) cash_receipt_id=122681
(65) receipt_number=
(66) customer_trx_id=2076879
(67) trx_number=
(68) applied_payment_schedule_id=2130594
(69) new_applied_amount=-33
(70) new_applied_from_amount=
(71) Claim_ID=168326
(72) Claim Transaction Number =
(73) Claim Payment Method =CREDIT_MEMO
(74) l_attribute_rec.attribute1 =
(75) l_attribute_rec.attribute2 =
(76) l_attribute_rec.attribute3 =
(77) p_comments =
(78) p_payment_set_id=
(79) p_application_ref_type=
(80) p_application_ref_id=
(81) p_application_ref_num=
(82) p_secondary_application_ref_id=
(83) p_application_ref_reason=
(84) p_customer_reference=9500197238
(85) l_attribute_rec.attribute3 =
(86) Invalid customer transaction identifier.
(87) APPLY : ORA-01403: no data found
(88) ORA-01403: no data found in Package AR_RECEIPT_API_PUB Procedure Apply
(89) An unexpected error occurred when applying application on receipt through AR Receipt API.
---------------- DED40371 ----------------

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