Claim Events Not Being Processed Create Accounting For Closed Claims
(Doc ID 2860870.1)
Last updated on JUNE 21, 2023
Applies to:Oracle Trade Management - Version 12.2.10 and later
Information in this document applies to any platform.
On : 12.2.10 version,
Noticed Claims in Trade Management are closed, but the Claim events not being processed in SubLedger Accounting / Create accounting programs. No errors, in the logs or output files.
1. Oracle Trade Management User > Claims
2. Process claims to Closed status
3. Run SubLedger Accounting program from Oracle Trade Management Administrator responsibility.
4. No errors, checked backend table data.
a.select * from ozf_claims_all where claim_number = '<insert claim_number>;
b.select * from ozf_xla_claim_headers where claim_id = '<insert claim_id from query a>';
c.select * from xla_events
where event_id in
(select event_id from ozf_xla_claim_headers where claim_id = '<insert claim_id from query a>');
Noticed the event records for claim were showing as unprocessed.
EVENT_STATUS_CODE = U
PROCESS_STATUS_CODE = U
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document