Oracle BI Applications (OBIA) 7.9.6.4 released

Good News Oracle Business Intelligence Application new version 7.9.6.4 is available to download.

Highlights of the Oracle BI Applications 7.9.6.4 Release:

  • New Application – Oracle Manufacturing Analytics with pre-built adapters for EBS Process Manufacturing R12.x and EBS Discrete Manufacturing R12.x and 11.5.10
  • New Application – Oracle Enterprise Asset Management Analytics with pre-built adapters for EBS R12.x, EBS 11.5.10 and IBM Maximo 7.5
  • Universal Adapter to extend the capability to other source systems
  • Certified for OBIEE 11g
  • Certified for Exalytics
  • Certified for DAC 11g including support for Exalytics / Times Ten, Patching Framework, Dual ETL Support and many other performance enhancements
  • Native support for mobile and tablet devices
  • Localized in 28 languages
  • Supported on Oracle, SQL Server, DB2 and Teradata DB
  • Rollup patch resolving 122 BI Applications bugs

Good thing so many bugs are fixed. To get solution / work around,  me and my team spent days on Severity 1 Service Requests with Oracle.

OBIA 7.9.6.4: Bugs Fixed in 7.9.6.4 [ID 1528774.1]

Link to Download Software and Documentations

https://blogs.oracle.com/proactivesupportEPM/entry/oracle_bi_applications_obia_7

Advertisements

TASK_GROUP_Load_PartyDimension “Duplicate Keys Found”

While Running Full load on Oracle Business Intelligence Applications 7.9.6.3, when using Source system R12 TASK_GROUP_Load_PartyDimension failed with error Log says the issue is because “duplicate keys found”

Extract from the Log

**********************************************************************************************************************

CREATE INDEX:W_PARTY_D:W_PARTY_D_U1 has started.

ANOMALY INFO::: Error while executing : CREATE INDEX:W_PARTY_D:W_PARTY_D_U1
MESSAGE:::java.lang.Exception: Error while execution : CREATE UNIQUE INDEX
W_PARTY_D_U1
ON
W_PARTY_D
(
INTEGRATION_ID Asc
,DATASOURCE_NUM_ID Asc
,EFFECTIVE_FROM_DT Asc
)
NOLOGGING
with error DataWarehouse:CREATE UNIQUE INDEX
W_PARTY_D_U1
ON
W_PARTY_D
(
INTEGRATION_ID Asc
,DATASOURCE_NUM_ID Asc
,EFFECTIVE_FROM_DT Asc
)
NOLOGGING
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
EXCEPTION CLASS::: java.lang.Exception

**********************************************************************************************************************

For Resolution:- Download and review the readme and pre-requisites for Patch.14085106.

Live Console in Oracle Sourcing (Explanation about Graphs)

Live Console allows user to graphically view and compare responses to a negotiation.

The Live Console gives user a single location from which he/she can generate many in-depth graphic displays. user can use these graphs to assist in analyzing  negotiation responses during and after a negotiation.

Live Console is not available for:

  1. RFIs
  2. Contract Purchase Agreement negotiations that do not have lines.
  3. Sealed negotiation (once the negotiation is unsealed, Live Console is available).
  4. Draft negotiations (since the negotiation has no responses).
  5. Additionally, line-level information and displays are not available for large or very large negotiations.
  6. Also, information is not available for Two-Stage RFQs until the technical evaluation is completed and the commercial stage is unlocked.

Graphs Area

The Graph Area can display four types of graphs.

Best Bids by Time (XY Chart)

  1. The graph shows bids for the top five suppliers. If the supplier has multiple bids, all bids for that supplier are shown.
  2. The Y axis shows the best bid offered for the negotiation. This is calculated as the sum of (price * quantity) for all lines on the negotiation. The X axis shows the time range over which the bids have been submitted.
  3. The vertical line indicates the close date

All Bids By Time (XY chart)

  1. This chart graphs all the bids for the negotiation.
  2. The Y axis shows the best bid offered for the negotiation. This is calculated as the sum of (price * quantity) for all lines on the negotiation. The X axis shows the time range over which the bids have been submitted.
  3. The vertical line indicates the close date.

Savings by Supplier (Bar chart)

  1. The graph shows bids for the top five suppliers. If the supplier has multiple bids, all bids for that supplier are shown.
  2. The Y axis shows the best bid offered for the negotiation. This is calculated as the sum of (quantity * (bid price – current price)) for all lines on the negotiation. The X axis shows the bid number.

Best Bids by Supplier (Bar chart)

  1. The graph shows bids for the top five suppliers. If the supplier has multiple bids, all bids for that supplier are shown.

Graphs are not available for

  1. Contract Purchase Agreement negotiations that have no lines.
  2. Blanket Purchase Agreements or Contract Purchase Agreement negotiations that have lines but no Estimated Quantity value.
  3. Negotiations for which there are no responses (for example, a negotiation that is in Preview status.
  4. Quotes that are not shortlisted from the technical evaluation stage of a Two-Stage RFQ.

 

Disable JRE Auto-Update for All E-Business Suite End-Users

All desktop administrators must IMMEDIATELY disable the Java Runtime Environment (JRE) Auto-Update option for all Windows end-user desktops connecting to Oracle E-Business Suite Release 11i, 12.0, and 12.1

Read Detail

Supplier Search results in ‘No results found’

While Searching Supplier using Payable Manager or any other responsibility in R12.1.X results into ‘No Results Found’ though supplier is already defined in system.

This is because POS: SM: Enable Data Security for Supplier” profile option value. Value should be NO at site level. In case if  you wish to use this feature the refer to Oracle Supplier Management Implementation and Administration Guide

Oracle Sourcing Configuration and Functionality

This document contains complete steps to setup Oracle Sourcing along with major functionality This document can be used to setup oracle sourcing where purchasing setup is already in place
Download