CST_MATCH_DATE_PERIOD Error Occurs When Transaction Date Is End of the Day of Inventory Period With Time Stamp 23:59

(Doc ID 2277010.1)

Last updated on JANUARY 15, 2018

Applies to:

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

Symptoms

Material transaction is not costed with CST_MATCH_DATE_PERIOD error.

ERROR
ERROR_CODE: CST_MATCH_DATE_PERIOD
ERROR_EXPLANATION: The transaction date is not within the accounting period specified

STEPS
The issue can be reproduced at will with the following steps:

  1. Make WIP Return transaction with transaction date: 31-MAY-2017 23:59:59
  2. Run Cost Manager
  3. Review Material Transaction screen then distribution record is not created.
  4. Above error is not generated on mtl_material_transactions table.

Cause

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