Claim Events Not Being Processed Create Accounting For Closed Claims (Doc ID 2860870.1)

Last updated on JUNE 21, 2023

Applies to:

Symptoms

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.


Steps:
---------
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

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.