Transaction Date Is Not Matching With ACCT_PERIOD_ID In MMT After Standard Cost Update

(Doc ID 2051954.1)

Last updated on MARCH 25, 2016

Applies to:

Oracle Cost Management - Version 12.1.1 and later
Information in this document applies to any platform.


On : 12.1.3 version, Standard Costing

When Update Standard Cost request is run in the last date of the inventory period and request is completing in the next period
standard cost update transactions have discrepancy in mtl_material_transactions table between transaction_date and ACCT_PERIOD_ID

The issue can be reproduced at will with the following steps:
1. Log in using Inventory Responsibility
2. Navigation Path :Costs>Item Costs>Submit Standard Cost Update program at 2015-05-31 23:56:00
3. Requests completes at 2015-06-01 00:00:15
4. In MMT Table (mtl_material_transactions) standard cost update transaction has acct_period_id column corresponding to May-15 period but transaction_date is in June-15 period


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms