Common Dimensions

This section lists the upgrade changes between 11.1.1.9.2 to 11.1.1.10.1 in Common Dimensions.

Supplier Site

  1. Tables with records updated:

    PeopleSoft 91 and 92 (On Premise)

    • W_SUPPLIER_ACCOUNT_D: VET_OWNED_FLG

    • W_SUPPLIER_ACCOUNT_D: HUB_ZONE_FLG

    • W_SUPPLIER_ACCOUNT_D: DISAB_VET_OWNED_FLG

  2. Issue and bug fixes covered:

    PeopleSoft

    • Added ability to source business classifications in Oracle BI Applications from PS_VNDR_RPT_ELEM.

Fiscal Calendar Dimension

  1. New feature introduced:

    • W_MCAL_CAL_DS and W_MCAL_CONTEXT_GS are added in 11.1.1.10.1.

      The existing SDE tasks for the corresponding W_MCAL_CAL_D and W_MCAL_CONTEXT_G table are now used to populate these new DS and GS tables. Additionally, new SIL tasks are created to load W_MCAL_CAL_D and W_MCAL_CONTEXT_G from the respective DS and GS tables.

      If you are using OLTP fiscal calendars, then this enhancement enables you to generate separate SDE and SIL+PLP load plans. Prior to this enhancement, you had to generate a single load plan that has both SDE and SIL+PLP. This enhancement enables you to load from multiple sources in parallel without inserting the unspec row, but deferring it to the SIL phase which would only add a single unspec row. Thereby avoiding the index failure error.

  2. Issues and bug fixes covered:

    • Created W_MCAL_CAL_DS for better implementation of Fiscal calendar ETL.