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!

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

Shivashish Roy-Humana

Fortunately, I was able to resolve the issue and found that when ORDS Admin is configured via SQL developer it leaves the WORKSPACE id ="" which caused the URL mapping not to work and connect to DB for APEX to launch.  additionally the "updated=######### " was also missing.  so I deleted the URL mapping XML file from the config folder and re-created via command line

java -jar ords.war map-url --type regex http://trn-.* training

I was able to make it work as desired using the REGEX expression . see below

old configuration  1

<?xml version="1.0" encoding="UTF-8"?>
<pool-config xmlns="http://xmlns.oracle.com/apex/pool-config">
<pool name="training" uri-pattern="http://trn-.*" workspace-id=""/>
<pool name="test" uri-pattern="http://tst-.*" workspace-id=""/>
</pool-config>

old configuration  2

<?xml version="1.0" encoding="UTF-8"?>
<pool-config xmlns="http://xmlns.oracle.com/apex/pool-config">
<pool name="training" uri-pattern="http://trn/http://trn-.*"/>
<pool name="test" uri-pattern="http://tst/http://tst-.*"/>
</pool-config>

both the above old configuration didn't work

new configuration

<?xml version="1.0" encoding="UTF-8"?>
<pool-config xmlns="http://xmlns.oracle.com/apex/pool-config">
<pool name="training" uri-pattern="http://trn-.*" updated="2016-10-27T15:39:38.527Z"/>
<pool name="test" uri-pattern="http://tst-.*" updated="2016-10-27T15:39:38.527Z"/>
</pool-config>

1 - 1

Post Details

Added on Nov 29 2019
2 comments
1,034 views