Tag Archives: System Profiles

Customizing R12 Start Page Logo

Posted by on August 27, 2012 No comments

Customizing R12 Start Page Logo

Problem:

How do I change or customize the Oracle logo on the R12 E-Business Suite Oracle Application Framework (OAF)/Self-Service Pages?

Solution:

In EBS, navigate to System Administrator > Profile > System

Query “Corporate Branding Image for Oracle Applications” and set its value at the Site Level to name of the picture file with the new logo. The file can be PNG, JPG or GIF (you may need to experiment to confirm this).

On the server, place the picture file in the $OA_MEDIA directory (such as F:oraclePRODappsapps_stcomnjavaclassesoracleappsmedia).

Reference:

Customizing the Corporate Branding Image for JTF-based Pages [ID 1464570.1]

An error occurred while attempting to establish an Applications File Server connection with the node FNDFS

Posted by on July 5, 2012 No comments

Problem:

In R12, after a concurrent request is run and the log file is viewed, when Tools –> Copy File is selected, a browser window opens and displays the following message:

An error occurred while attempting to establish an Applications File Server 
connection with the node FNDFS_. There may be a network configuration problem, 
or the TNS listener on node FNDFS_ may not be running. Please contact your 
system administrator.

Solution:

Set the RRA: Enabled system profile to Yes at the site level, log off and then log back on.

[amazon asin=0070077290&template=iframe image&chan=default]    [amazon asin=1453742735&template=iframe image&chan=default]    [amazon asin=0615238440&template=iframe image&chan=default]

The business group specified is invalid

Posted by on June 22, 2012 No comments

Problem:

After running a data pump import, the following is displayed in the “Data Pump Batch Exceptions Report”:

The business group specified is invalid

Cause:        You have specified an incorrect business group
identifier or name.
Action:        Correct the business group value or call your
local support representative.

Possible Solution:

Ensure that the business group in the data pump file matches the system profiles:

Profile > System > HR:Business Group
Profile > System > HR: Security Profile

 

You do not have permission to use this software

Posted by on June 15, 2012 No comments

Problem:

When access the Employee Self-Service page in R12, the following error appears:

Error
You do not have permission to use this software
Please contact your Information Technology Department.

Solution:

Set the system profile option ‘HR: Self Service HR Licensed’ to ‘Yes’ at the site level.

Reference:

https://forums.oracle.com/forums/thread.jspa?threadID=2370592

Function Not Available To This Responsibility

Posted by on August 23, 2011 No comments

Problem: When examining an EBS form using Help > Diagnostics > Examine, the following error occurs:

Function Not Available To This Responsibility.
Change responsibilities or contact your System Administrator.

Solution: This is standard functionality. The EBS instance was upgraded to R12.1.3.

To allow access to the submenu items under the Help menu > Diagnostics, please perform the following steps:

Choose System Administrator, navigate to System > Profiles, and query the profile “Utilities : Diagnostics”. At the appropriate level (user/responsibility), change the value to Yes.

Logout and then login (you may need to bounce iAS (Apache) to clear cache).

Retest the issue.

Reference:

“Function Not Available To This Responsibility” After Upgrading To Release 12.1.3 [ID 1200743.1]

[amazon asin=0070077290&template=iframe image&chan=default]     [amazon asin=1453742735&template=iframe image&chan=default]     [amazon asin=0615238440&template=iframe image&chan=default]

Unable to connect from client machine to new 11.5.10.2 instance

Posted by on December 12, 2008 No comments

Problem:

After configuring TNS names on the client, tried to connect to new 11.5.10.2 instance but failed.

Solution:

Managed SQL Access enabled. To disable, follow these steps:

Step 1:        Login to E-Business Suite with the ‘System Administrator’ Responsibility.

Step 2:        Go to : Profile –> System

Step 3:        Query the Profile “SQLNet Access’ at Site Level.

Step 4:        Set the Profile with the Value : ALLOW_ALL

Step 5:        Save and Exit Oracle Applications

Step 6:        Run Autoconfig on the 9i ORACLE_HOME

cd <9i ORACLE_HOME>/appsutil/scripts/$CONTEXT_NAME

adautocfg.sh

Step 7:        Bounce the 9i SQLNet Listener :

cd <9i ORACLE_HOME>/appsutil/scripts/$CONTEXT_NAME

addlnctl.sh stop <SID>

addlnctl.sh start <SID>

Metalink Reference:

Subject:  11.5.10 New Features : Managed SQL*Net Access from Hosts

Doc ID:  Note:291897.1

Integrating UPK With Oracle E-Business Suite Help Menu

Posted by on November 26, 2008 No comments

This documentation shows how integrate UPK content into the Help menu of Oracle E-Business Suite. Examples are drawn from the VIS4 instance; your instance may vary.

Step 1:        After creating the content in UPK Developer, publish the content to a UPK Player package. From the Tools menu, click Publish Content.

Step 2:        Choose Publish All Modules and click OK.

Step 3:        Check Deployment – Player Package and click Next.

Step 4:        Click Next.

Step 5:        Click Publish.

The modules are published.

Step 6:        In this example, the module is exported to the C:Program FilesUser Productivity KitUPK Developer 27PublishPlayer for Add New Responsibility to Existing User directory.

Rename the output directory to remove spaces.

Step 7:        The published directory (upktest in this example) must be copied onto the server. It must be copied to the $COMMON_TOP/portal/<context name> directory.

For VIS4, the upktest directory and its contents must be copied to:

/u3/oracle/vis4comn/portal/VIS4_appslinux

Step 8:        Copy the odcontenturl.js file in the hemi directory to odcustomurl.js. Modify the ORACLEHELP_URL to point to the old Oracle E-Business Suite help file (use the format “http://<oracle server>:<port> /OA_HTML/jsp/fnd/fndhelp.jsp”):

ORACLEHELP_URL=”http://appslinux.support.com:8004/OA_HTML /jsp/fnd/fndhelp.jsp?dbc=vis4″

The odcontenturl.js is located in /u3/oracle/vis4comn/portal/VIS4_appslinux /upktest/ORACLE/hemi/ directory.

Step 9:        Log on to the VIS4 instance and select the System Administrator responsibility. Navigate to Profile > System. The Find System Profile Values form appears. In the Profile field, enter %Help% and then click Find.

Step 10:   Locate the Applications Help Web Agent profile option.

Enter the following URL in the Site field:

http://appslinux.support.com:8004/upktest/ORACLE/hemi/odhelp.html?dbc=/u3/oracle/vis4appl/fnd/11.5.0/secure/VIS4_appslinux/vis4.dbc

Then click Save.

Step 11:    Finally, log off Oracle Applications and then log back on. When Help is selected, a new link (UPK) appears. When it is clicked, the custom Player content appears.

References:

Content Administration PDF (located in C:Program FilesUser Productivity KitUPK Developer 27docsReference).

[amazon asin=1849680167&template=iframe image&chan=default]     [amazon asin=1482009374&template=iframe image&chan=default]

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]

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.

Journal Wizard: Viewer application profile is not set.

Posted by on July 7, 2008 1 comment

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)