We have a standard API to update some of the fields in an approved PO
Please try this once and let me know if this is solving your purpose.
Thanks for your response, since standard API updates only specific columns(Unit_Price, Quantity, Promised_Date and Need_By_Date) and column we are trying to update doesn't fall under these, I am trying for this approach of PDOI.
I think, PDOI is always used to insert. not for update.
Which field you want to update?
I am looking at 'Oracle Manufacturing APIs and Open Interface Manual', I am pointing to 'PO_HEADERS_INTERFACE' using Process_Code = 'PENDING' , Action = 'UPDATE' ,
'PO_LINES_INTERFACE' - Action - 'UPDATE'.
We are trying to update 'Contract_num'. field in PO_LINES_ALL.
Contract_num is in which table?