Identify Orders Awaiting Extract
Summary:
We are currently live on Oracle Contract Management / Project Billing, Order Management, Subscription Management, Receivables, and Revenue Management. We have all of our integrations working as intended but are looking to see if we can further speed up processing of our integrations.
One area we have noticed slowness is in running the "Extract Sales Orders for Revenue Management" job as it needs to be run for each Business Unit.
My question is, can we identify from the database which records from OM are waiting to be extracted and then only run the extract job for those business units? Has anyone else attempted to write such a query?