Category Archives: 11i - Page 7

Troubleshooting Custom Reports

Posted by on September 15, 2008 No comments

Running Report from Command Prompt

To run the pay_register.rdf custom report from the Command Prompt, enter the following command at the prompt:

C:> C:oracleproduct10.2.0db_2binrwbuilder.exe report="C:Documents and Settingsuser01DesktopReports Tuning Issuetest.aippay_register.rdf" userid=apps/apps@vis2.world tracemode=TRACE_APPEND tracefile=c:temppay_register01.txt traceopts=(trace_SQL,TRACE_PLS,trace_prf,trace_tms)

The report loads in Reports Builder.

1. Compile the packages by typing Shift+Ctrl+K.

2. Run the Paper Layout version of the report by Shift+Ctrl+R.

3. In the Payroll ID parameter field, enter 112.

4. In the Pay Advice Date field, enter 2003/08/29.

Running SQL Code in SQL Developer

1. Open the report in Reports Developer and double-click on the Data Model icon (not word).

2. Double-click the Q_1 box. The SQL code for the Q_1 query appears.

3. Copy all the SQL code and run it in SQL Developer.

4. For the p_payroll_id, enter 112

5. For the p_pay_advice_date, enter 29-AUG-2003

Validation Error occurred

Posted by on September 14, 2008 No comments

Problem:

When trying to set up Workflow Notifications in Oracle Application Manager, the following error occurred:

Validation error occurred. Please check indicated fields below.

Solution:

Log on as user SYSADMIN and set up the workflow.

Run the $FND_TOP/sql/wfver.sql script.

Yellow bar appears on forms

Posted by on September 13, 2008 No comments

Problem:

When the Java forms are launched, a yellow bar appears at the bottom of the form with the message ‘Warning: applet window’

Cause:

Digital certificate recreated while applying patch (see “adogjf() Unable to generate jar files under JAVA_TOP”)

Solution:

Log on to the server as the applmgr user and perform the following steps:

  1. cd $APPL_TOP/admin
  2. adjkey –initialize
  3. adjbuild.sh /u0/oracle/testcomn/util/jinitiator/ /u0/oracle/testcomn/util/jinitiator/jinit11816.exe
  4. Force regeneration of the JAR files
  5. De-install JInitiator from Windows client
  6. Load E-Business Suite and launch the Java forms

Reference:

Note 141692.1 – How to Install a Digital Certificate in Oracle Applications Release 11i

Note 365735.1 – How to use, create and/or update Digital Certificates for 11i Applications

Introduction to Public-Key Cryptography (http://developer.mozilla.org/en/Introduction_to_Public-Key_Cryptography#Form_Signing)

Responsibilities not appearing after patching

Posted by on September 12, 2008 No comments

Problem:

After logging on to the E-Business Suite PROD instance, all the responsibilities have disappeared.

Solution:

In adadmin, enable maintenance mode. Exit adadmin. Run adadmin again and disable maintenance mode.

Error occurred while compiling application flexfields

Posted by on September 11, 2008 No comments

Problem:

While compiling flexfields using adadmin, the following message appears:

Deleting existing compiled flexfield information.
Compiling all application flexfields.
/u0/oracle/prodappl/fnd/11.5.0/bin/fdfcmp APPS/***** 0 Y
An error occurred while compiling application flexfields.
Continue as if it were successful [No] :

Solution:

Exit adadmin, and then recompile flexfields using adadmin once more.

Javakey

Posted by on September 10, 2008 No comments

This document shows how to use JavaKey.

  1. To display help for javakey, enter the command without any parameters:
 [applmgr@ebusinesstest u0]$ javakey
javakey
        l       list of the identities in the database.
        c       create an new identity.
        r       remove an identity from the database.
        i       import a public key, a key pair, etc.
        g       generate a key pair, a certificate, etc.
        d       display a certficate.
for more information, see documentation.
[applmgr@ebusinesstest u0]$
  1. To list all identities in the database, enter javakey l:
[applmgr@ebusinesstest u0]$ javakey l
Scope: sun.security.provider.IdentityDatabase, source file: /home/applmgr/identitydb.obj
JInitiator[identitydb.obj][trusted]
CWM[identitydb.obj][trusted]
ExpressWebAgent[identitydb.obj][trusted]
OEM_2.0[identitydb.obj][trusted]
obp[identitydb.obj][trusted]
appltop[identitydb.obj][trusted]
Pharm[identitydb.obj][trusted]
Developer[identitydb.obj][trusted]
Discoverer[identitydb.obj][trusted]
OracleApplications[identitydb.obj][trusted]
APPLTOP[identitydb.obj][trusted]
Dev2k[identitydb.obj][trusted]
[applmgr@ebusinesstest u0]$
  1. To create a new identity in the database, enter javakey c <newidentity>:
[applmgr@ebusinesstest u0]$ javakey c TestVS1
Created identity TestVS1[identitydb.obj][not trusted]
[applmgr@ebusinesstest u0]$ javakey c OracleApplications
An error occured trying to add OracleApplications to sun.security.provider.IdentityDatabase, source file: /home/applmgr/identitydb.obj[name conflict]
[applmgr@ebusinesstest u0]$

Invalid responsibility running patch 3262159

Posted by on September 10, 2008 1 comment

Problem:

When running patch 3262159, the following message appears:

ATTENTION: All workers either have failed or are waiting:
FAILED: file FNDLIBR      on worker  1.
ATTENTION: Please fix the above failed worker(s) so the manager can continue.
Checked adwork001.log:
/u0/oracle/prodappl/fnd/11.5.0/bin/FNDLIBR FND FNDCPBWV &ui_apps SYSADMIN 'System Administrator' SYSADMIN
List of errors encountered:
.......................................................................
_ 1 _
Please enter a valid responsibility.  The responsibility System
Administrator does not exist or is not active.  Check that the correct
application short name is specified for your responsibility.
(ROUTINE=AFPSSC)
.......................................................................
AD Worker error:
The above program failed with error code 1.
See the AD Worker log file and/or the program log file for details.

Solution:

In adctrl, used option 8 to skip the worker. Needed to disable, then enable maintenance mode. Then sourced the environment and ran:

/u0/oracle/prodappl/fnd/11.5.0/bin/FNDLIBR FND FNDCPBWV apps/apps SYSADMIN ‘System Administrator’ SYSADMIN

Reference:

Note 259319.1 – Adpatch Fails With Sysadmin Does Not Exist Or Not Active

adogjf() Unable to generate jar files under JAVA_TOP

Posted by on September 9, 2008 No comments

Problem:

While applying patch 6502082, the patch completes in error with the following message:

ERROR: Javakey subcommand exited with status 1
Javakey standard output:
Adding entry: META-INF/MANIFEST.MF
Copyright (c) 2002 Oracle Corporation
Redwood Shores, California, USA
AD Java Key Generation
Version 11.5.0
NOTE: You may not use this utility for custom development
unless you have written permission from Oracle Corporation.
Javakey error output:
Reading product information from file...
Reading language and territory information from file...
Reading language information from applUS.txt ...
Reading language information from applUS.txt ...
Successfully created javaVersionFile.
TEST_hrms not found in database.
java key error:
adjava -ms128m -mx256m sun.security.provider.Main -gs /u0/oracle/prodcomn/java/oracle/apps/pon/jar/ponam.jar.tmp /u0/oracle/prodcomn/java/oracle/apps/pon/jar/ponam.jar.uns
The above Java program failed with error code 1.
Assigned: file adpcpset.pls on worker  1 for product ad  username APPLSYS.

Solution:

  1. Source the apps tier environment (APPSORA.env) and run adjkey –l
[applmgr@ebusiness 6502082]$ adjkey -l
Copyright (c) 2002 Oracle Corporation
Redwood Shores, California, USA
AD Java Key Generation
Version 11.5.0
NOTE: You may not use this utility for custom development
unless you have written permission from Oracle Corporation.
Reading product information from file...
Reading language and territory information from file...
Reading language information from applUS.txt ...
Successfully created javaVersionFile.
Scope: sun.security.provider.IdentityDatabase, source file: /home/applmgr/identitydb.obj
[Signer]Customer[identitydb.obj][trusted]
[Signer]DEMO_ebusiness[identitydb.obj][trusted]
java key is complete.
  1. Rename the identitydb.obj file in /home/applmgr
  2. Run: adjkey –initialize to create a new certificate
[applmgr@ebusiness 6502082]$ mv /home/applmgr/identitydb.obj /home/applmgr/identitydb.obj.20080909a
[applmgr@ebusiness 6502082]$ adjkey -initialize
Copyright (c) 2002 Oracle Corporation
Redwood Shores, California, USA
AD Java Key Generation
Version 11.5.0
NOTE: You may not use this utility for custom development
unless you have written permission from Oracle Corporation.
Reading product information from file...
Reading language and territory information from file...
Reading language information from applUS.txt ...
Successfully created javaVersionFile.
AD Java Key will now create a signing entity for you.
Please enter the name of the entity you wish to create [Customer] :
After creating the signing entity, a certificate will
be created for signing jar files locally.  You can specify an
organization to be used in identifying the certificate.
Please specify an organization to be assigned to the certificate [DEFAULT_ORG] :
Created identity [Signer]Customer[identitydb.obj][trusted]
Generated DSA keys for Customer (strength: 512).
Generated certificate from directive file /u0/oracle/prodappl/admin/out/adcert.txt.
Your digital signature has been created successfully and
imported into the javakey identity database. This signature
will now be used to sign Applications JAR files whenever
they are patched.
IMPORTANT: If you have multiple web servers, you must copy
files to each of the remaining web servers on your site.
See the documentation reference for more information.
java key is complete.

References:

Note 141692.1 – How to Install a Digital Certificate in Oracle Applications Release 11i

Note 365735.1 – How to use, create and/or update Digital Certificates for 11i Applications

Grants missing after applying patch 6502082

Posted by on September 7, 2008 No comments

Problem: The following error occurs when applying patch 6502082 for the second time:

AutoPatch error:

Your database is missing important grants on SYS objects.

To fix this:

1) Log on as the database server owner, and set your environment for maintaining your database server.  Create a directory called $ORACLE_HOME/appsutil/admin and copy $APPL_TOP/admin/adgrants.sql to that directory.

2) Connect to the database as the SYS user and run adgrants.sql passing the name of the schema containing FND tables. For example, if the schema that contains FND tables in your database is called APPLSYS, you would run adgrants.sql as follows:

$ cd $ORACLE_HOME/appsutil/admin

$ sqlplus /nolog

SQL> connect / as sysdba

SQL> @adgrants.sql APPLSYS

Solution: Perform steps listed above

FAILED: file affurgol.sql on worker 1

Posted by on August 25, 2008 No comments

Problem: When applying patch, the following error appears:

ATTENTION: All workers either have failed or are waiting:
           FAILED: file affurgol.sql on worker  1.
ATTENTION: Please fix the above failed worker(s) so the manager can continue.

Checked log file /u0/oracle/testappl/admin/TEST/log/adwork001.log:

declare
*
ERROR at line 1:
ORA-01653: unable to extend table APPLSYS.WF_LOCAL_ROLES_STAGE by 2362205 in
tablespace APPLSYSD
ORA-06512: at "APPS.WF_LOCAL_SYNCH", line 2380
ORA-06512: at line 55

Solution: Resize the next extent to 40K.

SQL> select table_name, initial_extent, next_extent, min_extents, max_extents, pct_increase, blocks from dba_tables where table_name = 'WF_LOCAL_ROLES_STAGE';
TABLE_NAME                     INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE     BLOCKS
------------------------------ -------------- ----------- ----------- ----------- ------------ ----------
WF_LOCAL_ROLES_STAGE                    40960  1.9351E+10           1  2147483645            0          1

SQL> alter table applsys.WF_LOCAL_ROLES_STAGE storage (next 40K);
Table altered.

SQL> select table_name, initial_extent, next_extent, min_extents, max_extents, pct_increase, blocks from dba_tables where table_name = 'WF_LOCAL_ROLES_STAGE';
TABLE_NAME                     INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE     BLOCKS
------------------------------ -------------- ----------- ----------- ----------- ------------ ----------
WF_LOCAL_ROLES_STAGE                    40960       40960           1  2147483645            0          1

SQL> alter table applsys.WF_LOCAL_ROLES_STAGE allocate extent;
Table altered.

SQL> select table_name, initial_extent, next_extent, min_extents, max_extents, pct_increase, blocks from dba_tables where table_name = 'WF_LOCAL_ROLES_STAGE';
TABLE_NAME                     INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE     BLOCKS
------------------------------ -------------- ----------- ----------- ----------- ------------ ----------
WF_LOCAL_ROLES_STAGE                    40960       65536           1         505           50          5