Tag Archives: Financial Statement Generator

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]

Creating Database Link To Transfer FSG Reports

Posted by on January 29, 2007 No comments

Problem: A database link must be created in the Target instance to pull (transfer) FSG information to the production instance from the test instance.

Solution: Use Define Database Links in Oracle Applications.

To define a database link in General Ledger perform the following steps

on the Target instance (the one you are copying to):

Step 1:        Log on as sysadmin user and select a GL responsibility.

Step 2:        Navigate to Setup > System > Database Links.

There are six fields that have to be entered:

  1. Database Name
  2. Description
  3. Connect String
  4. Domain Name
  5. APPS Username
  6. APPS Password

Step 3:        In the source database, enter the following SQL query:

SELECT value FROM v$parameter
WHERE UPPER(name) = 'DB_NAME';
VALUE
--------------
PROD

This value is to be entered in the ‘Database Name’ field in Oracle Applications.

Step 4:        In the source database, enter the following SQL query:

SELECT value FROM v$parameter
WHERE UPPER(name) = 'DB_DOMAIN';
VALUE
---------------------

This value must be entered into the ‘Domain Name’ field in the form. If it is null, any value can be entered into this field (e.g. WORLD).

Step 5:        On the target database, grant privilege to apps user (log on as system user):

grant create database link to apps;

Step 6:        Ensure the two hosts are in the hosts file on each host.

127.0.0.1     localhost
128.x.x.x   oracleserver.domainname  oracleserver
128.x.x.x   oraclesrv.domainname     oraclesrv

Step 7:        Update the TNSNAMES.ORA file on each server with the entry for both instances:

PROD=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=ORACLESERVER.domainname)
(PORT=1525))
(CONNECT_DATA=
(SID=PROD)
)
)
MFGP=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=ORACLESRV.domainname)
(PORT=1527))
(CONNECT_DATA=
(SID=MFGP)
)
)

Step 8:        Ensure that the TNSNAMES.ORA was set up correctly using tnsping to ping the remote instance.

Step 9:        Ensure that SQL Restriction is turned off

Step 10:   Bounce the 920 TNS listener on each node.

Step 11:    Ensure that you can log on the other instance using SQL*Plus.

Step 12:   Enter the following values into the form:

Field Value
Database Name PROD
Description Test Database
Connect String PROD
Domain Name WORLD (since it is null, any value can be entered)
APPS Username apps
APPS Password apps

In the SQLNET.ORA file, I had to comment out the line: sqlnet.authentication_services= (NTS)

# sqlnet.authentication_services= (NTS)

Refer to Metalink Documents:

Doc ID 161635.1: (FSG Transfer Troubleshooting Guide)

Doc ID:  Note:1057188.6 (WHERE DO YOU DEFINE DATABASE LINKS FOR FSG’S?)

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