Skip to Main Content

E-Business Suite

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Approve Purchase Orders via SQL script

Ivan RuizNov 29 2019 — edited Feb 9 2021

Hello Team,

We constantly have stuck PO in 'In Process' status (we think the workflow is not working correctly). We are already investigating the cause but meanwhile we need a workaround to 'force' the approval of those stuck PO.

Is there any SQL script to force those PO to beĀ  approved directly from the Database or from the workflow administrator?

We are currently using another workaround which resets them into 'Incomplete' status to be approved again by the financial office but sometimes, even reseting them and trying to approve them again, they get stuck again in 'In process' status and that's why we are looking for a SQL script to approve them by force directly from the database.

Thank you

Comments
Post Details
Added on Nov 29 2019
2 comments
558 views