In this Document

Applies to:

Symptoms

There are 3772 transactions that have COSTED_FLAG = 'N' in mtl_material_transactions.

All are COGS Recognition transactions.  Standard Costing is being used.

Cause

Transaction_group_id was populated while costed_flag was at N.  

In order to be picked up for processing, transaction_group_id should be NULL with costed_flag = N.

Solution

  Resubmit these pending records to update the transaction_group_id to NULL.

 Please do the following:

 Make a back-up of your Mtl_MATERIAL_TRANSACTIONS table

  1.  Stop the Cost Manager

  2.  Run the following script:

Update mtl_material_transactions
SET transaction_group_id = NULL
WHERE costed_flag = 'N'
and organization_id = &org_id
and account_period_id = &period_id
and transaction_type_id = 10008;

3.  Then commit.

SQL>commit;

4. Launch the cost manager

5. Confirm that a cost worker is spawned to process these records.

References