General Issues and Workarounds

These topics involve general issues and workarounds for Oracle BI Applications.

Absence Fact Has Zero Rows

This issue applies to PeopleSoft Absence Adaptor.

The Assignment Integration ID in the Absence Event dimension is populated without spaces, while the Workforce fact table is populated with spaces. Due to this difference, the SIL Absence fact interface fails over the following join condition and no data is loaded to the Absence fact table:

W_WRKFC_EVT_F.ASSIGNMENT_ID = W_ABSENCE_EVENT_D.ASSIGNMENT_INTEGRATION_ID

Workaround

  1. Log in to the ODI repository using ODI Studio.
  2. Navigate to the SDE_PSFT_xx_Adaptor mapping folder and open the SDE_PSFT_AbsenceEventDimension_Preload.W_ABSENCE_EVENT_TMP interface.
  3. Navigate to Quick Edit, then Mappings tab, then ASSIGNMENT_INTEGRATION_ID Target Column Name.
  4. Open Mapping Expression and change the expression as follows: 
    from 
TRIM(SQ_ABSENCE_HIST.EMPLID)||'~'||TO_CHAR(SQ_ABSENCE_HIST.EMPL_RCD) 
to
SQ_ABSENCE_HIST.EMPLID||'~'||TO_CHAR(SQ_ABSENCE_HIST.EMPL_RCD
  5. Save the interface.
  6. Regenerate the scenario of this interface.
  7. Regenerate the load plan.

ETL Fails Due to ActivityResourcesFact and ActivityFact Failure

This issue applies to the Fusion adaptor.

ETL fails due to SDE_FUSION_ActivityFact and SDE_FUSION_ActivityResourcesFact failure.

Workaround

  1. Log into the Oracle Business Intelligence Administration Tool.
  2. In the Physical Layer, navigate to the Import Metadata option for CRManalytics.
  3. Select Activity, Activity Assignee, and ActivityContact view objects and click Import Selected.
  4. After importing, click Finish.

TABS in Sourcing Dashboard Do Not Show Report or Graph

Workaround

  1. Login to the environment with Administrator user.

  2. Browse the catalog to the Sourcing folder:

    /Shared/Procurement/Analytic Library/

  3. Find the Sourcing folder and click the More hyperlink below the Sourcing Folder and select Permissions.

  4. Select the two check boxes Apply permissions to Sub-folders and Apply permissions to item within folder below the Permissions dialog box and click OK.

    The logged in user should have at least one of these assigned roles to be able to access the content of the sourcing dashboard and reports in Release 9:

    • BI Administrator Role

    • Procurement Executive Analysis Duty

    • Procurement Managerial Analysis Duty

    • Procurement and Spend Executive for EBS

    • Procurement and Spend Executive for PSFT

    • Purchasing Buyer for EBS

    • Purchasing Buyer for PSFT

Regional Settings Are Not Saved After Logging In and Out

This issue applies to users who want to use the Configuration Manager and the Functional Setup Manager (FSM) in non-English languages.

The changes in Language (go to task Preferences, click Regional or Preferences, and select Language) are not saved properly after you log out of the application and log in again.

Workaround

After logging in, if the preference settings (for example, UI language, number format, date format, time format, time-zone) are not set to the required values, you can go to task Preferences, click Regional or Preferences, select Language, and change the preferences as required. Save the preferences and then continue to use other tasks without logging out.

Market Basket Analysis Facts and Dimensions Not Supported

Due to performance issues, Market Basket analysis related facts and dimensions are not supported.

List of logical facts not supported:

  • - Fact - CRM - Next Order Same Account

  • - Fact - CRM - Next Order Same Contact

  • - Fact - CRM - Order Item Same

  • - Fact - CRM - Product Affinity

List of logical dimensions not supported:

  • - Dim - Market Basket Product

  • - Dim - Next Product Purchased

Workaround

There is no workaround for this issue.

Fusion Direct Full Load ETL Results in SDE_FUSION_HRPERSONDIMENSION Failure

This issue applies to Fusion adaptor.

Fusion direct full load ETL results in SDE_FUSION_HRPERSONDIMENSION failure.

Workaround

Note:

Ensure that you perform these steps before generating a new load plan.
  1. Log in to ODI Studio and navigate to the Designer tab.
  2. Navigate to SDE_FUSION_HRPersonDimension.W_HR_PERSON_DS_SQ_PERSONDFF interface.
  3. Set column s_k_5000 as CAST(PERSONDFF.s_k_5000 AS VARCHAR(18)).
  4. Set column PERSONDFF_SRC_LAST_UPDATE_DATE as RUN_REPLICATED_TRANSACTIONAL("#IS_SDS_DEPLOYED", PERSONDFF.LastUpdateDate,          PERSONDFF.CDC$_SRC_LAST_UPDATE_DATE).
  5. Regenerate the scenario.

Human Resources E-Business Suite Payroll Patches for Payroll Analytics

This issue applies to Human Resources Analytics Payroll Subject Area for E-Business Suite.

If you are implementing Human Resources Analytics Payroll Subject Area for E-Business Suite, then it is mandatory to follow the E-Business Suite Payroll patching policy mentioned in My Oracle Support Note 295406.1 Mandatory Family Pack / Rollup Patch (RUP) levels for Oracle Payroll.

Load Plan Schedules Missing After Regeneration

This issue applies to the load plan regeneration.

After the load plan is regenerated in Configuration Manager, the load plan schedule is missing.

Workaround

Before regenerating a load plan, remove all existing schedules and recreate them after the regeneration is complete.

Non-supported Attributes and Metrics

This issue applies to notes on Inventory and Costing subject areas of PeopleSoft Data sources.

PeopleSoft:

The PeopleSoft data source does not support the following BMM Dimension Attributes:

"Core"."Dim - Lot"."Best By Date"

"Core"."Dim - Lot"."color"

"Core"."Dim - Lot"."Length"

"Core"."Dim - Lot"."Length UOM"

"Core"."Dim - Lot"."Thickness"

"Core"."Dim - Lot"."Thickness UOM"

"Core"."Dim - Lot"."Volume"

"Core"."Dim - Lot"."colume UOM"

"Core"."Dim - Lot"."Width"

"Core"."Dim - Lot"."Width UOM"

"Core"."Movement Type"."Transaction Action Code"

"Core"."Movement Type"."Transaction Action Description"

The PeopleSoft data sources does not support the following Metrics:

BMM:  "Core"."Fact - Supply Chain - Inventory Transaction"."Material Quantity"

BMM:  "Core"."Fact - Supply Chain - Inventory Transaction"."Material Amount"

BMM:  "Core"."Fact - Supply Chain - Inventory Transaction"."Total Material Amount Last 365 Days"

Presentation: "Inventory - Transactions".."Fact - Inventory Transactions"."Material Quantity"

Presentation: "Costing - Item Cost".."Fact - Costing - Item Cost"."Profit In Inventory"

Presentation: "Costing - Item Cost".."Fact - Costing - Item Cost"."Percentage of Profit In Inventory"

BMM: “Core”.”Fact – Supply Chain - Inventory Balance”.”In Transit Quantity”

BMM: “Core”.”Fact – Supply Chain - Inventory Balance”.”Receiving Quantity”

BMM: “Core”.”Fact – Supply Chain - Inventory Balance”.”Allocated Quantity”

BMM: “Core”.”Fact – Supply Chain - Inventory Balance”.”Un Allocated Quantity”

BMM: “Core”.”Fact – Supply Chain - Inventory Balance”.” # of Products Requiring Reorder”

BMM: “Core”.”Fact – Supply Chain - Inventory Balance”.”Value Only Amount”

BMM: “Core”.”Fact – Supply Chain - Inventory Balance”.”Value Transfer Amount”

BMM: “Core”.”Fact – Supply Chain - Inventory Balance”.”Returned Quantity”

BMM: “Core”.”Fact – Supply Chain - Inventory Balance”.”Replenishment Quantity”

BMM: “Core”.”Fact – Supply Chain - Inventory Balance”.” Inspection Consignment Quantity”

BMM: “Core”.”Fact – Supply Chain - Inventory Balance”.”Reorder Point”

BMM: “Core”.”Fact – Supply Chain - Inventory Balance”.” Inspection Amount”

BMM: “Core”.”Fact – Supply Chain - Inventory Balance”.”Returned Amount”

BMM: “Core”.”Fact – Supply Chain - Inventory Balance”.”Replenishment Amount”

BMM: “Core”.”Fact – Supply Chain - Inventory Balance”.”Inspection Consignment Amount”

BMM: “Core”.”Fact – Supply Chain - Inventory Balance”.”WIP Amount”

BMM: “Core”.”Fact – Supply Chain - Inventory Balance”.” Returned Quantity Year Ago”

BMM: “Core”.”Fact – Supply Chain - Inventory Balance”.” Chg Returned Quantity Year Ago”

BMM: “Core”.”Fact – Supply Chain - Inventory Balance”.” Chg Returned Quantity % Year Ago”

Presentation: “Facts - Inventory Balance”.”In Transit Quantity”

Presentation: “Facts - Inventory Balance”.”Receiving Quantity”

Presentation: “Facts - Inventory Balance”.”Allocated Quantity”

Presentation: “Facts - Inventory Balance”.”Un Allocated Quantity”

Presentation: “Facts - Inventory Balance”.”Replenishment Quantity”

Presentation: “Facts - Inventory Balance”.”Inspection Consignment Quantity”

Presentation: “Facts - Inventory Balance”.”# of Products Requiring Reorder”

The PeopleSoft data source does not support the following Presentation Subject Area:

Inventory - Bill of Materials

Inventory – Cycle Count

The PeopleSoft data source does not support the following Logical Tables and corresponding Dimensions:

Dim - Balancing Segment

Dim - Product Transaction Type (Stays deprecated)

Dim - Cost Valuation Unit
Notes on behavior of specific Attributes and Metrics on PeopleSoft data source:

  • BMM: "Core"."Fact - Supply Chain - Inventory Aging"."Days In Inventory"

    The “Days In Inventory” metric is defined as the number of days between the Date Received and the date of data extraction. The Date Received, for PeopleSoft Inventory, is retrieved from the latest Receipt Header record which matches a particular Physical Inventory record. If no Receipt Header can be found, then the Staged Date of the Physical Inventory is used. If there is no associated Receipt Header and no Staged Date for a Physical Inventory record, then Days In Inventory will not be populated for that record.

  • BMM: "Core"."Fact - Supply Chain - Inventory Aging"."Days Left Expiry" and “Days Since Expired” (affects of Date Received)

    The “Days Left Expiry” and “Days Since Expired” metrics are defined as the days between the Expiration Date for a Physical Inventory item and the date of data extraction. For lot controlled items, the Expiration Date is derived from the lot control record. For other items, the Expiration Date is derived by adding the item’s Shelf Life to the Date Received.

  • Plant Location

    In the PeopleSoft adaptor, Plant Locations are retrieved for every Business Unit which is marked with a Business Unit Type of “PLNT”. Only “PLNT” type Business Units are represented in the Plant Location Dimension.

Data Extraction Error 'XXXDFFBIVO of type View Definition is not found'

This issue applies to Fusion Applications on-premises data sources.

If during load plan execution you see the error message XXXDFFBIVO of type View Definition is not found(or similar), then you must check your Flexfield deployment. You might have an incomplete flexfield setup.

Workaround

Make sure that your flexfield setup is complete.

BI Metadata Repository Issue in Fusion Applications for Security View

Fusion Applications supports 18 levels of Territory Hierarchy, but the opaque security viewDim_Security_PrimaryTerritoryHierarchy_TerritoryResourceQuota' in the repository uses only 12 levels.

This results in a data security issue, where users are not able to view all records.

Workaround

  1. In Oracle BI Administration Tool, edit the repository.
  2. Click Physical, click Oracle Data Warehouse and select Dim_Security_PrimaryTerritoryHierarchy_TerritoryResourceQuota.
  3. Change the Default Initialization String to the following SQL statement:

    Note:

    In the SQL statement, for each of the Territory Hierarchy levels 0 to 17, repeat the 'OR' clause with a CASE statement 'case VALUEOF(n, NQ_SESSION.TERR_HIER_LEVEL_LIST)...'.
    select T.TERR_WID as TERR_WID,
'Y' as PRI_TERR_HIER_SEC_FLG
from W_TERR_DH T
where T.CURRENT_FLG = 'Y'
and
(
(
case VALUEOF(0, NQ_SESSION.TERR_HIER_LEVEL_LIST)
  when '0' then T.BASE_TERR_ID
  when '1' then T.LVL1_TERR_ID
  when '2' then T.LVL2_TERR_ID
  when '3' then T.LVL3_TERR_ID
  when '4' then T.LVL4_TERR_ID
  when '5' then T.LVL5_TERR_ID
  when '6' then T.LVL6_TERR_ID
  when '7' then T.LVL7_TERR_ID
  when '8' then T.LVL8_TERR_ID
  when '9' then T.LVL9_TERR_ID
  when '10' then T.LVL10_TERR_ID
  when '11' then T.LVL11_TERR_ID
  when '12' then T.LVL12_TERR_ID
  when '13' then T.LVL13_TERR_ID
  when '14' then T.LVL14_TERR_ID
  when '15' then T.LVL15_TERR_ID
  when '16' then T.LVL16_TERR_ID
  when '17' then T.TOP_LVL_TERR_ID
else 'NO_VALUE'
end
) in (VALUELISTOF(NQ_SESSION.SUPER_TERR_LIST))
or
(
case VALUEOF(1, NQ_SESSION.TERR_HIER_LEVEL_LIST)
  when '0' then T.BASE_TERR_ID
  when '1' then T.LVL1_TERR_ID
  when '2' then T.LVL2_TERR_ID
  when '3' then T.LVL3_TERR_ID
  when '4' then T.LVL4_TERR_ID
  when '5' then T.LVL5_TERR_ID
  when '6' then T.LVL6_TERR_ID
  when '7' then T.LVL7_TERR_ID
  when '8' then T.LVL8_TERR_ID
  when '9' then T.LVL9_TERR_ID
  when '10' then T.LVL10_TERR_ID
  when '11' then T.LVL11_TERR_ID
  when '12' then T.LVL12_TERR_ID
  when '13' then T.LVL13_TERR_ID
  when '14' then T.LVL14_TERR_ID
  when '15' then T.LVL15_TERR_ID
  when '16' then T.LVL16_TERR_ID
  when '17' then T.TOP_LVL_TERR_ID
else 'NO_VALUE'
end
) in (VALUELISTOF(NQ_SESSION.SUPER_TERR_LIST)) 
...
...and so on.
...
or
(
case VALUEOF(17, NQ_SESSION.TERR_HIER_LEVEL_LIST)
  when '0' then T.BASE_TERR_ID
  when '1' then T.LVL1_TERR_ID
  when '2' then T.LVL2_TERR_ID
  when '3' then T.LVL3_TERR_ID
  when '4' then T.LVL4_TERR_ID
  when '5' then T.LVL5_TERR_ID
  when '6' then T.LVL6_TERR_ID
  when '7' then T.LVL7_TERR_ID
  when '8' then T.LVL8_TERR_ID
  when '9' then T.LVL9_TERR_ID
  when '10' then T.LVL10_TERR_ID
  when '11' then T.LVL11_TERR_ID
  when '12' then T.LVL12_TERR_ID
  when '13' then T.LVL13_TERR_ID
  when '14' then T.LVL14_TERR_ID
  when '15' then T.LVL15_TERR_ID
  when '16' then T.LVL16_TERR_ID
  when '17' then T.TOP_LVL_TERR_ID
else 'NO_VALUE'
end
) in (VALUELISTOF(NQ_SESSION.SUPER_TERR_LIST))
)

Error While Running ETL in Windows 2008

This issue applies to running ETL in Windows 2008.

To resolve the error that you may encounter while running ETL in Windows 2008, use the following workaround.

Workaround

While running ETL in Windows, ensure that the file path in Configuration Manager to register src uses forward slashes as follows:

C:/work/biappsdw10.1dw/biappsmw3/Oracle_BI1/biapps/etl/data_files/src_files/PSFT_9_0

Employee Expense Dashboard Is Displayed Under Procurement Instead of Financial

This issue applies to Oracle Business Application – Procurement and Spend Analytics.

The Employee Expense Dashboard is displaying under Procurement, when it belongs only under Financial.

Workaround

  1. Log in to Oracle Business Intelligence Enterprise Edition.
  2. Display the Catalog.
  3. In the Folders pane, expand Shared Folders and Procurement.
  4. Click Dashboards.
  5. In the main panel, look for Employee Expenses, click More, and then click Properties.
  6. In the Properties window, click Hidden in the Attributes section.
  7. Click OK.

No External Data Support for UOM

For External data support, Unit Of Measure (UOM) maps need to call PL/SQL procedures in E-Business Suite to get the UOM conversions.

Workaround

Follow these instructions to manually generate the UOM Data from the E-Business Suite (EBS) source:

  1. Use the four SQL code examples to manually generate the UOM Data from the E-Business Suite (EBS) source.

    1. Replace the #BIAPPS.LANGUAGE_BASE with the correct values for your implementation.

    2. For an Incremental Load, replace 1=1 with the following filter value at places highlighted in the queries:

      CONV.LAST_UPDATE_DATE>TO_DATE(SUBSTR('#BIAPPS.LAST_EXTRACT_DATE',0,19),'YYYY-MM-DD HH24:MI:SS')
Example with values - CONV.LAST_UPDATE_DATE>TO_DATE(SUBSTR('2015-07-19 06:32:34',0,19),'YYYY-MM-DD HH24:MI:SS')

  2. Run each of these SQL code examples and create the csv file. The Name of the csv file should be in the following format:

    file_W_SDS_UOM_CONVERSION_....<SYSTIME>

  3. Copy this csv file in the Replicator directory where other csv files are stored.

  4. Ensure that the IS_SDS_DEPLOYED parameter is set to Y at the global level and at the Dimension Group Level for UOM_DIM. Use the Manage Dataload Parameters dialog in Configuration Manager to set the parameter.

  5. Continue with the normal load.

SQL Code Examples

Use the following SQL code examples:

Interclass

SELECT TO_CHAR(SQ_MTL_UOM_CONV_INTERCLASS.INVENTORY_ITEM_ID) PRODUCT_ID,
  TO_CHAR(SQ_MTL_UOM_CONV_INTERCLASS.ConversionRate) CONVERSION_RATE,
  TO_CHAR(SQ_MTL_UOM_CONV_INTERCLASS.CREATION_DATE, 'YYYY-MM-DD') CREATED_ON_DT,
TO_CHAR(NVL(SQ_MTL_UOM_CONV_INTERCLASS.LAST_UPDATE_DATE, SYSDATE), 'YYYY-MM-DD') CHANGED_ON_DT,
  TO_CHAR(SQ_MTL_UOM_CONV_INTERCLASS.CREATED_BY) CREATED_BY_ID,
  TO_CHAR(SQ_MTL_UOM_CONV_INTERCLASS.LAST_UPDATED_BY) CHANGED_BY_ID,
  SQ_MTL_UOM_CONV_INTERCLASS.X_CUSTOM X_CUSTOM,
  SQ_MTL_UOM_CONV_INTERCLASS.FROM_UOM_CODE FROM_UOM_CODE,
  SQ_MTL_UOM_CONV_INTERCLASS.TO_UOM_CODE TO_UOM_CODE,
  TO_CHAR(SQ_MTL_UOM_CONV_INTERCLASS.INVENTORY_ITEM_ID) INVENTORY_ITEM_ID
FROM
  (
  /* Subselect from SDE_ORA_UOMConversionGeneral_InterClass.W_UOM_CONVERSION_GS_SQ_MTL_UOM_CONV_INTERCLASS
  */
  SELECT UOM_CLASS_CONVERSIONS.INVENTORY_ITEM_ID INVENTORY_ITEM_ID,
    UOM_CLASS_CONVERSIONS.FROM_UOM_CODE FROM_UOM_CODE,
    UOM_CLASS_CONVERSIONS.TO_UOM_CODE TO_UOM_CODE,
    UOM_CLASS_CONVERSIONS.LAST_UPDATE_DATE LAST_UPDATE_DATE,
    UOM_CLASS_CONVERSIONS.LAST_UPDATED_BY LAST_UPDATED_BY,
    UOM_CLASS_CONVERSIONS.CREATION_DATE CREATION_DATE,
    UOM_CLASS_CONVERSIONS.CREATED_BY CREATED_BY,
    UOM_CLASS_CONVERSIONS.X_CUSTOM X_CUSTOM,
    INV_CONVERT.INV_UM_CONVERT_NEW( UOM_CLASS_CONVERSIONS.INVENTORY_ITEM_ID, 10, NULL, UOM_CLASS_CONVERSIONS.FROM_UOM_CODE, UOM_CLASS_CONVERSIONS.TO_UOM_CODE, NULL, NULL, 'U' ) ConversionRate
  FROM
    (
    /* Subselect from SDE_ORA_UOMConversionGeneral_InterClass.W_UOM_CONVERSION_GS_INTERCLASS_CLASS_CONVERSIONS
    */
    SELECT CONV.INVENTORY_ITEM_ID INVENTORY_ITEM_ID,
      UOM_FROM.UOM_CODE FROM_UOM_CODE,
      UOM_TO.UOM_CODE TO_UOM_CODE,
      NULL LAST_UPDATE_DATE,
      '0' LAST_UPDATED_BY,
      NULL CREATION_DATE,
      '0' CREATED_BY,
      '0' X_CUSTOM
    FROM APPS.MTL_UNITS_OF_MEASURE UOM_FROM,
      APPS.MTL_UNITS_OF_MEASURE UOM_TO,
      APPS.MTL_UOM_CLASS_CONVERSIONS CONV,
      APPS.MTL_SYSTEM_ITEMS_B ITEM
    WHERE (1                                =1)
    AND (UOM_TO.UOM_CODE                    =ITEM.PRIMARY_UOM_CODE
    AND CONV.INVENTORY_ITEM_ID              =ITEM.INVENTORY_ITEM_ID)
    AND (UOM_FROM.UOM_CLASS                 =CONV.FROM_UOM_CLASS)
    AND (UOM_TO.UOM_CLASS                   =CONV.TO_UOM_CLASS)
    AND (UOM_TO.LANGUAGE                    ='#BIAPPS.LANGUAGE_BASE')
    AND (UOM_FROM.LANGUAGE                  ='#BIAPPS.LANGUAGE_BASE')
    AND (NVL(CONV.DISABLE_DATE,SYSDATE)    >=SYSDATE)
    AND (NVL(UOM_FROM.DISABLE_DATE,SYSDATE)>=SYSDATE)
    AND (NVL(UOM_TO.DISABLE_DATE,SYSDATE)  >=SYSDATE)
    AND ( 1                                 =1 )
    UNION
    SELECT CONV.INVENTORY_ITEM_ID INVENTORY_ITEM_ID,
      UOM_TO.UOM_CODE FROM_UOM_CODE,
      UOM_FROM.UOM_CODE TO_UOM_CODE,
      NULL LAST_UPDATE_DATE,
      '0' LAST_UPDATED_BY,
      NULL CREATION_DATE,
      '0' CREATED_BY,
      '0' X_CUSTOM
    FROM APPS.MTL_UNITS_OF_MEASURE UOM_FROM,
      APPS.MTL_UNITS_OF_MEASURE UOM_TO,
      APPS.MTL_UOM_CLASS_CONVERSIONS CONV,
      APPS.MTL_SYSTEM_ITEMS_B ITEM
    WHERE (1                                =1)
    AND (CONV.INVENTORY_ITEM_ID             = ITEM.INVENTORY_ITEM_ID
    AND UOM_FROM.UOM_CODE                   = ITEM.PRIMARY_UOM_CODE)
    AND (UOM_FROM.UOM_CLASS                 =CONV.FROM_UOM_CLASS)
    AND (UOM_TO.UOM_CLASS                   =CONV.TO_UOM_CLASS)
    AND (UOM_FROM.LANGUAGE                  ='#BIAPPS.LANGUAGE_BASE')
    AND (UOM_TO.LANGUAGE                    ='#BIAPPS.LANGUAGE_BASE')
    AND (NVL(CONV.DISABLE_DATE,SYSDATE)    >=SYSDATE)
    AND (NVL(UOM_FROM.DISABLE_DATE,SYSDATE)>=SYSDATE)
    AND (NVL(UOM_TO.DISABLE_DATE,SYSDATE)  >=SYSDATE)
    AND ( 1                                 =1 )
    ) UOM_CLASS_CONVERSIONS
  WHERE (1=1)
  MINUS
  SELECT UOM_NON_CLASS_CONVERSIONS.INVENTORY_ITEM_ID INVENTORY_ITEM_ID,
    UOM_NON_CLASS_CONVERSIONS.FROM_UOM_CODE FROM_UOM_CODE,
    UOM_NON_CLASS_CONVERSIONS.TO_UOM_CODE TO_UOM_CODE,
    UOM_NON_CLASS_CONVERSIONS.LAST_UPDATE_DATE LAST_UPDATE_DATE,
    UOM_NON_CLASS_CONVERSIONS.LAST_UPDATED_BY LAST_UPDATED_BY,
    UOM_NON_CLASS_CONVERSIONS.CREATION_DATE CREATION_DATE,
    UOM_NON_CLASS_CONVERSIONS.CREATED_BY CREATED_BY,
    UOM_NON_CLASS_CONVERSIONS.X_CUSTOM X_CUSTOM,
    INV_CONVERT.INV_UM_CONVERT_NEW( UOM_NON_CLASS_CONVERSIONS.INVENTORY_ITEM_ID, 10, NULL, UOM_NON_CLASS_CONVERSIONS.FROM_UOM_CODE, UOM_NON_CLASS_CONVERSIONS.TO_UOM_CODE, NULL, NULL, 'U' ) ConversionRate
  FROM
    (
    /* Subselect from SDE_ORA_UOMConversionGeneral_InterClass.W_UOM_CONVERSION_GS_INTERCLASS_NON_CLASS_CONVERSIONS
    */
    SELECT CONV.INVENTORY_ITEM_ID INVENTORY_ITEM_ID,
      FROM_UOM.UOM_CODE FROM_UOM_CODE,
      TO_UOM.UOM_CODE TO_UOM_CODE,
      NULL LAST_UPDATE_DATE,
      '0' LAST_UPDATED_BY,
      NULL CREATION_DATE,
      '0' CREATED_BY,
      '0' X_CUSTOM
    FROM APPS.MTL_UOM_CONVERSIONS CONV,
      APPS.MTL_UNITS_OF_MEASURE FROM_UOM,
      APPS.MTL_UNITS_OF_MEASURE TO_UOM,
      APPS.MTL_SYSTEM_ITEMS_B ITEM
    WHERE (1                              =1)
    AND (CONV.INVENTORY_ITEM_ID           =ITEM.INVENTORY_ITEM_ID
    AND TO_UOM.UOM_CODE                   =ITEM.PRIMARY_UOM_CODE)
    AND (CONV.UOM_CLASS                   =TO_UOM.UOM_CLASS)
    AND (CONV.UOM_CLASS                   =FROM_UOM.UOM_CLASS)
    AND (FROM_UOM.UNIT_OF_MEASURE         =CONV.UNIT_OF_MEASURE)
    AND (FROM_UOM.LANGUAGE                ='#BIAPPS.LANGUAGE_BASE')
    AND (TO_UOM.LANGUAGE                  ='#BIAPPS.LANGUAGE_BASE')
    AND (NVL(TO_UOM.DISABLE_DATE,SYSDATE)>=SYSDATE)
    AND (NVL(CONV.DISABLE_DATE,SYSDATE)  >=SYSDATE)
        AND ( 1                               =1 )
    UNION
    SELECT CONV.INVENTORY_ITEM_ID INVENTORY_ITEM_ID,
      FROM_UOM.UOM_CODE FROM_UOM_CODE,
      TO_UOM.UOM_CODE TO_UOM_CODE,
      NULL LAST_UPDATE_DATE,
      '0' LAST_UPDATED_BY,
      NULL CREATION_DATE,
      '0' CREATED_BY,
      '0' X_CUSTOM
    FROM APPS.MTL_UOM_CONVERSIONS CONV,
      APPS.MTL_UNITS_OF_MEASURE FROM_UOM,
      APPS.MTL_UNITS_OF_MEASURE TO_UOM,
      APPS.MTL_SYSTEM_ITEMS_B ITEM
    WHERE (1                                =1)
    AND (CONV.INVENTORY_ITEM_ID             =ITEM.INVENTORY_ITEM_ID
    AND TO_UOM.UOM_CODE                     =ITEM.PRIMARY_UOM_CODE)
    AND (CONV.UOM_CLASS                     =FROM_UOM.UOM_CLASS)
    AND (CONV.UOM_CLASS                     =TO_UOM.UOM_CLASS)
    AND (TO_UOM.UNIT_OF_MEASURE             =CONV.UNIT_OF_MEASURE)
    AND (FROM_UOM.LANGUAGE                  ='#BIAPPS.LANGUAGE_BASE')
    AND (TO_UOM.LANGUAGE                    ='#BIAPPS.LANGUAGE_BASE')
    AND (NVL(FROM_UOM.DISABLE_DATE,SYSDATE)>=SYSDATE)
    AND (NVL(CONV.DISABLE_DATE,SYSDATE)    >=SYSDATE)
    AND ( 1                                 =1 )
    ) UOM_NON_CLASS_CONVERSIONS
  WHERE (1=1)
  ) SQ_MTL_UOM_CONV_INTERCLASS
WHERE (1=1)

Interclass_Resource

SELECT TO_CHAR(SQ_MTL_UOM_CONV_INTERCLASS.INVENTORY_ITEM_ID) PRODUCT_ID,
  TO_CHAR(SQ_MTL_UOM_CONV_INTERCLASS.ConversionRate) CONVERSION_RATE,
  TO_CHAR(SQ_MTL_UOM_CONV_INTERCLASS.CREATION_DATE, 'YYYY-MM-DD') CREATED_ON_DT,
TO_CHAR(NVL(SQ_MTL_UOM_CONV_INTERCLASS.LAST_UPDATE_DATE, SYSDATE), 'YYYY-MM-DD') CHANGED_ON_DT,
  TO_CHAR(SQ_MTL_UOM_CONV_INTERCLASS.CREATED_BY) CREATED_BY_ID,
  TO_CHAR(SQ_MTL_UOM_CONV_INTERCLASS.LAST_UPDATED_BY) CHANGED_BY_ID,
  SQ_MTL_UOM_CONV_INTERCLASS.X_CUSTOM X_CUSTOM,
  SQ_MTL_UOM_CONV_INTERCLASS.FROM_UOM_CODE FROM_UOM_CODE,
  SQ_MTL_UOM_CONV_INTERCLASS.TO_UOM_CODE TO_UOM_CODE,
  TO_CHAR(SQ_MTL_UOM_CONV_INTERCLASS.INVENTORY_ITEM_ID) INVENTORY_ITEM_ID
FROM
  (
  /* Subselect from SDE_ORA_UOMConversionGeneral_InterClass_Resource.W_UOM_CONVERSION_GS_SQ_MTL_UOM_CONV_INTERCLASS
  */
  SELECT UOM_CLASS_CONVERSIONS.INVENTORY_ITEM_ID INVENTORY_ITEM_ID,
    UOM_CLASS_CONVERSIONS.FROM_UOM_CODE FROM_UOM_CODE,
    UOM_CLASS_CONVERSIONS.TO_UOM_CODE TO_UOM_CODE,
    UOM_CLASS_CONVERSIONS.LAST_UPDATE_DATE LAST_UPDATE_DATE,
    UOM_CLASS_CONVERSIONS.LAST_UPDATED_BY LAST_UPDATED_BY,
    UOM_CLASS_CONVERSIONS.CREATION_DATE CREATION_DATE,
    UOM_CLASS_CONVERSIONS.CREATED_BY CREATED_BY,
    UOM_CLASS_CONVERSIONS.X_CUSTOM X_CUSTOM,
    INV_CONVERT.INV_UM_CONVERT_NEW( UOM_CLASS_CONVERSIONS.INVENTORY_ITEM_ID, 10, NULL, UOM_CLASS_CONVERSIONS.FROM_UOM_CODE, UOM_CLASS_CONVERSIONS.TO_UOM_CODE, NULL, NULL, 'U' ) ConversionRate
  FROM
    (
    /* Subselect from SDE_ORA_UOMConversionGeneral_InterClass_Resource.W_UOM_CONVERSION_GS_INTERCLASS_CLASS_CONVERSIONS
    */
    SELECT CONV.INVENTORY_ITEM_ID INVENTORY_ITEM_ID,
      UOM_FROM.UOM_CODE FROM_UOM_CODE,
      UOM_TO.UOM_CODE TO_UOM_CODE,
      NULL LAST_UPDATE_DATE,
      '0' LAST_UPDATED_BY,
      NULL CREATION_DATE,
      '0' CREATED_BY,
      '0' X_CUSTOM
    FROM APPS.MTL_UNITS_OF_MEASURE UOM_FROM,
      APPS.MTL_UNITS_OF_MEASURE UOM_TO,
      APPS.MTL_UOM_CLASS_CONVERSIONS CONV
    WHERE (1                                =1)
    AND (UOM_TO.UOM_CLASS                   =CONV.TO_UOM_CLASS)
    AND (UOM_FROM.UOM_CLASS                 =CONV.FROM_UOM_CLASS)
    AND ( 1                                 =1 )
    AND (NVL(UOM_FROM.DISABLE_DATE,SYSDATE)>=SYSDATE)
    AND (NVL(UOM_TO.DISABLE_DATE,SYSDATE)  >=SYSDATE)
    AND (NVL(CONV.DISABLE_DATE,SYSDATE)    >=SYSDATE)
    AND (UOM_TO.LANGUAGE                    ='#BIAPPS.LANGUAGE_BASE')
    AND (UOM_FROM.LANGUAGE                  ='#BIAPPS.LANGUAGE_BASE')
    AND (CONV.INVENTORY_ITEM_ID             =0)
    UNION
    SELECT CONV.INVENTORY_ITEM_ID INVENTORY_ITEM_ID,
      UOM_TO.UOM_CODE FROM_UOM_CODE,
      UOM_FROM.UOM_CODE TO_UOM_CODE,
      NULL LAST_UPDATE_DATE,
      '0' LAST_UPDATED_BY,
      NULL CREATION_DATE,
      '0' CREATED_BY,
      '0' X_CUSTOM
    FROM APPS.MTL_UNITS_OF_MEASURE UOM_FROM,
      APPS.MTL_UNITS_OF_MEASURE UOM_TO,
      APPS.MTL_UOM_CLASS_CONVERSIONS CONV
    WHERE (1                                =1)
    AND (UOM_FROM.UOM_CLASS                 =CONV.FROM_UOM_CLASS)
    AND (UOM_TO.UOM_CLASS                   =CONV.TO_UOM_CLASS)
    AND ( 1                                 =1 )
    AND (NVL(UOM_FROM.DISABLE_DATE,SYSDATE)>=SYSDATE)
    AND (NVL(UOM_TO.DISABLE_DATE,SYSDATE)  >=SYSDATE)
    AND (NVL(CONV.DISABLE_DATE,SYSDATE)    >=SYSDATE)
    AND (UOM_TO.LANGUAGE                    ='#BIAPPS.LANGUAGE_BASE')
    AND (UOM_FROM.LANGUAGE                  ='#BIAPPS.LANGUAGE_BASE')
    AND (CONV.INVENTORY_ITEM_ID             =0)
    ) UOM_CLASS_CONVERSIONS
  WHERE (1=1)
  MINUS
  SELECT UOM_NON_CLASS_CONVERSIONS.INVENTORY_ITEM_ID INVENTORY_ITEM_ID,
    UOM_NON_CLASS_CONVERSIONS.FROM_UOM_CODE FROM_UOM_CODE,
    UOM_NON_CLASS_CONVERSIONS.TO_UOM_CODE TO_UOM_CODE,
    UOM_NON_CLASS_CONVERSIONS.LAST_UPDATE_DATE LAST_UPDATE_DATE,
    UOM_NON_CLASS_CONVERSIONS.LAST_UPDATED_BY LAST_UPDATED_BY,
    UOM_NON_CLASS_CONVERSIONS.CREATION_DATE CREATION_DATE,
    UOM_NON_CLASS_CONVERSIONS.CREATED_BY CREATED_BY,
    UOM_NON_CLASS_CONVERSIONS.X_CUSTOM X_CUSTOM,
    INV_CONVERT.INV_UM_CONVERT_NEW( UOM_NON_CLASS_CONVERSIONS.INVENTORY_ITEM_ID, 10, NULL, UOM_NON_CLASS_CONVERSIONS.FROM_UOM_CODE, UOM_NON_CLASS_CONVERSIONS.TO_UOM_CODE, NULL, NULL, 'U' ) ConversionRate
  FROM
    (
    /* Subselect from SDE_ORA_UOMConversionGeneral_InterClass_Resource.W_UOM_CONVERSION_GS_INTERCLASS_NON_CLASS_CONVERSIONS
    */
    SELECT CONV.INVENTORY_ITEM_ID INVENTORY_ITEM_ID,
      FROM_UOM.UOM_CODE FROM_UOM_CODE,
      TO_UOM.UOM_CODE TO_UOM_CODE,
      NULL LAST_UPDATE_DATE,
      '0' LAST_UPDATED_BY,
      NULL CREATION_DATE,
      '0' CREATED_BY,
      '0' X_CUSTOM
    FROM APPS.MTL_UOM_CONVERSIONS CONV,
      APPS.MTL_UNITS_OF_MEASURE FROM_UOM,
      APPS.MTL_UNITS_OF_MEASURE TO_UOM
    WHERE (1                              =1)
    AND (CONV.UOM_CLASS                   =FROM_UOM.UOM_CLASS)
    AND (FROM_UOM.UNIT_OF_MEASURE         =CONV.UNIT_OF_MEASURE)
    AND (CONV.UOM_CLASS                   =TO_UOM.UOM_CLASS)
    AND (NVL(CONV.DISABLE_DATE,SYSDATE)  >=SYSDATE)
    AND (NVL(TO_UOM.DISABLE_DATE,SYSDATE)>=SYSDATE)
    AND ( 1                               =1 )
    AND (TO_UOM.LANGUAGE                  ='#BIAPPS.LANGUAGE_BASE')
    AND (FROM_UOM.LANGUAGE                ='#BIAPPS.LANGUAGE_BASE')
    AND (CONV.INVENTORY_ITEM_ID           =0)
    UNION
    SELECT CONV.INVENTORY_ITEM_ID INVENTORY_ITEM_ID,
      FROM_UOM.UOM_CODE FROM_UOM_CODE,
      TO_UOM.UOM_CODE TO_UOM_CODE,
      NULL LAST_UPDATE_DATE,
      '0' LAST_UPDATED_BY,
      NULL CREATION_DATE,
      '0' CREATED_BY,
      '0' X_CUSTOM
    FROM APPS.MTL_UOM_CONVERSIONS CONV,
      APPS.MTL_UNITS_OF_MEASURE FROM_UOM,
      APPS.MTL_UNITS_OF_MEASURE TO_UOM
    WHERE (1                                =1)
    AND (TO_UOM.UNIT_OF_MEASURE             =CONV.UNIT_OF_MEASURE)
    AND (CONV.UOM_CLASS                     =TO_UOM.UOM_CLASS)
    AND (CONV.UOM_CLASS                     =FROM_UOM.UOM_CLASS)
    AND ( 1                                 =1 )
    AND (NVL(FROM_UOM.DISABLE_DATE,SYSDATE)>=SYSDATE)
    AND (NVL(CONV.DISABLE_DATE,SYSDATE)    >=SYSDATE)
    AND (FROM_UOM.LANGUAGE                  ='#BIAPPS.LANGUAGE_BASE')
    AND (TO_UOM.LANGUAGE                    ='#BIAPPS.LANGUAGE_BASE')
    AND (CONV.INVENTORY_ITEM_ID             =0)
    ) UOM_NON_CLASS_CONVERSIONS
  WHERE (1=1)
  ) SQ_MTL_UOM_CONV_INTERCLASS
WHERE (1=1)

Intraclass

SELECT TO_CHAR(SQ_MTL_UOM_CONV_INTRACLASS.INVENTORY_ITEM_ID) PRODUCT_ID,
  TO_CHAR(SQ_MTL_UOM_CONV_INTRACLASS.ConversionRate) CONVERSION_RATE,
  TO_CHAR(SQ_MTL_UOM_CONV_INTRACLASS.CREATION_DATE, 'YYYY-MM-DD') CREATED_ON_DT,
TO_CHAR(NVL(SQ_MTL_UOM_CONV_INTRACLASS.LAST_UPDATE_DATE, SYSDATE), 'YYYY-MM-DD') CHANGED_ON_DT,
  TO_CHAR(SQ_MTL_UOM_CONV_INTRACLASS.CREATED_BY) CREATED_BY_ID,
  TO_CHAR(SQ_MTL_UOM_CONV_INTRACLASS.LAST_UPDATED_BY) CHANGED_BY_ID,
  SQ_MTL_UOM_CONV_INTRACLASS.X_CUSTOM X_CUSTOM,
  SQ_MTL_UOM_CONV_INTRACLASS.FROM_UOM_CODE FROM_UOM_CODE,
  SQ_MTL_UOM_CONV_INTRACLASS.TO_UOM_CODE TO_UOM_CODE,
  TO_CHAR(SQ_MTL_UOM_CONV_INTRACLASS.INVENTORY_ITEM_ID) INVENTORY_ITEM_ID
FROM
  (
  /* Subselect from SDE_ORA_UOMConversionGeneral_IntraClass.W_UOM_CONVERSION_GS_SQ_MTL_UOM_CONV_INTRACLASS
  */
  SELECT CONV.INVENTORY_ITEM_ID INVENTORY_ITEM_ID,
    FROM_UOM.UOM_CODE FROM_UOM_CODE,
    TO_UOM.UOM_CODE TO_UOM_CODE,
    NULL LAST_UPDATE_DATE,
    '0' LAST_UPDATED_BY,
    NULL CREATION_DATE,
    '0' CREATED_BY,
    '0' X_CUSTOM,
    INV_CONVERT.INV_UM_CONVERT_NEW( CONV.INVENTORY_ITEM_ID, 10, NULL, FROM_UOM.UOM_CODE, TO_UOM.UOM_CODE, NULL, NULL, 'U' ) ConversionRate
  FROM APPS.MTL_UOM_CONVERSIONS CONV,
    APPS.MTL_UNITS_OF_MEASURE FROM_UOM,
    APPS.MTL_UNITS_OF_MEASURE TO_UOM,
    APPS.MTL_SYSTEM_ITEMS_B ITEM
  WHERE (1                              =1)
  AND (TO_UOM.UOM_CODE                  = ITEM.PRIMARY_UOM_CODE
  AND CONV.INVENTORY_ITEM_ID            = ITEM.INVENTORY_ITEM_ID)
  AND (CONV.UOM_CLASS                   =TO_UOM.UOM_CLASS)
  AND (CONV.UOM_CLASS                   =FROM_UOM.UOM_CLASS)
  AND (FROM_UOM.UNIT_OF_MEASURE         =CONV.UNIT_OF_MEASURE)
  AND (FROM_UOM.LANGUAGE                ='#BIAPPS.LANGUAGE_BASE')
  AND (TO_UOM.LANGUAGE                  ='#BIAPPS.LANGUAGE_BASE')
  AND (NVL(TO_UOM.DISABLE_DATE,SYSDATE)>=SYSDATE)
  AND (NVL(CONV.DISABLE_DATE,SYSDATE)  >=SYSDATE)
  AND ( 1                               =1 )
  UNION
  SELECT CONV.INVENTORY_ITEM_ID INVENTORY_ITEM_ID,
    FROM_UOM.UOM_CODE FROM_UOM_CODE,
    TO_UOM.UOM_CODE TO_UOM_CODE,
    NULL LAST_UPDATE_DATE,
    '0' LAST_UPDATED_BY,
    NULL CREATION_DATE,
    '0' CREATED_BY,
    '0' X_CUSTOM,
    INV_CONVERT.INV_UM_CONVERT_NEW( CONV.INVENTORY_ITEM_ID, 10, NULL, FROM_UOM.UOM_CODE, TO_UOM.UOM_CODE, NULL, NULL, 'U' ) ConversionRate
  FROM APPS.MTL_UOM_CONVERSIONS CONV,
    APPS.MTL_UNITS_OF_MEASURE FROM_UOM,
    APPS.MTL_UNITS_OF_MEASURE TO_UOM,
    APPS.MTL_SYSTEM_ITEMS_B ITEM
  WHERE (1                                =1)
  AND (TO_UOM.UOM_CODE                    = ITEM.PRIMARY_UOM_CODE
  AND CONV.INVENTORY_ITEM_ID              =ITEM.INVENTORY_ITEM_ID)
  AND (CONV.UOM_CLASS                     =FROM_UOM.UOM_CLASS)
  AND (CONV.UOM_CLASS                     =TO_UOM.UOM_CLASS)
  AND (TO_UOM.UNIT_OF_MEASURE             =CONV.UNIT_OF_MEASURE)
  AND (FROM_UOM.LANGUAGE                  ='#BIAPPS.LANGUAGE_BASE')
  AND (TO_UOM.LANGUAGE                    ='#BIAPPS.LANGUAGE_BASE')
  AND (NVL(FROM_UOM.DISABLE_DATE,SYSDATE)>=SYSDATE)
  AND (NVL(CONV.DISABLE_DATE,SYSDATE)    >=SYSDATE)
  AND ( 1                                 =1 )
  ) SQ_MTL_UOM_CONV_INTRACLASS
WHERE (1=1)

Intraclass_Resource

SELECT TO_CHAR(SQ_MTL_UOM_CONV_INTRACLASS.INVENTORY_ITEM_ID) PRODUCT_ID,
  TO_CHAR(SQ_MTL_UOM_CONV_INTRACLASS.ConversionRate) CONVERSION_RATE,
  TO_CHAR(SQ_MTL_UOM_CONV_INTRACLASS.CREATION_DATE, 'YYYY-MM-DD') CREATED_ON_DT,
TO_CHAR(NVL(SQ_MTL_UOM_CONV_INTRACLASS.LAST_UPDATE_DATE, SYSDATE), 'YYYY-MM-DD') CHANGED_ON_DT,
  TO_CHAR(SQ_MTL_UOM_CONV_INTRACLASS.CREATED_BY) CREATED_BY_ID,
  TO_CHAR(SQ_MTL_UOM_CONV_INTRACLASS.LAST_UPDATED_BY) CHANGED_BY_ID,
  SQ_MTL_UOM_CONV_INTRACLASS.X_CUSTOM X_CUSTOM,
  SQ_MTL_UOM_CONV_INTRACLASS.FROM_UOM_CODE FROM_UOM_CODE,
  SQ_MTL_UOM_CONV_INTRACLASS.TO_UOM_CODE TO_UOM_CODE,
  TO_CHAR(SQ_MTL_UOM_CONV_INTRACLASS.INVENTORY_ITEM_ID) INVENTORY_ITEM_ID
FROM
  (
  /* Subselect from SDE_ORA_UOMConversionGeneral_IntraClass_Resource.W_UOM_CONVERSION_GS_SQ_MTL_UOM_CONV_INTRACLASS
  */
  SELECT CONV.INVENTORY_ITEM_ID INVENTORY_ITEM_ID,
    FROM_UOM.UOM_CODE FROM_UOM_CODE,
    TO_UOM.UOM_CODE TO_UOM_CODE,
    NULL LAST_UPDATE_DATE,
    '0' LAST_UPDATED_BY,
    NULL CREATION_DATE,
    '0' CREATED_BY,
    '0' X_CUSTOM,
    INV_CONVERT.INV_UM_CONVERT_NEW( CONV.INVENTORY_ITEM_ID, 10, NULL, FROM_UOM.UOM_CODE, TO_UOM.UOM_CODE, NULL, NULL, 'U' ) ConversionRate
  FROM APPS.MTL_UOM_CONVERSIONS CONV,
    APPS.MTL_UNITS_OF_MEASURE FROM_UOM,
    APPS.MTL_UNITS_OF_MEASURE TO_UOM
  WHERE (1                              =1)
  AND (CONV.UOM_CLASS                   =FROM_UOM.UOM_CLASS)
  AND (CONV.UOM_CLASS                   =TO_UOM.UOM_CLASS)
  AND (FROM_UOM.UNIT_OF_MEASURE         =CONV.UNIT_OF_MEASURE)
  AND (NVL(TO_UOM.DISABLE_DATE,SYSDATE)>=SYSDATE)
  AND (NVL(CONV.DISABLE_DATE,SYSDATE)  >=SYSDATE)
  AND ( 1                               =1 )
  AND (TO_UOM.LANGUAGE                  ='#BIAPPS.LANGUAGE_BASE')
  AND (FROM_UOM.LANGUAGE                ='#BIAPPS.LANGUAGE_BASE')
  AND (CONV.INVENTORY_ITEM_ID           =0)
  UNION
  SELECT CONV.INVENTORY_ITEM_ID INVENTORY_ITEM_ID,
    FROM_UOM.UOM_CODE FROM_UOM_CODE,
    TO_UOM.UOM_CODE TO_UOM_CODE,
    NULL LAST_UPDATE_DATE,
    '0' LAST_UPDATED_BY,
    NULL CREATION_DATE,
    '0' CREATED_BY,
    '0' X_CUSTOM,
    INV_CONVERT.INV_UM_CONVERT_NEW( CONV.INVENTORY_ITEM_ID, 10, NULL, FROM_UOM.UOM_CODE, TO_UOM.UOM_CODE, NULL, NULL, 'U' ) ConversionRate
  FROM APPS.MTL_UOM_CONVERSIONS CONV,
    APPS.MTL_UNITS_OF_MEASURE FROM_UOM,
    APPS.MTL_UNITS_OF_MEASURE TO_UOM
  WHERE (1                                =1)
  AND (CONV.UOM_CLASS                     =FROM_UOM.UOM_CLASS)
  AND (CONV.UOM_CLASS                     =TO_UOM.UOM_CLASS)
  AND (TO_UOM.UNIT_OF_MEASURE             =CONV.UNIT_OF_MEASURE)
  AND ( 1                                 =1 )
  AND (NVL(FROM_UOM.DISABLE_DATE,SYSDATE)>=SYSDATE)
  AND (NVL(CONV.DISABLE_DATE,SYSDATE)    >=SYSDATE)
  AND (FROM_UOM.LANGUAGE                  ='#BIAPPS.LANGUAGE_BASE')
  AND (TO_UOM.LANGUAGE                    ='#BIAPPS.LANGUAGE_BASE')
  AND (CONV.INVENTORY_ITEM_ID             =0)
  ) SQ_MTL_UOM_CONV_INTRACLASS
WHERE (1=1)

Metric Name Change for Average Resolution Rate in Service Analytics

This issue applies to metric name changes in Service Analytics.

In Service Analytics, the metric Average Resolution Rate has been renamed to Average Close Rate in the following subject areas:

  • Service - CRM Activities

  • Service - CRM Agreements

  • Service - CRM Customer Satisfaction

  • Service - CRM Service Requests

Workaround

If the Average Resolution Rate metric is being used in any custom reports, then those reports will no longer work. You need to modify each custom report to replace the old metric name with the new metric name.

Missing Predefined Object Duty Roles

This issue applies to the missing predefined object duty roles.

Oracle BI Applications Release 11.1.1.10.1 delivered the following new HR Subject Areas:

  • Human Resources - Workforce Compensation

  • Human Resources - Succession Planning

These subject areas have Oracle BI Enterprise Edition permissions against the corresponding Application Roles:

  • OBIA_AU_HCM_WRKFC_COMP_DUTY

  • OBIA_AU_HCM_SUCC_PLNING_DUTY

However, these application roles are missing in the bi stripe/jazn of the Oracle BI Applications Release 11.1.1.10.1 installation files.

Workaround

For non-administrator role access to these subject areas, add the Application Roles manually using Oracle Enterprise Manager Fusion Middleware Control. See, Managing Duty Roles in Oracle BI Applications, Oracle Business Intelligence Applications Security Guide.

SDE_FUSION_PARTYORGANIZATIONDIMENSION Populates With Data Has Gaps

This issue applies to SDE_FUSION_PartyOrganizationDimension.

Workaround

  1. Log in to the ODI Studio and navigate to the Designer tab.
  2. Open the BI Apps Project, click Mappings, and select SDE_FUSION_x_Adaptor (where x can be 9, 10, or 11).
  3. Expand SDE_FUSION_PartyOrganizationDimension.
  4. Open MAIN interface (blue) SDE_FUSION_PartyOrganizationDimension.W_PARTY_ORG_DS.
  5. Go to column PRIMARY_PHONE_AREA_CODE and replace the existing expression with SQ_W_FSN_PARTY_ORG_PS.PRIMARY_PHONE_AREA_CODE.

Award_WID Not Populating in Existing Project Facts

This issue applies to Award_WID not getting populated in the existing Project Budget and Cost facts.

Workaround

Use the CA_DETAIL_PROJ table to get the link between contract number, projects, and activities for the following existing facts:

  • W_PROJ_COST_LINE_FS

  • W_PROJ_INVOICE_LINE_FS

  • W_PROJ_REVENUE_LINE_FS

  • W_PROJ_BUDGET_FS

  • W_PROJ_FORECAST_FS

  • W_PROJ_COMMITMENT_FS

SDE_FUSION_HRASSIGNMENTDIMENSION Failure

This issue applies to Fusion Workforce adaptor.

Fusion direct full load ETL runs in to an error with SDE_FUSION_HRASSIGNMENTDIMENSION failure.

Workaround

Note:

Ensure that you perform the following steps before generating a new load plan.
  1. Log in to ODI Studio and navigate to the Designer tab.
  2. Navigate to the SDE_FUSION_HRAssignmentDimension.W_HR_ASSIGNMENT_DS_SQ_ASGDFF interface.
  3. Set the column ASGDFF_SRC_LAST_UPDATE_DATE in SDE_FUSION_HRAssignmentDimension.W_HR_ASSIGNMENT_DS_SQ_ASGDFF interface as RUN_REPLICATED_TRANSACTIONAL("#IS_SDS_DEPLOYED", ASGDFF.LastUpdateDate,      ASGDFF.CDC$_SRC_LAST_UPDATE_DATE ).
  4. Regenerate the scenario.

SDE_FUSION_HRPersonLegislation_VisaPermit Fails

This issue applies to the Fusion adaptor (Workforce).

Fusion direct full load ETL runs in to an error when SDE_FUSION_HRPersonLegislation_VisaPermit fails.

Workaround

Note:

Ensure that you perform these steps before generating a new load plan.
  1. Log in to ODI Studio, navigate to the Designer tab, then BI Apps Project, then Mappings, and the SDE_FUSION_10_Adaptor folder.
  2. Locate the SDE_FUSION_HRPersonLegislation_VisaPermit task and open the SDE_FUSION_HRPersonLegislation_VisaPermit.W_FSN_PER_VISAS_PERMITS_F_TMP_SQ_VISA interface.
  3. In the Quick-Edit tab, find the filter beginning RUN_REPLICATED_TRANSACTIONAL...and remove VISAPERMITPVO alias and AS keyword. It should look as follows: 
    RUN_REPLICATED_TRANSACTIONAL('#IS_SDS_DEPLOYED', 
VisaPermitId  in ( Select_physical MAX(CHK.VisaPermitId) from 
"oracle.apps.hcm.model.analytics.applicationModule.HcmTopModelAnalyticsGlobalAM_HcmTopModelGlobalAMLocal"..."HcmTopModelAnalyticsGlobalAM.PersonAM.VisaPermitPVO" CHK
Where CHK.VisaPermitPEOPersonId=VisaPermitPEOPersonId), 
VISAPERMITPVO.VisaPermitId=(Select MAX(CHK.VisaPermitId) from 
QUALIFY(HCM_PE_VISAPERMITPVO764912) CHK 
Where CHK.VisaPermitPEOPersonId=VISAPERMITPVO.VisaPermitPEOPersonId))
  4. Save the interface and regenerate the scenario.

SDE_FUSION_StatusDimension_EnrollmentStatus Failure

This issue applies to the Fusion Adaptor Direct.

Fusion direct full load ETL runs in to an error due to SDE_FUSION_StatusDimension_EnrollmentStatus failure.

Workaround

Note:

Ensure that you perform these steps before generating a new load plan.
  1. Log in to the ODI Studio and navigate to the Designer tab.
  2. Navigate to the SDE_FUSION_9_Adaptor adaptor folder and then to the    SDE_FUSION_StatusDimension_EnrollmentStatus.W_STATUS_DS interface.
  3. Change the Execute On property for column DELETE_FLG from Staging to Source.
  4. Regenerate the scenario.

SDE_Universal_PayrollBalanceDimension_Translate Fails

This issue applies to the Universal adaptor.

SDE_Universal_PayrollBalanceDimension_Translate fails as the balance name column has more than 80 characters.

Workaround

Ensure that the balance names in the source data are 80 characters or less.

SDE_FUSION_10_ADAPTOR_FTS_FUSION_HCMTOPMODELANALYTICSGLOBALAM_GROUPSAM_GROUPME MBERSPVO (187501) fails with return code 20942

This issue applies to the HCM Cloud View Object GroupMembersPVO.

The HCM Cloud View Object GroupMembersPVO performs an unexpected or requested outer join from the child HWM_GRP_MEMBERS_F and HCM_GRPS. Unless the bicc filtering is delivered, the VO may retrieve rows for groups that have no group members. If this is the case on your HCM Cloud source, you will encounter the above mentioned error.

Workaround

After the extractor .csv file is copied into the ODI file-system (and if you encounter the above mentioned error), edit the file and remove rows which have no value for the column GRP_MEMBER_ID. The file-name should contain *groupmemberspov*.csv The column corresponding to HWM_GRP_MEMBERS_F.GRP_MEMBER_ID is called GROUPMEMBERSDPEOGROUPMEMBERID in the .csv file representation of the VO data. You will need to do this each time similar data is extracted, until the bicc filtering is delivered into the Fusion / bicc system.

SIA is Supported on PSFT90 Adaptor

This issue applies to the PSFT90 adaptor enabled for SAI 11.1.1.10.2.

The PSFT90 adaptor is enabled for SIA 11.1.1.10.2 and is supported only for SIA and not for any other 11.1.1.10.2 BI Apps products like FSCM and HCM / ELM.

Workaround

This issue has no workaround.

ETL Fails with the “ORA-01792: maximum number of columns in a table or view is 1000” error message

This issue applies to Business Intelligence Applications consumer- version 11.1.8.1 and later using the Oracle 12c Database.

BI Applications 11.1.1.10.2 ETL fails owing to the following error: “ORA-01792: maximum number of columns in a table view is 1000.”

The Oracle 12c database supports a maximum of 1000 columns when creating a table.

Workaround

set “_fix_control”='17376322.OFF'

alter session set "_fix_control"='17376322:OFF';  or   alter system set "_fix_control"='173763222.OFF';

Rows Dropped When Contact Dimension is Added to Customer Dimension in Marketing Query

The issue applies to the Domain member table.

The issue is due to the missing records in the Domain member table W_DOMAIN_MEMBER_LKP_TL for DOMAIN_MEMBER_CODE = 'CONTACT'. This value should come from the seeded domain code. The value is actually seeded by default but the seeded member flag is not set properly in the seed data. This prevents the domain member from loading into the table W_DOMAIN_MEMBER_LKP_TL.

Workaround

This issue had no workaround currently.

The Configuration Manager Lists Organizations That Are Not Master Orgs

This issue applies to the MASTER ORG parameter.

The MASTER ORG parameter allows you to select from a list of Master Orgs retrieved from your OLTP. This list can also display certain non-Master orgs due to a code issue that has been fixed in the latest version.

Workaround

Ensure that you are aware of the Master Orgs in the system and select only those from the list.

The Taleo Cloud Source System Hits Daily Limit For Bulk Data Export requests

This issue applies to the Taleo Cloud source system. The Taleo Cloud source system enforces daily and transaction limits for bulk data export requests.

During the load plan execution, if a replication job hits the Taleo Cloud source system Daily Limit, then the job is paused for 24 hours but the status of the ODI LP step is marked as Completed.

Subsequent load plan steps of replication for the Taleo Cloud source system completes without actually running the replication and the rest of the ETL steps (SDE, SIL) are also completed for the Taleo Cloud source system without running the ETL. The next day, the load plan triggers the rest of the replication and completes the ETL.

The paused job is triggered automatically and runs the replication only for the entity which first hits the daily limit. For replicating the rest of the entities, a new load plan instance needs to be triggered after 24 hours of the previous load plan.

Workaround

If the Taleo zone limits are increased, it's recommended to update the Daily Limit on the Replicator to match the zone value, or update it to 0.

DAILY_EXPORT_LIMIT=0 (0 indicates unlimited).

Features Unavailable in On-Premises Deployments

This issue applies to features that are not available in the Oracle BI Applications Release 11.1.1.10.2 on-premises deployments.

The Manage Extensible Attribute feature is unavailable in the on-premises deployments.

Workaround

This issue has no workaround currently.

Groups Definition Missing in WebLogic Console

This issue applies to Oracle Business Application Procurement and Spend Analytics CaaS Release: 11.1.1.10.2 CaaS.

The following Groups definition is missing in the WebLogic Console:

  • OBIA_AU_LINE_MANAGER_EXPENSE_ANALYSIS_DUTY

  • Purchasing Extended Buyer

Workaround

  1. Login to the WebLogic Console.
  2. Go to Security Realms in the left hand side panel.
  3. Click on myrealm.
  4. Click Users and Groups and then click Groups.
  5. Create a new group named OBIA_AU_LINE_MANAGER_EXPENSE_ANALYSIS_DUTY.
  6. Create a new group named Purchasing Extended Buyer.

User with BI Consumer Role Can Access the PIM Dashboard

This issue applies to the PIM dashboard.

Any user with a BI consumer role can access the PIM dashboard. However opening the dashboard may cause failed reports.

Workaround

The user has to access the PIM dasboard with a PIM user ID after the required configurations. Accessing the PIM dashboard with other user IDs is not recommended.

In Procurement and Spend Analytics, VOs Are Not Loading As Required

This issue applies to Procurement and Spend Analytics.

The following VOs are not loading as required:

  • Extract for VO FscmTopModelAM.PrcPoPublicViewAM.StandardShipmentPVO failed with the following error:

    [nQSError: 77031] Error occurs while calling remote service ADFService11G. 
Details: Runtime error for service -- ADFService11G - No such view attribute 
name SecUnitOfMeasureLastUpdateDate

  • Extract for VO FscmTopModelAM.PrcPoPublicViewAM.StandardDistributionPVO failed with the following error:

    [nQSError: 77031] Error occurs while calling remote service ADFService11G. 
Details: Runtime error for service -- ADFService11G - No such view attribute 
name UnitOfMeasureLastUpdateDate

Some attributes which have been obsolete from the previous release are still included in the above PVOs. CM cloud seed data should remove those attributes from extraction.

As a result of these errors, the data is not getting loaded into the Purchase Order fact tables ((W_PURCH_SCHEDULE_LINE_F and W_PURCH_COST_F). In the Procurement-Cycle line, without data loaded in the schedule line fact table, the cycle line fact is empty. In Invoice Lines, the Invoice fact table includes invoice data as well as PO data. The Invoice fact table only populates with invoice data. The PO related dimension/metrics is not supported.

Workaround

This issue has no workaround currently.

Cloud Replicator Does Not Support Non SSL Enabled RightNow Sites

This issue applies to the current version of the Cloud Replicator.

The current version of the Cloud Replicator does not support extracting data from the non SSL enabled RightNow sites.

Workaround

For Cloud Replicator to work with the RightNow site as a valid cloud source connection, the site should be SSL enabled.

Issues in Costing - Inventory Valuation Subject Area

This issue applies to the Fusion data sources.

An unresolved issue with definitions of the following Fusion View Objects causes Cloud BI Extraction or on-premises regular ETL over these objects to fail:

  • FscmTopModelAM.OnhandValuationAM.OnhandValuationAccountedDailyPVO  

  • FscmTopModelAM.OnhandValuationAM.OnhandValuationCostedDailyPVO

These objects are used as primary data sources for this subject area.

Workaround

This issue has no workaround currently.

SILOS_SIL_HRPERSONLEGISLATION_FLEX_DIMENSION Fails

This issue applies to SILOS_SIL_HRPERSONLEGISLATION_FLEX_DIMENSION.

SIL_HRPersonLegislation_Flex_Dimension.W_HR_PERLEG_ADDL_D (Integration) fails on the target ORACLE connection BIAPPS_DW.

Workaround

  1. In the ODI Studio, click Models, click Oracle BI Applications, and select Dimensions.
  2. Open the table W_HRPERLEG_ADDL_D.
  3. Expand the columns and double-click PERLEG_ATTR3_CHAR.
  4. In the Description tab, set the slowly changing behavior to Overwrite on Change.
  5. Regenerate the scenario for SILOS_SIL_HRPERSONLEGISLATION_FLEX_DIMENSION.

Patch Set Assistant ATG Upgrade Fails for Many Languages

This issue applies to the Patch Set Assistant (PSA) ATG Upgrade.

The PSA ATG upgrade fails in languages other than English, Chinese and Italian. If the environment variables LANG and LC_ALL are set to values other than the following values, the PSA ATG upgrade fails:

  • zh_CN.utf8

  • zh_TW.utf8

  • it_IT.utf8

  • en_US.utf8

Workaround

After applying the Oracle Business Intelligence Applications patches and before running the PSA from the directory Oracle_BT1/bin/psa, follow these steps:

  1. Download the sql file, ATGPFREL12_fnd_preseed_language.sql, from My Oracle Support document 2157385.1– OBIA 11g: BIApps 11.1.1.10.2 Install - PSA ATG Upgrade Fails For Many Languages during OBIA Config.
  2. Back up the existing sql file (cp Oracle_BI1/biapps/admin/provisioning/update/11.1.1.9.0/from0/sdf/atg/fnd_prese ed_language.sql) using the following command:
    Oracle_BI1/biapps/admin/provisioning/update/11.1.1.9.0/from0/sdf/atg/fnd_preseed_language.sql_BAKUP_ORG.
  3. Patch the sql file that you downloaded in step 1 using the following command:
    cp ATGPFREL12_fnd_preseed_language.sql  Oracle_BI1/biapps/admin/provisioning/update/11.1.1.9.0/from0/sdf/atg/fnd_prese ed_language.sql .

Upgrade Issues with the Taleo Adaptor

You may encounter certain issues while upgrading from 11.1.1.10.1 to 11.1.1.10.2 with the Taleo adaptor.

Taleo Adaptor Load Plan Generation Failed

After you upgrade from 11.1.1.10.1 to 11.1.1.10.2, you may see the following error while generating new Load Plans or while regenerating Load Plans.

DSN not configured for LS : DS_TALEOxxxx_SRCFILES java.lang.Exception: 
ODI repository not configured properly , please check ALL the logical schemas 
associated with the chosen PLV DS_TALEO15A_SRCFILES 
at oracle.apps.bi.lp.gen.LPG_ODIRep.buildLSCacheforOdiRep(Unknown Source) 
at oracle.apps.bi.lp.gen.LPG_ODIRep.<init>(Unknown Source) 
at oracle.apps.bi.lp.gen.LPG_Generator.generateLP(Unknown Source) 
at oracle.apps.bi.lp.gen.LPG_MultiGenerator.generateLP(Unknown Source) 
at oracle.apps.bi.configmngr.service

Workaround

  1. In the BI Applications Configuration Manager, edit the Taleo Source to ensure that the new logical schemas are stamped properly

  2. Open the Taleo Source, click Next, and then save.

You do not need to change any settings. Clear the generation state of any existing Load plans and regenerate them before use.

Taleo Adaptor Load Plan Failure

While running the Taleo adaptor Load Plan in the upgrade environment ( 11.1.1.10.2), you might have multiple Taleo replication jobs fail in the Load Plan with the error :INDEXORA-02261: such unique or primary key already exists in the table.
An example of the error: 
ODI-1217: Session CLOUD_CONNECTOR_INVOKE_WEB_SERVICE (1807501) fails with return code 7000.
ODI-1226: Step Cloud Connector Invoke Web Service fails after 1 attempt(s).
ODI-1232: Procedure Cloud Connector Invoke Web Service execution fails.
Caused By: org.apache.bsf.BSFException: The application script threw an exception: 
java.lang.RuntimeException: ---Custom Exception : 
JOB Failed :Submitted Job Failed to complete  :
TLO_JOB_LEVEL

-- Error Code  :  CLOUD_REP_00016:Loader Error

-- Error Message  :  java.lang.Exception :  ReplicateType: 
DATA - Error Synchronizing Metadata for TLO_JOB_LEVELFAILED to update 
table TLO_JOB_LEVELORA-02261: such unique or primary key already exists in the table    
ERROR: running update ddl:ALTER TABLE TLO_JOB_LEVEL ADD CONSTRAINT UK_TLO_JOB_LEVEL
UNIQUE (JOB_LEVEL_NUMBER) USING INDEXORA-02261: such unique or primary key already 
exists in the tableoracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)

Workaround

  1. Execute SDS_TABLE_MAINTENANCE ODI scenario to drop the indexes from a given SDS schema. You can find this scenario from the BI Apps ODI project path:

    BI Apps Project/Components/SDS/Generate SDS DDl.

    When you run this procedure scenario, it would prompt for the procedure variable option values. Use the below ODI scenario variable and values while executing it.

    Variables Values

    UTIL_GENDDL_CREATE_SCRIPT_FILE

    Use Default value

    UTIL_GENDDL_FILE_OUTPUT_LSCHEMA

    Use Default value

    UTIL_GENDDL_RUN_DDL

    Overwrite value with “Y”

    UTIL_GENDDL_SDS_LSCHEMA
    Overwrite with valid ODI Taleo SDS logical schema’s. Below are the valid ODI logical schemas:
    Adapter Name ODI Logical Schemas

    TALEO_13B_Adaptor

    DS_TALEO13B_SDS

    TALEO_13C_Adaptor

    DS_TALEO13C_SDS

    TALEO_14A_Adaptor

    DS_TALEO14A_SDS

    TALEO_14B_Adaptor

    DS_TALEO14B_SDS

    TALEO_15A_Adaptor

    DS_TALEO15A_SDS

    UTIL_GENDDL_TABLE_MASK

    Use Default value

    UTIL_GENSDS_DROP_INDEXES

    Overwrite value with “Y”

    UTIL_GENSDS_GATHER_TABLE_STATS

    Use default Value

    UTIL_GENSDS_RESET_TABLE_STATS

    Use Default Value

  2. Restart the Load Plan.

While running the Taleo adaptor load plan in the upgrade environment (11.1.1.10.2), you may see a load plan failure with the below exception. 
ODI-1217: Session CLOUD_CONNECTOR_INVOKE_WEB_SERVICE (1817501) fails with return code 7000.
ODI-1226: Step Cloud Connector Invoke Web Service fails after 1 attempt(s).
ODI-1232: Procedure Cloud Connector Invoke Web Service execution fails.
Caused By: org.apache.bsf.BSFException: The application script threw an exception: 
java.lang.RuntimeException: -- Custom Exception - HTTP error code : 
500---- Internal Server Error
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<Response><Error><ErrorCode>CLOUD_REP_00004:Server 
Error</ErrorCode><JobId>0</JobId><Message>Dangling meta character '*' 
near index 0*^</Message></Error></Response>

Workaround

  1. Connect to the Business Intelligence Applications Components Repository (BIACOMP) platform schema using SQL tools and run the script:

    update cr_properties  set value='false' where name='IS_EXTENSIBLE'; commit;

  2. Restart the Load Plan.

PeopleSoft Tables to be Completely Extracted

This issue applies to the PeopleSoft Cloud Source adaptor.

The following error message comes up after the completion of an ETL process run: 
Caused By: java.sql.SQLException: ORA-20000: Error creating Index/Constraint
:W_PSFT_INT_ORG_DH_PS_P1 => ORA-01452: cannot CREATE UNIQUE INDEX; duplicate
keys found

Workaround

The following tables need to be completely extracted every time after an ETL process has been run:

  • PSTREENODE

  • PSTREELEAF

Data Is Not Visible in Employee Expenses Subject Areas

This issues applies to Procurement and Spend Analytics.

When you try to view data in the Employee Expenses - Credit Card, Employee Expenses - Overview, and Employee Expenses - Violations subject areas, you see no data. This situation is caused by a security issue that prevents data from being properly extracted into fact tables.

Workaround

This issue has no workaround currently.

Incorrect Inventory Organization Prompts on the Logistics Dashboard for Supply Chain Reporting

This issue applies to Supply Chain reporting.

If you do not use Fusion Applications, you might notice incorrect values for Inventory Organization prompts on the Logistics dashboard for Supply Chain reporting. You can edit the SQL statements for the prompts to correct these values.

Workaround

  1. In BI Analytics, under Catalog, navigate to Shared Folders, Supply Chain Management, Analytic Library, Embedded Content, Logistics, and select Prompts.
  2. Edit the Hit or Miss Accuracy prompt.
  3. Edit the Inventory Organization prompt.
  4. Under Option, update the SQL statement to generate the list of values to be SELECT "Inventory Organization"."Inventory Org Name", "Fact - Inventory Cycle Count"."Counted Quantity" FROM "Inventory - Cycle Count"
  5. Click OK and save the changes.
  6. Edit the Inventory Value Dashboard page promts.
  7. Edit the Inventory Organization prompt.
  8. Update the SQL statement to be: SELECT "Inventory Organization"."Inventory Org Name", "Fact - Costing - Inventory Valuation"."Accounted Onhand Amount" FROM "Costing - Inventory Valuation".
  9. Click OK and save the changes.

Cycle Count Subject Area is not Supported for the PeopleSoft Adaptor

This issue applies to PeopleSoft users.

The Cycle Count subject area is not supported for the PeopleSoft adaptor. Therefore, Cycle Count reports are not populated, including those on the following dashboard pages:

  • Fusion Logistics - Exact Matches Rate

  • Fusion Logistics - Hit or Miss Accuracy Inventory

  • Cycle Count Inventory - Cycle Count Details

Multi-Select Extensible Attribute List-of-Values (LOV) Columns Are Not Supported

This issue applies to BI Applications.

When you add to a report an extensible attribute column that is a list-of-values (LOV) and that has multiple values selected, you notice that rows are missing.

Workaround

This issue has no workaround.

Email Address Missing While Extracting Data from GlobalPerson

This issue applies to the missing privileges for the provisioned extractor user in the Fusion Applications release 11 POD environments.

While extracting data from the GlobalPersonForETLPVO Fusion view object (VO), using the FUSION_APPS_OBIA_BIEE_APPID user , some of the persons' email addresses are missing. This issue is due to the missing privileges for this user in the Fusion Applications release 11 POD environments. This user is the provisioned extractor user that the Oracle BI Applications ETL process uses to extract data from Fusion Applications. In order to extract secured data such as PII information (for example, person's home email, home phone, and national identifiers) , you must ensure that this user is granted the data security policies that allow it to read the underlying tables.

Workaround

  1. Log in to the Fusion Applications, with a user that has the IT Security Manager role.
  2. Navigate to Setup and Maintenance, search and launch the Manage Duties task.
    This opens the Oracle Entitlements Server tab, commonly known as the Authorization Policy Manager (APM).
  3. Use the search box to search for the FUSION_APPS_OBIA_BIEE_APPID user.

    Note:

    There is also a role called FUSION_APPS_OBIA_BIEE_APPID. Do not search for and create policies for the role. You must ensure to search for and create policies for the FUSION_APPS_OBIA_BIEE_APPID user.
    The search result displays the Business Intelligence Applications Extract Transform and Load Application Identity user name.
  4. Select this user name in the search result area and click on the Open (folder) icon.
    This opens a new tab displaying details such as the role assignments of this user.
  5. Click on the Find Global Policies to open the Search Policies tab.
    In the Data Security Policies for: region within the Search Policies tab are listed all of the currently granted data security policies to this user.
  6. Click New to open the New Policy tab with four sub-tabs and enter the following information in each sub-tab:
    • General Information tab:

      • Name: Custom Grant for Person Email to OBIA

      • DB Resource: Person Email

      • Module: Global Human Resources

      • Start Date: 1/1/01

    • Roles tab: There is no information to enter on this tab. It must, however, display a single entry for FUSION_APPS_OBIA_BIEE_APPID user name.

    • Rule tab:

      • Row Set: All Values

    • Action tab: Select Report Person Email and shuttle to the selected actions list.

    • Click Save on the New Policy tab. This saves and returns you to the Search Policies tab with a confirmation message. Press OK to confirm.

  7. Repeat Step 6 for the following DB Resource and Actions:

    • DB Resource: Person Phone; Action: Report Person Phone

    • DB Resource: Human Resources Address; Action: Report Person Address

  8. On the Search Policies tab, sort Data Security Policies by Action (descending), scroll, and verify that the policies for Report Person Email , Report Person Phone, and Report Person Address have been created successfully.
  9. If the BI reports additionally need to extract other secured details such as National Identifiers, Visa , then create data security policies for the following:

    • DB Resource: Person National Identifier; Action: Report Person National Identifier

    • DB Resource: Person Visa Action; Action: Report Person Visa

    • DB Resource: Person Passport; Action: Report Person Passport

    • DB Resource: Person Driver License; Action: Report Driver License

    Note:

    If you are uncertain whether the Oracle Business Intelligence ETL process needs to extract data from these objects, then do not create the data security policies for that object. Only do so, when you are absolutely certain.