My Oracle Support Banner

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 JUNE 21, 2023

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"?


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.