Before you Begin
This 20-minute hands-on tutorial shows you how calculate periodic movement from closing balance input.
Background
Your business process may require you to load period-end account balances, rather than current period movements. If you enable the Calculate Movements system rule, you can load period end closing balances to the Closing Balance Input member, and the rule will calculate a specified current period movement. The Calculate Movement rule runs during the consolidation process. The existing Closing Balance plus the current entry for the specified movement are subtracted from Closing Balance Input to calculate the current period movement value. It writes the result to a specified movement member, replacing any existing values. After the Calculate Movements rule executes, the Closing Balance member is recalculated using the default consolidation process, and will match the entered closing balance value.
What Do You Need?
An EPM Cloud Service instance allows you to deploy and use one of the supported business processes. To deploy another business process, you must request another EPM Enterprise Cloud Service instance or remove the current business process.
- Have Service Administrator access to EPM Enterprise Cloud Service. The instance should not have a business process created.
- Upload and import this snapshot into your instance.
For more information on uploading and importing migration snapshots, refer to the Administering Migration for Oracle Enterprise Performance Management Cloud documentation.
- Save and extract this data file locally. You will be importing data using this data file.
Modifying Member Attributes
- From the Home Page, click Application, then Overview, then Dimensions.
- Select the Movement dimension to open it.
- Locate the member Mvmts_ChangesInBalanceSheet.
- Optional: Select the Member Name column, then click (Freeze). This keeps the Member Name column on the screen as you scroll to the right to locate the Is Default Movement attribute.
- Select Default_Mvmt_Yes for the attribute Is Default Movement.
- Locate the member Mvmts_ChangesInWorkingCapital.
- Select Default_Mvmt_Yes for the attribute Is Default Movement.
- Click Save, then Cancel.
- Select the Account dimension to open it.
- Locate the member FCCS_Balance Sheet.
- Optional: Select the Member Name column, then click (Freeze). This keeps the Member Name column on the screen as you scroll to the right to locate the Default Movement attribute.
- Click the drop-down list for the attribute Default Movement and select Mvmts_ChangesInBalanceSheet. Click Save.
- Locate the member Accounts Receivable Trade.
- Click the drop-down list for the attribute Default Movement and select Mvmts_ChangesInWorkingCapital.
- Click Save.
- Locate the member Obsolete Inventory.
- Click the drop-down list for the attribute Default Movement and select Mvmts_ChangesInWorkingCapital. Click Save, then Cancel. Note: This attribute can be selected only for “FCCS_Balance Sheet” and level 0 accounts.
- On the Application page, click Actions, then Refresh Database.
- Click Create, then Refresh Database.
- Click Refresh, then Finish.
- Click Close twice.
Managing Ownership
- From the Home page, click Application, then Consolidation. Verify the Manage Ownership tab is open.
- Verify the Point of View is Actual, FY18, Jan. Select Actions, then Recompute Ownership Data.
- Verify the POV, then click Recompute.
Importing Data
- Open the RefApp_MovementsCalc_DataLoadFile_Data.csv file. Note the accounts for which a Closing Balance amount will be loaded in February. They are:
- Cash
- Accounts Receivable Trade
- Other Accounts Receivables
- Obsolete Inventory
- Navigate to Application, then Overview.
- From the Actions Menu, select Import Data.
- Click Create. For source file, click Browse, and select the file RefApp_MovementsCalc_DataLoadFile_Data.csv.
- Click Import. Click OK, then click Close twice, and select the Jobs card. Verify the job completed, then click Home.
Consolidating Data
- From the Home page, select Data.
- Expand the Reference_Application folder, then select (to open) the Movement Calculations form.
- Closing balances have been loaded to the Closing Balance - Input member for February (you may need to scroll the columns to see the February data). Right-click a cell in the Feb column and select Consolidate.
- In the Enter Period field, select Feb, then click Launch.
- Note that the Feb Closing Balance does not yet reflect the Feb Closing Balance Input entries.
- Click Close to close the form, then click Home.
Modifying Calculation Settings
- From the Home page, select Application, Consolidation, then Consolidation: Process -> Local Currency.
- Select the Calculate Movements row, then enable the Calculation Settings by changing the No to Yes.
Reviewing and Reloading Data
- Re-open the Movement Calculations data form.
- Right-click a cell in the Feb column and select Consolidate. In the Enter Period field, select Feb, then click Launch.
- Note that the calculated movements for the two level 0 accounts for which a default movement was entered are posted against “Changes in Working Capital” while for the other two the movements are posted to “Changes in Balance Sheet”.
- Manually enter the following data:
- Cash -> Changes in Balance Sheet = 50 (replacing the existing entry)
- Accounts Receivable -> Changes in Balance Sheet = 50
- Other Accounts Receivable -> Changes in Working Capital = 50
- Obsolete Inventory -> Changes in Working Capital = 50 (replacing the existing entry)
- Click Save.
- Right-click a cell in the Feb column and select Consolidate, and in the Enter Period field, select Feb. Then click Launch.
- Note that the default movement amount is replaced but other data entered is not replaced.
Modifying Calculation Settings
- From the Home page, select Application, then Consolidation, then Consolidation: Process -> Local Currency. Select the Calculate Movements row.
- Disable Calculation Settings by changing Yes to No. At the verification screen, click OK.
- Reopen the Movement Calculations form.
- Enter 400 for Closing Balance Input for all accounts.
- Click Save. Right-click a cell in the Feb column and select Consolidate. In the Enter Period field, select Feb, then click Launch.
- Note that the movements data does not change. All movement amounts are treated as if they had been manually entered, and as a result, the derived Closing Balance no longer matches the entered Closing Balance.
Learn More
Calculating Movements From Closing Balances in Financial Consolidation and Close
F48688-01
October 2021
Copyright © 2021, Oracle and/or its affiliates.
This 20-minute hands-on tutorial shows you how calculate periodic movement from closing balance input.
This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.
If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, then the following notice is applicable:
U.S. GOVERNMENT END USERS: Oracle programs (including any operating system, integrated software, any programs embedded, installed or activated on delivered hardware, and modifications of such programs) and Oracle computer documentation or other Oracle data delivered to or accessed by U.S. Government end users are "commercial computer software" or "commercial computer software documentation" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, the use, reproduction, duplication, release, display, disclosure, modification, preparation of derivative works, and/or adaptation of i) Oracle programs (including any operating system, integrated software, any programs embedded, installed or activated on delivered hardware, and modifications of such programs), ii) Oracle computer documentation and/or iii) other Oracle data, is subject to the rights and limitations specified in the license contained in the applicable contract. The terms governing the U.S. Government's use of Oracle cloud services are defined by the applicable contract for such services. No other rights are granted to the U.S. Government.
This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.
Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.
Intel and Intel Inside are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Epyc, and the AMD logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.
This software or hardware and documentation may provide access to or information about content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services unless otherwise set forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services, except as set forth in an applicable agreement between you and Oracle.