API to allow config and especially ad-hoc run of BICC extracts and jobs

User_NQABC

Description

Request:

API to allow invocation of BICC extracts and BICC jobs (equivalent to manually creating a Schedule with Recurrence = "Immediate")
API to be synchronous – call does not return until extract is complete – and return an error code 
API to include everything possible manually via Console. For example configuring and running an ad-hoc BICC Incremental from a specific Effective Date

 

 

Use Case and Business Need

Our immediate issue is wanting to run a set of BICC extracts on completion of other jobs (eg. GL consolidations, allocations etc.) which we would coordinate via job dependencies in our enterprise scheduling tool (control m). We also want to move the BICC data extracts from UCM to our data lake as soon as they are available (via a job that runs immediately on completion of the BICC extract).

Current workaround is highly inadequate: schedule BICC jobs at 5am, hoping that GL jobs are complete. We then schedule the push of files from UCM to our data lake at 6am, hoping the BICC files are written - we have to set conservative time buffers which slows down the end to end process, and still risks possibility of previous step not being complete.

Original Idea Number: f6838757a8

Kim V

API to allow BICC extracts would make life a lot easier. Now it requires scripting to download all necessary files from the UCM. It would increase integration efforts if Oracle Development would provide such API for this generic code

User_NQABC

we might be in luck: 

https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=191416116083419&id=2453249.1&displayIndex=1&_afrWindowMode=0&_adf.ctrl-state=gvziqqkm8_80#FIXhttps://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=191416116083419&id=2453249.1&displayIndex=1&_afrWindowMode=0&_adf.ctrl-state=gvziqqkm8_80#FIX