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]
0 Comments.