Changing Domain Name in Oracle Applications 11i

Posted by on October 15, 2008 No comments

This documentation shows how to change the network domain name of the server that houses an Oracle Applications 11i instance (ebusiness).

  1. Log on to the ebusiness server (either on the console or using VNC or PuTTY). Run the network system settings tool (Red Hat menu > System Settings > Network).

Change the server name from ebusiness.support.com to ebusiness. illuminatnm.com. Save the settings. Do not attempt to restart the network services using this tool, since it will disconnect the remote connection tool.

  1. Edit the context file $APPL_TOP/admin/TEST_ebusiness.xml and replace ‘support.com’ with ‘illuminatnm.com’. With vi, use this command:
:%s/support.com/illuminatnm.com/g

Save the context file and exit the text editor.

  1. Stop the application tier services and then run AutoConfig on the database and application tiers:
cd /u0/oracle/testcomn/admin/scripts/TEST_ebusiness
./adstpall.sh

On the database tier:

cd /u0/oracle/testdb/9.2.0
. TEST_ebusiness.env
cd /u0/oracle/testdb/9.2.0/appsutil/scripts/TEST_ebusiness
./adautocfg.sh

On the application tier:

cd /u0/oracle/testappl
. APPSORA.env
cd /u0/oracle/testcomn/admin/scripts/TEST_ebusiness
./adautocfg.sh

Run the database tier and application tier AutoConfig processes in separate sessions (terminal windows).

  1. As the root user, update the hosts file on the server (/etc/hosts) to reflect the new host name:
x.x.x.x   ebusiness.illuminatnm.com   ebusiness
  1. As the root user, restart network services:
service network restart
  1. As the applmgr user, bounce the application tier services.
cd /u0/oracle/testcomn/admin/scripts/TEST_ebusiness
./adstpall.sh
(wait five minutes)
./adstrtal.sh
  1. Log on to the E-Business TEST application on the client machine using the new URL:
http://ebusiness.illuminatnm.com:8001

If E-Business Suite does not launch properly, reboot the server. After booting, start the application tier services. Then log on to the TEST instance.

Metalink References:

Note: 177311.1 – How to Change Domain Name in Oracle Applications 11i

Note: 342332.1 – Troubleshooting Login Problems in Oracle Applications 11i (11.5.2 – 11.5.10+)

Customizing Fixed Assets Manager

Posted by on October 13, 2008 No comments

1. Navigate to System Administrator > Application > Menu.
Query FA_MAIN in the User Menu  Name field.
Note the values in the Menu, User  Menu Name, Menu Type and Description fields.

2. Clear the form and enter a new menu.
In the Menu and User Menu Name  fields, enter CUSTOM_FA_MAIN.
Enter the same Menu Type (Standard)  and enter a new description (Custom Main menu for Oracle Assets).
Enter the original menu name as a  submenu of the custom menu. Then click Save.

3. Navigate to System Administrator > Security > Responsibility > Define
In the Responsibility Name field, query Fixed Assets Manager.
Note the Responsibility Name,  Application, Responsibility Key, Description, Data Group Name, Menu and Request Group Name.

4. Clear the form and enter a new responsibility. Enter a new Responsibility Name, Responsibility Key and Description.
The Menu must be the custom menu  created above. The Application, Data Group Name and Request Group Name fields remain the same.
Under Menu Exclusions, choose Menu and select the FA_SETUP_MAIN menu.
Then click Save.

5. Navigate to System Administrator > Security > User > Define
To add the custom responsibility to a user, query the user.
Under Direct Responsibilities, insert the custom responsibility.
Then click Save.

Note that the menu exclusion for the Fixed Assets Manager was included (FA_PURGE) in the new
responsibility Custom Fixed Assets Manager, so that additional functionality would not appear in this new
responsibility.

Report Manager SuperUser FRS Issue

Posted by on October 7, 2008 No comments

Report Manager SuperUser > Financial Report Submission

1. Submission Parameters

Primary Parameters:

Report Name: Actual/Budget Income Statement
Period: Dec-07
Date: 31-Dec-2007
Currency: USD
Ledger: Vision Operations (USA)
Content Set: <blank>
Display Set: <blank>
Row Order: Account Format
Rounding Option: Calculate Then Round
Flag Exception: <blank>

Additional Parameters:

Segment Override: <blank>

Scheduling Options:

Now Selected

Click Next.

2. Publishing Parameters

Primary Parameters:

Default Template: Actual/Budget Income Statement
Timeframe: Dec-07
Set Auto Archive? No

Security:

No Security Selected

Availability:

Now Selected

Click Next.

3. Storage Location

Location: Use Last

Click Next.

4. Warning

The report and timeframe selected already exists in the selected Publishing Location. Do you wish to overwrite?

Click Yes.

5. Presentation

Create Menu Item for this report? Unchecked

Click Next.

6. Review

Click Submit.

7. Confirmation

Click Monitor Requests

8. Requests

Click Refresh until Actual/Budget Income Statement (Publish and Presentation Program) completes.

Then click Output.

9. Click View Report Now

10. In the Actual/Budget Income Statement, click the hyperlink in any cell.

The following appears:

Error

The following error has occurred
Exception Name: oracle.apps.bne.exception.BneFatalException – You do not have permission to access this functionality.
Action: Please contact your support representative.
Log File Bookmark: 309685

Solution (R12):

1. Navigate to:

System Administrator > Application > Function

The Form Functions form appears. Under the Description tab, search for each of the following functions under User Function Name field:
Account Analysis and Drilldown
FSG Drilldown: Launch Page
FSG Drilldown: Select Content Set Rows
FSG Drilldown: Effective Range Selection Page
FSG Drilldown: Balance Inquiry Page

Ensure that the corresponding User Function Names have the following corresponding functions (which do not end in _G):
Account Analysis and Drilldown                  GL_INQ_SEARCH
FSG Drilldown: Launch Page                      GL_INQ_FSG_DRL_LAUNCH
FSG Drilldown: Select Content Set Rows          GL_INQ_FSG_DRL_CONTENT
FSG Drilldown: Effective Range Selection Page   GL_INQ_FSG_DRL_EFF_RNG
FSG Drilldown: Balance Inquiry Page             GL_INQ_FSG_DRL_BAL_INQ

2. Added Web ADI, Vision University responsibility to user OPERATIONS.

3. Set profile ‘BNE Allow No Security Rule’ to Yes at Responsibility level

4. Turn on Web ADI Debug Info for logging:

Set the profiles under System Administrator – System Profiles
Example:
BNE Server Log Filename : <create name> (make sure name doesn’t exist already and if it does, delete it)
BNE Server Log Level : TRACE
BNE Server Log Path : free to choose, eg. in the IAS_TOP/Apache/Jserv/logs (use the full path)

Current Values:
BNE Server Log Filename : bne.log
BNE Server Log Level : ERROR
BNE Server Log Path : /usr/tmp

New Values:
BNE Server Log Filename : bne.log
BNE Server Log Level : TRACE
BNE Server Log Path : /usr/tmp

Reproduce the issue.

Once the issue was reproduced, turn off Trace by setting BNE Server Log Level back to Detail.

Log file /usr/tmp/bne.log shows the following error:

10/7/08 2:12 PM AJPRequestHandler-ApplicationServerThread-9 ERROR          BneUIXUtils.createErrorPage() Page: Page[name=]
10/7/08 2:12 PM AJPRequestHandler-ApplicationServerThread-9 ERROR          BneUIXUtils.createErrorPage() Event: PageEvent[name=null,FrmDrillContext=p1001r100002l100002c1002,bne:page=oracle.apps.frm.drilldown.webui.DrillOARedirectPage,FrmDocId=3001]
10/7/08 2:12 PM AJPRequestHandler-ApplicationServerThread-10 ERROR          DrillOARedirectPage.renderPage() Failed functionSecurity Check for function: GL_INQ_SEARCH
10/7/08 2:12 PM AJPRequestHandler-ApplicationServerThread-10 ERROR          BneUIXUtils.createErrorPage() Error number 522858
10/7/08 2:12 PM AJPRequestHandler-ApplicationServerThread-10 ERROR          BneUIXUtils.createErrorPage() Stack Trace:
oracle.apps.bne.exception.BneFatalException: You do not have permission to access this functionality.
        at oracle.apps.frm.drilldown.webui.DrillOARedirectPage.renderPage(DrillOARedirectPage.java:114)
        at oracle.apps.bne.webui.framework.BneBasePageController.createPageBody(BneBasePageController.java:529)
        at oracle.apps.bne.webui.framework.BneBasePageController.handlePage(BneBasePageController.java:287)
        at oracle.apps.bne.webui.BneApplicationService.handleRequest(BneApplicationService.java:157)
        at oracle.apps.bne.framework.BneBajaServlet.doRequest(BneBajaServlet.java:246)
        at oracle.apps.bne.framework.BneBaseServlet.doGet(BneBaseServlet.java:79)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:743)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
        at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
        at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)
        at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
        at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318)
        at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:627)
        at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:376)
        at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:870)
        at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:451)
        at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:299)
        at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:187)
        at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
        at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
        at java.lang.Thread.run(Thread.java:595)

Note the error:

Failed functionSecurity Check for function: GL_INQ_SEARCH

5. Add Missing Functions to Report Manager SuperUser menu

Check Security > Responsibility > Define to get menu

Responsibility Name: Report Manager SuperUser
Menu: RptMgr SuperUser

Add the following functions to the Report Manager Superuser menu:
Account Analysis and Drilldown
FSG Drilldown: Launch Page
FSG Drilldown: Select Content Set Rows
FSG Drilldown: Effective Range Selection Page
FSG Drilldown: Balance Inquiry Page

Do not add any prompts or descriptions for the functions.

Reference:

Subject:  Report Manager FSG DrillDown Fails With You Do Not Have Permission
Doc ID:  Note:436502.1

[amazon asin=0071779728&template=iframe image&chan=default]     [amazon asin=1849680620&template=iframe image&chan=default]     [amazon asin=0071622292&template=iframe image&chan=default]

Insufficient privileges for cloning

Posted by on September 23, 2008 No comments

Problem:

When trying to log on to the newly cloned TEST instance as sysadmin user, the following error appears:

You have insufficient privileges for the current operation. Please contact your System Administrator.

Solution:

Used URL:

http://ebusinesstest.support.com:8001/OA_HTML/jsp/fnd/aoljtest.jsp

to compare differences between TEST and PROD. Noticed that JSP Ping not working on both.

In Metalink, searched for error:

java.lang.StringIndexOutOfBoundsException: String index out of range: -1

Checked document: Subject:  Troubleshooting Login (Doc ID:  Note:178437.1), “3. Login: java.lang.StringIndexOutOfBoundsException when log into jtflogin.jsp”

In SQL*Plus, executed the following code:

select SESSION_COOKIE_DOMAIN from icx_parameters;

update icx.icx_parameters set SESSION_COOKIE_DOMAIN = ‘.support.com’;

commit;

select SESSION_COOKIE_DOMAIN from icx_parameters;

Tested logon on ebusinesstest, working now.

Reference:

Subject:  Configuring and Troubleshooting the Self Service Framework 5.5.2 with 11i (Doc ID:  Note:177095.1)

TNS Connectivity With Database Breaks Running Autoconfig (Cloning)

Posted by on September 22, 2008 No comments

Problem:

When running AutoConfig, it fails at 50% with the following error:

ERROR

ORA-12224: TNS:no listener

Solution:

Run the following, and then restart AutoConfig.

perl <AD_TOP>/bin/adgentns.pl appspass=<APPSpwd> contextfile=<CONTEXT> -removesystem

perl /u0/oracle/testappl/ad/11.5.0/bin/adgentns.pl appspass=APPS contextfile=/u0/oracle/testappl/admin/TEST_ebusinesstest.xml –removesystem

Reference:

Subject:  TNS Connectivity With Database Breaks After Running Autoconfig

Doc ID:  Note:377764.1

1020  unzip -od /u0/oracle/testora/iAS/ /u0/patches/p5035661_11i_LINUX.zip

1021  . /u0/oracle/testappl/APPSTEST_ebusinesstest.env

1022  cd /u0/oracle/testora/iAS/appsoui/setup/

1023  perl OUIsetup.pl

1024  perl /u0/oracle/testappl/ad/11.5.0/bin/adgentns.pl appspass=APPS contextfile=/u0/oracle/testappl/admin/TEST_ebusinesstest.xml -removesystem

1025  cd /u0/oracle/testcomn/clone/bin/

1026  perl adcfgclone.pl appsTier

Version of OUI too low (Cloning)

Posted by on September 21, 2008 No comments

Problem:

When rerunning adcfgclone.pl, the following error occurs:

ERROR: The version of the OUI found in /u0/oracle/testora/iAS/appsoui (2.1.0.17.0) is too low. Please make sure that you have applied the latest OUI patch required by Rapid Clone.

Restart adclone.pl after performing required corrections.

ERROR: Failed to execute adclone.pl

Solution:

Apply patch 5035661:

A. Applying the patch on the iAS $ORACLE_HOME:

———————————————-

1.Unzip the patch into the <iAS ORACLE_HOME> directory:

unzip -od <iAS ORACLE_HOME> p5035661_11i_<PLATFORM>.zip

ie: unzip -od /u01/oracle/prodora/iAS p5035661_11i_LINUX.zip

2.Source the Apps environment file :

On Unix/Linux, execute <APPL_TOP>/APPS<SID>_<hostname>.env

On Windows, execute <APPL_TOP>Envshell.cmd.

If the environment file is not available, please make sure the environment variable ‘APPL_TOP’ is set.

3.Change directory to the <iAS ORACLE_HOME>/appsoui/setup

4.Execute the perl script OUIsetup.pl:

perl OUIsetup.pl

NOTE:

In the case of a Multi-Node instance, the above process should be repeated on the <iAS ORACLE_HOME> of each Node.

unzip -od /u0/oracle/testora/iAS/ /u0/patches/p5035661_11i_LINUX.zip

. /u0/oracle/testappl/APPSTEST_ebusinesstest.env

cd /u0/oracle/testora/iAS/appsoui/setup/

perl OUIsetup.pl

Error AC-50207 occurs while cloning

Posted by on September 20, 2008 No comments

Problem:

When running adcfgclone.cfg on the Apps tier, it completes with the following error:

Running Rapid Clone with command:

perl adclone.pl java=../jre/1.3.1 mode=apply stage=/u0/oracle/testcomn/c lone/bin/.. component=appsTier method=CUSTOM appctxtg=/u0/oracle/testappl/admin/ TEST_ebusinesstest.xml  showProgress contextValidated=true

Beginning application tier Apply – Thu Sep 18 14:33:30 2008

Log file located at /u0/oracle/testappl/admin/TEST_ebusinesstest/log/ApplyAppsTi er_09180233.log

–     50% completed

AC-50207: Fatal: Failed to execute one or more of the config tools during Contex t Value Management

Deactivating Context Value Management System.

Restored the Context file in :

/u0/oracle/testappl/admin/TEST_ebusinesstest.xml

Aborting the running of Context Value Management

Error occured before Context Value Management could be completed

|     50% completed       WARNING: AutoConfig completed with errors. Check log file at /u0/oracle/testappl/admin/TEST_ebusinesstest/log/ApplyAppsTier_09180233. log for details.

/u0/oracle/testappl/admin/TEST_ebusinesstest/log/ApplyAppsTier_09180233.log shows:

[AutoConfig Error Report]

The following report lists errors AutoConfig encountered during each

phase of its execution.  Errors are grouped by directory and phase.

The report format is:

<filename>  <phase>  <return code where appropriate>

[SETUP PHASE]

AutoConfig could not successfully execute the following scripts:

Directory: /u0/oracle/testcomn/admin/install/TEST_ebusinesstest

adgentopfile.sh         INSTE8_SETUP       1

AutoConfig is exiting with status 1

Solution:

Source the apps tier environment and run AutoConfig (/u0/oracle/testcomn/admin/scripts/TEST_ebusinesstest/adautocfg.sh)

Important 11i Files, Directories, Locations

Posted by on September 19, 2008 No comments

This documentation lists important files, directories and locations.

Output for adadmin and adpatch:

$APPL_TOP/admin/<SID>/log

Output for concurrent requests:

$COMMON_TOP/admin/log/<CONTEXT_NAME>

$COMMON_TOP/admin/out/<CONTEXT_NAME>

Output files from installation:

Database logfile:

$ORACLE_HOME/appsutil/log/<CONTEXT_NAME>

e.g. C:oraclevisdb9.2.0appsutillogVIS_eam 11060210.log

Appltop logfile:

$APPL_TOP/admin/<CONTEXT_NAME>/log

e.g. C:oraclevisappladminVIS_eamlog11060210.log

Output files from running AutoConfig:

Database logfile:

<RDBMS ORACLE_HOME>/appsutil/log/<CONTEXT_NAME> /<MMDDhhmm>/adconfig.log

e.g. C:oraclevisdb9.2.0appsutillogVIS_eam 11160751adconfig.log

Appltop logfile:

<APPL_TOP>/admin/<CONTEXT_NAME>/log/<MMDDhhmm>

e.g. C:oraclevisappladminVIS_eamlog11060210.log

Output files from running TUMS:

$COMMON_TOP/temp

Database context file:

<RDBMS ORACLE_HOME>/appsutil/<CONTEXT_NAME>.xml

e.g. C:oraclevasudb9.2.0appsutilVASU_localhost.xml

Application context file:

$APPL_TOP/admin/<CONTEXT_NAME>.xml

e.g. C:oraclevasuappladminVASU_localhost.xml

Concurrent manager log file:

$APPLCSF/$APPLLOG/SID_MMDD.mgr

JInitiator files:

$APPL_TOP/admin/appltop.cer

$APPL_TOP/admin/adsign.txt

$APPL_TOP/admin/adcert.txt

$HOME/identitydb.obj (/home/applmgr)

Launch Forms Logon:

http://<server>:<port>/dev60cgi/f60cgi

Launch Self Service Personal Home Page Mode (“Personal Home Page”):

http://<server>:<port>/OA_HTML/US/ICXINDEX.htm

Launch Self Service Personal Home Page Mode (“Framework only”):

http://<server>:<port>/oa_servlets/AppsLogin

Test your Webserver setup for Self Service Framework Applications:

http://ebusinesstest.support.com:8001/OA_HTML/jsp/fnd/aoljtest.jsp

Running Oracle Configuration Manager

Posted by on September 19, 2008 No comments

Download Oracle Configuration Manager from Metalink > Software Configuration Manager, and copy to the server.

ocm-Production-Linux-i386.zip

Note: source database tier environment file.

1. Unzip the Oracle Configuration Manager distribution file into the ORACLE_HOME directory as follows:

unzip -d $ORACLE_HOME ocm-Production-Linux-i386.zip

2. After the file has been unzipped, install and complete the configuration of Oracle Configuration Manager by entering the following command:

$ORACLE_HOME/ccr/bin/setupCCR -s  xxxxxxxx vasudev.seeram@emaildomain.com TT

where xxxxxxxx is your CSI number

3. To configure the database for configuration collection, run the following script:

$ORACLE_HOME/ccr/admin/scripts/installCCRSQL.sh collectconfig -s TEST -r sys -p syspassword

4. To configure an Oracle E-Business Suite, run the following script from the $ORACLE_HOME:

$ORACLE_HOME/ccr/admin/scripts/installCCRSQL.sh ebs_collectconfig -u apps -w appspassword -s TEST

5. To check status of Scheduler:

$ORACLE_HOME/ccr/bin/emCCR status

6. To start the Scheduler:

$ORACLE_HOME/ccr/bin/emCCR start

7. To manually collect data for the instance and upload it:

$ORACLE_HOME/ccr/bin/emCCR collect

Reference:

http://download.oracle.com/docs/cd/B19306_01/install.102/b28484/install.htm

Export Function Not Working

Posted by on September 19, 2008 No comments

Steps to reconfigure exporting in Oracle Applications:

1. Set System Profile Options ‘Export: Mime type’ to ‘text/tab-separated-values’

2. Setup your browser and Windows Explorer with this new mime type (if using Internet Explorer) :

– start Windows Explorer
– choose menu Tools => Folder Options…
– click on ‘File Types’ tab
– click on ‘New’ button to add a new type: File Extension: tsv
– click on ‘Advanced’ button and complete with: Associated File Type:
‘Microsoft Office Excel Comma Separated File’ (select it from the list)
– enable ‘Automatic prompting for file downloads’ option from Internet
Explorer: menu Tools => Internet Options… Security tab => click on ‘Custom Level’ button => ‘Downloads’ section

Next, run the “Rebuild Help Search Index” concurrent program as follows:

1. Log into PROD
2. Choose the System Administrator responsibility
3. Navigate to Requests > Run
4. Choose “Single Request” and press “OK”
5. In the Name field choose the process “Rebuild Help Search Index”
6. A box with parameters will popup – leave the defaults and press “OK”
7. Press “Submit” to run the report
8. To view the progress of the process navigate to Requests > View and find all requests.