Discrepancies Between The MTA And SLA Tables

Last updated on DECEMBER 01, 2017

Applies to:

Symptoms

On : 12.1.3 version, Inventory Costing

ACTUAL BEHAVIOR
---------------
The 'Create Accounting - Cost Management' and 'Transfer Journal Entries to GL - Cost Management' not processing transactions and 'Subledger Period Close Exceptions Report' not showing errors

Transactions in xla_ae_headers with gl_transfer_status_code='N'.

Ran the program Submit 'Transfer Journas to GL-Receiving' concurrent program for all operating units.
it didnot give any output

The 'Complete Multiperiod Accounting' successfully processed the period end accruals. 

Many transactions in the mtl_transaction_accounts and wip_transaction_accounts tables where column gl_sl_link_id is null.


EXPECTED BEHAVIOR
-----------------------
 Expect all transactions to transfer from Inventory to GL

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.Responsibility: Cost Management – SLA
2. Navigation: SLA - Create Accounting
3. Parameters:
Ledger:
End Date: current date (default)
Mode: Final (default)
Errors Only: No (default)
Report: Summary (default)
Transfer to General Ledger: Yes
Post in General Ledger: No
Include User Transaction Identifiers: No
4. Jobs run by “Create Accounting”:

Changes

Cause