5Period Close Components

This chapter contains the following:

Overview of Period Close

While implementing your accounting configuration, optionally define and maintain period close components, including allocations and periodic entries, revaluations, and historical rates.

If you use allocations, revaluation, or translation, configure the following tasks in the Define Period Close Components task list in your implementation project:

  • Manage Allocations and Periodic Entries

  • Manage Revaluations

  • Manage Historical Rates

FAQs for Period Close

Use the Social link on the Period Close work area to collaborate with members of your team or others within your company to effectively close the period.

For example, as a controller, you keep Oracle Social Network open from the Period Close Overview page during the period close so you can be aware of any transactions that must be posted for the period.

On the All tab:

  • You see a conversation that needs your attention.

  • Your boss, the chief financial officer, started a private conversation with you to announce the close of a deal worth 15,000,000 USD and wants it booked for this period.

  • You download and listen to a voice message file that the chief financial officer posted sharing details about the delivery of the goods to help you confirm that the revenue can be posted to this period.

  • You create a new conversation and invite your accounting manager to join, marking it so she knows to reply quickly.

  • Your accounting manager added you to a conversation for the revenue adjustment journal.

  • Your accounting manager adds a post to the conversation confirming that the revenue is posted.

You navigate to the Close Monitor page to view the latest financial balances and confirm that the revenue is posted.

Depending on your job role and permissions, you can access social networking features for the following Oracle Fusion General Ledger business activities:

  • Period status

  • Journal

Allocations and Periodic Entries

This example distributes a cost that's recorded in one account to different cost centers, based on the headcount in each cost center. The headcount is recorded using the statistical currency, and the cost centers receiving the cost are in a parent cost center. The chart of account consists of the following segments:

  • Company

  • Line of Business

  • Account

  • Cost Center

  • Product

  • Intercompany

Create the Rule

Navigate to the Calculation Manager, which is the tool for managing allocations.

  1. Navigate to the Journals work area.

  2. Click the Tasks icon and select the Create Allocation Rules task. The task opens the Enterprise Performance Management workspace.

  3. From the Navigate menu, select Administer, Calculation Manager.

  4. Expand the Essbase application.

  5. Find the balances cube for the chart of accounts that's associated with the relevant ledger and expand it.

  6. Right-click the Rules node and select New from the menu. The New Rule window opens.

    Tip: Since the rule is going to allocate cost based on headcount, consider including headcount in the rule name.
  7. Accept the default values for the rest of the fields and click OK. The New Rule window closes and the Rule Designer opens in a new tab with the name of the rule you just entered.

Define the Point of View

Set the Point of View to default values that are fixed throughout the allocation rule. For example, if a chart of accounts has a future-use segment that's currently not used, you can use the Point of View to set a default value such as 000. Then you don't have to select a value for this segment when defining the rule.

  1. In the Rule Palette, select the Point of View object and place it between the beginning and ending components in the flow chart on the Designer area.

  2. To have users supply the accounting period when the allocation is run, use a variable. Runtime prompt variables make rules dynamic and reusable. Click in the Value field for the Accounting Period row.

  3. Click the Actions icon and select Variable. The Select Variable window opens.

  4. Select the Database category, which is the category for the specific cube. The Application category applies to all cubes.

  5. In this example, the accounting period is already defined as a variable, so select it and click OK.

  6. Click the Member Selector button. The Member Selector window opens. You can set the fixed dimensions namely, Ledger, Company, Line of Business, Product, and Intercompany segments from the Member Selector. You can also set the Currency and Currency type. You can expand the dimensions to find the values or you can search for them. Alternatively, instead of using the Member Selector, you can enter the values manually.

  7. Select Ledger from the Dimensions drop down value.

  8. Expand All Ledgers.

  9. Select the appropriate ledger.

  10. Click the Select icon to move the ledger to the Selections panel.

  11. From the Dimensions list, select the Company, the Line of Business, the Product, the Intercompany, and the Currency dimensions, and set them.

  12. Select Currency Type from the Dimensions list.

  13. Expand the Currency Type node and select Total. This selection indicates that the allocation is going to use balances in the ledger currency, including the equivalent ledger currency balances of foreign currency journals.

    Note: If you select Entered, the allocation would only use amounts where the entered currency is the currency that was selected for the Currency dimension.
  14. Click OK. The Member Selector window closes.

Fixed values have now been set for all of the segments, except the Account and Cost Center segments.

Define the Allocation Component

  1. From the Rule Palette, select the Allocation object and place it between the point of view member components in the flow chart on the Designer Area. The Allocate Wizard window opens and the Point of View tab opens.

    This Point of View is specific to the Allocation component, so if you have a rule with multiple Allocation components, you can specify a Point of View for each of them. Since this rule has only one Allocation component, and you have already defined a Point of View, skip this step.

  2. Click Next. The Source tab opens.

    The source is the revenue pool to be distributed or allocated. A source can be a referenced account balance or a user-defined amount. For this rule, the source is the communication cost. To retrieve the cost, you must provide the account combination. You already specified values for the Company, Line of Business, Product, and Intercompany segments in the Point of View, so the only source segments to specify here are Account and Cost Center.

  3. Click the Member Selector button. The Member Selector window opens.

    1. On the Dimensions list, select Account.

    2. Click the Search tab and search for the communications cost account.

    3. Select the account and click the Select icon to move the account to the Selections section.

    4. On the Dimensions list, select Cost Center.

    5. Click the Search tab and search for the cost center.

    6. Select the cost center and click the Select icon to move the cost center to the Selections section.

    7. Click OK. The Member Selector window closes.

  4. The remaining dimensions, Scenario, Balance Amount, and Amount Type, specify what balance to retrieve from the source account. On the Allocate Wizard window, the default value for the Scenario dimension is Total for Allocations, which is the sum of the actual and allocated amounts. Since the source for this rule only involves actual balances, you must change the value. Click the Member Selector button. The Member Selector window opens.

    1. On the Dimensions list, select Scenario.

    2. Expand Scenario in the Members tab.

    3. Select Actual and click the Select button to move it to the Selections section.

      Note: If you have two rules with the second rule using the allocations resulting from the first rule, use the Allocated scenario for the second rule.
    4. On the Dimensions list, select Balance Amount.

    5. Expand Balance Amount in the Members tab.

    6. Since the rule is going to allocate communications cost for the period, select Period Activity. Click the Select icon to move it to the Selections section.

    7. Click OK. The Member Selector window closes.

  5. Accept the default value for the Amount Type dimension as Period to Date.

  6. Click Next. The Allocation Range tab opens. The range is the spread of values that the source is distributed against. In this rule, the cost is allocated across cost centers.

  7. Click in the Select Value field in the Cost Center row.

  8. Click the Actions icon and select Member. The Select Member window opens.

    1. Select the appropriate parent value and click the Select icon to move it to the Selections section.

      Note: Always select a parent value because you have to allocate across a range of values.
    2. Click OK. The Member Selector window closes.

  9. Click Next. The Target tab opens.

  10. The target receives the allocated amount. Enter the account number within quotation marks in the Account row.

  11. Click Next. The Offset tab opens.

    The offset receives the offsetting debit or credit to balance the allocation that was generated. On the Offset tab, enter the account number in the Account row and the cost center in the Cost Center row, within quotation marks.

    Caution: The offset must be a child value. If you select a parent value, the allocation rule fails validation.
  12. Click Next. The Exclude tab opens.

    Note: Use the Exclude tab for partial allocations. Specifically where you want to allocate a percentage of the total source and the percentage itself can't be entered. Instead, the percentage has to be calculated based on all the members in the basis and then some members have to be excluded from the allocation target range.

    For example, a basis contains cost centers 100, 200, 300, and 400. You want to distribute the source evenly across each cost center, so each cost center should be allocated 25% of the source. But you have to exclude cost center 300 from the allocation range. In this example, you would specify cost center 300 in the Exclude tab. When the allocations are generated, 75% of the source is allocated, 25% each to cost centers 100, 200, and 400. The 25% for cost center 300 remains unallocated because cost center 300 is excluded.

  13. This particular allocation isn't excluding any values, so click Next. The Basis tab opens.

  14. On the Basis tab, for the Account dimension, enter the account number that has the headcount values.

    Note: The basis determines the ratio in which the source must be allocated to each member of the allocation range. The basis could be distributing the source evenly. Or you can select specific statistical or account balances for a particular period as the basis.

    For this allocation, the ratio is going to be calculated by dividing a cost center's headcount by the total headcount.

  15. Enter Period Activity in quotation marks for the Balance Account dimension because the total headcount for each cost center is included in one journal recorded in one period.

  16. Enter STAT in quotation marks in the Currency dimension. The values for the other dimensions are derived automatically based on the Point of View and range specified previously.

  17. Click Next. The Basis-Options tab opens.

  18. Accept the default settings and click Next. The Rounding tab opens.

  19. Specify the rounding options in case of rounding differences when the allocation is generated. Since the allocation is in US dollars, on the Rounding tab, enter 2 as the number of decimal places to use. Click Finish. The Allocate Wizard window closes.

Validate the Rule

Validation is an important and required step. Validation checks for consistency against the outline of the balances cube that it references. For example, validation checks that the offset is a child, not a parent value, and checks that entered values exist.

  1. Click the Validate icon on the toolbar. After the validation is completed, a message appears stating whether the validation was successful.

  2. Click OK.

  3. Click the Validate and Deploy icon to deploy the rule and make it available for generation in the general ledger.

  4. Click Yes to first save the rule.

  5. After the deployment is completed, a message appears stating whether the deployment was successful.

  6. Click OK.

Generate the Allocation Journal

Generate the allocation journal using the following steps:

  1. Navigate to the Journals work area.

  2. Click the Tasks icon.

  3. Select the Generate General Ledger Allocations task.

  4. In the Rule or Rule Set field, enter the name of the allocation rule. The Accounting Period prompt should appear.

  5. Select the accounting period.

  6. The Post Allocations option is selected by default.

  7. Click Submit. A confirmation message appears stating that the process was submitted.

  8. Click OK.

Review the Journal

  1. Navigate to the Journals work area

  2. Click the Tasks icon.

  3. Select the Manage Journals task.

  4. Enter the first part of the allocation rule name in the Journal field.

  5. Enter a value in the Accounting Period field.

  6. Select Allocations in the Source field.

  7. Click Search.

  8. Click the Journal link to open the journal. The cost that was allocated has a credit and the debits to the different cost centers are based on their headcount.

Now that the rule is defined, all that's needed for future accounting periods is to generate the journals.

Overview of Allocation and Periodic Entries

In Oracle Fusion General Ledger, use the Calculation Manager to create allocations and other formula journal templates for generating periodic journal entries automatically. Allocations are defined and generated from preaggregated balances in the GL Balances cubes, which provide the following benefits:

  • Immediate real-time access to financial balances for allocations and periodic entries.

  • Accelerated performance for complex allocations.

You can base formulas on multiple criteria. For example:

  • Use account balances or statistical amounts to allocate shared revenue or costs across multiple organizational units and ledgers.

  • Define complex computations based on variables from different charts of accounts.

  • Group journal formulas together and execute sequentially to update account balances in a step-by-step process.

Overview of Recurring Entries

Define recurring journal formulas for transactions that you repeat every accounting period, such as accruals, depreciation charges, and allocations. Your formulas can be simple or complex. Each formula can use:

  • Fixed amounts and account balances, including standard, actual amounts, statistics, and period-to-date or year-to-date balances.

  • Amounts from the current period, prior period, or same period last year.

  • Amounts in your formulas, including total balances, entered currency balances, or statistical balances.

You can quickly create recurring formulas by copying and modifying existing formulas. You can:

  • Define single ledger or multiple ledger recurring journal formula batches.

  • Create a recurring journal formula batch that contains recurring journal entries for different ledgers.

  • Define recurring journal formulas for your ledger currencies, entered currencies, and statistical currency.

Overview of Using Calculation Manger

In addition to the Enterprise Performance Management Workspace buttons, the Calculation Manager toolbar displays buttons that are specific to the Calculation Manager. Not all buttons display in all the views and designers within the Calculation Manager.

The Calculation Manager toolbar consists of the following buttons:

  • Home: Displays the default start-up option for the content area.

  • System View: Displays the main view within the Calculation Manager. (This is the default view).

  • List View: Displays a list of objects that you can filter by application type, application, object or database type, deployment status, and validation status.

  • Custom View: Displays a view you can change with folders that you create.

  • Filter Options: Opens the Filter dialog that you can use to filter objects in the List View.

  • Refresh: Refreshes the view with your latest changes.

The Calculation Manager toolbar adds the following buttons when you open a rule:

  • Save: Saves the object with which you are working.

  • Validate: Validates the object with which you are working.

  • Validate and Deploy: Validates and deploys the object with which you are working.

FAQs for Manage Allocations and Periodic Entries

How can I access the Calculation Manager?

Login into the Oracle Fusion General Ledger application and navigate to the Journals work area. From the Journals work area select the Create Allocation Rules link and automatically log into the Calculation Manager in Workspace to create new allocation rules or rule sets.

Note: The application or the balances cube that is currently selected in the General Ledger Data Access Set is automatically selected in the Calculation Manager.

How can I create a folder in the Custom View?

In the Custom View, create folders that contain only the allocation rules, allocation rule sets, and formulas you want to view and work with.

To create a folder in the Custom View:

  1. In the System View, select View, Custom View.

  2. In the Custom View, right-click the Essbase application type, and select New Folder.

  3. In New Folder, enter a name for the folder.

  4. Click OK.

Tip: You can create nested folders by right-clicking the folder you want to create a folder in and selecting New Folder.

How can I rename a folder in the Custom View?

Rename the folders you create in the Custom View.

To rename a folder in the Custom View:

  1. In the System View, select View, Custom View.

  2. In the Custom View, expand the Essbase application type.

  3. Right-click the folder you want to rename, and select Rename.

  4. In the Rename Folder, enter a new name for the folder.

  5. Click OK.

You can export your allocation rules from a source environment and import them to a target environment using a implementation projects. In the Setup and Maintenance work area, create an implementation project that includes only the Manage Allocations and Periodic Entries task. Then use the Manage Configuration Packages task to export and import the allocation rules.

Allocation Rules

Overview of Allocation Rules

The Calculation Manager enables you to create, validate, deploy, and administer sophisticated multidimensional allocation rules. An allocation rule is logical expressions or formulas that are created within an application to produce a set of resulting values. Create an allocation rule set of two or more related rules to launch the rules sequentially.

Before you create a rule or rule set, you must understand the database outline and the application with which you are working. This information helps you create your allocation rules more efficiently. Learn the following about your data:

  • How the data is stored and aggregated.

  • What level the data gets loaded into the database.

  • What order the calculations are performed.

  • What key assumptions drive the calculations.

Create allocation rules using components like formulas, member ranges, and variables, including run time prompt variables.

Edit an Allocation Rule

You can edit the structure of an allocation rule by adding to, removing, or changing its components. You can also edit the properties of the allocation rule's components and the properties of the allocation rule itself. You can edit these properties of an allocation rule:

  • Name and caption

  • Description and comments

  • Range of dimensions and members

  • Variables, you include in the allocation rule

Scenario

To edit an allocation rule:

  1. Navigator > General Accounting: Journals > Create Allocation Rules link.

  2. Navigate menu > Administration > Calculation Manager.

  3. In the System View, expand the Essbase Application Type, the Application, or Database, and Rules. Do one of these tasks:

    1. Right-click the rule you want to edit, and select Open.

    2. Select the rule you want to edit, and select File, Open.

  4. To edit the rule, in the Rule Designer, add new components, and copy and delete existing components, from the rule's flow chart.

    Note: As you edit components in an allocation rule, you can increase or decrease the size of the component icons and the amount of detail that is displayed in the flow chart. To edit, you use the zoom bar to zoom in and out within the flow chart. When the flow chart is displayed in small or very small sizes, the component captions do not display, but you can place your mouse pointer over any icon to read its caption. Regardless of the size of the components in the flow chart, you can select a component to view its properties on the Properties tab.
  5. To delete a component from the flow chart, select the component, right-click it, and select Remove.

  6. To copy and paste a component, select the component, right-click it, and select Copy. Then paste it into the flow chart.

  7. To add a new component:

  8. From New Objects, drag and drop components to insert a new component into the rule's flow chart:

    • Point of Views

    • Allocations

    • Formulas

  9. From Existing Objects, drag existing objects from Essbase applications and drop them into the rule's flow chart.

  10. For Essbase: On Global Range, you can edit the values that is, members, variables, and functions that define the range of values to be calculated when the rule is launched.

  11. Select values for a dimension by clicking its row in the Select Value column.

  12. When the Actions icon is displayed, click it, and select one of these:

    • Variable

    • Member

    • Member

  13. For Essbase: On Variables, you can create variables for the rule.

  14. On Usages tab, you can view which rules and rule sets use the rule, if any. This is the information you can view about the rules and rule sets that use the rule:

    Note: On the Usages tab, you view which allocation rules and rule sets use the rule, if any. You cannot edit any of the information on this tab. The following information is displayed for the allocation rules and rule sets using the allocation rule:
    • Names

    • Database

    • Application Name

    • Deployment Status

    • Validation Status

    • Description

  15. Select File, Save.

Print an Allocation Rule

You can print an allocation rule's properties, its flow chart, and the details of its components. For example, if you print an allocation rule that contains a formula component for allocation expenses and shows:

  • The formula syntax.

  • The functions and variables that comprise the formula.

  • A summary of the steps in the rule's flow chart but not in graphical form.

  • The rule's properties.

Note: You cannot print allocation rule sets.

Scenario

To print an allocation rule:

  1. Navigator > General Accounting > Journals >Create Allocation Rules link.

  2. Navigate menu > Administration > Calculation Manager.

  3. In the System View, expand the Essbase Application Type, the Application, or Database, and Rules. Select the rule you want to print.

  4. Select File, Print.

    Note: You can also select File, Print from within the Rule Designer to print a rule.
  5. In Print Preview, do these tasks:

  6. Select the Print options:

    • Paper size

    • Print orientation: portrait or landscape.

  7. Select General Rule Information to print the rule's description and other details from the Properties tab. The details include the rule's name, the application, its owner, the date the rule was created, and the date the rule was last modified.

  8. Select Flow Chart and Expanded or Collapsed, to print the flow chart, and you want to print it with the component details expanded or collapse.

  9. Select the number of pages you want to print the components across (horizontally). Select the number of pages to print the components down (vertically).

  10. Select the Page Order options:

    • Down, then across: The components in the flow chart print down (vertically, as rows do) on the number of pages you specified in the previous step. Then the components print across (horizontally, as columns do) on the number of pages you specified in the previous step.

    • Across, then down: The components in the flow chart print across (horizontally, as columns do) on the number of pages you specified in the previous step. Then the components print down (vertically, as rows do) on the number of pages you specified in the previous step.

  11. Select the remaining Rule Information options:

    • Select Summary, to print a summary of the components in the flow chart.

    • Select Variable Section to print information about any variables used in the rule.

    • Select Detail Section to print detailed information about the components in the rule.

    • Select Page break before sections to create a page break between summary, variable, and detail sections. This option is selected by default.

    • Select Nested Rules to print rules contained in other rules.

  12. Select Generate PDF.

  13. A PDF file of the rule is opened in Adobe Acrobat.

  14. Click the Print icon in Adobe Acrobat.

  15. In the Print dialog, select the print options specific to the printer you are using, and click Print.

FAQs for Allocation Rules

How can I open an allocation rule?

You open an allocation rule from the System View that is displayed by default when you open Calculation Manager. You can also open a rule using File, Open from within the tab of another rule, rule set, component, or template.

To open an allocation rule:

  1. Navigator > General Accounting: Journals > Create Allocation Rules link.

  2. Navigate menu > Administration > Calculation Manager.

  3. In the System View, expand the Essbase Application Type, the Application, or Database, and Rules.

  4. Do one of these tasks:

    • Right-click the rule you want to open, and select Open.

    • Select the rule you want to open, and select File, Open.

How can I save an allocation rule?

You must save an allocation rule after you create or edit it. When you save the allocation rule, it is saved to the application and application type for which you created it. After you save it, you can validate and deploy it in Calculation Manager. You can generate it in Oracle Fusion General Ledger.

To save an allocation rule after you create or edit it, select File, Save.

Note: To see the allocation rule in the System View after you save it, you may refresh the application list. To do this, right-click the application type, the application, or the database (for Essbase), and select Refresh.

How can I save an allocation rule with a different name?

You can save an allocation rule with a different name using Save As. You can also copy a rule from one rule set to another within the same rule set type using Save As. Save As creates a copy of the original rule with a different name to distinguish it from the original.

To save an allocation rule with a different name:

  1. In the System View, expand the Essbase Application Type, the Application, or Database, and Rules.

  2. Right-click the rule you want to save with a different name, and select Open.

  3. In the Rule Designer, select File, Save As.

  4. In Save As, enter the rule's new name, and select the Application Name.

  5. Select the Database.

    Note: You cannot change the database of a rule you save with a different name.
  6. Click OK. The new rule is added to the application list in the System View.

How can I delete an allocation rule?

You delete an allocation rule from the System View. You can delete an allocation rule only if it is not used by other rules or rule sets. If the rule is being used, you must remove the allocation rule from the rules and rule sets using it, or make copies of it for the rules and rule sets using it, before you delete it. To see if a rule is used by other rules and rule sets, you can show the usages of the rule.

To delete an allocation rule:

  1. In the System View, expand the Essbase Application Type, the Application, or Database, and Rules.

  2. Make sure the rule you want to delete is not being used by another rule set or rule.

  3. Right-click the rule you want to delete, and select Delete.

  4. Click OK to confirm deletion of the rule.

Allocation Rule Sets

Overview of Allocation Rule Sets

You create an allocation rule set by combining allocation rules or allocation rule sets that can be generated sequentially. You add rules and rule sets to a rule set by dragging and dropping them into it.

After you create and save the rule set, you can validate and deploy it. Then you can generate it in Oracle General Ledger.

Note: Rule sets are supported in Essbase aggregate storage applications used in Oracle General Ledger in sequential mode only.

Copy an Allocation Rule Set to Another Application

From the System View, you can copy an allocation rule set to another application of the same application type (Essbase) or database.

Note: Allocation rule sets are not supported in Essbase Aggregate Storage or Block Storage applications, other than Aggregate Storage applications used in Oracle General Ledger.

Scenario

Use the following steps to copy a rule set to another application:

  1. In the System View, expand the Essbase Application Type and the Application.

  2. Expand RuleSets.

    Note: Only one rule set node exists for each application at the same level as the plan types and databases.
  3. Right-click the allocation rule set you want to copy, and select Copy To.

    Note: You can also copy an allocation rule set when you are working with it in the Ruleset Designer, and paste it into another allocation rule set or allocation rule.
  4. Select the rule set name, select Edit, Copy, open the rule or rule set into which you want to copy it, and select Edit, Paste.

  5. In Save As, enter a new name for the allocation rule set, or accept the default name, and select an application and calculation or plan type. Click OK.

    Note: You cannot copy the allocation rule set to more than one application and calculation or plan type.

The new allocation rule set is added to the application and calculation or plan type you selected. To see it in the System View, you must refresh the application list. To refresh the application list, click the Refresh icon on the toolbar.

Save an Allocation Rule Set

You must save an allocation rule set after you create or edit it. When you save the allocation rule set, it is saved to the application and application type for which you created it. After you save it, you can deploy, validate, and generate it. You can deploy and validate it in Calculation Manager; you can generate it from Oracle General Ledger.

Scenario

To save an allocation rule set after you create or edit it, select File, Save, or click the Save icon.

Note: To see the allocation rule set within the System View after you save it, you must refresh the application list. To do this, right-click the application type, the application, the database (Essbase), and select Refresh. You can also click the Refresh icon on the toolbar to refresh the application list in the System View.

Save an Allocation Rule Set with a Different Name

You can save an allocation rule set with a different name using Save As. Saving it with a different name creates a copy of the rule set.

Scenario

  1. In the System View, expand the Essbase Application Type and the Application.

  2. Expand RuleSets.

    Note: For Essbase applications, only one rule set node exists for each application at the same level as the plan types and databases.
  3. Right-click the rule set you want to save with a different name, and select Open.

  4. In the Ruleset Designer, select File, Save As.

  5. In Save As, enter the rule set's new name, and select an application. Click OK.

    Note: You cannot change the application type of a rule set you save with a different name. The new rule set must have the same application type as the rule set from which the rule set is created.

    The new rule set is added to the application list in the System View.

Delete an Allocation Rule Set

You delete an allocation rule set from the System View. You can delete an allocation rule set only if it is not being used by other allocation rule sets. To see if it is being used by other rule sets, you can show its usages. If it is being used, you must remove it from the allocation rule sets that are using it, or make copies of it for the allocation rule sets that are using it, before you delete it.

Scenario

  1. In the System View, expand the Essbase Application Type and the Application.

  2. Expand RuleSets.

  3. To make sure the rule set is not being used by another rule set, right-click it, and select Show Usages.

  4. Right-click the rule set you want to delete, and select Delete.

  5. Click OK to confirm deletion of the rule set.

Refresh Allocation Rules or Rule Sets

In the System View, you can refresh any level of the application list. You can refresh:

  • Application Type

  • Application

  • Database

  • One or Multiple Rule Sets or Rules

By default, when you refresh an application, application type, or database, all of the rules, rule sets, components, and templates belonging to it are refreshed.

However, refreshing the rule sets or rules within an application does not refresh higher levels in the application list or rule sets or rules that belong to other applications.

Note: You can also click the Refresh icon on the toolbar to refresh the entire application list in the System View.

Scenario

  1. In the System View, expand the Essbase Application Type and the Application.

  2. To refresh rule sets, right-click RuleSets, and select Refresh or to refresh rules, expand the database, right-click Rules, and select Refresh.

    Note: You can also right-click the application type, the application, or database that contains the allocation rules you want to refresh, and select Refresh.

Show Usage of an Allocation Rule or Rule Set

You can display the allocation rules and rule sets that are using a rule or allocation rule set. Viewing the usages of rules or rule sets is useful when deleting rules or rule sets and you must know what objects are using it.

Scenario

  1. In the System View, expand the Essbase Application Type and the Application.

  2. To show the usages of a rule set, expand RuleSets.

  3. Right-click the rule set whose usages you want to see.

  4. Select Show Usages or to show the usages of a rule, expand the database, and Rules.

  5. Right-click the rule whose usages you want to see, and select Show Usages.

  6. You can view this information about the rule or allocation rule set:

    1. Names

    2. Database

    3. Application Name

    4. Deployment Status

    5. Validation Status

    6. Description

      Note: You can also view a rule or rule set's usages from within the Rule or Ruleset Designer on the Usages tab.
  7. After you review the information, click OK.

Change Owner of an Allocation Rule or Rule Set

You can change the owner of an object such as a rule, rule set, or formula in the System View. The application to which it belongs must be deployed. By default, an object's owner is the user that creates it, unless the user changes the ownership. Users can edit only objects they own, with the exception of administrators who can edit any objects.

Scenario

  1. In the System View, expand the Essbase Application Type and the Application.

  2. To change the ownership of a rule set, expand RuleSets or to change the ownership of a rule, expand the database, and then expand Rules.

  3. Right-click the object, and select Change Ownership.

  4. In Change Owner, select the owner to whom you want to transfer ownership of the object.

  5. Click OK.

    Note: The user you assigned ownership to can edit the object.

FAQs for Allocation Rule Sets

How can I open an allocation rule set?

You open an allocation rule set from within the System View. You can also open a rule set from within the Ruleset Designer, by selecting File, then Open.

To open an allocation rule set:

  1. In the System View, expand the Essbase application type and the application.

  2. For Essbase: Expand RuleSets, right-click the rule set you want to open, and select Open.

    Note: For Essbase applications, there is only one rule set node for each application at the same level as the databases.

How can I open an allocation rule within an allocation rule set?

You can open an allocation rule from within an allocation rule set from the System View or from the Ruleset Designer.

To open an allocation rule within an allocation rule set:

  1. In the System View, expand the Essbase Application Type and the Application.

  2. Expand your rule set that contains the rule you want to open.

    Note: For Essbase applications, only one rule set node exists for each application at the same level as the databases.
  3. Right-click the rule you want to open, and select Open.

    Note: You can also open a rule that belongs to an allocation rule set from within the Ruleset Designer. To do this, in the Ruleset Designer, right-click the rule, and select Open.

How can I remove an allocation rule from an allocation rule set?

When you remove a rule from an allocation rule set, the rule is not deleted. The rule exists independently of the rule set in the database.

To remove an allocation rule from an allocation rule set:

  1. In the System View, expand the Essbase Application Type and the Application.

  2. Expand RuleSets, right-click the rule set you want to open, and select Open.

    Note: Only one rule sets node exists for each application at the same level as the plan types and databases.
  3. In Ruleset Designer, right-click the rule you want to remove, and select Remove.

Select File, Save.

Overview of Point of View and Allocation Components

Every data value in a report is derived from the intersection of a member from each dimension in the Essbase database connection. Financial Reporting enables a designer to place these dimensions on the report grid or user point of view. Report viewers can change the member selected for dimensions on the user point of view. This enables report viewers to configure the reports to fit their needs. The user point of view can also be used in books.

You create and edit point of view components from within a rule to set members, variables, and functions that contain the global range of the point of view component. You can nest a point of view component within another point of view component.

Allocation components contain calculations for distributing data from members at one level in the database outline to other members in the outline. Formula components contain calculation statements that you design using members, functions, and variables.

FAQs for Point of View and Allocations Components

How can I open a point of view or allocation component?

You open a point of view or allocation component from within the flow chart of the rule to which it belongs.

Note: You cannot open the allocation component from the System View.

To open a point of view or an allocation component:

  1. In the System View, expand the Essbase Application Type, the Application, Database, and Rules.

  2. Right-click the rule that contains the component you want to open, and select Open. The rule is displayed in the Rule Designer.

  3. When the rule opens, click the point of view component or double-click the allocation component in the rules flow chart to open the component.

How can I save a point of view or allocation component ?

You save a point of view or an allocation component when you save the rule to which it belongs in the Rule Designer. Unlike the formula components, point of view and allocation components cannot exist independently for the rule to which they belong.

To save a point of view or allocation component:

  • Select File and Save, or click the Save icon, once you finish designing a point of view or an allocation component.

How can I copy and paste a point of view or allocation component?

You can copy a point of view or allocation component from within the rule in which it is used, and you can paste the component into the same or a different rule.

To copy and paste a point of view or allocation component in a rule flow chart:

  1. In the System View, expand the Essbase Application Type, the Application, Database, and Rules.

  2. Right-click the rule that contains the point of view or allocation component you want to copy and paste, and select Open. The rule is displayed in the Rule Designer.

  3. In the Rule Designer, right-click the point of view or allocation component you want to copy in the rules flow chart, and select Copy to copy only the component or Copy Group to copy the component and the associated components within it.

  4. Do one of the following tasks:

    • To paste the component into the same rule, right-click the location in the flow chart where you want to paste the component, and select Paste.

    • To paste the component into a different rule, open the rule, right-click the location in the flow chart where you want to paste the component, and select Paste.

    Note: You can also select Edit and Paste.
  5. Select File and Save.

How can I delete a point of view or allocation component?

You delete a point of view or an allocation component from the System View. Since point of view or allocation components can be used in only one rule, you can delete these components by removing them from the rule to which they belong.

To delete a point of view or an allocation component:

  1. In the System View, expand the Essbase Application Type, the Application, or Database, and Rules.

  2. Right-click the rule that contains the point of view or allocation component you want to delete, and select Open. The rule is displayed in the Rule Designer.

  3. In the Rule Designer, select the point of view or allocation component you want to delete in the flow chart.

  4. Right-click the point of view or allocation component.

  5. Select Remove to confirm the removal of the component.

    Note: If the allocation component is within the point of view component, then removing the point of view component removes the allocation component.
  6. Select File and Save.

This example demonstrates how to generate an allocation or periodic entry manually from the Oracle Fusion General Ledger.

You are the General Accountant for InFusion America Inc. You have created allocation and periodic journal entry definitions for several monthly entries. You now generate these entries.

Note: Schedule allocations and periodic entries in the Journals work area for automatic generation. The accounting period automatically increments for each subsequent run if defined as a Run Time Prompt for the Allocation Rule selected.

Prior to generating the allocation and periodic entries, the following tasks must be completed:

  • The period is set to Open or Future Enterable. You post in open periods, but generation can take place in either an open or future enterable period.

  • The rules or rules sets have been defined, validated, and deployed successfully from the Calculation Manager.

  • The journal balances, which are inputs for the allocation or periodic rules, are entered and posted in the proper period.

Generating Allocations and Periodic Entries Manually

  1. From the Navigator, click the Journals link to open the Journals work area.

  2. In the task pane of the Journals page, click the Generate Allocations link to open the Submission page.

  3. Optionally select one or all of the following options:

    • Print Output

    • E-mail me the output

    • Notify me when this process ends

  4. Select a rule or rule set from the list of values.

  5. Enter the submission parameters, including Ledger, Balancing Segment Value, and Period. The application automatically sets the last day of the submission period as the Accounting Date and Calculation Effective Date.

  6. Accept the selected check box for the Post Allocations option to enable the process to post the journal entries.

    If you deselect the check box for the Post Allocations option, you must either manually post or define an AutoPost Criteria Set to post automatically.

  7. Click Submit.

    After the generation process is complete, the journal entries created by the process are available for inquiry on the Journals page.

Overview of Revaluations

The revaluation process is used to adjust account balances denominated in a foreign currency. Revaluation adjustments represent the difference in account balances due to changes in conversion rates between the date of the original journal and the revaluation date. These adjustments are posted through journal entries to the underlying account with the offset posted to an unrealized gain or loss account. All debit adjustments are offset against the unrealized gain account and all credit adjustments are offset against the unrealized loss account. If the same account is specified in the Unrealized Gain Account and Unrealized Loss Account fields, the net of the adjustments is derived and posted.

For balance sheet accounts, the revaluation journal entries are reversed in the next period. AutoReverse can be used to automate the reversals. For income statement accounts that use the PTD method of revaluation, the revaluation journals aren't reversed since each period's revaluation adjustment is for that period.

In Oracle Fusion General Ledger, the revaluation functionality provides the following advantages:

  • Full multicurrency functionality to eliminate currency barriers across a global business.

  • Predefined revaluation rules to ensure consistency in generation of revaluation entries each period.

  • Usage of prevailing currency normalization accounting standards including:

    • US Financial Accounting Standards Board, Financial Accounting Statement No. 52 (FAS 52), Foreign Currency Translation.

    • International Financial Reporting Standards, International Accounting Standard No. 21 (IAS 21), The Effects of Changes in Foreign Exchange Rates.

  • Support for multiple balancing segments to provide clarity in tracking the profitability and performance for more distinct segments of your enterprise in any currency