Synchronize upscope/downscope changes between Sales Order and Purchase Requisition/Order

One of the limitations of using Back to Back orders/Drop Ship in Oracle is not being able to auto-update upscope/downscope changes from Sales Order to Purchase Requisition/Purchase Orders.

In case of Drop Ship, it can be achieved by disabling the Processing Constraint on Ordered Quantity.

Order Management -> Setup -> Rules -> Security -> Processing Constraints

Identify the below constraint and disable it.
Update Constraint -> Ordered Quantity -> Validation Template "PO Approved"

But in case of B2B orders, how do you achieve this?

DBMS Scheduler

How to schedule a plsql script?

Above is the example if you have to run the script for second half of the month, on week days between 7 am to 9 pm incrementing every 6 minutes.
(I have created a procedure to submit the Workflow concurrent Program XBOL_SCHEDULE_WORKFLOW).

Integrate Oracle Projects with Order Management

Oracle has still not come up with a way to integrate Oracle Projects with Order Management.

With the use of the powerful "Workflow builder" and using standard APIs, we can integrate seamlessly between Projects and OM.

Oracle Web ADI

Oracle Web ADI leverages Desktop Application functionality for performing E-business Suite tasks.

I have been able to use this further to be able to create Custom Integrators for various modules.These custom Integrators are simple to build and easy to Use.
The Integrators can be used to Mass create/update Application data directly from the spreadsheets.