Read the Statements. Drag and Drop Each Item Into the Associated Level of the Pssp Hierarchy.

Browser version scriptSkip Headers

Oracle® Fusion Accounting Hub Implementation Guide 11g Release half-dozen (11.1.6) Office Number E20374-06

Habitation

Contents

Book List

Contact Us

---

5 Define Period Shut Components

This affiliate contains the post-obit:

Manage Menses Shut

Period Close Components: Explained

Manage Allocations and Periodic Entries

Manage Revaluations

Manage Period Shut

Opening Outset Menstruation: Overview

For all ledgers, primary, secondary, and journal and subledger level reporting currencies, open the get-go period of the ledger when you are fix to transact in that period.

To open up the showtime period of your ledgers, navigate to the Open up First Period task in the master ledger task list and click the Become to Task icon. On the submission page, select the ledger and the flow to open. Click the Submit button to launch the open period process.

There are other ways to open up the first flow or subsequent periods without going into the Setup and Maintenance piece of work surface area. You can maintain the ledgers' period statuses from the:

• Shut Status region in the Full general Accounting Dashboard. The Close Status region provides real time visibility into the period close process from your subledgers to your General Ledger across the unabridged enterprise.

• Manage Accounting Periods job in the Catamenia Close piece of work area.

• Process Monitoring work area, which provides a framework for launching, monitoring and maintaining processes across Oracle Fusion Financials.

Close Monitor: Overview

The Shut Monitor:

• Provides information on the period close status for a given bookkeeping period across multiple products for related ledgers in a hierarchical ledger set based display.

• Uses the hierarchical ledger set to mirror the consolidation relationships and roll ups of entities across the enterprise.

• Summarizes menstruation close condition data for each ledger across multiple products and for each consolidation node across multiple ledgers.

• Provides the contact information of the director for a given node on the ledger set hierarchy.

• Summarizes high level income statement results for each entity and aggregates this financial information at each consolidation node.

• Displays each of these elements of information, period status, manager data, and financial data, in separate tags that are navigated to for each node of the interactive hierarchical display.

• Provides views for a given ledger prepare, for a particular accounting period, and currency.

The flow status information that is displayed is broken down by application module including General Ledger, Payables, Receivables, Asset, Projects, and Costing. Some modules track their entity at a more granular level, such as:

• Business organization units for Payables, Receivables, and Projects

• Asset Books for Assets

• Cost Arrangement Books for Costing

The Close Monitor indicates the number of the subunits past module for the ledgers. It also displays the fractional indicator, where applicative, of how many of the subunits are at the closed status.

Secondary ledgers, journal level, or transaction level reporting currencies cannot be associated with subledger business concern units for Payables, Receivables, and Projects. Equally such, if the ledger set displayed in the hierarchy includes members that are secondary ledgers, journal, or subledger level reporting currencies, the catamenia condition indicated in the Shut Monitor for such subledger modules is based on its related principal ledger. Asset books and toll organization books can be associated with all types of ledgers. Therefore in the case of the Assets and Costing modules, their menstruum condition for secondary ledger or reporting currencies is shown appropriately for the books directly associated with them. Otherwise, their period statuses are derived from the books associated with their primary ledgers.

Setting Upward the Close Monitor

The Close Monitor setup is comprised of a ledger set hierarchy definition whereby a predefined ledger fix is addressed, with each ledger and ledger set up assigned a manager who is responsible for its financial shut, and a logo to stand for the entity in the display.

Notation

The list of managers available for consignment contains the persons defined in the Human Capital letter Management (HCM) module of Oracle Fusion Applications. The attributes defined in HCM, such as the picture of the person and contact details, are shown in the Close Monitor.

The ledger set serves as the foundation of this setup.

• The members of the Close Monitor hierarchy must share a common chart of accounts and calendar.

• The financial information displayed in the Close Monitor is derived from the account group assigned to the ledger gear up, therefore, an assignment is required. The account group:

  • Must include ii line items whose account designations respectively query the total revenues and total expenses of the arrangement.

  • Reflects a summarized income statement in the financial data tab of the Close Monitor.

• All ledgers in the ledger set share a common chart of accounts and the option of accounts are equally applicable throughout the nodes in the ledger set hierarchy.

• When working with ledger sets that include members that are also ledger sets, you tin choose any of the ledger sets in the selector to bespeak the top starting ledger set to display in the Close Monitor.

• If different business relationship groups are assigned to each ledger set up fellow member in such a ledger set, the account group used to display the financial data is the ane assigned to the ledger set specified in the selector in the Close Monitor.

• To have meaningful comparison and summation along the ledger set hierarchy:

  • Assign ledgers to the ledger set that have a relevant currency representation that matches the intended group currency that the Close Monitor displays the financial information in.

  • Select the appropriate principal, secondary, or reporting currency ledger for assignment to the ledger set.

  • Alternately, utilise translated balances (balance level reporting currency) in the ledger fix selection to satisfy the common group currency requirement if needed.

Viewing the Close Monitor

You choose a ledger set, an accounting period, and currency as the view criteria for the Close Monitor display. You can alter this selection at whatsoever time.

For instance, modify the currency displayed by:

• Working with a global ledger set up.

• Shifting the focus to a lower level ledger set that is aggregating at the continental level, such as North America, that uses a different group currency.

• Including the ledger with the relevant currency representation that matches the selected group currency that the Close Monitor financial data is displayed in.

Note

If matching financial data for a ledger in the selected currency is not bachelor, a message is displayed stating that the requested financial data is not available.

The Close Monitor supports different zoom levels to enable y'all to:

• Conform viewing a larger ledger fix hierarchy in its entirety, given the express display area of the user interface.

• Evidence detail data for each node which can vary, decreasing and simplifying in content as you zoom out further to be able to adjust showing more nodes in a single view.

• Hover over the more summarized node and view a dial out of that particular node that shows the complete set of information available at the 100% zoom level.

• Leave the zoom level at 100% and move effectually the brandish to other ledger sets or ledgers currently not in view.

Note

A view control panel that can be exposed on demand allows y'all to adjust the zoom level, pan beyond the hierarchy, flip the display tabs, and switch the hierarchy display format.

Period Close Components: Explained

While implementing your accounting configuration, optionally define and maintain the flow close components to customize your accounting configurations setup.

Period shut components include allocations, period entries, revaluation, and historical rates.

If you lot utilize allocations, revaluation, or translation, configure the following tasks under the Define Catamenia Shut Components parent task in your implementation project:

• Manage Allocations and Period Entries

• Manage Revaluations

• Manage Historical Rates

Manage Allocations and Period Entries

Manage Allocations and Period Entries is a transmission job in the implementation project. Utilize the Calculation Manager to create allocations and other formulaic journal templates for generating periodic journal entries automatically. Base formulas on multiple criteria.

Yous must perform an external procedure outside the Setup and Maintenance work expanse to complete this task. In order to setup your allocations rules, navigate to the Journals piece of work surface area and click the Create Allocations Rules chore from the Tasks pane. This task navigates you lot to Calculation Manager, a framework that enables you define your allotment rules and formulas using a graphical interface and intuitive stride-by-step wizards.

Manage Revaluations

Defines currency revaluation options, such as the range of accounts to revalue and the proceeds or loss accounts. Revaluation is washed to suit strange entered amounts due to currency fluctuations. Navigate to the Manage Revaluations page, and define and generate your revaluation definitions.

Manage Historical Rates

Historical rates are the weighted average rate for transactions that occur at different points in time. Used by the system to calculate the conversion rate on equity account balances during foreign currency translation of the balance sheet.

Navigate to the Currency Rates Manager page to define and maintain your historical rates that are used in the translation process. In Oracle Fusion General Ledger, y'all can currently define historical rates using an ADF Desktop Integrator spreadsheet.

To create new historical rates, specify the required Ledger and the other optional fields, as needed. Click the Create in Spreadsheet button to open the spreadsheet for uploading.

To update the existing historical rates for your ledgers, click the Edit in Spreadsheet button, the spreadsheet is prepopulated with the existing historical rates.

Note

Before using the historical rates spreadsheet, install the ADF Desktop Integrator client as an add on to Microsoft Excel.

Manage Allocations and Periodic Entries

Resource allotment and Periodic Entries: Overview

In Oracle Fusion General Ledger, utilize the Adding Manager to create allocations and other formulaic journal templates for generating periodic periodical entries automatically. Base of operations formulas on multiple criteria. For case, utilize account balances or statistical amounts to allocate shared acquirement or costs across multiple organizational units and ledgers. Define complex computations based on variables from different charts of accounts. Grouping journal formulas together and execute sequentially to update account balances in a step-by-stride process.

The Calculation Manager provides flexibility, automation, intelligence, and command in distributing costs and revenues beyond the enterprise. In addition, the Adding Managing director:

• Distributes revenues or costs with recursive allotment rules

• Creates circuitous formula rules using formula components

• Contains an Allotment Wizard to define allotment and formula rules

• Uses existent fourth dimension checking of rule definitions to validate definiteness of rules

• Minimizes setup and maintenance time with reusable components

• Simplifies allocation generation machinery by integrating with enterprise scheduler

• Groups rules together in rule sets and cascading allocations for processing efficiencies

• Creates master, statistical, or foreign currency resource allotment and formula rules

Access the Calculation Manager from the Tasks pane of the General Bookkeeping dashboard or Journals work area by clicking on the:

• Define Allocation Rules link to define or modify resource allotment definitions

• Generate Allocations link to run the allocation procedure

Note

For more information, see:

• Hyperion Calculation Manager Release 11.1.2.i Designer's Guide

Calculation Director: Overview

The Adding Manager creates, validates, deploys, and administers sophisticated allotment rules. In the Calculation Manager:

• Base formulas on multiple criteria, such every bit business relationship balances or statistical amounts, to classify shared acquirement or costs across multiple organizational units.

• Use complex computations based on different variables to automatically calculate allocated amounts.

• Group journal formulas together and executed sequentially to update business relationship balances step-past-step.

There are iii types of objects that can be created in Calculation Managing director:

• Components: Comprise formulas, points of view, or allocation objects.

• Rules: Incorporate components such as points of view, formulas, and templates, which are used to create resource allotment calculations.

• Rule Sets: Contain sets of rules that tin can be calculated sequentially

Note

The following are limitation in Oracle Fusion General Ledger.

• Allocation rules cannot exist shared across rule sets in Adding Manager.

• Within a rule or rule set, the same target or offset cannot be written to past multiple rule components.

• When generating allocation rules with run time prompts other than the User Point of View in an allocation rule component, an fault occurs.

Allotment Security: Explained

The following privileges and permissions are associated with the Calculation Manager:

• Generate General Ledger Allocation Formula - Generate Allocation and Periodic Entries: Permits generation of resource allotment and periodic entries.

• Define General Ledger Allocation Formula - Manage Resource allotment Rules or Rulesets via Calculation Manager: Grants the ability to update allocation rules or rulesets owned by the user with view access to all allocation rules or rulesets regardless of their buying.

• Define Self Managed General Ledger Resource allotment Formula - Manage Resource allotment Rules or RuleSets via Calculation Manager: Grants the ability to update resource allotment rules or rulesets, just express to the ones owned by the user.

• Administrate Full general Ledger Allocation Formula - Administrate Resource allotment Rules or RuleSets via Calculation Manager: Grants the ability to update all aspect of allocation rules or rulesets including the ownership attribute, regardless of the original definition's buying.

Calculation Manager Toolbar: Explained

In addition to the Oracle Hyperion Enterprise Operation Management Workspace buttons, the Calculation Manager toolbar displays buttons that are specific to the Calculation Managing director. Non all buttons display in all the views and designers within the Calculation Director.

The Adding Managing director toolbar consists of the following buttons:

• Home: Displays the default startup option for the content area.

• System View: Displays the primary view within the Calculation Managing director. (This is the default view).

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

• Custom View: Displays a view you lot can customize with folders you create and objects yous drag and drop into them.

• Filter Options: Opens the Filter dialog that you tin utilise 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:

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

• Validate: Validates the object with which y'all are working.

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

Adding Manager Menus: Explained

Calculation Managing director menus and card options display in improver to Oracle Hyperion Enterprise Performance Management Workspace menus and carte du jour options. The menus and options vary depending on the view you are using and the object with which you are working. The default view of the Calculation Director displays the following menus when you launch Calculation Manager, System View.

Notation

This topic describes the Adding Managing director card options only.

File Carte

Enables you to create new objects, open and close objects, import and export objects, print rules, and log off.

Note

Not all of these file carte options are available for the products that utilise Calculation Manager.

• New, Dominion: Creates a new rule

• New, Ruleset: Creates a new dominion prepare

Edit Menu

Enables you to edit objects you select. It is available from most of the views and from within the Rule and Component definition pages.

• Edit, Delete: Deletes an object selected in the Organisation, List, or Custom View

• Edit, Copy: Copies selected text

• Edit, Paste: Pastes text copied to the clipboard to the correct of the cursor

• Edit, Copy Group: Copies a component group

Note

The Edit menu is non available within the Deployment View.

View Menu

Enables you to open different views.

• View, View Pane: Displays or hides a list of existing and/or new objects that yous can add to rules, dominion sets, components, and templates past dragging and dropping them.

  Note

  This is the only View menu option bachelor from within the Rule Designer and Ruleset Designer.

• View, Listing View: Displays a list of the objects you select on the Filter dialog. The filter dialog enables you to create a filtered list, by application type of applications, databases, and objects.

• View, System View: Displays a listing of the Essbase applications, databases, and objects to which you lot have access. This is the default view.

• View, Custom View: Displays a view that yous can customize with folders you create and drag and drop objects into them. This view enables y'all to organize objects in a way that is meaningful to y'all.

• View, Deployment View: Displays a listing, by application type and awarding, of the rules and rule sets that are deployed and not deployed with their deployment and validation status.

Tools Menu

Enable you to install other products, search for objects, create a filtered list of objects for the List View, edit the caption of an object, and access the Variable Navigator and Variable Designer.

• Tools, Filter: Opens the Filter dialog from which you can filter by application blazon, application, object blazon (rule, rule set up, formula or script component, or template), calculation type, program type, database, deployment status, and validation status. You lot can also select All to brandish all application types, applications, objects, and databases, regardless of their deployment and validation condition.

• Tools, Variables: Opens the Variable Navigator in which you lot can navigate to a location for which you desire to create, edit, re-create, or delete a variable. From the location you select in the Variable Navigator, you lot can display the Variable Designer in which y'all can create, edit, copy, and delete variables for components.

  Note

  The two menu option listed above are non available inside the Deployment View.

Actions Carte

Enables you to validate and deploy objects y'all select in the views and from within the Rule and Ruleset Designers. Not all of the Deportment menu options are available from within the views and designers.

• Deportment, Validate: Validates the rule, rule set, and formula component you selected

  Note

  This is the but Deportment menu selection available from inside the Deployment View.

• Actions, Deploy: Deploys the rules or rulesets you selected.

• Actions, Quick Deploy: Deploys the rule in fewer steps than regular deployment by using a shortcut to one or more applications.

  Note

  This feature is available only from within the Rule Designer for Essbase business organization rules.

Using Flow Charts: Explained

View rules and templates, and the components that incorporate them, in a flow chart within the Dominion Designer. When you open a dominion, move amongst the components that comprise it, for example, formulas, ranges, and loops, past selecting them in the period chart. Increase or decrease the size of the flow chart to view or hide details of the components.

When y'all select a component in the flow chart, its backdrop, usages, and other information are displayed in tabs below the flow chart. As you move among the components, the tabs beneath the period nautical chart change. For example, if you open up an allocation rule that contains a formula component, and select the formula component in the menstruation chart the following properties are displayed:

• Backdrop of the formula, such as proper noun, description, application, and awarding type to which it belongs

• Usages of the formula, such every bit which rules and templates it is used in

• Text of the formula, such as the variables, members, and functions, that are displayed in the tabs below the flow nautical chart

Views: Explained

Views enable you lot to see Adding Manager objects in different contexts. For example, the Deployment View displays objects according to whether they are deployed or not deployed. The Custom View displays objects according to filters and criteria that y'all select.

The Calculation Manager contains the post-obit views:

• List View

• System View

• Custom View

• Deployment View

• View Pane

List View

The List View contains a filtered list of Essbase applications, or databases, and objects, rule sets, rules, or formula components, according to filter criteria you specify.

System View

The System View is the default view that is displayed when you launch the Calculation Manager. It contains a list of all of the applications and objects to which you have access. Your admission privileges are determined by the function yous are assigned in Shared Services. For each object, the owner, the user who made the last change, and the date the changes were last made are listed.

Custom View

The Custom View enables you lot to create folders and elevate and drop objects into them to create a view that contains only the objects you lot want. This view enables yous to organize objects in a way that is meaningful to you lot.

Deployment View

The Deployment View contains a list, by awarding type and application, of the rules and dominion sets that are deployable with their deployment and validation status. From this view, select rules and rules sets in an awarding to brand them deployable. Then deploy one or more than rules or rule sets (known as a partial deployment), or you can deploy all rules and rule sets in an application (known equally a full deployment).

View Pane

The View Pane enables you to create or open an object. Brandish the View Pane in the left frame of the window. Depending on whether yous are working in a rule or a dominion set, the Rule or Ruleset Palette, is displayed in the View Pane. In the Palette, drag new and existing objects and drop them into the rule, rule set, or period chart.

When working with views, display or hide the View Pane using the View menu. In the Custom View, drag and drop new and existing objects from the View Pane into the custom folders yous create. In the Arrangement and Listing views, the View Pane is hidden past default. In the Deployment View, the View Pane is not available.

Note

The content of the View Pane varies depending on which view yous are in and whether y'all are working with a dominion set, a dominion, a template, or a component.

The following table lists the tasks that tin can be performed from the various views in the Calculation Director.

Tasks	Listing View	Arrangement View	Custom View	Deployment
Create, open, rename, delete, refresh, and close objects	Yes	Yes	Yes	Yes
Set preferences	Yes	Yes	Yes	Aye
Import and export objects	Yes	Aye	Yes	Yes
Show the usages of objects	Yep	Yes	Aye	Yes
Create a copy of objects	Yes	Yes	Yes	Yes
Print a business organization rule	Yes	Yes	Yes	Aye
Select views	Yep	Yep	Yes	Yes
Exit or log off Workspace	Yes	Yeah	Yes	Yeah
Work with favorites	Yeah	Yes	Yeah	Yes
Perform an advanced search	Yes	Yes	Yes	Aye
Access help	Yes	Yes	Yes	Yes
Filter objects in the view according to criteria y'all specify	Yes
Piece of work with variables	Aye	Yeah		Yes
Validate objects	Yes			Yes
Create a shortcut to a business organization dominion		Yes
Import and export business rules and other objects		Yes	Yes
Validate and migrate objects		Aye	Aye
Change the owner of an object			Yes	Yes
Deploy objects				Aye

Filtering Objects in the List View: Examples

You tin use filters in the List View to filter objects co-ordinate to:

• Application Blazon that is populated by default with the application type, such as Essbase, your awarding or database, in which yous are creating the new rule.

• Object type, such every bit allocation rules, allocation dominion sets, and formula components

• Deployment or validation condition

Scenario

To create a filtered list of objects in the List View:

1. From the System View, select View, Listing View.

   The Filter dialog is displayed the first time you open the List View. If y'all select filtering options, and then close the List View to work in the Organization or Custom View. When you reopen the List View, the filter dialog is not displayed. If you lot want to change the filtering options when you reopen the Listing View, select Tools, Filter to open up the Filter dialog.

2. In the Filter dialog, on Filter Options, nether Awarding Type, select Essbase.

3. Do one of these tasks:

   • For Essbase: In the Application and Object Type fields, select the applications and object types you lot want to display in the Listing View. The default is All.

   • Under Deployed Status and Validated Status, clear any bank check boxes of selections you do not want to display. All bank check boxes are selected by default.

     Tip

     Click Reset to reset the dialog with default values.

   • On Advanced Options, for Object Characterization, select one of these options to display only objects whose names match the criteria:

     • Starts With, to display only objects whose names start with characters you lot specify.

     • Ends With, to display but objects whose names stop with characters you specify.

     • Contains, to display merely objects whose names incorporate characters you specify.

     • Matches, to brandish just objects whose names match characters you specify.

   • Enter the characters that are common to the names of the objects you want to display.

   • Select Ignore case, if you desire to display objects whose names contain characters in either upper or lower instance, even if the case does not lucifer the case of the text y'all entered in step 6.

   • In Created By, enter the name of the user who created objects yous desire to display.

   • In Modified Past, enter the name of the user who modified objects you desire to display.

   • For Created Date, select After, Before, or Betwixt to display simply objects that were created subsequently, before, or between dates yous specify. Between is the default. Click the driblet down arrows to display calendars from which you can select dates.

   • For Modified Date, select After, Earlier, or Between to display only objects that were modified after, before, or between dates you specify. (Between is the default.) Click the dropdown arrows to display calendars from which you can select dates.

   • For Any Text, select an option to display only objects containing text that starts with, ends with, contains, or matches text that you enter. To brandish objects that include this text regardless of its instance, select Ignore example.

4. Click OK.

Generating Allocations and Periodic Entries Manually: Worked Example

This case 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 accept created allocation and periodic periodical entry definitions for several monthly entries. You lot now generate these entries.

Note

Schedule allocations and periodic entries in the Journals work area for automatic generation.

Prior to generating the resource allotment and periodic entries, the following tasks must exist completed:

• The period is gear up to Open up or Time to come Enterable. You mail in open up periods, but generation can take place in either an open up or hereafter enterable period.

• The rules or rules sets take been divers, validated, and deployed successfully from the Adding Manager.

• The journal balances, that 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 up the Submission folio.
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 prepare 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 menstruation as the Accounting Date and Adding Effective Date.
6. Accept the selected check box for the Mail Allocations option to enable the procedure to postal service the journal entries.

   If you deselect the check box for the Post Allocations choice, you must post the entry manually or define an AutoPost Criteria Prepare to automatically post the periodical entries.

7. Click Submit.

   Subsequently the generation procedure is complete, the journal entries created by the process are available for inquiry on the Journals folio.

FAQs for Manage Allocations and Periodic Entries

How tin I access the Calculation Director?

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

Notation

The application or the balances cube that is currently selected in the General Ledger Data Access Gear up is automatically selected in the Adding Manager.

How tin 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 desire to view and work with. To add objects to your folders, elevate them from the Existing Objects pane and drib them into the folders.

To create a binder in the Custom View:

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

2. In the Custom View, correct-click the Essbase awarding blazon, and select New Folder.

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

4. Click OK.

Tip

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

How tin can I rename a folder in the Custom View?

Rename the folders yous create in the Custom View.

To rename a folder in the Custom View:

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

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

3. Correct-click the folder you desire to rename, and select Rename.

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

5. Click OK.

Manage Revaluations

Revaluation Process: Explained

The revaluation process is used to suit business relationship balances denominated in a foreign currency. Revaluation adjustments represent the difference in the value of the balance due to changes in conversion rates betwixt the date of the original journal entry and the revaluation date. These adjustments are posted through journal entries to the underlying account with the outset posted to an unrealized gain or loss business relationship. All debit adjustments are showtime against the unrealized proceeds business relationship and all credit adjustments are offset confronting 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 canvass accounts, the revaluation periodical entries are reversed in the adjacent period. AutoReverse can exist used to automate the reversals. For income statement accounts that use the PTD method of revaluation, the revaluation periodical entries aren't reversed since each menstruation's revaluation adjustment is but for that catamenia.

In Oracle Fusion Full 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 Lath (FASB) Financial Bookkeeping Statement No. 52 (FAS 52), Foreign Currency Translation

  • International Fiscal Reporting Standards (IFRS) International Bookkeeping Standard No. 21 (IAS 21), The Furnishings of Changes in Foreign Exchange Rates

• Support for multiple balancing segments to provide clarity in tracking the profitability and performance for more singled-out segments of the your enterprise in whatsoever currency

Definition

When defining your revaluations, perform the following:

• Include accounts for tracking gains and losses, currency conversion rates, and the number of transaction currencies to revalue.

• Define dissever revaluation definitions for each course of accounts, using a different charge per unit type for each class.

• Choose various conversion types and methodologies for different account ranges, such equally current rates and year-to-date (YTD) method for balance sheet accounts, and average rates and period-to-engagement (PTD) method for income statement accounts.

Note

Income argument accounts can also be revalued using YTD method.

Hierarchies and flexible account pick criteria, such as usage of parent values from your business relationship hierarchy, streamlines maintenance of revaluation definitions. The parent values can be selected for the main balancing and the natural account segments using the Is a last descendant of operator. Leveraging hierarchy versions extends your revaluation definitions during organizational changes. Adjust business relationship selection criteria monthly to call back the accounts that need to exist revalued for the current accounting catamenia.

Share revaluation definitions across ledgers that take the same nautical chart of accounts to reduce maintenance.

Generation

Generating revaluations include:

• Using defined revaluation criteria and automatically generating entries to shorten your shut process.

• Selecting automatic posting every bit part of the generate revaluation criteria to help you to achieve processing efficiency.

• Scheduling revaluations to run during off summit hours to save your system resources.

• Utilizing date constructive business relationship hierarchies to generate revaluations to go on results in line with your current organization structures.

Always run revaluation to bring monetary balances to electric current rates before performing currency translation or remeasurement.

Revaluation Execution Report

The Revalue Balances process automatically generates the Revaluation Execution report when y'all run revaluation. This report shows the details of your account balance revaluation and the periodical batches created after running revaluation. The report includes the currencies and revaluation rates used to revalue your accounts, the unrealized gain or loss account in which you recorded net gains and losses, and the range of accounts revalued. The study also prints the names of your batch and journals that the revaluation procedure creates for each strange currency, as well as the total debits and credits of the created entries.

If the Revaluation procedure cannot locate rates for one or more than currencies, balances are non revalued for those currencies. In this case, the Revaluation process completes with a alert and the execution report lists which currencies are missing rates.

Accounting for Unrealized Gain or Loss on Revaluation: Explained

Revaluation launches a procedure that revalues the ledger currency equivalent balances for the accounts and currencies you select, using the appropriate current rate for each currency. Resulting unrealized gain or loss amounts are posted to the unrealized gain or loss accounts or to the cumulative translation adjustment (CTA) business relationship you lot specify, and are counterbalanced past balancing segment values. This process creates a revaluation journal which can be posted automatically.

Oracle Fusion General Ledger creates journal entries to adjust the ledger currency balances for conversion rate fluctuations, in accordance with Statement of Financial Accounting Standards (SFAS) No. 52, Foreign Currency Translation and International Accounting Standard (IAS) 21, The Furnishings of Changes in Strange Exchange Rates.

The revaluation journal entries generated and posted in the primary ledger are automatically generated, converted, and posted to each of their reporting currencies. Define the CTA account for unrealized gains or losses in the reporting currency prior to running revaluation.

Income Statement Accounts Revaluation Dominion: Explained

Revaluation is the process which adjusts asset or liability accounts that may exist materially understated or overstated due to a fluctuation in the conversion rate between the time the transaction was entered and the time revaluation takes place. You lot may want to revalue income statement accounts every bit well. The Income Statement Accounts Rule indicates whether period-to-date (PTD) or yr-to-date (YTD) method is to exist used when revaluing income statement accounts.

Click the Income Statement radio buttons on the Create Revaluation page to specify whether you want to revalue income statement accounts using PTD or YTD balances. There are two radio buttons, 1 for PTD and one for YTD.

If y'all select to revalue PTD balances for income statement accounts, the process continues to appropriately revalue YTD balances for remainder sheet accounts. In the revaluation definition if the range of accounts consists of both income argument and balance sheet accounts and you select PTD as an selection for income statement business relationship revaluation rule, a dissever revaluation journal is created for the income statement accounts. Revaluing the PTD balance of your income statement accounts creates weighted average YTD balances using period rates from each respective catamenia against the PTD account balance in compliance with the Statement of Fiscal Accounting Standards (SFAS) No. 52, Foreign Currency Translation.

To summarize, when you run revaluation on your income statement accounts, the process produces two separate journal entries; one that revalues your balance canvas accounts and another for your income statement accounts. You lot do non demand to reverse the PTD revaluation journal entry for your income argument accounts in the subsequent period since that revaluation just applies to terminal period'south activity.

Note

This functionality only applies when the range of accounts to be revalued in the revaluation definition consist of income statement accounts in add-on to balance sail accounts. Normally simply rest sheets accounts are revalued.

Revaluing Across Multiple Balancing Segments: Worked Example

This case demonstrates how to revalue foreign currency balances across multiple balancing segments. Your company, InFusion America, Inc. has three lines of business. You revalue your foreign currency account balances for two of your divisions, Air Components and Repair Parts. Your Installation Services line of business concern does non accept foreign currency transactions. Your company is your primary balancing segment and your lines of business are represented in your secondary balancing segment.

Annotation

Enable up to three balancing segments to use the multiple balancing segment feature.

The post-obit are points to consider in running the revaluation process.

• Revaluation posts the resulting gain or loss amounts confronting the unrealized gain or loss accounts, substituting the balancing segment values appropriately for all balancing segments.

• Gain or loss accounts and revaluation business relationship ranges are not validated against your data access set security when the revaluation definition is created because the ledger context is non known at the time of definition.

• Data access set security is enforced when the Revalue Balances procedure is executed. Limited write admission to the gain or loss accounts due to inadequate access results in an error.

• Segment value security rules are enforced when you enter the account ranges and the unrealized gain and loss accounts. Only segment values you take access to are bachelor in the list of values.

• Business relationship ranges you have read and write access to are revalued. Business relationship combinations that you do not have admission to are ignored.

• Revaluation expands the parent master balancing segment to the kid values. Data admission gear up security applies to the kid values merely, non the parent value.

• Posting supports multiple balancing segments for calculating the entry to the Cumulative Translation Adjustment accounts when replicating revaluation journals to reporting currencies.

Defining Revaluations

1. From the Manage Revaluations folio, click the Create icon.
2. Enter the values in the following table in the right fields.

   Field	Value
   Proper name	InFusion America Revaluation
   Description	Revaluation for all strange currency balances.
   Chart of Accounts	InFusion America Chart of Accounts
   Currency	Leave blank Note If left bare, all currencies are revalued and after saving, the field automatically displays: All currencies.
   Conversion Rate Type	Daily
   Days to Scroll Forwards	5
   Unrealized Proceeds Account	011-00-96600000-0000-000-000
   Unrealized Loss Account	011-00-96700000-0000-000-000
   Income Statement Account Basis	PTD
   Postal service Automatically	Aye

   
   
3. In the Revaluation Accounts region, click the Add Row icon.
4. Click the Change filter weather icon to enter the filter used to select the accounts to revalue.
5. Click the Add Field drop downward pointer and select your company, InFusion America Inc. from the list.

   Field	Value
   Equals	011

   
   
6. Click the Add Field driblet down arrow and select your two Lines of Business concern: 30 for Air Components and 40 for Repair Parts.

   Note: Your Installation Services line of business, l, is not included considering it does not have strange currency transactions.

   Field	Value
   Between	30
   	xl

   
   
7. Click the Add Field drop down arrow and select Business relationship from the listing.

   Field	Value
   Betwixt	10000000
   	29999999

   
   
8. Click OK to take your filters.
9. Click the Salve and Close button to save your revaluation.

   Optionally, select the Save and Generate buttons to run the revaluation immediately.

lawsonundegaire.blogspot.com

Source: https://docs.oracle.com/cd/E29597_01/fusionapps.1111/e20374/F494861AN210CF.htm

Share this post