Oracle® Business Intelligence Applications for 7.9.6.3
Extension Pack

Release Notes for
Oracle Business Intelligence Applications Users

Version 7.9.6.3 Extension Pack

April 17, 2012

Oracle Business Intelligence
Applications Release Notes for 7.9.6.3 Extension Pack

Copyright © 2009, 2012, Oracle and/or its affiliates. All
rights reserved.

This software and related documentation are provided
under a license agreement containing restrictions on use and disclosure and are
protected by intellectual property laws. Except as expressly permitted in your
license agreement or allowed by law, you may not use, copy, reproduce,
translate, broadcast, modify, license, transmit, distribute, exhibit, perform,
publish, or display any part, in any form, or by any means. Reverse engineering,
disassembly, or decompilation of this software, unless required by law for
interoperability, is prohibited.

The information contained herein is subject to change
without notice and is not warranted to be error-free. If you find any errors,
please report them to us in writing.

If this is software or related documentation that is
delivered to the U.S. Government or anyone licensing it on behalf of the U.S.
Government, the following notice is applicable:

U.S. GOVERNMENT RIGHTS Programs, software, databases, and
related documentation and technical data delivered to U.S. Government customers
are "commercial computer software" or "commercial technical data" pursuant to
the applicable Federal Acquisition Regulation and agency-specific supplemental
regulations. As such, the use, duplication, disclosure, modification, and
adaptation shall be subject to the restrictions and license terms set forth in
the applicable Government contract, and, to the extent applicable by the terms
of the Government contract, the additional rights set forth in FAR 52.227-19,
Commercial Computer Software License (December 2007). Oracle America, Inc., 500
Oracle Parkway, Redwood City, CA 94065.

This software or hardware is developed for general use in
a variety of information management applications. It is not developed or
intended for use in any inherently dangerous applications, including
applications that may create a risk of personal injury. If you use this software
or hardware in dangerous applications, then you shall be responsible to take all
appropriate fail-safe, backup, redundancy, and other measures to ensure its safe
use. Oracle Corporation and its affiliates disclaim any liability for any
damages caused by use of this software or hardware in dangerous
applications.

Oracle and Java are registered trademarks of Oracle
and/or its affiliates. Other names may be trademarks of their respective
owners.

Intel and Intel Xeon are trademarks or registered
trademarks of Intel Corporation. All SPARC trademarks are used under license and
are trademarks or registered trademarks of SPARC International, Inc. AMD,
Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered
trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open
Group.

This software or hardware and documentation may provide
access to or information on content, products, and services from third parties.
Oracle Corporation and its affiliates are not responsible for and expressly
disclaim all warranties of any kind with respect to third-party content,
products, and services. Oracle Corporation and its affiliates will not be
responsible for any loss, costs, or damages incurred due to your access to or
use of third-party content, products, or services.

Documentation Accessibility

For information about Oracle's commitment to
accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.

Access to Oracle Support

Oracle customers have access to electronic support
through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info  or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs   if you are hearing
impaired.

Contents

Oracle®
Business Intelligence Applications for 7.9.6.3 Extension Pack. 1

Audience. 4

Documentation
Accessibility. 4

Accessibility
of Code Examples in Documentation. 4

Accessibility
of Links to External Web Sites in Documentation. 4

TTY
Access to Oracle Support Services. 5

Related
Documents.
5

Conventions. 5

Release
Notes.
6

1.1....
How to Use These Release Notes. 6

1.2....
Certification Information. 6

1.3....
Oracle Business Intelligence Applications for 7.9.6.3 Extension Pack:
General
6

1.3.1
DAC - Importing of R12 and 11510 container 6

1.3.2
DAC - Full load failing with Create Index Failure issues. 6

1.3.3
ETL for Demand Fact 7

1.3.4
ETL for Resource Availability Fact 7

1.3.5
Manufacturing Operation Detail Report 7

1.3.6
Overhead Cost Metric. 7

1.3.7
Backlog Cost Metric. 7

1.3.8
Margin Analysis Report 7

1.3.9
Parent Demand Item Description. 7

1.3.10
SQL Server Collation for source databases. 8

Preface

Oracle Business Intelligence
Applications are comprehensive prebuilt solutions that deliver pervasive
intelligence across an organization, empowering users at all levels — from front
line operational users to senior management — with the key information they need
to maximize effectiveness. Intuitive and role-based, these solutions transform
and integrate data from a range of enterprise sources, including Siebel, Oracle,
PeopleSoft, and corporate data warehouses — into actionable insight that enables
more effective actions, decisions, and processes.

These release notes describe known
issues and workarounds for the products that are on the Oracle Business
Intelligence. To install these products, refer the Oracle Business
Intelligence Applications Installation and Configuration Guide Release 7.9.6.3
Extension Pack, which is available on Oracle Business Intelligence
Applications Documentation Web site:

http://www.oracle.com/technology/documentation/bi_apps.html

Audience

This document is intended for BI
managers and implementers of Oracle Business Intelligence Applications for
7.9.6.3 Extension Pack.

Documentation
Accessibility

Our goal is to make Oracle products,
services, and supporting documentation accessible, with good usability, to the
disabled community. To that end, our documentation includes features that make
information available to users of assistive technology. This documentation is
available in HTML format, and contains markup to facilitate access by the
disabled community. Accessibility standards will continue to evolve over time,
and Oracle is actively engaged with other market-leading technology vendors to
address technical obstacles so that our documentation can be accessible to all
of our customers. For more information, visit the Oracle Accessibility Program
Web site at

http://www.oracle.com/accessibility/

Accessibility of Code Examples in
Documentation

Screen readers may not always
correctly read the code examples in this document. The conventions for writing
code require that closing braces should appear on an otherwise empty line;
however, some screen readers may not always read a line of text that consists
solely of a bracket or brace.

Accessibility of Links to
External Web Sites in Documentation

This documentation may contain links
to Web sites of other companies or organizations that Oracle does not own or
control. Oracle neither evaluates nor makes any representations regarding the
accessibility of these Web sites.

TTY Access to Oracle Support
Services

Oracle provides dedicated Text
Telephone (TTY) access to Oracle Support Services within the United States of
America 24 hours a day, seven days a week. For TTY support, call
800.446.2398.

Related Documents

For more information, see the
following documents in the Oracle Business Intelligence Applications
documentation set:

Oracle Business Intelligence
Applications Installation and Configuration Guide Release 7.9.6.3 Extension
Pack

Certification Matrix for Oracle
Business Intelligence Applications for 7.9.6.3 Extension Pack

Conventions

The following text conventions are used in this document:

Convention

Meaning

boldface

Boldface type indicates graphical user interface
elements associated

with an action, or terms defined in text or the
glossary.

italic

Italic type indicates book titles, emphasis, or
placeholder variables for

which you supply particular values.

monospace

Monospace type indicates commands within a paragraph,
URLs, code

in examples, text that appears on the screen, or text
that you enter.

1

Release Notes

These release notes describe known
issues and workarounds for Oracle Business Intelligence Applications for 7.9.6.3
Extension Pack, and contain the following sections:

·
Section 1.1, "How to Use These Release
Notes"

·
Section 1.2, "Certification
Information"

·
Section 1.3, "Oracle Business Intelligence
Applications: General"

1.1
How to Use
These Release Notes

These release notes are updated periodically as new
information becomes available. To ensure that you are reading the latest version
of the release notes, check the Oracle Business Intelligence Applications
Documentation Web site:

http://www.oracle.com/technology/documentation/bi_apps.html

1.2
Certification
Information

For certification information, refer
to the Certification matrix for Oracle Business Intelligence Applications for
7.9.6.3 Extension Pack document. This document is part of the Oracle Business
Intelligence Applications documentation set. It is also available from the
following location:

http://www.oracle.com/technetwork/middleware/ias/downloads/fusion-certification-100350.html

1.3
Oracle
Business Intelligence Applications for 7.9.6.3 Extension Pack:
General

This section provides release notes for Oracle Business
Intelligence Applications for 7.9.6.3 Extension Pack general. It contains the
following topics:

1.3.1     DAC -
Importing of R12 and 11510 container

Importing of both the DAC Extension Pack containers in the
same repository causes integrity violations in DAC. Please import only the DAC
container that corresponds to your source system.

1.3.2    DAC - Full load failing with
Create Index Failure issues

The DAC full load fails on certain tables with the create
index error.

This issue has been reported when the Data Warehouse
connection in Informatica has been created with ODBC connection type. Create the
Data Warehouse connection in Informatica with 'Oracle Thin' Client type to avoid
this issue.

1.3.3    ETL for Demand
Fact

When a functional scenario exists in such way that the demand
for an item in a sales order

Needs to be fulfilled from multiple supply organizations, and
the Assembly demand date is the same, then the demand fact fails in DAC with
index creation error.

1.3.4    ETL for Resource Availability
Fact

In certain cases, the resource availability task for Discrete
and Process runs for more than 10 hours. This task also shows up as 'Failed' in
the DAC even when the Informatica workflow is running in the background. As a
workaround, please mark the task as completed.

1.3.5    Manufacturing Operation Detail
Report

The Operations Detail report shows records across
organizations in cases where the Work Order number is not unique across
organizations.

1.3.6     Overhead Cost Metric

Overhead Cost is not reported for Process Manufacturing
Organizations.

1.3.7    Backlog Cost
Metric

Backlog is reported as negative when the Planned and Actual
completion dates of a work order

fall in different periods and period is added as filter or
dimensionality for the analysis.

1.3.8    Margin Analysis
Report

In the Margin Analysis report, please select an Operating
Unit in the organization prompt

to render data for Revenue.

1.3.9    Parent Demand Item
Description

The parent demand item description in the Planning Subject
area comes up as Null. Please use the Parent Demand Item name present in the
Planning Subject area instead of the Parent Demand Item Description column.

1.3.10
SQL Server Collation for source databases

Some of the IBM Maximo Adapters run into an issue when the
collation of the SQL Server source database is set to case sensitive and the
MAXIMO tables are created in lower case.

Copyright
©2009,
2012, Oracle and / or its affiliates. All rights reserved. http://www.oracle.com