Rel 12 ezROI Script for Standard Purchase Orders Using ASN
(Doc ID 1333911.1)
Last updated on FEBRUARY 22, 2021
Applies to:Oracle Inventory Management - Version 12.0.0 and later
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) 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)
|SHIP||Shipment header and shipment lines
|Receiving transaction created||Receiving and delivery transaction
|RECEIVE||Receiving transaction created||Receiving transaction created||Receiving and delivery transaction
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:
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