Monthly Archives: October 2008

ServiceAliasException: Could not initialize Service Alias: TNS-04404

Problem:

After installing Oracle Database 10g (10.2.0.1) and upgrading it to 10.2.0.2, the listener service was not created. When attempting to create using netca (from the Command Prompt), the following error appears:

ServiceAliasException: Could not initialize Service Alias: TNS-04404

Solution:

In the C:oracleproduct10.2.0db_1networkADMIN directory, rename the listener.ora, sqlnet.ora and tnsnames.ora to listener.ora.bak, sqlnet.ora.bak and tnsnames.ora.bak.

Then rerun netca (Net Configuration Assistant) to recreate the sqlnet.ora (second option on the menu), listener.ora (first option) and tnsnames.ora (third option).

After exiting netca, start the listener by issuing the command ‘lsnrctl start’.

Changing Domain Name in Oracle Applications 11i

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

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

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