Create Accounting Error XLA_00707_AAD_XXXXXXXX_PKG.EventClass - ORA-01403: no data found
(Doc ID 1476456.1)
Last updated on JUNE 07, 2021
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
How to Identify the Problematic Transactions:-
Use the Queries below:-
Input :-
a. Package Name
b.Event id.
c.Inventory_item_id
d. Organization_id
Do following to pull the code for EventClass_267.
1.Please note the Line number after executing the below query.
select LINE from dba_source where type='PACKAGE BODY' and name = 'XLA_00707_AAD_XXXXXXXX_PKG'
and text like '%FUNCTION EventClass_267%';
Please note the Line number after executing the below query.
select LINE from dba_source where type='PACKAGE BODY' and name = 'XLA_00707_AAD_XXXXXXXX_PKG'
and text like '%END EventClass_267%';
Please substitue the linenumbers from query 1 and query 2 into this query and then execute the below query.
select text from dba_source where type='PACKAGE BODY' and name = 'XLA_00707_AAD_XXXXXXXX_PKG'
and line between <
and <
2. Get the Event_id from the Log File.
select * from xla_events where event_id in(XXXXXX,YYYYYY);
3. select * from xla.xla_transaction_entities where entity_id in
(select entity_id from xla_events where event_id in(XXXXXX,YYYYYY);
4. 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)));
5. select * from mtl_transaction_accounts 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)));
6. select * from mtl_cst_actual_cost_details 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)));
7. select * from mtl_cst_txn_cost_details 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)));
8.From the above Query get the Inventory_item_id and Organization_id
select * from mtl_system_items where inventory_item_id = <Inventory_item_id> and organization_id>;
9.select * from cst_item_costs where inventory_item_id <Inventory_item_id> and organization_id>;
10.select * from cst_item_cost_details where inventory_item_id <Inventory_item_id> and organization_id>;
Changes
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 |
Changes |
Cause |
Solution |
References |