These topics involve general issues and workarounds for Oracle BI Applications.
This issue applies to PeopleSoft Absence Adaptor.
W_WRKFC_EVT_F.ASSIGNMENT_ID = W_ABSENCE_EVENT_D.ASSIGNMENT_INTEGRATION_ID
Workaround
This issue applies to the Fusion adaptor.
SDE_FUSION_ActivityFact
and SDE_FUSION_ActivityResourcesFact
failure.Workaround
Workaround
Login to the environment with Administrator user.
Browse the catalog to the Sourcing folder:
/Shared/Procurement/Analytic Library/
Find the Sourcing folder and click the More hyperlink below the Sourcing Folder and select Permissions.
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
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.
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.
This issue applies to Fusion adaptor.
Workaround
Note:
Ensure that you perform these steps before generating a new load plan.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.
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.
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
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.
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.
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
This issue applies to running ETL in Windows 2008.
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
This issue applies to Oracle Business Application – Procurement and Spend Analytics.
Workaround
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:
Replace the #BIAPPS.LANGUAGE_BASE
with the correct values for your implementation.
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')
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>
Copy this csv
file in the Replicator directory where other csv
files are stored.
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.
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)
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.
This issue applies to the missing predefined object duty roles.
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.
This issue applies to SDE_FUSION_PartyOrganizationDimension
.
Workaround
SQ_W_FSN_PARTY_ORG_PS.PRIMARY_PHONE_AREA_CODE
.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
This issue applies to Fusion Workforce adaptor.
Workaround
Note:
Ensure that you perform the following steps before generating a new load plan.This issue applies to the Fusion adaptor (Workforce).
Workaround
Note:
Ensure that you perform these steps before generating a new load plan.This issue applies to the Fusion Adaptor Direct.
Workaround
Note:
Ensure that you perform these steps before generating a new load plan.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.
This issue applies to the HCM Cloud View Object GroupMembersPVO.
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.
This issue applies to the PSFT90 adaptor enabled for SAI 11.1.1.10.2.
Workaround
This issue has no workaround.
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';
The issue applies to the Domain member table.
Workaround
This issue had no workaround currently.
This issue applies to the MASTER ORG parameter.
Workaround
Ensure that you are aware of the Master Orgs in the system and select only those from the list.
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).
This issue applies to features that are not available in the Oracle BI Applications Release 11.1.1.10.2 on-premises deployments.
Workaround
This issue has no workaround currently.
This issue applies to Oracle Business Application Procurement and Spend Analytics CaaS Release: 11.1.1.10.2 CaaS.
OBIA_AU_LINE_MANAGER_EXPENSE_ANALYSIS_DUTY
Purchasing Extended Buyer
Workaround
This issue applies to the PIM dashboard.
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.
This issue applies to Procurement and Spend Analytics.
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.
Workaround
This issue has no workaround currently.
This issue applies to the current version of the Cloud Replicator.
Workaround
For Cloud Replicator to work with the RightNow site as a valid cloud source connection, the site should be SSL enabled.
This issue applies to the Fusion data sources.
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.
This issue applies to SILOS_SIL_HRPERSONLEGISLATION_FLEX_DIMENSION.
Workaround
This issue applies to the Patch Set Assistant (PSA) ATG Upgrade.
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:
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
In the BI Applications Configuration Manager, edit the Taleo Source to ensure that the new logical schemas are stamped properly
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
INDEXORA-02261: such unique or primary key already exists in the table
.
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
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:
|
||||||||||||
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 |
Restart the Load Plan.
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
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;
Restart the Load Plan.
This issue applies to the PeopleSoft Cloud Source adaptor.
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
PSTREENODE
PSTREELEAF
This issues applies to Procurement and Spend Analytics.
Workaround
This issue has no workaround currently.
This issue applies to Supply Chain reporting.
Workaround
SELECT "Inventory Organization"."Inventory Org Name", "Fact - Inventory Cycle Count"."Counted Quantity" FROM "Inventory - Cycle Count"
SELECT "Inventory Organization"."Inventory Org Name", "Fact - Costing - Inventory Valuation"."Accounted Onhand Amount" FROM "Costing - Inventory Valuation"
.This issue applies to PeopleSoft users.
Fusion Logistics - Exact Matches Rate
Fusion Logistics - Hit or Miss Accuracy Inventory
Cycle Count Inventory - Cycle Count Details
This issue applies to BI Applications.
Workaround
This issue has no workaround.
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