Cost Management: In Transit Transactions Not Transferring To GL (Doc ID 1558625.1)

Last updated on APRIL 05, 2023

Applies to:

Goal

You have inter-org transactions where the in-transit shipment and receipt transactions are done. You can view the distributions in Material Transactions in inventory and they have a costed flag set to Yes. The distributions can be viewed on-line. However in the XLA_EVENTS table they have an EVENT_STATUS_CODE of 'U' and PROCESS_FLAG of 'I'.

The transactions also appear on the Subledger Period Exceptions Report in Cost Management.

When reviewing the output of:
select * from xla_accounting_errors where event_id in (select event_id from xla_events where entity_id in (select entity_id from XLA_TRANSACTION_ENTITIES_upg where source_id_int_1 = '&transaction_id'))

The following error is noted:

The account code combination [account number] for line 1 is a control account. Please provide a third party name and third party site for each subledger journal entry line that uses a control account.

What can be done to get these transactions processed to GL?
 

Solution

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