How to reprocess po_requisitions_interface_all
In this post, We will discuss how we can reprocess the po_requisitions_interface_all
error out records to import in to the Oracle requisition base tables. We need
to update some columns in the interface table to process the rejected again
from po_requisitions_interface_all. Here below are the steps for how to
reprocess po_requisitions_interface_all.
Steps for How to reprocess po_requisitions_interface_all
UPDATE po_requisitions_interface_all
SET requisition_header_id = Null,
requisition_line_id = Null,
req_distribution_id = Null,
req_number_segment1 = Null,
process_flag = Null
WHERE process_flag = 'ERROR';
commit;
SET requisition_header_id = Null,
requisition_line_id = Null,
req_distribution_id = Null,
req_number_segment1 = Null,
process_flag = Null
WHERE process_flag = 'ERROR';
commit;
0 comments:
Post a Comment