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.
This document shows how to use JavaKey.
[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]$
[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]$
[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]$
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
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:
[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.
[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
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
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
Problem:
While applying patch 6502082, the patch hangs at the line:
Assigned: file adpcpset.pls on worker 1 for product ad username APPLSYS.
Solution:
The Parallel Compile step can take about 32 minutes to run.
Problem: When creating a document in Journal Wizard, an error is displayed: Viewer application profile is not set.
Solution: Set the ‘GL : Default Desktop Viewer’ to a value.
Step 1: To reproduce the error:
Viewer application profile is not set.
Step 2: Open the Find System Profile Values form:
(N) System Administrator > Profile > System
Step 3: Find the profile ‘GL : Default Desktop Viewer’.
Step 4: Enter a value for the ‘GL : Default Desktop Viewer’, such as Excel 2000, Excel 2002, Excel 2003 or Excel 97.
Reference:
Metalink Doc ID: Note:459431.1 (Subject: Launch Journal Wizard Fails With Viewer Application Profile Is Not Set)
Problem: Newly installed Linux is not able to access the Internet.
Solution: Route not configured to the gateway.
At a Terminal window, enter:
route add default netmask 0.0.0.0 gw 200.65.1.7 eth1
Configuration for PC in Software Services Area
The network port used by Linux is the one on the main board, not the Ethernet card that is used by Windows.
[root@enterprise ~]# route Kernel IP routing table Destination Gateway Genmask Flags Metric Ref Use Iface 200.65.1.0 * 255.255.255.0 U 0 0 0 eth1 169.254.0.0 * 255.255.0.0 U 0 0 0 eth1 default 200.65.1.7 0.0.0.0 UG 0 0 0 eth1
Here are some sample SQL*Loader scripts for the ce_statement_headers_int_all and ce_statement_lines_interface tables:
LOAD DATA REPLACE INTO TABLE ce.ce_statement_headers_int_all FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( statement_number CHAR, bank_account_num CHAR, statement_date CHAR, bank_name CONSTANT 'Bank Name', bank_branch_name CONSTANT '', creation_date SYSDATE, last_update_date SYSDATE, control_begin_balance DECIMAL EXTERNAL, control_total_dr DECIMAL EXTERNAL, control_total_cr DECIMAL EXTERNAL, control_end_balance DECIMAL EXTERNAL, control_dr_line_count INTEGER EXTERNAL, control_cr_line_count INTEGER EXTERNAL, control_line_count INTEGER EXTERNAL, currency_code CONSTANT 'TTD', int_calc_balance DECIMAL EXTERNAL ) LOAD DATA REPLACE INTO TABLE ce.ce_statement_lines_interface FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( bank_account_num CHAR, trx_date DATE, attribute1 CHAR, trx_code CHAR, bank_trx_number CHAR, amount DECIMAL EXTERNAL, attribute2 CHAR, trx_text CHAR, statement_number CHAR, line_number INTEGER EXTERNAL, original_amount DECIMAL EXTERNAL, currency_code CHAR, creation_date SYSDATE, last_update_date SYSDATE, charges_amount CONSTANT 0.00 )
Recent Comments