Thursday, October 7, 2010

PO Receipt interface

PO receipt interface is to interface the po receiving transactions.


Interface Tables
RCV_HEADERS_INTERFACE

RCV_TRANSACTION_INTERFACE.

MTL_SERIAL_NUMBERS_INTERFACE.

MTL_TRANSACTIONS_LOT_INTERFACE.

Interface Errors tables.
PO_INTERFACE_ERRORS.


Base tables.
RCV_SHIPMENT_HEADERS

RCV_SHIPMENT_LINES

RCV_TRANSACTIONS


These are the steps to be followed .


1. Insert header records into RCV_HEADERS_INTERFACE

2. insert transaction records information into RCV_TRANSACTION_INTERFACE.
3. Based on the control of the item
if item is serial controlled insert serial information in to MTL_SERIAL_NUMBERS_INTERFACE table

If the item is lot controlled item then insert records into lot interface table MTL_TRANSACTIONS_LOT_INTERFACE table.

4.Run Receiving Transaction Processor concurrent request.
5. For Receving errors run the report Receiving Interface Errors Report

No comments:

Post a Comment