Path To Understand Oracle Fusion Application

Path To Fusion

Advertisements

How to Find Software Versions and Patches in an Oracle Business Intelligence Applications Environment

This MOS Note will help consultants to find the exact Version and Patch level for installed components. This is very useful when you are logging an Oracle Service Request.  

 

OBIA: How to Find Software Versions and Patches in an Oracle Business Intelligence Applications Environment? [ID 1519745.1]

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

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.

Oracle BI Apps – What are customers interested in?

A very informative Post by Rajesh Dhanapal from Infosys.

In the current era the customers are not interested to wait for months and years for BI project implementation. The customers are keen on quick wins rather than implementing the BI solution from scratch by following traditional BI approach. The Oracle BI Apps solution provides head start for the organisation to reach the to-be state quicker with reduced time and effort, and reduced risk.Read Details

The Future of Project Management is Social

Rapid Ascent. Breakneck Speed. Lightning Fast. Perhaps even overwhelming. No matter which set of adjectives we use to describe it, social media’s rise into the enterprise mainstream has been unprecedented. Indeed, the big 4 social media powerhouses (Facebook, Google+, LinkedIn, and Twitter), have nearly 2 Billion users between them.

You may be asking (as you should really) “That’s all well and good for the consumer, but for me at my company, what’s your point? Beyond the fact that I can check and post updates, that is.”

Good question, kind sir.

Read Details on

https://blogs.oracle.com/applications/entry/the_future_of_project_management

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.