R12 - ezROI Script for Standard Purchase Orders Returns
Last updated on JUNE 01, 2016
Applies to:Oracle Inventory Management - Version 12.0.0 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.
Executable:RVCTP - Receiving Transaction Processor
To provide a sample script for populating the Receiving Transactions Interface (ROI) using the SELECT query offered on Page 16-88 of the following manual:
- Oracle Supply Chain Management APIs and Open Interfaces for Rel 12 (Part No. B40113-01)
The script provided on this note takes the Purchase Order Number and Operating Unit as parameters before populating the Receiving Transaction Interface
ready to be processed by the Receiving Transaction processor.
The manual may be downloaded here.
The Receiving Transaction Processor has the ability to return a Delivered item back to Receiving or directly back to the Supplier as well as returning
a Received item back to the Supplier.
By default, the sample script will insert in to RCV_TRANSACTIONS_INTERFACE (RTI) a Return to Supplier where a Delivery line is found in RCV_TRANSACTIONS (RT).
This can be changed by altering the following variables contain in the script:
V_RT_DELIVER BOOLEAN := TRUE; -- If TRUE Return performed on RT DELIVER. If FALSE Return performed on RT RECEIVE
|DELIVER||TRUE||TRUE||RETURN TO VENDOR|
|DELIVER||TRUE||FALSE||RETURN TO RECEIVING|
|RECEIVE||FALSE||TRUE||RETURN TO VENDOR|
|RECEIVE||FALSE||FALSE||It is not possible to perform a RETURN TO RECEIVING on a transaction that is already in Receiving.|
- Oracle E-Business Suite Error Correction Support Policy (V.3) <Note:1195034.1>
The script provided by this note is for educational purposes only and is not supported by Oracle Global Customer Support.
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