How to Update Transaction Date When Transaction Stuck in MTL_TRANSACTIONS_INTERFACE With Error: "No Open Period Found For Date Entered"

(Doc ID 1675813.1)

Last updated on JULY 24, 2017

Applies to:

Oracle Inventory Management - Version and later
Information in this document applies to any platform.
Transaction Open Interface, mtl_transactions_interface, INVTVPTX


Find some transactions in the Open Transaction Interface form (INVTVPTX) show the following error:



Need to update the transaction date to a date within an open period.

How to update Transaction Date for transactions stuck in MTL_TRANSACTIONS_INTERFACE with error: "No Open Period Found For Date Entered"?


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