APPS Blogs

Path To Understand Oracle Fusion Application

Oracle e-Business Suite - Sun, 2013-05-26 07:45

Path To Fusion


Categories: APPS Blogs

Automatic Shared Memory Management problem ?

Bas Klaassen - Thu, 2013-03-14 05:30
From time to time one of out 10g databases (10.2.0.5) seems to 'hang' Our monitoring shows a 'time out' on different checks and when trying to connect using sql, the sql session is hanging. No connection is possible. A few days ago, something like this happened again. Instead of bouncing the database, I decided to look for clues to find out why the database was 'hanging'. The server itself did Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com1
Categories: APPS Blogs

OER for Fusion Application

Oracle e-Business Suite - Mon, 2013-03-11 12:47

Replacement of ETRM/IREP for Fusion Application is Oracle Enterprise Repository. You can access this using following link.
https://fusionappsoer.oracle.com/

What Is OER?

Very simply this is a standalone catalog of technical information about Oracle’s Application products.  For E-Business Suite users it equates to the iRepository tool (http://irep.oracle.com/index.html), or for PeopleSoft its similar to the PeopleSoft Interactive Services Repository.

It contains a wealth of information, with the primary purpose of facilitating the creation of Application to Application integrations, and creating extensions and customizations. With this detailed technical knowledge of the inner workings and API’s available for Oracle Applications a better level of code reuse and overall accuracy can be achieved.

Accessing OER

Access is available either from Oracle’s globally shared public OER instance, or as part of your local Fusion Application instance deployment. Detail on creating a local OER installation is found in Oracle Fusion Middleware Installation Guide for Oracle Enterprise Repository (E15745-07). The URL’s for OER will be:

An OER login may be required, although Oracle’s public instance also supports guest access at this time.

OER catalogs technical components by various attributes, with the key ones being NameType, and Logical Business Area (LBA).  LBA is the lower level of the Fusion Applications Taxonomy and is used to tag each technical object with the feature and product that it is owned by and associated with.

The general keyword search actually uses indexes of all the fields/attributes associated with a entry.

Whilst the basic Asset Search should suffice in most cases, and is a simpler UI, the Browse feature (IE required) provides many powerful features and graphical views, including an object hierarchy and the Navigator to display objects related to each other

.

Oracle Enterprise Repository

Oracle Enterprise Repository

How To Get The Most From Oracle Enterprise Repository For Troubleshooting Fusion Applications [ID 1399910.1]


Categories: APPS Blogs

Approvals in Fusion Procurement

Oracle e-Business Suite - Fri, 2013-03-08 02:08
Key features exist in Fusion Procurement approvals

There are many useful features that can be used with Fusion Procurement. Here are just some of the more significant examples:

  • Both Serial and Parallel Approval for all document types.
  • Various ways to configure responses, including features like first responder wins to help avoid lengthy processing times.
  • Notification by email as well as several rich dashboard components (e.g. worklist) to show items currently awaiting action.
  • Expiration, reminder and escalation features on pending actions.
  • Delegation and vacation rules to forward actions to dedicated proxies as needed
  • Rich notification content including clickable links to go directly to document details.
  • Wide range of attribute values to use in the creation of custom approval processing rules.
What hierarchies can be used to generate approval lists?

Fusion Applications provides standard support for the following methods to derive the list of approvers

  • Supervisor Hierarchy. This uses the HCM employee definition, leveraging the specific assignment of a supervisor person to each employee. AMX engine calls HCM to request the users that are in the hierarchy and passes in a starting position (normally the person submitting the purchasing document) and the maximum number of levels in the hierarchy to climb up.
  • Position Hierarchy. This uses the Job definitions in HCM and selects all employees tied to the position that gets included in the selected hierarchy. Again this accepts the starting position (person) and the top job level to climb to before completing.
  • Approval Group is simple a group of predefined people. This can be a static list or may be custom to generate at run-time based on approval document attribute data.
  • Job Level. This works very similarly to the Position Hierarchy whereby it uses start and end Job definitions to traverse the hierarchy and select approvers.
What is Approvals Management (AMX)

Approvals Management (AMX) is an independent product that comes from the Fusion Middleware SOA Server, and provides general approval services to any product in Fusion Applications. AMX can be considered the meeting point between the powerful and flexible Oracle Business Rules capability and the advanced process control capabilities of Oracle Human Workflow.
The BPEL process that controls approvals has points at which it invokes the AMX services to initiate the approval process. The BPEL process controls the procurement process around approvals, however AMX and Human Workflow are responsible for the entire approval process.

AMX features include:

  • The execution of rules that govern the selection and generation of approver lists.
  • The sending of notifications to the participants on the generated list.
  • The processing of responses from those approvers, and selection of appropriate next approval action.
  • The return of the completion status back to the Procurement BPEL process for actioning.

Still eRecords and eSignatures are not supported by AMX in version 1.0.

For Complete Details Please refer to Document Approval in Fusion Procurement Products [ID 1319614.1]


Categories: APPS Blogs

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

Oracle e-Business Suite - Thu, 2013-03-07 01:20

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]


Categories: APPS Blogs

Oracle BI Applications (OBIA) 7.9.6.4 released

Oracle e-Business Suite - Wed, 2013-02-27 00:03

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


Categories: APPS Blogs

TASK_GROUP_Load_PartyDimension “Duplicate Keys Found”

Oracle e-Business Suite - Mon, 2013-02-25 08:33

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.


Categories: APPS Blogs

Fusion Applications Transactional Business Intelligance (OTBI) and Descriptive Flexfield

Oracle e-Business Suite - Thu, 2013-02-21 07:46

Fusion Applications OTBI and Descriptive Flexfield

In Oracle Transactional Business Intelligence for Oracle Fusion applications a very good feature is to use DFF to make any analysis. It used to be very painful for any organization to make analysis based on DFF using BIAPPS. Now it’s just matter of few clicks and you are done.

What Oracle says “If a descriptive Flexfield is enabled for Oracle Business Intelligence, the Manage Descriptive Flexfields task displays a BI Enabled checkbox for each global, context, and context-sensitive segment. Select a segment’s BI Enabled checkbox to specify that the segment is available for use in Oracle Business Intelligence.

a list of all the predefined “BI Enabled”  DFFs available in Oracle Metalink Note Fusion Applications Business Intelligence – List of Descriptive Flex Field Mappings [ID 1509316.1]


Categories: APPS Blogs

Oracle BI Apps – What are customers interested in?

Oracle e-Business Suite - Sun, 2013-02-03 08:05

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


Categories: APPS Blogs

Missing controlfiles ?

Bas Klaassen - Mon, 2012-12-10 03:36
During the backup check this morning, I noticed something strange.. The backup logfile was showing the following error : Normal 0 21 false false false NL X-NONE X-NONE Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com2
Categories: APPS Blogs

The Future of Project Management is Social

Oracle e-Business Suite - Tue, 2012-09-25 12:32

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


Categories: APPS Blogs

Should you go to OpenWorld 2012

Andrews Consulting - Wed, 2012-07-11 12:25
Oracle OpenWorld is still over 11 weeks away (September 30 – October 4) but those considering going need to decide soon whether to participate this year. Registration costs will increase $300 at the end of this week. More importantly, hotel and flight options become more scarce and expensive as each day passes. OpenWorld has become […]
Categories: APPS Blogs

Collaborate 2012 reflections

Andrews Consulting - Wed, 2012-05-16 09:34
Collaborate is always worthwhile but it forces you to work hard to catch back up after a week out of the office.  The time since Collaborate has given me a chance to reflect on all that I learned there.  This posting will net out my reactions to a great conference. The JD Edwards community was […]
Categories: APPS Blogs

Collaborate 2012 – one of the best ever!

Andrews Consulting - Fri, 2012-04-27 10:14
Attendance at Collaborate this year was up roughly 50% from 2011 with over 1,100 people from JDE customer organizations and a total of over 6,000 attendees. The move back to Vegas certainly helped but the turnout is also a sign of an improving business atmosphere and a renewed interest in investing in IT. Monday at […]
Categories: APPS Blogs

Why Oracle President Mark Hurd won’t be at Collaborate

Andrews Consulting - Mon, 2012-04-23 11:41
At the first few Collaborate conferences after Oracle acquired PeopleSoft and JD Edwards then President Charles Phillips gave the opening keynote speech. A key message was that Oracle cared deeply about all of its application customers and especially those new to Oracle. I was fortunate enough to interview him on two of those occasions. His […]
Categories: APPS Blogs

Oracle OEM 12c unzipping.....

Bas Klaassen - Mon, 2011-10-17 07:03
I decided to download the OEM12c software from Oracle to install the new OEM.After downloading the software, I had some trouble unzipping the two files.The files downloaded where :- em12_linux_x86_disk1of2.zip- em12_linux_x86_disk2of2.zipWhen unzipping the files, the following error occurred :[oracle@localhost software]$ unzip em12_linux_x86_disk2of2.zipArchive: em12_linux_x86_disk2of2.Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com8
Categories: APPS Blogs

Oralce eBS R12 Financials Cookbook

Bas Klaassen - Tue, 2011-10-11 04:22
Last week I was reading a Oracle eBS R12 Financials Cookbook. This book is written for Oracle functional eBS specialists. The book describes the most important processes in financials, and how to execute those processes. For example, voiding a payment. The book is showing screen prints of how to do this in R12. Not only is the book using screen pints from R12, but also a step by step explanation Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com20
Categories: APPS Blogs

JDE at OpenWorld

Andrews Consulting - Mon, 2011-10-10 14:21
OpenWorld is so big it is really many conferences all held together.  To cover as much as possible,I brought along three associates who spent all their time attending JDE specific sessions and talking to JDE customers and partners.  I focused on the keynotes and Oracle big picture sessions while fitting in as many JDE sessions […]
Categories: APPS Blogs

The cloud must go on

Andrews Consulting - Thu, 2011-10-06 13:32
Salesforce.com CEO Mark Benioff has become the newest addition to the enemies of Ellison list. Benioff had paid a million dollars for the right to offer a speech at OpenWorld but was told late in the day before his presentation that it was being cancelled. Apparently, Oracle CEO Larry Ellison was worried that Benioff’s message […]
Categories: APPS Blogs

Pages

Subscribe to Oracle FAQ aggregator - APPS Blogs