How to perform a full load in BI Apps

28 May

In new BI APPS, the OOB tools (BI Application configuration Manager and Functional setup manager) are really helpful in terms of populating the Domain values automatically. And also it will provide a clear checklist of tasks that should be completed before doing a load. This is really an outstanding work from oracle to minimize the dependency on documentation to configure the BI Apps.

I have outlined the high-level steps to perform a BI Apps Full load into warehouse.

In BIACM (BI Application Configuration Manager): Login to biacm (http://<hostname>:<port>/biacm) and follow these instructions:

  1. Configure the Source System Connection Pool by choosing your Source Product Line and Version.

  2. Select the offerings e.g. Oracle Project Analytics/ Finance Analytics/ etc…

  3. Click on “Perform Functional Configurations” under Functional Configuration Task list and configure the Offerings in Functional Setup Manager (FSM). Here the FSM will provide us a checklist of the tasks we need to do like the list of parameters and other functional settings that we need to setup for a load.

  4. And come back to biacm application and click on “Manage Load Plans” under “Load Plans” Tasks list to create the Load Plans. In BI APPS, we have a provision to separate the Loads into mini batch loads to minimize the applications/database downtimes. Generally, we will create one Domain Load Plan (SDE, SIL) and one Source Extract and Load (SDE, SIL and PLP). But it’s all depends on the Load strategy we define and will create different set of Load plans like SDE, SIL and PLP.

    Domain Load Plan (SDE, SIL): which does extracting the data from Source system and populate the configuration files to load data into

    Source Extract and Load (SDE, SIL and PLP):

  5. Once we created the load plans, save them and generate the Load Plan details. Now click on Execute button to kick off the Load.

Once the Load plan is started, you can monitor the load with tasks by tasks status in ODI Console/ODI Studio. I would prefer the ODI studio as best practice to use to monitor the loads and troubleshooting the issues.

In ODI Studio:

After Load Plan started, Login to ODI Studio with biapps admin username and password, and navigate to Operator, to monitor the load plan with the steps (tasks) those are configured either in sequential or Parallel order for execution. Here you can see the overall Load Plan status by Tasks and also the summary of tasks execution to know how many are in the state of Done/Error/Running/Waiting etc..

We will troubleshoot the failed tasks and after issue fixes we have the ability to start that particular task individually. If any failed task ran successfully after fixes, The ODI will resume the load plan automatically to start next dependent (serial) tasks. Otherwise, we can also resume the Load plan with its “restart from the failure” option.

And also if we feel if the failed task is not a potential failure for the load, then we can “Mark as complete” it like DAC.

Upon Load Plan is successful, the ODI will load data into Warehouse and frees up the work tables where it was doing the transformations.

A sample Screen Shot of BI APPS Oracle Project Analytics Dashboard after a full load using ODI 11g:

Have a great time folks…




Tags: , , , , , , ,

12 responses to “How to perform a full load in BI Apps

  1. Naeem Akhtar

    May 29, 2013 at 6:25 am

    Thanks for useful post.

    Can you post something related to configuration of BI Apps like (Financial Anaylitics, HRMS Analytics) for some sample company (not with vision instance)

    Naeem Akhtar

  2. Dinesh

    May 30, 2013 at 4:05 pm

    Great job Shiva. Just a small technical suggestion. Screenshots above are non readable even after zoom. It would be great if snapshots are readable.

  3. ravi kumar

    May 31, 2013 at 6:18 am

    hi shiva
    while configuring bi apps i am getting the following error

    INST-07515: ODI Oracle home not found in the inventory

    Please guide me in resolving this issue


  4. Giridhar

    June 17, 2013 at 2:28 pm

    Thanks for sharing this info Shiva. It would be nice to setup ETL load Plan from OBIEE. I am curious on how does the load plan work if you have Informatica as an ETL tool vs ODI.

  5. raghunagadasari

    July 11, 2013 at 11:31 am

    Hi Shiva,
    Thanks for your Post and its really good. We are working in the similar project. When we are loading data for HR Analytics we are getting below error.

    ” oracle.odi.core.repository.UncategorizedRepositoryAccessException: ODI-10182: Uncategorized exception during repository access.”

    PLease see the below link for detailed Error Message.

    PLease help me on this issue.

    Thanks in Advance..
    Raghu Nagadasari

  6. Rp

    February 20, 2014 at 10:41 pm

    Can you run partial domain load plan without selecting all the fact groups. We have oracle financials and we are getting grk constraint violation errors when we run Domain only load plan for general ledger balance and ledger journals. Can’t find anything on whether partial load plans are allowed or not.

    • Rp

      February 20, 2014 at 10:42 pm

      I meant Fk violation errors.

  7. Eduardo

    August 29, 2014 at 6:39 pm

    Hi Shiva

    I already made the first load (full load) of information. What I need to do if I need to make a Full Load again, I missed some steps in the configuration and I need to realod the Info.

    Any advice?


    • vipul

      February 5, 2015 at 9:45 pm

      Hi Eduardo were you able to find out if there’s a way to make a full load again

      • arjun

        November 10, 2015 at 3:09 pm

        To do a full load again, you have to reset the warehouse data scenario. Very cumbersome tool

  8. Chuka Osemeka

    September 13, 2014 at 10:24 am

    The screen shots are unreadable!

    Can you give rereadable screen shots?

  9. Pingback: redyampavan

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: