Sunday, April 25, 2010

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).

Sunday, April 11, 2010

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.