Inventory To GL Reconciliation Step

In R12, the GL transfer is a two-step process. The first step is from Costing to SLA. The second step is from SLA to GL. Costing team is only responsible for the first step. We can provide some guideline to check the inventory material distributions have been accounted in SLA.  To confirm the integrity between SLA and GL, we need to go to a Financials referrals

/*------- Verify that all Material Transaction Account distributions accounted in SLA ----------- */                                     If the following query returns any rows then that means there are distributions in MTA which have not been created in SLA ,This may indicate a problem in SLA create accounting process if it is a R12 transaction, If it is a historical 11i transaction, it may tell you that the accounting has not been upgraded to SLA
SELECT *
FROM mtl_transaction_accounts a
WHERE a.transaction_date between TO_DATE('&&from_dt','DD-MM-YYYY')
AND TO_DATE('&&to_dt','DD-MM-YYYY')+0.99999
AND a.accounting_line_type<>15
AND a.reference_account =&&Account_id
AND a.organization_id = &&organization_id
AND NOT EXISTS (SELECT NULL
FROM xla_distribution_links
WHERE source_distribution_type =
'MTL_TRANSACTION_ACCOUNTS'
AND application_id = 707
AND source_distribution_id_num_1 =
a.inv_sub_ledger_id);
In addition to this scrip you will be prompted for 4 parameters:
1. From Date
2. To Date
3. Account ID
4. Organization ID
The account_id is the GL account identifier. It is called CCID frequently.It is stored in the GL_CODE_COMBINATIONS table.If the user does not know the GL account ID, they can run a query against GL_CODE_COMBINATIONS where they can see the segments that build up the CCID