Edi Yanto (何 萬 新)

Receiving and Return Transaction with Receiving Open Interface (ROI)

Posted on: January 20, 2012


The Receiving Transaction Processor processes pending or unprocessed receiving transactions. We can receive the Purchase Order either using the Expected Receipt form or by putting the record into the Receiving Open Interface (ROI). And then if we will submit the receiving transactions processor so the PO will be received.
Records needs to be inserted into rcv_transactions_interface with processing_status_code and transaction_status_code as ‘PENDING’ and transaction_type of ‘RECEIVE’ and ‘DELIVER’ (Receiving). For Return Receiving transaction use the transaction_type of ‘RETURN TO RECEIVING’ (parent_transaction_id of transaction_id for DELIVER transaction) and transaction_type of ‘RETURN TO VENDOR’ (parent_transaction_id of transaction_id for RECEIVE transaction).

  • Interface Tables (for Lot and Serial Controlled Item)
    • RCV_HEADER_INTERFACE
    • RCV_TRANSACTIONS_INTERFACE
    • RCV_LOTS_INTERFACE
    • RCV_SERIALS_INTERFACE
    • MTL_TRANSACTION_LOTS_INTERFACE
    • MTL_SERIAL_NUMBER_INTERFACE
  • Base Tables
    • RCV_SHIPMENT_HEADERS
    • RCV_SHIPMENT_LINES
    • RCV_LOT_TRANSACTIONS
    • RCV_SERIAL_TRANSACTIONS
    • MTL_LOT_NUMBERS
    • MTL_SERIAL_NUMBERS
    • MTL_MATERIAL_TRANSACTIONS
  • Error Table
    • PO_INTERFACE_ERRORS

Tags:

17 Responses to "Receiving and Return Transaction with Receiving Open Interface (ROI)"

Hii ..
I have requirement to upload receiving transaction from legacy system to Oracle with quality status ACCEPT, is it possible ? because when I try many times still no luck ..
Thank you …

Like

Hi Lucky,

The steps to insert transaction type “ACCEPT” to ROI are:
1. set the Profile Option “QA:PO Inspection” to “Oracle Purchasing”
2. the PO already has RECEIVE transaction
3. insert ACCEPT record on the RECEIVE transaction
– TRANSACTION_TYPE = ‘ACCEPT’, INSPECTION_STATUS_CODE = ‘ACCEPTED’, INSPECTION_QUALITY_CODE = ‘Excellent’ (get the value from po_quality_codes)
4. Run the Receiving Transaction Processor for the specific Group ID on Purchasing Responsibility
5. Navigate to Receiving Transaction Summary form, find your receipt number and it will has RECEIVE and ACCEPT transaction

Btw, how about your steps?

Thanks,
Edi Yanto

Like

Very well explained blog… and quite explainatory reply of the query…
I appreciate…

Like

Thanks Prashant..🙂

Like

Hi
We have a requirement to perform Receive , Deliver and RTV(return to Vendor) in Oracle based on the data file sent by the legacy system as the actual Receiving process happens in a different system. The number of records in a file might be around 5k-8k records.

Any suggestion on bulk processing as the program has to perform Receive first and then Deliver and then RTV .

Like

Hi Vijay,

Transaction size is one of the issue of processing data textfile, maybe you can move all the data on text file to temporary table first using BULK COLLECT, after that process them to perfom Receive -> Deliver -> RTV.

Thanks,
Edi Yanto

Like

hi dude.i have a requirement.i had done receiving for direct delivery through rcv_transactions_interface.now i want to do correections on direct delivery.Please help me.

Like

Hi,
The period is closed but i have to pass transaction returns in Transaction Open Interface. Can i process, if so how can i do that.

Like

Hi Farooq,

Reopen the period first, after that pass he transation return to iface.

Thanks,
Edi Yanto

Like

Hi I want to Know the Interface table which is used for Purchasing Receipt for Lot Enabled Items.

RCV_HEADERS_INTERFACE

RCV_TRANSACTIONS_INTERFACE

RCV_LOTS_INTERFACE

RCV_SERIALS_INTERFACE

is there Any other Table for that?

Plz Give Me any Suggestions..!!

Like

Hi Sakthiarun,

MTL_TRANSACTION_LOTS_INTERFACE

Thanks,
Edi Yanto

Like

Hi Edi,
I have the below transaction to perform using ROI.
Receive–> Accept And Reject — Deliver the Accept the record– > Return to receive the delivered the record — again accept the record from return to receive.
i can able to complete the process upto return to receive.
i cant complete the accept from return to receive (using ROI)
The Error Was
WMSINB-23188:Lot/Serial validation failed
from INV_RCV_INTEGRATION_PVT.validate_lot_serial_info
while analysis of this package the function lot_entered_on_parent return true there was one entry available for the first accept because
but while perform transaction through form we dont have any entry for the first accept.

kindly help me to fix it.
Thanks
Mohan

Like

Hi Edi,
The above process for LOT Controlled item,if with out lot control i can able to perform the transaction.
Thanks
Mohan

Like

Hi ,

I’m getting Error In MTL_TRANSACTIONS_INTERFACE for WIP Return and WIP component issue transaction types
as ‘Could not find Parent Transaction for this Work Order-less component transaction’

Could You Help me on this issue

Like

Hi Azeez,

The causes of this error may be:
1. The Backflush Transactions are stuck in MTL_TRANSACTIONS_INTERFACE (MTI) table for a Flow Schedule when the parent record is not present in MTI.
2. The backflush transaction loses reference to the completion transaction. The completion transaction is already processed and exists in the history table (MTL_MATERIAL_TRANSACTIONS), but the reference to the completion transaction is missing.
3. Check the TRANSACTION_BATCH_ID in MTL_TRANSACTIONS_INTERFACE. If you are not populating the batch id, the transaction processor does not realize that the transactions should be processed together or fail together if there is a problem. The solution is to populate the TRANSACTION_BATCH_ID when populating the open interface table.

Thanks,
Edi Yanto

Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 1,368 other followers


Edi Yanto
Oracle Applications Technical Consultant
View Edi Yanto's profile on LinkedIn

My Certifications






Follow me on Twitter

Archives

January 2012
M T W T F S S
« May   Mar »
 1
2345678
9101112131415
16171819202122
23242526272829
3031  

Visitors

Categories

Blog Stats

  • 140,585 hits

Users Online

web counter

Pages

%d bloggers like this: