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 APRIL 10, 2018

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

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