Is BICC recommended approach for frequent scheduling? PFB the details: * What sort of data is being extracted? — Subscription and Assets Data * What is the data volume that you are expecting? — 300 records per day * How frequently we want the extraction? — 30 minutes * Where are we going to extract the data? — UCM server

You will have to figure this out from your end. Some of the points for you to consider: * How much of average data is extracted on daily basis * How many different PVOs are involved * Can some of the PVO extraction (if it is multiple PVOs) be pushed to off-business hours * Are all the PVOs being used are specifically recommended for BICC extraction or not Ultimately, the BICC would be using the OTBI engine and Fusion DB to extract the data, so it would certainly have some impact on your Fusion performance.

Oracle Communities

Oracle Analytics and AI

Child Item

BICC frequency recommendation

Prabhjeet Kaur

Is BICC recommended approach for frequent scheduling?

PFB the details:

What sort of data is being extracted? — Subscription and Assets Data
What is the data volume that you are expecting? — 300 records per day
How frequently we want the extraction? — 30 minutes
Where are we going to extract the data? — UCM server

Find more posts tagged with

BICC

Accepted answers

All comments

Nathan CCC

Hi, BICC is the recommended approach for "bulk extracts" (lots of rows). Using the SOAP or REST API or reports in OTBI is not recommended approach for "bulk extracts" (but lots of customers prefer this method).

For more information see

Oracle Fusion Cloud Applications Creating a Business Intelligence Cloud Extract F81528-01 23C

https://docs.oracle.com/en/cloud/saas/applications-common/23c/biacc/index.html#COPYRIGHT_0000

My Oracle Support https://support.oracle.com/

Oracle Applications Cloud: Data Export Best Practices (Doc ID 2615185.1)

Oracle Fusion Transactional Business Intelligence and BI Cloud Connector Performance Recommendations (Doc ID 2679006.1)

Prabhjeet Kaur

Thanks @Nathan CCC

We need the details how frequently BICC jobs can be scheduled. Will there be any impact on fusion performance if BICC jobs are scheduled to execute every 30 min for incremental data?

Shankar-Oracle

You will have to figure this out from your end. Some of the points for you to consider:

How much of average data is extracted on daily basis
How many different PVOs are involved
Can some of the PVO extraction (if it is multiple PVOs) be pushed to off-business hours
Are all the PVOs being used are specifically recommended for BICC extraction or not

Ultimately, the BICC would be using the OTBI engine and Fusion DB to extract the data, so it would certainly have some impact on your Fusion performance.

Nathan CCC

Hi Prabhjeet,

The latency is determined by the non functional supplemental requirements you have gathered from your consumers regards how out of date the data can be before it impact the business process. You can schedule as often as choose as a trade of between what your data extract consumers need versus what all the other users need to carry on doing their day to day data entry business process.

If you use the scheduler in BICC the values in the list of values for recurrence are immediate, hourly, daily, day of month, year. But you can also schedule as often as you wish by for example calling API to run the Enterprise Scheduler Service job definition for an extract schedule in BICC.

Each view object is a sql query. So you can read the sql in the view object to understand the impact it will have on the application database in terms of tables and views selected. And you can do data analysis on your data volumes over time to know how much data to expect to be extracted each period of time. Your extract will also put a load on the middleware not just the database.

Prabhjeet Kaur

Thanks @Nathan CCC