Create Accounting Error XLA_00707_AAD_XXXXXXXX_PKG.EventClass - ORA-01403: no data found (Doc ID 1476456.1)

Last updated on SEPTEMBER 21, 2022

Applies to:

Symptoms

Create Accounting completed with the following error.

ERROR

An internal error has occurred in the program XLA_00707_AAD_XXXXXXXX_PKG.EventClass_267. ORA-01403: no data found.

EVENT CLASS CODE = FOB_RCPT_RECIPIENT_RCPT

The following events are present in the line extract but MISSING in the header extract:
Event_id = XXXXXX
Event_id = YYYYYY

Note: This may be applicable to other class codes also

How to Identify the Problematic Transactions:-

Use the Queries below:-

Input :-

a.Event id.
b.Inventory_item_id
c. Organization_id

1. Get the Event_id from the Log File.
select * from xla_events where event_id in(XXXXXX,YYYYYY);

2. Transaction Data
select * from mtl_material_transactions where transaction_id in
(select source_id_int_1 from xla.xla_transaction_entities where entity_id
in (select entity_id from xla_events where event_id in(XXXXXX,YYYYYY)));

3.From the above Query get the Inventory_item_id and Organization_id and run below queries

select inventory_item_id, organization_id, segment1, inventory_item_flag, inventory_asset_flag
from mtl_system_items_b where inventory_item_id = <Inventory_item_id> and organization_id>;

4. Item Cost Data
select * from cst_item_costs where inventory_item_id = <Inventory_item_id> and organization_id = <organization_id>;

5. Item Cost Details Data
select * from cst_item_cost_details where inventory_item_id = <Inventory_item_id> and organization_id = <organization_id>;

Cause

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