Performance Issues With Receiving Transactions, Corrections And Returns Forms (Doc ID 1438194.1)

Last updated on AUGUST 21, 2016

Applies to:

Oracle Inventory Management - Version 12.1.1 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
Form:RCVTXERT.FMB - Enter Receiving Transactions GUI
Form:RCVTXERE.FMB - Enter Returns GUI
Form:RCVTXECO.FMB - Enter Corrections GUI


Symptoms

In Oracle Inventory, slow performance is reported for Returns, Receiving Transactions and Corrections forms. This issue has been observed with the following views:

- RCV_RETURNS_V
- RCV_CORRECTIONS_V
- RCV_TRANSACTIONS_V

The issue can be reproduced at will with the following steps:
1. Navigate to
Receiving > Receiving Transactions
-or-
Receiving > Corrections
-or-
Receiving > Returns
2. Query for Purchase Order or Receipt.

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