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:
Oracle Cost Management - Version 12.0.0 and laterInformation in this document applies to any platform.
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
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
Symptoms |
Cause |
Solution |
References |