PO Receipt Conversion

Requirement – Details about PO Receipt Creation

Solution:

INSERT INTO rcv_headers_interface
(
header_interface_id
, group_id
, processing_status_code
, receipt_source_code
, transaction_type
, last_update_date
, last_updated_by
, last_update_login
, vendor_id
, receipt_num
, expected_receipt_date
, validation_flag
)
SELECT
rcv_headers_interface_s.NEXTVAL
, 1--rcv_interface_groups_s.NEXTVAL
, 'PENDING'
, 'VENDOR'
, 'NEW'
, SYSDATE
, 1--ln_user_id
, 0
, ln_vendor_id
, cur_inv.invoice_num
, SYSDATE
, 'Y'
FROM dual;

FOR cursor1 IN cur_item_reciept(cur_inv.invoice_num)
LOOP
IF cursor1.closed_code IN ('APPROVED','OPEN')
AND cursor1.quantity_received < cursor1.quantity
AND NVL(cursor1.cancel_flag,'N') = 'N' THEN

INSERT INTO rcv_transactions_interface
(
interface_transaction_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
, po_line_id
, item_id
, quantity
, unit_of_measure
, po_line_location_id
, auto_transact_code
, receipt_source_code
, to_organization_code
, source_document_code
, document_num
, header_interface_id
, validation_flag
)
SELECT
rcv_transactions_interface_s.NEXTVAL
, 1--rcv_interface_groups_s.CURRVAL
, SYSDATE
, ln_user_id
, SYSDATE
, ln_user_id
, 0
, 'RECEIVE'
, SYSDATE
, 'PENDING'
, 'BATCH'
, 'PENDING'
, cursor1.po_line_id
, cursor1.item_id
, cursor1.quantity
, cursor1.unit_meas_lookup_code
, cursor1.line_location_id
, 'RECEIVE'
, 'VENDOR'
, cursor1.organization_code
, 'PO'
, cursor1.segment1
, rcv_headers_interface_s.CURRVAL
, 'Y'
FROM dual;
Then run Receiving Transaction Processor.
Go through Metalink Doc - 307166.1
Cheersss...