Step 1: insert the data interface tables as below
DECLARE
insert into po_headers_interface
(INTERFACE_HEADER_ID,
ACTION,
ORG_ID,
DOCUMENT_TYPE_CODE,
PO_HEADER_ID,
firm_flag
)
VALUES
(po_headers_interface_s.NEXTVAL,
'UPDATE',
82,-- ORG ID
'STANDAD',
67089, -- po header Id
);
insert into po_lines_interface
(INTERFACE_LINE_ID,
INTERFACE_HEADER_ID,
ACTION,
LINE_NUM,
shipment_num,
line_type,
ITEM_ID,
UNIT_PRICE,
quantity,
need_by_date)
values
(po_lines_interface_s.nextval,
po_headers_interface_s.CURRVAL,
2, -- Line num
2, -- Ship num
'Goods',
2, -- Item id
100000, unit pirce
1,
to_date('02-NOV-2015','DD-MON-YYYY')
);
COMMIT;
END;
Step 2 : Ran the standard "Import Standard Purchase order" program to move the data from interface tables to base tables.
Base tables : PO_HEADERS_ALL
PO_LINES_ALL
PO_LINE_LOCATIONS_ALL
PO_DISTRIBUTIONS_ALL
Error Table : PO_INTERFACE_ERRORS
DECLARE
insert into po_headers_interface
(INTERFACE_HEADER_ID,
ACTION,
ORG_ID,
DOCUMENT_TYPE_CODE,
PO_HEADER_ID,
firm_flag
)
VALUES
(po_headers_interface_s.NEXTVAL,
'UPDATE',
82,-- ORG ID
'STANDAD',
67089, -- po header Id
);
insert into po_lines_interface
(INTERFACE_LINE_ID,
INTERFACE_HEADER_ID,
ACTION,
LINE_NUM,
shipment_num,
line_type,
ITEM_ID,
UNIT_PRICE,
quantity,
need_by_date)
values
(po_lines_interface_s.nextval,
po_headers_interface_s.CURRVAL,
2, -- Line num
2, -- Ship num
'Goods',
2, -- Item id
100000, unit pirce
1,
to_date('02-NOV-2015','DD-MON-YYYY')
);
COMMIT;
END;
Step 2 : Ran the standard "Import Standard Purchase order" program to move the data from interface tables to base tables.
Base tables : PO_HEADERS_ALL
PO_LINES_ALL
PO_LINE_LOCATIONS_ALL
PO_DISTRIBUTIONS_ALL
Error Table : PO_INTERFACE_ERRORS
No comments:
Post a Comment