Upgrade Business Analytics Warehouse Schema and Data
Use these instructions to upgrade the business analytics warehouse schema and data. Additionally, perform the mandatory steps applicable to Oracle Fusion Applications source.
-
Navigate to the Upgrade BIApps 111192 to 1111101 FUSION 9 load plan under Predefined Load Plans > Upgrade.
-
In the Property Inspector windows, set the applicable value for the IS_SDS_DEPLOYED variable for the root step.
-
Set the value to Y if the SDS is deployed.
-
Set the value to N if the SDS is not deployed.
-
Note:
The Upgrade Load Plans can only be executed from ODI Studio. Before running Domain-Only Load Plans, you must first execute Upgrade BIApps 111192 to 1111101 BIA11 Internal Tables predefined load plan in order to upgrade the data warehouse domain specific internal tables.
- Run the Internal load plan.
- No need to pass any Startup Value.
- Execute the specific adapter upgrade load plan to upgrade schema and warehouse data.
-
Note down the GENERATE_UPGRADE_DDL procedure failure step parameter values by opening the upgrade load plan.
Note:
If there is a failure in the schema upgrade such as a failure in Upgrade LP due to the Upgrade DW DDL procedure DDL statements execution on your warehouse, then perform these steps to run Upgrade DW DDL procedure from outside the upgrade LP.For example, in the image, four scenario variables are overwritten. You need to note down these parameter values and when running the Upgrade DW DDL procedure from outside the upgrade LP, you must use the same values.
BIAPPS.UTIL_GEN_UPG_DDL_TABLE_LIST: W_AP_HOLDS_F,W_AP_XACT_F,W_AR_XACT_F,W_PURCH_RQSTN_LINE_F,W_RQSTN_LINE_COST_F,W_NEG_RESPONSES_F,W_NEG_AWARDS_F,W_NEG_LINES_F,W_NEG_INVITATIONS_F,W_PURCH_COST_F,W_PURCH_RCPT_F,W_PURCH_SCHEDULE_LINE_F,W_PURCH_CHANGE_ORDER_F,W_AP_INV_DIST_F BIAPPS.UTIL_GEN_UPG_DDL_RUN_MODE -- COPY_MODE BIAPPS.UTIL_GENDDL_CHAR_CLAUSE -- Y BIAPPS.UTIL_GENDDL_RUN_DDL -- Y
- Navigate to the Designer tab in ODI Studio, go to BI Apps Project, then Components, the DW folder, next Oracle, and then select the Generate DW DDL folder path to open GENERATE_UPGRADE_DDL scenario.
- Click the Run icon to execute the procedure
While running the procedure, ODI Studio prompts for variable values as shown in the image:
Overwrite the four variable values that you noted down. Apart from the four variable values, overwrite
BIAPPS.UTIL_GENDDL_CREATE_SCRIPT_FILEvariable value withYto create a script file and also overwriteBIAPPS.UTIL_GENDDL_SCRIPT_LOCATIONvariable value with a valid server location to place the generated script and log files.Click on OK button to run the procedure.
