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]