Can Work Confirmations (WC) Be Created Programmatically Using ROI? (Doc ID 1435396.1)

Last updated on JUNE 12, 2017

Applies to:

Oracle iSupplier Portal - Version 12.1.3 and later
Information in this document applies to any platform.

Goal

Is it possible to create Work Confirmations (WC) automatically? Does the ROI - Receiving Open Interface support WC creation?

Example:  Use the Receiving Open Interface (ROI) to create new work confirmation records for Complex Purchase Orders

Replication Steps:

1. Insert records into the rcv_headers_interface using data like:

RECEIPT_SOURCE_CODE VENDOR
ASN_TYPE WC
SHIPMENT_NUM --WC shipment Num

2. Insert records into the rcv_transactions_interface using data like:

INTERFACE_SOURCE_CODE ISP
TRANSACTION_TYPE RECEIVE
SHIPMENT_NUM -WC shipment Num

3. Run the Receiving Transaction Processor, for example for Advance Shipment Notices (ASNs) from suppliers.

At this moment all rows are processed without error and the Work Confirmations (WC) seems created without any problems.

Oracle Supply Chain Management APIs and Open Interfaces Guide Release 12
Part No. B40113-02
and
<Note:290489.1> (New Receiving Open Interface (ROI) Functionality in
Procurement Family Pack J/11.5.10) does not mention if importing WC receipt by ROI is supported.

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