Oracle Business Intelligence Applications

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIA 11g - how to run full load for HR load plan only

Received Response
11
Views
3
Comments

Hi All,

I configured OBIA 11.1.110.2 Financial and HR analytics and the source system is EBS R12. created 4 separated loads for each analytics as below

1. Financial domain only

2. financial  SDE and SIL

3. HR Domain only

4. HR SDE and SIL

Kindly advise how to run a full load for HR analytics?? is there any impact on finical data? if yes, what is the best approach to run a full load?

Regards,

Avinash

Answers

  • Charles M
    Charles M Rank 6 - Analytics Lead

    Hi Avinash,

    I don't believe this is possible (although, you may want to consult with Oracle support directly to confirm).

    In the meantime, have a look at these note for starters:

    OBI Apps 11G -- Triggering Full Load For One BI Apps Offering in Multiple Offering Environment (Doc ID 2033490.1)

    OBIA 11G: Can You do a Truncate and Load For a Particular Fact or Dimension Table? (Doc ID 2058982.1)

    Also ... you can search on "UPDATE W_ETL_LOAD_DATES SET COMMITTED=0" to see some examples of how to do this at the fact group/table level.

    Regards,

    Charles

  • Avinash Pentyala
    Avinash Pentyala Rank 5 - Community Champion

    Hi Charles,

    Thanks, I have verified with Oracle Support, currently OBIA doesn't have the option to run particular load plan as full load.

    Regards,

    Avinash

  • Charles M
    Charles M Rank 6 - Analytics Lead

    Thanks for the update, Avinash.