Cost Management: In Transit Transactions Not Transferring To GL
Last updated on JANUARY 01, 2018
Applies to:Oracle Cost Management - Version 12.1.3 and later
Information in this document applies to any platform.
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?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms