My Oracle Support Banner

Unable to Query Transactions in Material Transaction Form(INVTVTXN), but There Exists the Inventory Transactions in MTL_MATERIAL_TRANSACTIONS (Doc ID 2382750.1)

Last updated on JULY 15, 2022

Applies to:

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

Symptoms

Problem Statement
Confirmed there exists the inventory transactions in MTL_MATERIAL_TRANSACTIONS.
But unable to query the transaction in Material Transactions form.

Error
FRM-40350: Query Caused no records to be retrieved.

Steps To Reproduce

  1. Launch Material Transactions form
    (N)Inventory > Transactions > Material Transactions
  2. Select Organization
  3. Clear Transaction Dates(From) and set the item
  4. Search
    ==>FRM-40350: Query Caused no records to be retrieved.

Cause

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
Symptoms
Cause
Solution
References


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