Oracle cloud consulting

Question: 1 Is it necessary to run the 'Transfer General Ledger Balances to Essbase' program after loading a new account segment hierarchy or after enabling segment security on an account segment? Answer When a new hierarchy is created for a segment or security is enabled on a segment of the accounting flexfield it's not necessary to run the Transfer General Ledger Balances to Essbase program. Those changes will be reflected in the cube by publishing the hierarchy of the segment. You can use the Publish Account Hierarchies page to Publish Account Hierarchies pushing the changed settings to the Essbase cube Question: 2 What is the program "Transfer General Ledger Balances to Essbase program" used for? Answer Oracle Essbase is embedded within Oracle Fusion General Ledger and provides multidimensional balances cubes. Every time a transaction or journal is posted in General Ledger, the balances cubes are updated at the same time, therefore the program "Transfer ...

Introduction to FRS Reports - For beginners  The ESS Base database is primarily used to derive GL balances by applying member combinations, which will aid the reporting needs, moreover, the data are easy multidimensional drag and drop features which makes it user-friendly and yet efficient    What are members? Member is a parameter that essentially provides a direction to get transactional balances. What are rows and columns? If you are aware of EBS, then this gives the same meaning in Fusion also. For non-EBS consultants, rows and columns can define how the data can be populated. For instance, I can fix account and financial year in columns and BSV (company segment) in a row. What is point of view? Point of view is an intersection parameter to retrieve data, this can be seen in each dimension in a data source. Here, dimension is nothing but a database item I will come up with a use case in the next post how any financial statement can be created in Oracle fusion FRS Happ...