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

Last updated on APRIL 18, 2024

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.

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

	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

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

References

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

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

Applies to:

Goal

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!