Rel 12 ezROI Script for Standard Purchase Orders Using ASN (Doc ID 1333911.1)

Last updated on DECEMBER 02, 2016

Applies to:

Oracle Inventory Management - Version 12.0.0 and later
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) based on 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 manual may be downloaded here.

The script provided on this note takes the Purchase Order Number, Operating Unit and ASN Shipment Number as parameters before populating the Receiving Transaction Interface ready to be processed by the Receiving Transaction processor.

The Receiving Transaction Processor has the ability to either create the Shipment Header and Lines only or to process the transactions.
This is dependent on values set within the table RCV_TRANSACTIONS_INTERFACE (RTI)

RTI.TRANSACTION_TYPERTI.AUTO_TRANSACT_CODE
= NULL
RTI.AUTO_TRANSACT_CODE
= RECEIVE
RTI.AUTO_TRANSACT_CODE
=DELIVER
SHIP Shipment header and shipment lines
created
Receiving transaction created Receiving and delivery transaction
created
RECEIVE Receiving transaction created Receiving transaction created Receiving and delivery transaction
created

Oracle Supply Chain Management APIs and Open Interfaces for Rel 12 (Part No. B40113-01) Receiving Open Interface Page 16-61

The sample script uses the value SHIP for RTI.TRANSACTION_TYPE

By default the script will only create the Shipment Header and Shipment Lines.
Updating the following line in the script from TRUE to FALSE will cause Receiving Transactions  (RT) to be attempted:

V_CREATE_RSL_ONLY BOOLEAN := TRUE; -- If TRUE only RSL created. If FALSE RT will be attempted.



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