This post explains the process to setup Oracle Financials Cloud as a data source in Data Management and execute the initialization process. I encountered an error during the initialization process which I have given the details and resolution for it.
Configure Cloud Financials as a Data Source in Data Management
To add Oracle Financials Cloud as a data source, we need to create an user id in Oracle Financials Cloud with ‘General Accounting Manager’ responsibility (role) AND access to all the ledgers. Data access sets must be granted to the user for all entities (needed for drill through)
In Data Management, add source system of type ‘Oracle Financials Cloud’. In Drill Through URL, enter R13 for release 13 of ERP or R12 for release 12 of Oracle Financials. Refer this link for more details.
Click Configure, enter Oracle Cloud Financials Cloud credentials and URL (See format given below). Ensure ‘Test Connection’ is successful’. Refer this link for more details.
A quick background on Oracle Financials Cloud GL Balances Cube
In Oracle Fusion General Ledger (Oracle Financials Cloud), a new balances cube is created when an accounting configuration is submitted for a primary or secondary ledger that uses to a new unique combination of chart of accounts and calendar. This balances cube is an Essbase database that maintains financial balances in a multidimensional database. The Essbase balances cube(s) are named after the chart of accounts they contain.
The Oracle Fusion General Ledger updates balances in real time to the relational tables and the General Ledger Balances cubes. Most inquiry and reporting are now performed from the General Ledger Balances cubes and not from the relational tables (Account balances were maintained in relational tables in Oracle E-Business Suite General Ledger). More information regarding this setup is available at this link.
The balances cube(s) are named after the chart of accounts they contain and are available to perform ad-hoc analysis from Smartview. Sample URL format is given below.
https://XXX.us2.oraclecloud.com/workspace/SmartViewProviders
Use the server name for your instance in this URL. Access to the GL Balances cube will depend on the security access given to the id used to perform ad-hoc analysis on the GL Balances cube using Smartview.
Oracle Financials Cloud initialization in Data Management
For Oracle Financials Cloud, Data Management looks up the configuration of the GL Balances cube during initialization and fetches balances from the GL Balances cube once successfully initialized. Initialization fails when the GL Balances cube has not been created or not refreshed after a cloning/migration was done from another instance.
Once Oracle Financials Cloud was successfully set up as a data source, the initialization process was executed. However, during initialization, we encountered an error and the process log contained the following error message:
INFO [AIF]: Standard Error: java.lang.Exception: Unable to find txt data file for essRequestId: 10825 at com.hyperion.aif.fusion.FusionAdapter.main(FusionAdapter.java:135)
The initialization issue pointed to the re-creation of the GL Balances Cube or the order in which it was created after migration. After completion of cloning/migration, these Essbase cubes must be recreated against the cloned Fusion Applications database, to confirm that the re-wiring was successfully completed, and to ensure that the cubes exactly correlate to the transactional data in the cloned database. This process is called ‘re-spinning’.
Another way to find out if the GL balances cube exists is to run a SQL query using OTBI against the Fusion database tables to ensure the cubes exist. Query select * from gl_balances table should result in records that show the existence of GL Balance Cubes
If the query does not return any valid records indicating the existence of GL Balances cube, then the GL Balances cube needs to be recreated/refreshed. Refer to the Oracle documentation for creation of the GL Balances cube.
Once the GL balances cube was created, the initialization process was successful. On successful initialization, Data Management creates a target application of type ‘Essbase’ with the name same as the ERP Chart of Accounts name.
Useful Links:
Oracle Cloud Financials Accounting Configuration
GL_BALANCES_CUBES table details
Documentation for integrating Oracle Financials Cloud using Data Management