APPS Blogs

Hi All, Today I would like to share the issue which I faced.   Problem Description: In Oracle Access Manager 10g (10.1.4.3), getting below issue when I tried to click tab’s under identity/access console. Cause: In Oracle Access Manager 10g (10.1.4.3), Traceback reporting in the Bug Report Form and Stylesheet Error Report Form is disabled by default. [...]

This is a content summary only. Visit my website http://onlineAppsDBA.com for full links, other content, and more!

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:

• Your local instance URL: http://%5BFusionInstance%5D:%5Bport%5D/oer
• Oracle’s public instance URL: https://fusionappsoer.oracle.com

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 Name, Type, 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

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

 If you start WebLogic Admin Server and if Admin Server hangs at “Initializing self-tuning thread pool” then look for following ______ <12-Jan-2013 14:34:04 o’clock GMT> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to STARTING> <12-Jan-2013 14:34:04 o’clock GMT> <Info> <WorkManager> <BEA-002900> <Initializing self-tuning thread...

This is a content summary only. Visit my website http://onlineAppsDBA.com for full links, other content, and more!

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]

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]

In OTM FTI you may get an error like this:

OTM > Transportation Intelligence > Dashboard

Path not found (/shared/FTI Reports/_Portal/Main Dashboard/dashboard layout)


Error Details

Error Codes: U9KP7Q94    

From OTM install guide In the $OBIEE_DATA/web/config/ directory, edit the instanceconfig.xml as follows:

a. Change the CatalogPath to point the new “aa” directory that was created when you extracted the aa_webcat.zip file. The template shows the following line.

vi instanceconfig.xml


Search for string CatalogPath and you'll find this
$OBIEE_DATA/web/catalog/samplesales
Edit this line so that it looks like this:
$OBIEE_DATA/web/catalog/aa


Note: Do not put in the $OBIEE_DATA only add the reference to the “aa” directory.

The entry may look like this:

/opt/oraclebi/oraclebidata/web/catalog/aa   Save.
Restart services.

oc4j -start
./run-sa.sh start64
./run-saw.sh start64
./run-sch.sh start64

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

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.

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]

Hi All , We have an urgent requirement for a full time Oracle Technical Administrator for our organisation. Great opportunity to work extensively on oracle database technologies. - Candidate must have more than 6 months of experience in Oracle Apps DBA - Candidate must have good knowledge on Linux server - Candidate will be cross [...]

This is a content summary only. Visit my website http://onlineAppsDBA.com for full links, other content, and more!

Problem Description: Error while recreating OracleAS Metadata Repository Schemas using MRCA tools.   I couldn’t able to remove the old schema from DB using MRCA tools. Here I would like to cover the steps of removing ODS schema from DB directly. Remove the failed MR installation using cleanMR. The cleanMR script is located in the [...]

This is a content summary only. Visit my website http://onlineAppsDBA.com for full links, other content, and more!

Problem Description: Unable to bring up Oracle Application Server 10g Release 3 (10.1.3) and notice following error in opmn.log. 13/02/15 16:09:57 [ons-internal] ONS server initiated 13/02/15 16:09:57 [pm-internal] Create pm state directory: /u01/apps/oracle/opmn/logs/states 13/02/15 16:09:57 [pm-internal] PM state file does not exist: /u01/apps/oracle/opmn/logs/states/.opmndat 13/02/15 16:09:57 [pm-internal] OPMN server ready.  Request handling...

This is a content summary only. Visit my website http://onlineAppsDBA.com for full links, other content, and more!

Problem Description: During the installation of Oracle Application Server 10g Release 3 (10.1.3) or SOA 10g (10.1.3.1.0), the ascontrol application is configured automatically only when choosing a basic installation type. If an advanced installation type is chosen, there is an option to configure the ascontrol application for the instance being installed. On the “Administration Settings” [...]

This is a content summary only. Visit my website http://onlineAppsDBA.com for full links, other content, and more!

1 Updating SUN IdM 6.0 to IdM 7.1 Pre Installation Tasks NOTE: 1. All the steps should be executed only on one Prod jvm. 2. Before executing any steps, please go through all the steps in the document. 3. All the steps must be executed with IdM Upgrade Team. Screen share (Net Meeting) is required [...]

This is a content summary only. Visit my website http://onlineAppsDBA.com for full links, other content, and more!

SIM2OIM:- Oracle WevSet (OW) (earlier Sun Identity Manager – SIM) is Identity Management product from Sun that Oracle acquired in and renamed as Oracle Waveset (OW). Oracle Identity Manager (OIM) is a provisioning and identity Management product from Thor Xellerate that Oracle acquired and renamed as Oracle Identity Manager (OIM). Oracle Identity Manager is strategic [...]

This is a content summary only. Visit my website http://onlineAppsDBA.com for full links, other content, and more!

Hi All, This post will provide detailed steps to replicate one OIM 10g environment to the other. It is assumed that source and target OIM environments are of 10g version and are on patches with same application server. Steps to be performed at Source OIM environment: Shutdown the OIM server. Export the OIM database using [...]

This is a content summary only. Visit my website http://onlineAppsDBA.com for full links, other content, and more!

This is part II of SSL in WebLogic Server that covers creating KeyStore, generating Certificate Signing Request (CSR), importing Certificate in KeyStore, and finally using this keyStore with WebLogic Server. I strongly recommend to go through Part I “SSL in WebLogic KeyStore, Identity & Trust Store, Root and Intermediate CA“   High Level Steps to [...]

This is a content summary only. Visit my website http://onlineAppsDBA.com for full links, other content, and more!

Oracle with Endeca plans to create a comprehensive technology platform to process, store, manage, search and analyze structured and unstructured information together enabling businesses to make stronger and more profitable decisions. Therefore, Oracle Endeca Information Discovery (Formerly Endeca Latitude) is an enterprise data discovery platform for rapid, intuitive exploration and analysis of data from any [...]

This post covers basics of SSL in WebLogic Server and how to configure SSL with Custom Certificates and Certifying Authority. For SSL in Oracle E-Business Suite click here, SSL in Oracle Internet Directory (OID) click here , SSL in Oracle Virtual Directory (OVD) click here , and for SSL in Oracle Access Manager (OAM) click here Secure Socket Layer [...]

This is a content summary only. Visit my website http://onlineAppsDBA.com for full links, other content, and more!

Akhilesh pinged me today and told me that autoconfig was not working on a newly upgraded R12 instance.  It was failing with these errors:

AutoConfig could not successfully execute the following scripts:   Directory: /r12ascp/erpapp/10.1.3/perl/bin/perl -I /r12ascp/erpapp/10.1.3/perl/lib/5.8.3 -I /r12ascp/erpapp/10.1.3/perl/lib/site_perl/5.8.3 -I /usnapss1/erpapp/appl/au/12.0.0/perl -I /r12ascp/erpapp/10.1.3/Apache/Apache/mod_perl/lib/site_perl/5.8.3/sun4-solaris-thread-multi /r12ascp/erpapp/inst/apps/usnapss1_r12ascp/admin/scripts/adexecsql.pl sqlfile=/r12ascp/erpapp/inst/apps/r12ascp_r12ascp/admin/install     afwebprf.sql            INSTE8_PRF         1     amscmprf.sql            INSTE8_PRF         1     amswebprf.sql           INSTE8_PRF         1     cncmprf.sql             INSTE8_PRF         1     csfadmprf.sql           INSTE8_PRF         1     oksfrmprf.sql           INSTE8_PRF         1
   Directory: /r12ascp/erpapp/inst/apps/r12ascp_r12ascp/admin/install     ibywebprf.sh            INSTE8_PRF         1
If we tried running any of the above scripts, they failed with this error:

SQLPLUS Executable : /r12ascp/erpapp/10.1.2/bin/sqlplus


SQL*Plus: Release 10.1.0.5.0 - Production on Mon Feb 4 12:04:27 2013

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Enter value for 1: Enter value for 2: Enter value for 3: Connected.
declare
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: hex to raw conversion error
ORA-06512: at "APPS.WF_EVENT", line 3600
ORA-06512: at "APPS.FND_WF_ENGINE", line 1025
ORA-06512: at "APPS.FND_PROFILE", line 3064
ORA-06512: at "APPS.FND_PROFILE", line 3514
ORA-06512: at "APPS.ADX_PRF_PKG", line 203
ORA-06512: at line 167
ORA-06512: at line 217

So I checked the code on line 3600 for wf_event package:
select line,textfrom dba_sourcewhere name='WF_EVENT'and line between 3550 and 3610;
 3600
 wf_event.local_system_guid := hextoraw(wf_core.translate('WF_SYSTEM_GUID'));I did another code search:
select line,textfrom dba_sourcewhere text like '%WF_SYSTEM_GUID%';This was the result of the query:   select text into l_result from wf_resources where name='WF_SYSTEM_GUID' andlanguage='US';
SQL> select text from wf_resources where name='WF_SYSTEM_GUID' and 2  language='US';
TEXT--------------------------------------------------------------------------------CAFECAFE-0013-0001-0029-ABCDEFABCDEF
That was weird as that is the GUID used by Oracle JRE plugin 1.3.1.29.
I checked the actual GUID:SQL> select guid from wf_systems;
GUID--------------------------------D37180AE23A4479AE04400212846C6CE
Updated the correct GUID:
SQL> update wf_resources 2  set text='D37180AE23A4479AE04400212846C6CE' 3  where name='WF_SYSTEM_GUID' and 4  language='US';
1 row updated.
SQL> commit;

Re-ran $INST_TOP/admin/install/adwebprf.sql apps appspassword ORACLE_SID

New error this time:

SQL> @afwebprf.sql apps appspassword r12ascp
Connected.
declare
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "APPS.WF_EVENT", line 3602
ORA-06512: at "APPS.FND_WF_ENGINE", line 1025
ORA-06512: at "APPS.FND_PROFILE", line 3064
ORA-06512: at "APPS.FND_PROFILE", line 3514
ORA-06512: at "APPS.ADX_PRF_PKG", line 203
ORA-06512: at line 167
ORA-06512: at line 217

Checked the code again:


    3602
 wf_event.local_system_status := wf_core.translate('WF_SYSTEM_STATUS');

SQL> select text from wf_resources where name='WF_SYSTEM_STATUS' and 2  language='US';
TEXT--------------------------------------------------------------------------------CAFECAFE-0013-0001-0029-ABCDEFABCDEF
So I checked with query:
select count(*) from wf_resources where text='CAFECAFE-0013-0001-0029-ABCDEFABCDEF';1207 rows
select count(*) from wf_resources;1775 rows


So I inquired about an existing good instance.  No R12 instance was available, so I copied from an 11i instance with sqlplus COPY command:

First put the tnsnames.ora entry for the good instance in the DB $TNS_ADMIN/tnsnames.ora file
Then used the sqlplus copy command, which is the fastest way to copy data between two oracle databases:

SQL> copy from apps/****@11iascp to apps/****@r12ascp create wf_resources_d1 using select * from wf_resources

Array fetch/bind size is 15. (arraysize is 15)
Will commit when done. (copycommit is 0)
Maximum long size is 80. (long is 80)
Table WF_RESOURCES_11i created.

  1717 rows selected from apps@usnapsd1.
  1717 rows inserted into WF_RESOURCES_11i.
  1717 rows committed into WF_RESOURCES_11i at apps@r12ascp.


Since there was a difference of 58 rows, I first copied those rows in a different table:

create table wf_resources_more as
( select * from wf_resources
where (name,type) in
(
select name,type from wf_resources
minus
select name,type from wf_resources_11i
);

Which created table wf_resources_more with 58 rows.

Then I delete those 58 rows from the wf_resources table:
delete wf_resources

where (name,type) in
(
select name,type from wf_resources
minus
select name,type from wf_resources_11i
);

Then I updated the table with 11i values, through a correlated update statement:
update wf_resources aset a.text=(select text from wf_resources_11i bwhere a.type||a.name = b.type||b.name)
That updated the 1717 common rows with correct values.
Then I inserted the extra 58 rows new in R12
insert into wf_resources (select * from wf_resources_more);commit;
I ran adwebprf.sql again and it gave a new error:
SQL> @afwebprf.sql apps appspass r12ascpConnected.declare*ERROR at line 1:ORA-01403: no data foundORA-06512: at "APPS.WF_EVENT", line 3604ORA-06512: at "APPS.FND_WF_ENGINE", line 1025ORA-06512: at "APPS.FND_PROFILE", line 3064ORA-06512: at "APPS.FND_PROFILE", line 3514ORA-06512: at "APPS.ADX_PRF_PKG", line 203ORA-06512: at line 167ORA-06512: at line 217
Again I checked code on line 3604 of WF_EVENT:
 select name into wf_event.local_system_name
     3605 from wf_systems
     3606 where guid = wf_event.local_system_guid;Then I realized that after the correlated update, the wf_resources table now had the GUID of 11i system:
SQL> select name,text 2  from wf_resources 3  where name='WF_SYSTEM_GUID';
NAME------------------------------TEXT--------------------------------------------------------------------------------WF_SYSTEM_GUIDCA43363B52162863E04400212846C6CE
So I updated it again:
I checked the actual GUID:SQL> select guid from wf_systems;
GUID--------------------------------D37180AE23A4479AE04400212846C6CE
Updated the correct GUID:
SQL> update wf_resources 2  set text='D37180AE23A4479AE04400212846C6CE' 3  where name='WF_SYSTEM_GUID' and 4  language='US';
1 row updated.
SQL> commit;

Re-ran $INST_TOP/admin/install/adwebprf.sql apps appspassword ORACLE_SID
SQL> @afwebprf.sql apps appsapss1 usnapss1Connected.[ APPS_WEB_AGENT ]Application Id : 0Profile Value  : http://usnapss1.tsg.ge.com:8004/pls/usnapss1Level Name: SITEINFO           : Updated/created profile option value..Deleted : 0[ APPS_SERVLET_AGENT ]Application Id : 0Profile Value  : http://usnapss1.tsg.ge.com:8004/OA_HTMLLevel Name: SITEINFO           : Updated/created profile option value..Deleted : 0[ APPS_JSP_AGENT ]Application Id : 0Profile Value  : http://usnapss1.tsg.ge.com:8004Level Name: SITEINFO           : Updated/created profile option value..Deleted : 0[ APPS_FRAMEWORK_AGENT ]Application Id : 0Profile Value  : http://usnapss1.tsg.ge.com:8004Level Name: SITEINFO           : Updated/created profile option value..Deleted : 0[ WF_MAIL_WEB_AGENT ]Application Id : 0Profile Value  :Level Name: SITEINFO           : Updated/created profile option value....
It succeeded.
I told Akhilesh about the result and asked him to run autoconfig.  We tailed the log at
$INST_TOP/admin/log/02042015/adconfig.log
Adconfig succeeded without errors this time:
AutoConfig is exiting with status 0
AutoConfig execution completed on Mon Feb  4 20:17:58 2013
Time taken for AutoConfig execution to complete : 2 mins  38 secs
I was overjoyed, and so was Akhilesh.  We still had 53 rows which had the value of text as:CAFECAFE-0013-0001-0029-ABCDEFABCDEF
select count(*) from wf_resourceswhere text='CAFECAFE-0013-0001-0029-ABCDEFABCDEF';53 rows.
We would investigate further, how this had happened.  I suspect human error.  Human error makes troubleshooting more interesting, just like human error makes chess more interesting.  If it was a computer playing chess, it would not make any mistakes and win the game.  It is the human errors which make chess and troubleshooting, an interesting pursuit.