OBIA 11g - Data Load Missing Load Plan Steps
(Doc ID 2206598.1)
Last updated on JUNE 04, 2018
Applies to:Business Intelligence Applications Consumer - Version 126.96.36.199.1 and later
Information in this document applies to any platform.
OBIA Version: 188.8.131.52.1 and 184.108.40.206.2
PeopleSoft: FMS 9.1, HCM 9.1 and CS 9.0
Offerings: Procurement and Spend and Financial
Configured OBIA according to the configuration guide. Then generated the load plan for Finance focused on General Ledger for example. Noticed that there are 0 rows in W_GL_BALANCE_F table.
When checking the generated load plan, particularly under 3 SDE Fact GLBAL_FG, there is only one scenario, which is SDE_PSFT_STAGE_GLBALANCEFACT_EXTRACT.
Further investigation shows that this scenario only loaded one of the temp tables but not the W_GL_BALANCE_FS, which is the source table expected later to eventually load W_GL_BALANCE_F table.
In this case, going to ODI -> Designer -> Load Plans and Scenarios -> BIAPPS Load Plan -> Load Plan Dev Components -> SDE -> PSFT_9_1 -> 3 SDE Fact GLBAL_FG PSFT_9_1, open it, it shows several other steps.
The missing steps are not in the generated load plan, but do exist in the "template" (System Load Plan).
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!