R12 - ezROI Script for Standard Purchase Orders Returns (Doc ID 1340331.1)

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


Goal

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_CREATE_RTV BOOLEAN := TRUE; -- If TRUE 'RETURN TO VENDOR' will be attempted. If FALSE 'RETURN TO RECEIVING' will be attempted.

V_RT_DELIVER BOOLEAN := TRUE; -- If TRUE Return performed on RT DELIVER. If FALSE Return performed on RT RECEIVE

 

RT. Transaction_TypeV_RT_DELIVERV_CREATE_RTVRTI.Transaction_Type
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.



Please review the following notes before raising a Service Request with Support:
- Oracle E-Business Suite Error Correction Support Policy (V.3) <Note:1195034.1>


Disclaimer Notice:
The script provided by this note is for educational purposes only and is not supported by Oracle Global Customer Support.

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