Procurement - EBS (MOSC)

MOSC Banner

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')

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center