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:

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

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