Script:How to Import Balances into FDM as YTD Even Though ERPi Extracts in Periodic
Posted by Priya Doyle on 07 February 2011 12:16 PM
Applies to:Oracle Financial Data Quality Management ERP Integration Adapter for Oracle - Version: 188.8.131.52.00 to 184.108.40.206.00 - Release: 11.1 to 11.1
Hyperion Financial Data Quality Management - Version: 220.127.116.11.00 to 18.104.22.168.00 [Release: 11.1 to 11.1]
Information in this document applies to any platform.
Currently depending on the account type inside of EBS the financial information can be extracted as a YTD or Periodic amount.
For Balance Sheet accounts (Asset,Liab,Equity) the balance is a roll forward amount (YTD) amount. Every time you open/close ending balances are rolled over to the next period.
For Income Statement (Rev/Exp) the balance is maintained as period amounts. The total for the Year is sum of the period net of all the periods.Access to the FDM Script Editor either via the Web Interface or the Workbench Win32No Configuration Requirements are Necessary.
To bring in all values as a YTD amount a simple FDM Import Format script can be applied to the amount field to manually do the math.
This script is provided for educational purposes only and not supported by Oracle Support Services. It has been tested internally, however, and works as documented. We do not guarantee that it will work for you, so be sure to test it in your environment before relying on it.
Proofread this script before using it! Due to the differences in the way text editors, e-mail packages and operating systems handle text formatting (spaces, tabs and carriage returns), this script may not be in an executable state when you first receive it. Check over the script to ensure that errors of this type are corrected.