This section lists the upgrade changes between 11.1.1.9.2 to 11.1.1.10.1 in Common Dimensions.
Supplier Site
Tables with records updated:
W_SUPPLIER_ACCOUNT_D: VET_OWNED_FLG
W_SUPPLIER_ACCOUNT_D: HUB_ZONE_FLG
W_SUPPLIER_ACCOUNT_D: DISAB_VET_OWNED_FLG
Issue and bug fixes covered:
Added ability to source business classifications in Oracle BI Applications from PS_VNDR_RPT_ELEM
.
Fiscal Calendar Dimension
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.
Created W_MCAL_CAL_DS for better implementation of Fiscal calendar ETL.