How can the Receiving Data Collection Script (rcv11i.sql) be run as individual scripts? (Doc ID 1294177.1)

Last updated on OCTOBER 05, 2016

Applies to:

Oracle Inventory Management - Version 11.5.4 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.
***Checked for relevance on 05-May-2015***

Goal

How can the Receiving Data Collection Script be run as individual scripts?


You should always try to run the Receiving Data Collection script using the Application first.
<Note: 423279.1> How Can The Receiving Data Collection Script Be Run From Within The Oracle Application?

If for any reason using the application doesn't work, then attempt to use the standalone script: <Note: 402245.1> Receiving Transactions Data Collection Script rcv11i_sa.sql

 

The purpose of these scripts is to collect data dump from key tables related to receiving transactions. The tables to collect data from depend on the type of source transaction, i.e., purchase order (PO), purchase order release (PR), Internal Requisition (IR, supplied by Internal Sales Order), Return Material Authorization (RMA) or Inter-organization Transfer/Shipment (IOT). The SELECT statements within the scripts are generic and can be run on releases 11.5.4 through 12.1.x data models.

DISCLAIMER: These scripts are developed and maintained by Oracle Support Services. It is provided for diagnostic purposes only "as is". It has been tested internally and should work as intended.

 

NOTE: This script is provided for educational purposes only and not supported by Oracle Support Services. It has been tested internally, however, and works as documented. We do not guarantee that it will work for you, so be sure to test it in your environment before relying on it.

Solution

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