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
Here is the sample for po receipt interface for loctor controled on default and serial control on receipt
begin
INSERT INTO rcv_headers_interface
(header_interface_id,
GROUP_ID,
processing_status_code,
receipt_source_code,
asn_type,
transaction_type,
last_update_date,
last_updated_by,
last_update_login,
creation_date,
created_by,
shipment_num,
shipped_date,
vendor_id,
employee_id,
validation_flag,-- freight_amount,
--freight_carrier_code, num_of_containers,
ship_to_organization_code,
expected_receipt_date)
SELECT rcv_headers_interface_s.NEXTVAL,
rcv_interface_groups_s.NEXTVAL,
'PENDING',
'VENDOR',
'ASN',
'NEW',-- 'CANCEL',
SYSDATE,
1003,
1,
SYSDATE,
1003,
'SHIP-1234',
SYSDATE,
1,
245,
'Y',
'MAD',
SYSDATE + 5
FROM DUAL;
INSERT INTO rcv_transactions_interface
(interface_transaction_id,
header_interface_id,
GROUP_ID,
last_update_date,
last_updated_by,
creation_date,
created_by,
last_update_login,
transaction_type,
transaction_date,
processing_status_code,
processing_mode_code,
transaction_status_code,
quantity,
unit_of_measure,
auto_transact_code,
receipt_source_code,
source_document_code,
document_num,
release_num,
document_line_num,
document_shipment_line_num,
VENDOR_id ,
notice_unit_price,
validation_flag,
subinventory,
to_organization_code,
item_id ,
LOCATOR_id,
uom_code)
SELECT rcv_transactions_interface_s.NEXTVAL,
rcv_headers_interface_s.CURRVAL,
rcv_interface_groups_s.CURRVAL,
SYSDATE,
1003,
SYSDATE,
1003,
1,
'RECEIVE', --'SHIP', --'06-JAN-1998',
SYSDATE,
'PENDING',
'BATCH',
'PENDING',
2,
'EACH',
'DELIVER', --'SHIP',
'VENDOR',
'PO',
'39338',
'',
'1',
'',
1,
972,
'Y',
'01',
'MAD',
8,
1241,
'EA'
FROM DUAL;
INSERT INTO mtl_serial_numbers_interface
(transaction_interface_id,
last_update_date, last_updated_by,
creation_date, created_by,
last_update_login, fm_serial_number,
to_serial_number, product_code,
product_transaction_id
)
VALUES (mtl_material_transactions_s.NEXTVAL,
sysdate,
1003,
sysdate, 1003,1,
365879989,
365879990,
'RCV',
rcv_transactions_interface_s.CURRVAL
);
COMMIT ;
end;
References:
No comments:
Post a Comment