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

Question

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

Charles M · Answer

Thanks for the update, Avinash.

Avinash Pentyala · Answer

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 · Answer

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