Setting General Ledger Profile Options
During your implementation, you set a value for each profile option in your General Ledger application to specify how your General Ledger application controls access to and processes data.
In general, profile options can be set at one or more of the following levels: site, application, responsibility and user. Use the Update Personal Profile Options window to set your profile options only at the user level. Your system administrator uses the Update System Profile Options window to set profile options at different levels.
Profile Options not Owned by General Ledger
The following profile options affect the operation of General Ledger, but are not "owned" by General Ledger:
Note: General Ledger's Account Inquiry window ignores the setting of this profile option. This allows you to drill down to your subledgers independent from their multiple organization setup. As a result, when you drill down to subledger details, General Ledger will show you all of the transactions that comprise an account balance, regardless of which organization originated the transaction.
Profile Options Owned by General Ledger
You can set the following profile options in General Ledger applications.
|
Budgetary Control Group
| --
|
|
|
|
| Optional
|
|
Daily Rates Window: Enforce Inverse Relationship During Entry
| --
|
|
|
|
| Optional
| No
|
Dual Currency
| --
|
|
|
|
| Optional
|
|
Dual Currency Default Rate Type
| --
|
|
|
|
| Optional
|
|
FSG: Accounting Flexfield
|
|
|
|
|
| Optional
| Account
|
FSG: Allow Portrait Print Style
|
|
|
|
|
| Optional
| No
|
FSG: Enforce Segment Value Security
|
|
|
|
|
| Optional
| No
|
FSG: Expand Parent Value
|
|
|
|
|
| Optional
| No
|
FSG: Message Detail
|
|
|
|
|
| Optional
| Minimal
|
GL AHE: Saving Allowed
| --
|
|
|
|
| Optional
| Yes
|
GL: Owners Equity Translation Rule
| --
|
|
|
|
| Optional
| PTD
|
GL Set of Books ID
| --
|
| --
| --
| --
| N/A
|
|
GL Set of Books Name
|
|
|
|
|
| Required
|
|
GLDI: AutoCopy Enforcement Level
| --
|
|
|
|
| Optional
| None
|
GLDI: Budget Wizard Enforce Segment Value Security
| --
|
|
|
|
| Optional
| No
|
GLDI: Budget Wizard Privileges
|
--
|
|
|
|
|
Optional
| Entry
Upload
Submit
|
GLDI: Journal Wizard Privileges
|
--
|
|
|
|
|
Optional
| Entry
Upload
Submit
|
GLDI: Report Wizard Privileges
| --
|
|
|
|
| Optional
| Define, Submit
|
Intercompany: Subsidiary
|
|
|
|
|
| Optional
|
|
Intercompany: Use Automatic Transaction Numbering
|
|
|
|
|
| Optional
|
|
Journals: Allow Multiple Exchange Rates
|
|
|
|
|
| Optional
| No
|
Journals: Allow Non-Business Day Transactions
| --
|
|
|
|
| Optional
|
|
Journals: Allow Posting During Journal Entry
|
|
|
|
|
| Optional
| No
|
Journals: Allow Preparer Approval
| --
|
|
|
|
| Optional
| No
|
Journals: Default Category
|
|
|
|
|
| Optional
|
|
Journals: Display Inverse Rate
|
|
|
|
|
| Optional
| No
|
Journals: Enable Prior Period Notification
| --
|
|
|
|
| Optional
| No
|
Journals: Find Approver Method
|
|
|
|
|
| Optional
| Go Up Manage-
ment Chain
|
Journals: Mix Statistical and Monetary
|
|
|
|
|
| Optional
| No
|
Journals: Override Reversal Method
| --
|
|
|
|
| Optional
| Yes
|
Use Performance Module
|
|
|
|
|
| Optional
| Yes
|
Key
|
| You can update the profile option.
|
--
| You can view the profile option value but you cannot change it.
|
| Otherwise, you can not view or change the profile option.
|
Budgetary Control Group
Assign budgetary control groups when you enable budgetary control for your set of books. Budgetary control groups include a set of options which are used to enforce budgetary control based on combinations of journal entry source and category. You can also define budgetary control options for the detail and summary accounts for which you want to enforce budgetary control.
You can only view this profile option at the user level. Your System Administrator must set this profile option at the site, application, responsibility or user level.
Daily Rates Window: Enforce Inverse Relationship During Entry
Use this profile option to specify whether to enforce the automatic calculation of inverse exchange rates in the Daily Rates window. When the profile option is set to Yes and you enter a daily rate to convert currency A to currency B, General Ledger automatically calculates the inverse rate (currency B to A) and enters it in the adjacent column. If either rate is changed General Ledger automatically recalculates the other.
You can only view this profile option at the user level. Your System Administrator must set this profile option at the site, application or responsibility level.
Dual Currency
Choose the dual currency for your set of books if you want to enable the dual currency feature and calculate weighted-average rates for specific accounts. You can choose any currency other than your functional currency. You must ensure that each set of books has only one dual currency.
Caution: This profile option is used to support an old General Ledger feature called Dual Currency. We recommend that you use Multiple Reporting Currencies instead. Set this profile option only if you currently use Dual Currency. Setting this profile option invokes additional Dual Currency processing which may fail if you are not using Dual Currency. If you set this profile option, you must also set the Dual Currency Default Rate Type profile option.
You can only view this profile option at the user level. Your System Administrator must set this profile option at the site, application or responsibility level.
Dual Currency Default Rate Type
When using Dual Currency, you can either specify a transaction rate for each transaction or use the daily rate associated with the transaction date. Use this profile option to specify the default currency conversion type Journal Import should use to determine the daily rate if you do not enter a transaction rate.
Caution: This profile option is used to support an old General Ledger feature called Dual Currency. We recommend that you use Multiple Reporting Currencies instead. Set this profile option only if you currently use Dual Currency. If you set this profile option, you must also set the Dual Currency profile option.
You can only view this profile option at the user level. Your System Administrator must set this profile option at the site, application or responsibility level.
FSG: Accounting Flexfield
Choose the General Ledger application reporting flexfield. For your General Ledger application, select the account as your reporting flexfield.
The default value for this profile option is account.
You cannot view this profile option at the user level. Your System Administrator must set this profile option at the site or application or level.
FSG: Allow Portrait Print Style
Control the print orientation of your Financial Statement Generator reports that are less than or equal to 80 characters wide. You can print these reports in either portrait style (80 character wide) or landscape style (132 character wide). The following values are available to you:
Yes: Your General Ledger application prints reports that are less than or equal to 80 characters wide in portrait (80 character wide).
No: Your General Ledger application prints reports that are less than or equal to 80 characters wide in landscape (132 character wide).
If this profile option is not enabled, or your reports are more than 80 characters wide, your General Ledger application produces landscape style (132 character wide) or landwide style (180 character wide) reports, depending on the report character width.
You can set this profile option at the user level. Or, your System Administrator can set this profile option at the site, application, responsibility or user level.
FSG: Enforce Segment Value Security
Control whether your defined security rules will apply to reports produced using FSG. The following values are available to you:
Yes: If security rules are defined that prevent you from accessing specific account segment values, then you cannot produce financial information for those same segment values when you run FSG reports. For example, if you are excluded from using any accounts for cost centers 100 and 200, then any balances for those same accounts will not appear on any FSG reports you might run.
No: Defined security rules are not used for FSG reporting purposes.
FSG: Expand Parent Value
Control the expansion of parent values when requesting summary balances. The following values are available to you:
Yes: FSG uses the rollup group to determine whether to expand a parent value into its child ranges. If the parent value belongs to a rollup group, FSG does not expand the parent value into its child ranges. If the parent value does not belong to a rollup group, FSG expands the parent value into its child ranges.
No: FSG uses the summary flag associated with the flexfield assignment to determine whether to expand a parent value into its child ranges. If the summary flag is set to Yes, FSG does not expand the parent value into its child ranges. If the summary flag is set to No, FSG expands the parent value into its child ranges.
The default value for this profile option is No.
You can set this profile option at the user level. Or, your System Administrator can set this profile option at the site, application, responsibility or user level.
FSG: Message Detail
Specify the level of detail in your error message log file when you request your Financial Statement Generator reports. Your General Ledger application divides error messages into the following three catalogs:
Catalog I: contains all detail memory figures, detail timings, and SQL statements which is useful for program debugging.
Catalog II: contains all file and function names, and all messages which give process information. This is useful for finding out where a process failed.
Catalog III: contains only error messages and other important messages, and therefore gives the least amount of information for program debugging.
You specify the level of detail for your error message log file by setting this profile option to one of the following values:
Minimal: Catalog III messages.
Normal: Catalog II and III messages.
Full: Catalog I, II, and III messages.
The default value for this profile option is Minimal.
You can set this profile option at the user level. Or, your System Administrator can set this profile option at the site, application, responsibility or user level.
GL AHE: Saving Allowed
Specify whether to allow account hierarchy changes to be saved from Account Hierarchy Editor. The following values are available:
Yes: You can save changes to account hierarchies from Account Hierarchy Editor.
No: You can only view account hierarchies from Account Hierarchy Editor. You cannot save changes.
The default value for this profile option is Yes.
You can only view this profile option at the user level. Your System Administrator must set this profile option at the site, application, responsibility, or user level.
GL: Owners Equity Translation Rule
Specify the rule General Ledger follows to translate owners' equity accounts when you have not entered specific historical rates or amounts. The following values are available:
PTD: The Period-to-Date rule is used to translate owners' equity accounts. For each period for which you translate owners' equity accounts, the historical rate is set to the period-average rate.
YTD: The Year-to-Date rule is used to translate owners' equity accounts. For each period for which you translate owners' equity accounts, the historical rate is set to the period-end rate.
The default value for this profile option is PTD.
You can only view this profile option at the user level. Your System Administrator must set this profile option at the site, application, or responsibility level.
GL Set of Books ID
This profile option displays the current Set of Books ID when you are in the System Administrator responsibility.
You cannot change the value of this profile option. Instead, you set the profile option GL Set of Books Name and your General Ledger application automatically determines and displays the value for GL Set of Books ID.
GL Set of Books Name
Specify your set of books. This option also associates a set of books with a responsibility.
You cannot view this profile option at the user level. Your System Administrator can set this profile option at the site, application or responsibility level.
GLDI: AutoCopy Enforcement Level
Specify the enforcement level for the Report Wizard's AutoCopy function. The following values are available to you:
None: You can choose to work with copies or originals of existing reports and report objects.
Enforce Copy: When working with existing reports or report objects, you must create copies rather than use the originals that are stored in the applications database.
Enforce Original: When working with existing reports or report objects, you must work with the originals that are stored in the applications database.
You can only view this profile option at the user level. Your System Administrator must set this profile option at the site, application, responsibility, or user level.
GLDI: Budget Wizard Enforce Segment Value Security
Specify whether segment value security is enforced when using the GLDI Budget Wizard. The following values are available to you:
No: Segment value security is not enforced.
Yes: Segment value security is enforced.
You can only view this profile option at the user level. Your System Administrator must set this profile option at the site, application, responsibility, or user level.
GLDI: Budget Wizard Privileges
Specify the Budget Wizard usage privileges. The following values are available to you:
None: You cannot use this feature.
Entry: You can only enter budget data in a budget worksheet.
Entry, Upload: You can enter budget data and upload that data to the General Ledger interface table.
Entry, Upload, Submit: You can enter budget data, upload that data, and submit budget import processes.
You can only view this profile option at the user level. Your System Administrator must set this profile option at the site, application, responsibility, or user level.
GLDI: Journal Wizard Privileges
Specify the Journal Wizard usage privileges. The following values are available to you:
None: You cannot use this feature.
Entry: You can only enter journals in a journal worksheet.
Entry, Upload: You can enter journals and upload them to the General Ledger interface tables.
Entry, Upload, Submit: You can enter journals, upload them, and submit journal import processes.
You can only view this profile option at the user level. Your System Administrator must set this profile option at the site, application, responsibility, or user level.
GLDI: Report Wizard Privileges
Specify the Report Wizard usage privileges. The following values are available to you:
None: You cannot use this feature.
Define: You can define reports but cannot submit them.
Submit: You can submit reports but cannot define them.
Define, Submit: You can define and submit reports.
You can only view this profile option at the user level. Your System Administrator must set this profile option at the site, application, responsibility, or user level.
Intercompany: Subsidiary
Specify the subsidiary name (defined on the Subsidiaries window) to which a responsibility can enter intercompany transactions using the CENTRA system.
You cannot view this profile option at the user level. Your System Administrator must set this profile option at the site, application, or responsibility level.
Intercompany: Use Automatic Transaction Numbering
Specify whether General Ledger uses automatic transaction numbering for intercompany transactions made in the CENTRA system. The following values are available to you:
No: You must enter unique transaction numbers manually.
Yes: General Ledger generates transaction numbers automatically.
You cannot view this profile option at the user level. Your System Administrator must set this profile option at the site or application level.
Journals: Allow Multiple Exchange Rates
Specify whether you want to allow multiple conversion rates within a journal entry. The following values are available to you:
Yes: You can override the converted amount when you enter journals.
No: You cannot override the converted amount when you enter journals.
The default value for this profile option is No.
You can set this profile option at the user level. Or, your System Administrator can set this profile option at the site, application, responsibility or user level.
Journals: Allow Non-Business Day Transactions
Specify whether you want to allow posting on non-business days. Business and non-business days are defined on the Transaction Calendar. The following values are available to you:
Yes: You can post transactions on non-business days.
No: You cannot post transactions on non-business days.
You can only view this profile option at the user level. Your System Administrator must set this profile option at the site, application, responsibility, or user level.
Journals: Allow Posting During Journal Entry
In earlier releases of General Ledger, this profile option specified whether you wanted to allow posting from the Enter Journals window. As of Release 11, security over posting is handled by Oracle Applications' function security features.
If you are a new customer, this profile option will not appear in any lists of available profile options. If you are an existing customer, the profile option will appear, but General Ledger will ignore any value you have set for it.
Journals: Allow Preparer Approval
Specify whether preparers can approve their own journal batches. The following values are available to you:
Yes: Preparers are allowed to approve journal batches that fall within their authorization limit.
No: Preparers cannot approve their own journal batches.
The default value for this profile option is No.
You can only view this profile option at the user level. Your System Administrator must set this profile option at the site, application, responsibility or user level.
Journals: Default Category
Specify the default journal entry category. When you enter manual journal entries, the category will default to the category you specify here.
You can set this profile option at the user level. Your System Administrator can set this profile option at the site, application, responsibility or user level.
Journals: Display Inverse Rate
Specify how you enter and display conversion rates in the Enter Journals window. The following values are available to you:
Yes: You can enter and display conversion rates in the functional-to-foreign format, that is, the rate by which you multiply a functional amount to determine the foreign amount.
No: You can enter and display conversion rates in the foreign-to-functional format, that is, the rate by which you multiply a foreign amount to determine the functional amount.
The default value for this profile option is No.
You can set this profile option at the user level. Or, your System Administrator can set this profile option at the site, application, responsibility or user level.
Journals: Enable Prior Period Notification
Specify whether General Ledger should notify you when you are entering a journal for a prior period. The following values are available to you:
Yes: General Ledger will display a message when you are entering a journal for a prior period. You have to confirm that this is what you want to do.
No: General Ledger will not notify you when you enter a prior period journal.
You can only view this profile option at the user level. Your System Administrator must set this profile option at the site, application, responsibility, or user level.
Journals: Find Approver Method
Specify the default approval method for the Journal Approval process. The following values are available to you:
Go Up Management Chain: The journal batch moves up the approval hierarchy until it has been approved by an approver whose authorization limit is sufficient to allow approval. The journal batch must be approved by all intermediate approvers as well.
Go Direct: The journal batch is sent directly to the first approver in the approval hierarchy who has an authorization limit high enough to allow approval. The preparer's direct manager receives a courtesy notice.
One Stop Then Go Direct: The journal batch is first sent to the preparer's manager for approval. If further approvals are required, the journal batch is sent directly to the first approver in the approval hierarchy who has an authorization limit high enough to allow approval.
The default value for this profile option is Go Up Management Chain.
You cannot view this profile option at the user level. Your System Administrator must set this profile option at the site, application, or responsibility level.
Journals: Mix Statistical and Monetary
Choose whether to enable users to enter statistical amounts along with monetary amounts in the Enter Journals window. The following values are available to you:
Yes: You can enter statistical amounts along with monetary amounts when you enter journals. The window appears only for those accounts for which you define a statistical unit of measure.
No: You are not able to enter statistical amounts along with monetary amounts in the Enter Journals window.
The default value for this profile option is No.
You can set this profile option at the user level. Or, your System Administrator can set this profile option at the site, application, responsibility or user level.
Journals: Override Reversal Method
Specify whether users can override the default reversal method when they reverse a journal. The default reversal method is specified when you define journal categories. The following values are available to you:
Yes: Users can change the default reversal method when they are reversing journals.
No: Users cannot change the default reversal method when they are reversing journals.
You can only view this profile option at the user level. Your System Administrator must set this profile option at the site, application, responsibility, or user level.
MRC: Reporting Set of Books
See: Multiple Reporting Currencies
Use Performance Module
Specify whether General Ledger concurrent programs will make use of the statistical data collected by the General Ledger Optimizer program to enhance the performance of some concurrent programs. The concurrent programs affected include Posting, Summarization, MassAllocations, Consolidation, Year End Carry Forward, Budget Range Assignments and Historical Rates Assignment.
The default value for this profile option is Yes, and we strongly advise you NOT change it unless specifically told by Oracle Customer Support.
See Also
Budgetary Control and Online Funds Checking
Creating a Budgetary Control Group
Overview of Dual Currency
Overview of Financial Statement Generator
Creating Journal Batches
Journal Approval Overview
Using Account Hierarchy Editor
Overview of GL Desktop Integrator
Common User Profile Options
Profile Options in Oracle Application Object Library
Overview (of Average Balance Processing)