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 11.5.10.2 and later
Information in this document applies to any platform.
Transaction Open Interface, mtl_transactions_interface, INVTVPTX

Goal

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

Solution

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
Goal
Solution

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