Wednesday, July 23, 2014

Oracle Report Manager Profile Options

Please note that the Report Manager (FRM) touches a lot of modules:

  • General Ledger (GL)
  • Financial Statement Generator (FSG)
  • Web ADI (BNE)
  • BI Publisher (XDO)
  • Report Generator (RG)

 

 

Profile Option Name Values Description
FRM: Debug Mode Yes / No activates / de-activates Debug Mode
FRM: File Listener   This profile option is seeded into the environment but are no longer used by the Report Manager product. 
Please be aware that setting these profile options will have no effect.
FRM: Generate HTML Report Yes / No see Note:827288.1
FRM: Home/Exit Navigation   This profile option is seeded into the environment but are no longer used by the Report Manager product. 
Please be aware that setting these profile options will have no effect.
FRM: Report Link   This profile option is seeded into the environment but are no longer used by the Report Manager product. 
Please be aware that setting these profile options will have no effect.
FRM: Set Auto Archive null / number of month This profile option sets a default value for the Set
Auto Archive option on the Publishing Parameters
page. Enter a positive integer to specify the
number of months from the date of publishing that
the report will be marked for archive in the
Reports Repository.
For example: To automatically mark reports for
archive after one month, enter "1".
Users can override the default value at submission
time on the Publishing Parameters page. Note that
reports are not actually archived until the Maintain
Repository concurrent request is run. For more
information, see Archiving Reports, page 6-5.
FRM: User To Value Owner Access Yes / No The profile option is only set at the user level.
When set to "Yes" it enables a user to add
participating value sets and assign owner access.
For more information, see User to Value Security,
page 7-1.
Additionally, setting this profile option to "Yes" for
a user gives that user owner privileges for all
folders and reports in the repository, overriding
any repository security restrictions defined for
individual folders or reports. See Defining
Repository Security, page 6-3.
FRM:Report Data Path

a valid temporary directory: e.g. /var/tmp

see also Patch:7296641
     
ADI: Allow Sysadmin to View all Output no / yes Set this to "Yes" to allow users with the System
Administrator responsibility to view the output for
all users. This option overrides user to value
security for System Administrators
ADI: Use Function Security yes / no  
     
     
BNE Allow No Security Rule  

 

BNE Allow Set Parameters    
BNE Disable    
BNE Document Lifetime    
BNE Enable Digital Signature    
BNE Enforce Parameter Values    
BNE Excel Worksheet Maximum    
BNE FND Jar Path    
BNE JAR Path    
BNE Offline List of Values Limit    
BNE Redirect Home Enabled    
BNE Redirect Portal URL    
BNE Server Log Filename e.g.  bne.log  
BNE Server Log Level REQUIRED | CRITICAL ERROR | ERROR | WARNING | INFORMATION | DETAIL | TRACE  
BNE Server Log Path e.g. /tmp  
BNE Servlet Link    
BNE Servlet Path    
BNE UIX Base Path    
BNE UIX Headless Mode Enabled    
BNE UIX Physical Directory    
BNE Upload Batch Size    
BNE Upload Import Directory    
BNE Upload Retry Count    
BNE Upload Sleep Seconds    
BNE Upload Staging Directory a valid temporary directory: e.g. /var/tmp if not set, Template upload will not work
BNE Upload Text Directory    
BNE XML Response Compression    
     
     
FSG: Accounting Flexfield    
FSG: Allow Portrait Print Style    
FSG: Database Codeset e.g.  If you are using English, then use 'US' If this profile 'FSG: Database Codeset' is missing, you can create it manually or by applying Patch 8668357:R12.FRM.B

see 
Note:858505.1
FSG: Enable Search Optimization yes / no In rel 11i valid settings are NO or YES
In Rel 12i the profile option 'FSG: Enable Search Optimization' MUST be YES 

Setting this profile option to NO in Rel 12i, could cause unpredictable and invalid results.
for example: zeros being returned for all actual balances - though data exists in GL_BALANCES
SG: Enforce Segment Value Security    
FSG: Expand Parent Value    
FSG: Message Detail    
FSG: String Comparison Mode    
FSG:Enable Attribute Reporting    
     
     
GL : Default Desktop Viewer Excel 97, Excel 2000, Excel 2002, Excel 2003, Excel 2007 Set up according to the version of Excel being used.
GL: Data Access Set   To view and interact with ledger data, the appropriate Data Access Set must be assigned to the General Ledger responsibility.
GL: Debug Mode   Allow features in General Ledger to run in Debug Mode where additional messages are detailed in the log file. Debug Mode operates for many General Ledger features, such as Journal Import, Posting, Translation, Revaluation, Consolidation, Recurring Journals, and Mass Allocation
     

 

 

See also
Oracle General Ledger Reference Guide
      This guide provides detailed information about setting up Oracle General Ledger profile options and Oracle Web Applications Desktop Integrator profile options.

Oracle Report Manager User's Guide Release 12.1

No comments:

Post a Comment