Edi Yanto (何 萬 新)

Receiving and Return Transaction with Receiving Open Interface (ROI)

Posted by: Edi Yanto 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

Advertisement
Tags:

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 )

Connecting to %s

RSS Syndication


Edi Yanto
Oracle Applications Technical Consultant
View Edi Yanto's profile on LinkedIn
Edi Yanto (何 萬 新) - Blogged Page Rank Check

My Certifications

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

Join 4 other followers

 

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

Top Rated

RSS Unknown Feed

  • An error has occurred; the feed is probably down. Try again later.

RSS detikcom: situs warta era digital

  • An error has occurred; the feed is probably down. Try again later.

 

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

Visitors

Categories

Blog Stats

  • 49,482 hits

Users Online

web counter

Pages

Follow

Get every new post delivered to your Inbox.