PO's are approving directly by buyers
We have applied a data fix for InProgress Po's to change the status to incomplete. We are following AME approval process due to invalid approvers, we removed and chosen exiting approver as a final approver.
We followed below data fix in Test environment, when we try to approve PO, it's directly approving with buyer, please assist.
create table poh_03122019_bkp as select * from po_headers_all WHERE po_header_id = 1805402;
UPDATE po_headers_all
SET authorization_status = decode(approved_date, NULL, 'INCOMPLETE','REQUIRES REAPPROVAL'),
wf_item_type = NULL,
wf_item_key = NULL,
approved_flag = decode(approved_date, NULL, 'N', 'R')