Category Archives: 11i - Page 8

adpcpset.pls hangs applying patch 6502082

Problem:

While applying patch 6502082, the patch hangs at the line:

Assigned: file adpcpset.pls on worker  1 for product ad  username APPLSYS.

Solution:

  1. Stop and restart database tier services (9.2.0 TNS Listener and database)
  2. Apply patch 3586394 (BRANCHED PATCH FOR BUG 3211492 (ADUTLRCMP.PLS) OVER 3242200 (ADHPCP))

The Parallel Compile step can take about 32 minutes to run.

Journal Wizard: Viewer application profile is not set.

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:

  1. (N) General Ledger, Vision Operations (USA) > Journals > Launch Journal Wizard
  2. Click (B) Create Document

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)

CE Sample SQL*Loader Scripts

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
)

Troubleshooting instance after cloning

Situation: After reinstalling Red Hat Enterprise Linux AS 4 on the server and restoring Oracle Applications, the instance is started.

Problem: When accessing page http://ebusiness.support.com:8001/oa_servlets/AppsLogin, the following error is encountered:

Internet Explorer cannot display the webpage

   Most likely causes:
You are not connected to the Internet.
The website is encountering problems.
There might be a typing error in the address.

   What you can try:
     Diagnose Connection Problems  

     More information 

This problem can be caused by a variety of issues, including: 

Internet connectivity has been lost.
The website is temporarily unavailable.
The Domain Name Server (DNS) is not reachable.
The Domain Name Server (DNS) does not have a listing for the website's domain.
If this is an HTTPS (secure) address, click Tools, click Internet Options, click Advanced, and check to be sure the SSL and TLS protocols are enabled under the security section. 

For offline users

You can still view subscribed feeds and some recently viewed webpages.
To view subscribed feeds 

Click the Favorites Center button , click Feeds, and then click the feed you want to view. 

To view recently visited webpages (might not work on all pages) 

Click Tools , and then click Work Offline.
Click the Favorites Center button , click History, and then click the page you want to view.

Solution: Apply patch 4198954. Create a directory 4198954, copy the patch into this directory and extract the patch (two RPMS and README). Install the RPMS using rpm -ivh … . The RPMS install without issue

Then reran patch 3830807. Relink Application files using adadmin, use all defaults for the relink (takes about ten minutes).
Did not work.

Updated /etc/hosts

Checked Apache logs

/u0/oracle/testora/iAS/Apache/Apache/logs/error_log
/u0/oracle/testora/iAS/Apache/Jserv/logs/mod_jserv.log

See Metalink Doc ID: Note: 231137.1 “Troubleshooting the Self Service Framework with Oracle Applications”

Search for: File does not exist: /oa_servlets/AppsLogin
See Metalink Doc ID: Note: 344379.1  “Subject:  File Not Found /oa_servlets/AppsLogin”

http://ebusiness.support.com:8001/pls/TEST/fnd_web.ping

http://ebusiness.support.com:8001/OA_HTML/US/ICXINDEX.htm

ftp /usr/java/j2sdk-1_3_1_11-linux-i586.rpm.bin from 200.65.1.86 into the /usr/java (make this directory if necessary)
chmod a+x j2sdk-1_3_1_11-linux-i586.rpm.bin
Unzips jdk-1.3.1_11.i586.rpm
rpm -ivh jdk-1.3.1_11.i586.rpm

SUCCESS! Page appears.

Installing Oracle Applications Release 11.5.10.2 on Demo Laptop (Windows 2000 Pro)

Installing Oracle Applications Release 11.5.10.2 on Demo Laptop (Windows 2000 Pro)
———————————————————————————-

See Metalink Doc ID:  Note: 316806.1 (Subject: Oracle Applications Installation Update Notes, Release 11i (11.5.10.2))

1. Installed Windows 2000 Pro on 160GB hard drive: C: 160GB
Formatting C: as NTFS took about 1 hour
Setup copied all files on hard drive

2. Under Personalize Your Software:
Name: applmgr
Organization: Illuminat

3. Under Computer Name and Administrator Password
Computer name: APPSWINDOWS
Administrator password: <leave blank>

4. Install Windows 2000 Service Pack 4.

5.
******************************************
THIS WORKS: ENABLE LOOPBACK ADAPTER & DISABLE NETWORK ADAPTER
SET LOOPBACK ADAPTER TO STATIC IP ADDRESS
IP: x.x.x.x
GATEWAY: 255.255.255.0

PRIMARY DNS: x.x.x.x
SECONDARY DNS: x.x.x.x
******************************************

6. Install a printer (any printer will do, for example EPSON FX-80)

7. Make directory C:TEMP. Point environment variable to TEMP, TMP and TMPDIR to C:TEMP.

8. Install MKS Toolkit to C:mksnt.

9. Install Microsoft Visual C++ 6.0 to C:VC98. Apply Visual Studio Service Pack 3.

10. Unzip GnuMake to a temporary directory (e.g. C:TEMP). (No need to install Zip/Unzip and Java. Run ‘which unzip.exe’). Recompile GNU Make by running VCVARS32.bat and then changing to the GNU Makebin directory and running build_w32.bat (TWICE). Change to the WinRel directory and copy gnumake.exe to c:mksntmksnt.

Answering adadmin Prompts

This section shows the typical responses for an adadmin session. Note that in this example, the VIS2 instance is used. The directories shown may differ for another instance. Note that pressing Enter for the responses uses the default answer, shown in brackets ([]).

[applmgr@appslinux ~]$ cd /u2/oracle/vis2appl/
[applmgr@appslinux vis2appl]$ . APPSORA.env
[applmgr@appslinux vis2appl]$ adadmin logfile=adadmin_20080516a.log
                     Copyright (c) 2002 Oracle Corporation
                        Redwood Shores, California, USA
                     Oracle Applications AD Administration
                                 Version 11.5.0
NOTE: You may not use this utility for custom development
      unless you have written permission from Oracle Corporation.
Your default directory is '/u2/oracle/vis2appl'.
Is this the correct APPL_TOP [Yes] ? <Press Enter> 
************* Start of AD Administration session *************
AD Administration version: 11.5.0
AD Administration started at: Fri May 16 2008 13:30:01
APPL_TOP is set to /u2/oracle/vis2appl
You can be notified by email if a failure occurs.
Do you wish to activate this feature [No] ? <Press Enter>
Please enter the batchsize [1000] : <Press Enter>
Please enter the name of the Oracle Applications System that this
APPL_TOP belongs to.
The Applications System name must be unique across all Oracle
Applications Systems at your site, must be from 1 to 30 characters
long, may only contain alphanumeric and underscore characters,
and must start with a letter.
Sample Applications System names are: "prod", "test", "demo" and
"Development_2".
Applications System Name [VIS2] : VIS2 *
NOTE: If you do not currently have certain types of files installed
in this APPL_TOP, you may not be able to perform certain tasks.
Example 1: If you don't have files used for installing or upgrading
the database installed in this area, you cannot install or upgrade
the database from this APPL_TOP.
Example 2: If you don't have forms files installed in this area, you cannot
generate them or run them from this APPL_TOP.
Example 3: If you don't have concurrent program files installed in this area,
you cannot relink concurrent programs or generate reports from this APPL_TOP.
Do you currently have files used for installing or upgrading the database
installed in this APPL_TOP [YES] ? YES *
Do you currently have Java and HTML files for HTML-based functionality
installed in this APPL_TOP [YES] ? YES *
Do you currently have Oracle Applications forms files installed
in this APPL_TOP [YES] ? YES *
Do you currently have concurrent program files installed
in this APPL_TOP [YES] ? YES *
Please enter the name Oracle Applications will use to identify this APPL_TOP.
The APPL_TOP name you select must be unique within an Oracle Applications
System, must be from 1 to 30 characters long, may only contain
alphanumeric and underscore characters, and must start with a letter.
Sample APPL_TOP Names are: "prod_all", "demo3_forms2", and "forms1".
APPL_TOP Name [appslinux] : appslinux *
You are about to use or modify Oracle Applications product tables
in your ORACLE database 'VIS2'
using ORACLE executables in '/u2/oracle/vis2ora/8.0.6'.
Is this the correct database [Yes] ? <Press Enter>
AD Administration needs the password for your 'SYSTEM' ORACLE schema
in order to determine your installation configuration.
Enter the password for your 'SYSTEM' ORACLE schema: manager
The ORACLE username specified below for Application Object Library
uniquely identifies your existing product group: APPLSYS
Enter the ORACLE password of Application Object Library [APPS] : <Press Enter>
AD Administration is verifying your username/password.
The status of various features in this run of AD Administration is:
                                           <-Feature version in->
Feature                          Active?   APPLTOP    Data model    Flags
------------------------------   -------   --------   -----------   -----------
CHECKFILE                        Yes       1          1             Y N N Y N Y
PREREQ                           Yes       6          6             Y N N Y N Y
CONCURRENT_SESSIONS              No        2          2             Y Y N Y Y N
PATCH_TIMING                     Yes       2          2             Y N N Y N Y
PATCH_HIST_IN_DB                 Yes       6          6             Y N N Y N Y
SCHEMA_SWAP                      Yes       1          1             Y N N Y Y Y
Identifier for the current session is 33937
Reading product information from file...
Reading language and territory information from file...
Reading language information from applUS.txt ...
Reading database to see what industry is currently installed.
Reading FND_LANGUAGES to see what is currently installed.
Currently, the following language is installed:
Code   Language                                Status
----   --------------------------------------- ---------
US     American English                        Base
Your base language will be AMERICAN.
Setting up module information.
Reading database for information about the modules.
Saving module information.
Reading database for information about the products.
Reading database for information about how products depend on each other.
Reading topfile.txt ...
Saving product information.
AD code level : [11i.AD.I.6]

Exception in TimedProcess

Problem: When attempting to start or stop the Oracle instance, the following message is returned:

Executing service control script:

/u3/oracle/vis4comn/admin/scripts/VIS4_appslinux/adcmctl.sh stop

script returned:

****************************************************

ERROR :

Exception in TimedProcess…Failed to  execute command =

/u3/oracle/vis4comn/admin/scripts/VIS4_appslinux/adcmctl.sh stop apps/apps

****************************************************

Solution: You are not logged on as the Oracle user (most likely as root). Log on as the Oracle user (applmgr or oracle)

11i Installation Troubleshooting

Installation of 11i instance on Windows Server 2003

1. Installed Visual C++ 6.0 and Visual Studio Service Pack 4

2. Set IP address in hosts file

3. Installed ActivePerl and Microsoft XML Parser

4. Started staging process:
cd
perl E:Disk1rapidwizadautocfg.pl

Error Encountered:
—————–
Only 12-13 files copied from Start CD

5. Uninstalled MKS Toolkit from C:Program Files and reinstalled it to C:mksnt

6. Changed TEMP environment variables to C:TEMP

7. Retried staging process:

Error Encountered:
—————–

Failed to copy adautocfg.pl to C:TEMPstaging

8. Determined which perl was being executed:
which perl

perl from MKS Toolkit being executed, because it is ahead of ActivePerl on path.

9. Uninstalled and reinstalled ActivePerl.

10. Retried staging process. Same error (Failed to copy adautocfg.pl to C:TEMPstaging)

11. Modified PATH environment variable so that ActivePerl (C:PERLbin) ahead of MKS Toolkit in path

12. Retried staging process. Staging progressing without errors.

13. Started installation by running rapidwiz

Error Encountered:
—————–

‘which’ not found

Solution:
——–

In Rapid Install, set MKS Directory to C:mksntmksnt

Error Encountered:
—————–

‘gnumake’ not found

Solution:
——–

Unzip make3.81 tar, set VC environment (VCVARS.bat), compiled gnumake (build_w32.bat) and copied gnumake.exe to C:Windowssystem32. Check that gnumake is in path by typing ‘which gnumake’

14. No errors encountered while installing. Post-install steps completed successfully.

15. After installing, logged on to application and submitted concurrent job. ‘Inactive Manager’

Error Encountered:
—————–

Active Users report completed on error:

ERR REP-3002: Error initializing printer. Please make sure a printer is installed.

Solution:
——–

Checked Metalink Doc ID: Note:365267.1 (Subject: All Requests End In Error With REP-3002: Error Initializing Printer)

Installed a local printer (Epson FX-80)

Error Encountered:
—————–

Internet Explorer crashing when forms are loaded.

Solution:
——–

Deinstall JInitiator and reinstall it.

Installing Oracle Applications 11i Checklist

This is a list of steps to check for when installing Oracle Applications.

Step 1:        Ensure that hostname and IP address are in hosts file. Under Windows, ensure that in the hosts file, the hostname is in the following order:

127.0.0.1                    localhost.localdomain                       localhost

xx.xx.xx.xx               hostname.domainname                   alias

Step 2:        Ping machine. It should return:

C:> ping alias

Pinging hostname.domainname [xx.xx.xx.xx] with 32 bytes of data:

Step 3:        Create domain user applmgr and ensure that it is assigned to the Administrators group of the local machine.

Step 4:        Install Visual C++ 6.0 to C:VC98 and apply service pack 4

Step 5:        Install Cygwin to C:cygwin (see Metalink document “Using Cygwin to Maintain Release 11i on Windows” Doc ID:302859.1 for packages to download).

Step 6:        To compile GNU Make, run VCVARS.bat from Visual C++ directory and in the gnumake-3.79.1 directory, run build_w32.bat twice. Copy gnumake.exe to c:cygwinbin (or C:mksntmksnt).

Step 7:        Install Microsoft XML Parser (MSXML) 3.0 Service Pack 4 or later SDK. Copy file from Microsoft XML Parserlib to C:VC98lib.( 11.5.9)

Step 8:        Install Java SDK 1.3.1_18 (11.5.9) (or 1.3.1_15?)

Step 9:        Install Perl (download ActivePerl from http://www.perl.com) (11.5.10)

Step 10:   Copy zip.exe and unzip.exe to C:mksntmksnt

Step 11:    Ensure that all files are on the path:

which gnumake

which perl

which zip

which cc

which link

Modify path if necessary to include: C:Perlbin; C:cygwinbin;C:VC98bin.

Step 12:   Ensure correct versions of Perl and Java installed:

Perl –version

ActivePerl version should be v5.8.8

On Linux, Perl should be 5.003 or later

Java –version

Should be 1.3.1_18

Step 13:   Set TEMP and TMP environment variables for user applmgr to C:TEMP.

Step 14:   Check manual on startCD for instructions on directory structure (11.5.9).

Step 15:   Set up staging area.

Invalid MIT-MAGIC-COOKIE-1 key

Problem: When the Statement of Account report (a PDF-output report) is run, it gives the following error message:

Spawned Process 6276
Xlib: connection to "oradata:0.0" refused by server
Xlib: Invalid MIT-MAGIC-COOKIE-1 key
Xlib: connection to "oradata:0.0" refused by server
Xlib: Invalid MIT-MAGIC-COOKIE-1 key
REP-3000: Internal error starting Oracle Toolkit.
REP-3000: Internal error starting Oracle Toolkit.

Solution: Set the DISPLAY environment variable and run xhost +.

root@ORADATA # echo $DISPLAY
root@ORADATA # xhost
xhost:  unable to open display ""
root@ORADATA # DISPLAY=10.0.240.13:0.0
root@ORADATA # xhost
xhost:  unable to open display ""
root@ORADATA # export DISPLAY
root@ORADATA # xhost
access control enabled, only authorized clients can connect
root@ORADATA # xhost +
access control disabled, clients can connect from any host
root@ORADATA #