My Oracle Support Banner

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

Last updated on APRIL 01, 2024

Applies to:

Oracle Cost Management - Version 12.0.0 and later
Information in this document applies to any platform.


Create Accounting completed with the following error.


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


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.
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>;


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

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