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

Wednesday, July 16, 2014

How to enable debugging / tracing?

 

How to enable debugging / tracing?

Do the following steps to enable the BNE logging.
- Login to the System Administrator Responsibility.
- Open the System -> Profiles form.
- Search for profiles using '%BNE%LOG%'
This should return three profiles.

  • BNE Server Log Level - This should be set to 'Trace'.
  • BNE Server Log Filename - Specify the log file name here (eg: 'bne.log').
  • BNE Server Log Directory - Provide the path of the log file directory here.

In older versions the profiles may be named:

  • BNE Debug Log Level
  • BNE Debug Log Filename
  • BNE Debug Log Directory
  1. Set the above three values on SITE level (use a unique file name, to insure only information for your problem is included)
  2. Set profiles Bounce the Web server (so that the changes take effect)
  3. Reproduce the issue
  4. Change the file name profile option value after reproducing the issue, so that the BNE log file will have log messages related to this issue only.
  5. If the log file is being generated for a related Service Request then also upload the BNE log to that SR.

Also set Profile Option: FRM: Debug Mode to Yes on Site level.

LOV For Inventory Org Contains No Values In Locations Form

 

SYMPTOMS

Need to assign new Inventory Orgs to a location on the locations form on the "Other Details" tab.  However, an error message is received when this is attempted:
LOV contains no values.

CAUSE

There must be a row in the view FINANCIALS_SYSTEM_PARAMETERS for the SET_OF_BOOKS_ID associated with the organization if it is to be selected on the Locations form.
This query returns the set_of_books_id associated with the organization:
select organization_id, business_group_id, organization_name, set_of_books_id
from ORG_ORGANIZATION_DEFINITIONS;

This query determines if there is a row for the set_of_books_id identified in the first query:
select *
from FINANCIALS_SYSTEM_PARAMS_ALL
where set_of_books_id in (<set_of_books_ids from previous query>);

The FINANCIALS_SYSTEM_PARAMS_ALL table populates the FINANCIALS_SYSTEM_PARAMETERS view. 

select *
from FINANCIALS_SYSTEM_PARAMETERS
where set_of_books_id in (<set_of_books_ids from previous query>);

Also, the inventory organization field can only be entered in the Location form if either (or both) INV or PO is fully installed.
The following query returns the installation status of these two modules:

select p.application_id, p.status, a.application_short_name
from fnd_product_installations p, fnd_application a
where  p.application_id = a.application_id
and a.application_short_name in ('PO','INV')

 

SOLUTION

Using an Inventory or Purchasing responsibility, navigate Setup > Organizations > Set of Books to ensure a set of books has been selected.
This creates a row in the FINANCIALS_SYSTEM_PARAMS_ALL table, which populates the FINANCIALS_SYSTEM_PARAMETERS view.

Once the set of books has a row in this view, the inventory organization will appear in the LOV on the Locations form.

Location is not Coming in the List of Values (LOV) in Default Bill Only Location in Organization Additional Information

 

GOAL

   Default Bill Only Location List of Values not showing the location. What is the cause?

SOLUTION

   The cause of the issue is Organization is not selected in the Location Definition form. Attaching organization to location
   is mandatory. Please perform the following steps to resolve the issue:-

   1. Navigate to India Local Inventory.

   2. Oracle Inventory > Setup > Location > Query the location.

   3. Click on Other Tab and select the organization. Save changes.

   4. Retest the issue.

   5. Migrate the solution to appropriate environment.

Not Able To Attach Inventory Organization To Location

 

Solution:

The HR:Query Only profile needs to be set to No at the Responsibility level

Inventory Organization Is Not Appearing In The Location Setup LOV for Inventory Organization

 

APPLIES TO:

Oracle Human Resources - Version 12.0.0 and later
Information in this document applies to any platform.
***Relevancy checked - 13-Jan-2013***

SYMPTOMS

On : 11.5.10.2 version, Orgs,Jobs,Locs,Positions etc
Find that an Inventory Organization is not appearing in the Inventory Organization LOV
EXPECTED BEHAVIOR
-----------------------
Expect all Inventory Organizations to appear in the Inventory Organization LOV
STEP
-----------------------
The issue can be reproduced at will with the following steps:
1. Using Inventory Super User Responsibility
2. Inventory > Define Location
3. Query "LocationXXXX" location and under > Other Detail tab
The field called Inventory Organization, the LOV shows only two values
BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot select the desired Inventory Organization from the LOV.

CAUSE

The issue is caused by the following setup:
The organization is linked to wrong set of books
NO record in FINANCIALS_SYSTEM_PARAMS_ALL for org_id
The two organizations that are showing in the inventory LOV have the same set of books,
the organization that is new and is NOT showing in the LOV has a DIFFERENT set of book.

SOLUTION

To implement the solution, please execute the following steps:
1. Using System Administrator Responsibility
2. Set Profile options:
MO:Operating Unit = (your choice)
Set of books name = (your choice)
3. Using Purchasing Responsibility and menus,
4. Select setup set of books, choose, and make sure you choose the same set of books.
5. Save.
6. Set the HR: User Type profile option.
7. Retest the issue.
8. Migrate the solution as appropriate to other environments.

Wednesday, July 9, 2014

Oracle Fixed assets Profile Options

 

 Account Generator: Purge    Runtime Data

 FA: Number Mass Addition Parallel Requests

 FA: Allow Swiss Special Assets

 FA: Number of Parallel Requests

 FA: Archive Table Sizing Factor

 FA: Print Debug

 FA: Cache Sizing Factor

 FA: Print Timing Diagnostics

 FA: Deprn Single

 FA: Security Profile

 FA: Generate Expense Account

 FA: Default DPIS to Invoice Date

 FA: Large Rollback Segment   Name

 FA: Mass Copy All Cost Adjustments

Account Generator: Purge Runtime Data

Always set this profile option to Yes to ensure that Oracle Workflow has finished generating accounting flexfield code combinations.

Temporarily set this option to No at the user level if you are debugging the account generator. Running the account generator with this option set to No fills up the workflow tables and slows performance.

FA: Allow Swiss Special Assets

Controls whether you can use the Swiss insurance calculation method.

If this profile option is set, when you add insurance details on the Fixed Asset Insurance window, you can check the Special Swiss Assets check box, which signifies that this asset will use the Swiss insurance calculation method.

FA: Archive Table Sizing Factor

This profile option controls the space allotted for the temporary tables created when you archive and purge a book.

The sizing factor specifies how many storage kilobytes to reserve for the initial extent. The default value is 100 kilobytes.

Update this option if you are archiving a large number of records for a fiscal year.

FA: Cache Sizing Factor

This profile option controls the database information retained in the concurrent program for performance improvement. The range is 0 to 25.

FA: Deprn Single

Controls the caching buffer used when you run depreciation. You can set the buffer to either No (20) or Yes (1).

If you set FA: Deprn Single to No, the cache is reset after every 20 assets. If you set FA: Deprn Single to Yes, the cache is reset after every asset.

FA: Generate Expense Account

Allows you to generate the depreciation expense account based on Workflow rules.

When you set this profile option to Yes, Generate Accounts reads the profile option and generates the expense account using Workflow rules. If you do not set this profile option or you set it to No, Generate Accounts uses the expense account entered for an asset in the Assignments window.

FA: Large Rollback Segment Name

This profile option indicates the rollback segment name that Oracle Assets uses for programs requiring large rollback space.

If you do not specify a large rollback segment, Oracle Assets uses the first available rollback segment.

FA: Number Mass Addition Parallel Requests

•Controls the number of requests the Mass Additions Post program will run in parallel. When you run the program, Oracle Assets spawns a parent process with several child processes.

•Enter a number between 1 and 20 to specify the maximum number of parallel requests you want to allow. The parent process is not included in this number.

FA: Number of Parallel Requests

•This profile option controls the number of requests that Oracle Assets programs can run in parallel.

•Enter a number between 1 and 20 to specify the maximum number of parallel requests that you want to allow.

FA: Print Debug

This option indicates whether debug tracing messages are printed in concurrent program log files. Support uses these messages to identify a problem with the code.

FA: Print Timing Diagnostics

This option indicates whether timing diagnostic messages are printed in concurrent program log files. Support. uses these messages to identify a problem with the code.

FA: Security Profile

Restricts access to the organizations defined in the security profile. This option is seeded at the site level with the view–all security profile created for the Startup Business Group.

FA: Default DPIS to Invoice Date

Enables you to use the Future Transactions feature by allowing the default date–placed–in–service to be the invoice date, even when the invoice date is in a future accounting period. If you set this profile option to Yes, Oracle Assets defaults the date–placed–in–service to the invoice date for future transactions. If you set this profile option to No, Oracle Assets does not default the date–placed–in–service to the invoice dates, and you cannot use the Future Transactions feature.

FA: Mass Copy All Cost Adjustments

Allows the Mass Copy program to copy all cost adjustments, even when the un-revalued cost is different in the corporate book and the associated tax books.

How Oracle Assets calculates depreciation for assets using the Following Month (FOL MONTH) Prorate convention and Flat Rate..?

 

Asset Information Example:

Cost : 10000

Date Placed In Service : 01-JUN-2007
Method : Flat Rate 12%
Prorate Convention Code : Following Month
Prorate Date : 01-JUL-2007
The following example calculations will result based on these two scenarios utilizing the 'Depreciate when placed in service' flag during asset depreciation.

1. When 'Depreciate when placed in service' flag is Checked:
- The 'Depreciate when placed in service' is checked for the 'Following Month' Prorate convention:

(N>Setup> Assets System> Prorate Convention)

- Then the value of DEPRN_START_DATE in the table FA_BOOKS will be 01-JUN-2007 as you need to start depreciation from date placed in service.
- Through depreciation run for Jul-07, the system should calculate the depreciation as following:
yearly depreciation = cost * flat rate = 10000 * 0.12 = 1200
yearly depreciation for 2007 (Jul to Dec) = 1200/12 * 6 = 600 (because the prorate is 1-Jul-07)
this yearly depreciation should be divided by 7 periods (Jun-Dec) = 600/7 = 85.71
Depreciation in Jul-07 = Jun depreciation + Jul depreciation = 85.71 + 85.71 = 171.42

2. When 'Depreciate when placed in service' flag is Unchecked:

Now, what should be the value if 'depreciate when placed in service' was unchecked before asset
creation:
- The value of DEPRN_START_DATE in the table FA_BOOKS should be 01-JUL-2007 (prorate date)
- When running Jul-2007 depreciation:
yearly depreciation = cost * flat rate = 1000 * 0.12 = 1200
yearly depreciation for 2007 (Jul to Dec) = 1200/12 * 6 = 600 (because the prorate is 1-Jul-07)
this yearly depreciation should be divided by 6 periods (Jul to Dec) = 600/6 = 100
Depreciation in Jul-07 = 100