1/4

Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Diversity and Inclusion
• Related Documentation
• Conventions

1 Release Notes

• About These Release Notes
  • Obtaining Patches from My Oracle Support
  • Oracle BI Applications Issues and Workarounds Identified Since the Previous Revision
  • Functional Setup Manager - Statement of Direction
• Issues and Workarounds for Installation, Upgrade, and Documentation
  • Installation
    • The stop/start sh Script Isn't Running Properly
  • Upgrade
    • Mapping Fails Due to Aggregate Function Inside Filter During Upgrade
    • Filters with SELECT Statement Failing with Invalid Identifier Error
    • Import Source Adaptor IBM DB2 UDB Technology CROSS JOIN Syntax Isn't Getting Updated
    • Maps Fail with Invalid Identifier Error
    • JDBC URL for Non-Fusion Source File Data Servers
    • NOW User-Defined Function Causing Maps to Fail with Invalid Character Error
    • TRUNC() User-Defined Function Causing Inconsistent Data Types
    • Optimizer Picking Incorrect Index Scan for Queries with CASE Statements
    • Data Issue with Multiple Aggregate Steps After Upgrading to Oracle Data Integrator 12c
    • User-Defined Function CONCAT Isn't Getting Resolved
    • Non-Oracle Source Registration Database Connection Issue
    • SDE EBS Mappings Fail Due to Incorrect Joins
    • SDE Mappings Fail with Invalid Identifier for the Seed Data Variable
    • Unable to Specify an Outer Join on a Correlation Column
    • Too Much Recursion in Text Resolution Issue when Generating a Scenario
    • SDE Mappings Fail with $CDC_DML_CODE/CDC$_SRC_LAST_UPDATE_DATE Invalid Identifier
    • Upgraded Interfaces are Failing with Missing IN or OUT Parameter at Index Exception
    • SDE_FUSION_TIMECARDPROCESSEDTIMEFACT_HWM Fails Due to Missing Columns in Nested SELECT
    • EBS SDE Mappings Are Failing Due to Missing or Incorrect Reference
    • SDE_FUSION_SALESINVOICELINESFACT Fails with Invalid Identifier Error
    • SILOS Mapping Fails with Invalid Identifier Error
    • Incorrect Column Alias Causing SDE FUSION Mappings Failure
    • Default Knowledge Module Replaces the Knowledge Module Imported from ODI 12.2.1.3
  • Documentation Corrections
    • General Documentation Issues
• General Issues and Workarounds
  • SDE_JDE_PurchaseAgreementLineFact Map Fails
  • SDE_PSFT_ProjectAwardFundingFact Map Fails to Convert Data Type
  • BIA_11 ODI XML Import Fails in the Windows Environment
  • E-Business Suite Source Extraction in the SDS Mode Fails
  • Change in Language Isn't Working as Expected
  • UCM - RIDC Thin Communication API has been Deprecated
  • Resource Limit Exception for Data Source When System is Under Stress
  • ODI Agent Overwrites the Maximum Number of Sessions to the Default Value of 1000
  • SDE_ORA_QARESULTSFACT Map Fails with the Invalid Identifier Error
  • Exceeded the Configured Maximum Number of Rows Returned for a View
  • Error While Selecting Mark as Complete for Failed Step in the ODI Console
  • Distributed Transaction Waiting for Lock
  • Error While Resetting the Data Warehouse and SDS Schema
  • SDE_PSFT_DOMAINGENERAL_ETHNICGROUP Map Failing During Incremental Run
  • Mark Manifest as Processed Step in Load Plan Gets Delayed
  • ARG_GROUP Invalid Identifier Error
  • Exception Appears While Resetting the Source Dependent Schema
  • Improve Fusion FTS Load Performance by Enabling External Table Mode
  • Order of Joins Generated in the Load Data Step Differs in Oracle Data Integrator 12c
  • Non-Oracle Source Adapters Scenario Regeneration Issue
  • Source Dependent Extract Maps Fail with Invalid Identifier Error
  • Hierarchy Maps Fail with Invalid Identifier Error
  • Data Types Created Incorrectly While Creating the C$ Table
  • Unable to Generate Scenario for SDE_FUSION_PARTYSUPPLIERSTAGING
  • Unable to Authorize Connection Between the WebLogic Servers
  • Map SDE_SBL_822_ADAPTOR_SDE_PRODUCTATTRIBUTERELATION_1 is Failing
  • ETL Fails Due to ActivityResourcesFact and ActivityFact Failure
  • Regional Settings Aren't Saved After Logging Out and In
  • Market Basket Analysis Facts and Dimensions Not Supported
  • Human Resources E-Business Suite Payroll Patches for Payroll Analytics
  • Load Plan Schedules Missing After Regeneration
  • Non-supported Attributes and Metrics
  • Data Extraction Error 'XXXDFFBIVO of type View Definition is not found'
  • BI Metadata Repository Issue in Fusion Applications for Security View
  • SDE_FUSION_PARTYORGANIZATIONDIMENSION Populates With Data Has Gaps
  • Award_WID Not Populating in Existing Project Facts
  • SDE_Universal_PayrollBalanceDimension_Translate Fails
  • ETL Fails with the “ORA-01792: maximum number of columns in a table or view is 1000” error message
  • The Configuration Manager Lists Organizations That Aren't Master Orgs
  • The Taleo Cloud Source System Hits Daily Limit For Bulk Data Export requests
  • Features Unavailable in On-Premises Deployments
  • Groups Definition Missing in WebLogic Console
  • Cloud Replicator Doesn't Support Non SSL-Enabled RightNow Sites
  • SILOS_SIL_HRPERSONLEGISLATION_FLEX_DIMENSION Fails
  • PeopleSoft Tables to be Completely Extracted
  • Incorrect Inventory Organization Prompts on the Logistics Dashboard for Supply Chain Reporting
  • Cycle Count Subject Area is not Supported for the PeopleSoft Adaptor
  • Multi-Select Extensible Attribute List-of-Values (LOV) Columns Aren't Supported
  • Email Address Missing While Extracting Data from GlobalPerson
  • ODI Metadata Patch Import Fails for Non-Oracle Source Databases
  • SDE_PSFT Maps Fail for Non-Oracle Source Databases
  • Test Connection of an Oracle WebLogic Data Source Fails
  • Unable To Add Custom Lookup In Dataset For Two Reusable Mappings
  • Dashboard Unresponsive When Report Column Contains Multiple Currencies
• Issues and Workarounds for Oracle GoldenGate
  • Support GoldenGate Integration for GL Segment Related Extract (EBS)