Essbase
Discussion List
-
How to Extract Chart of Accounts Values and HierarchiesSummary How to Extract Chart of Accounts Values and HierarchiesContent Hi I would just like to inquire if there is a standard report (OTBI), program or an API that can e…User_2025-02-11-12-30-38-982 1.2K views 9 comments 4 points Most recent by Truptesh Solanki General Ledger & Intercompany -
how can distribute retained earnings by business unitHow can to make our dsitribution of retained earnings by BU now we have 2 legal entity but 3 bussiness units This 2 BU are under 1 of legal entity but need to see this r…Christian Leon 11 views 2 comments 0 points Most recent by Christian Leon General Ledger & Intercompany -
What is this notepad type deployed status in allocation 'calculation manager'?Summary: In calculation manager in allocation, under system view we have 'Deploy' column where we are getting a third type of deployed status apart from green tick type …Arvind_Behura 11 views 3 comments 0 points Most recent by Hussian Sharief M-Oracle General Ledger & Intercompany -
How to build a FRS report to show trailing actuals and budget for an entitySummary: We have two separate FRS reports to print 12 month trailing budget and actual, which are working fine. The new requirement is to print the actual for the curren…SuniChacko 56 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
Unable to Publish Account Hierarchies for few Value setsSummary: Unable to Publish Account Hierarchies for few Value sets Content (required): We are not able to publish Accounting Hierarchies for Some value sets which for few…Rohit Kumar Singh 1.2K views 12 comments 0 points Most recent by Cezar M-Oracle General Ledger & Intercompany
-
Do we really need the BIAdministrator role for the Account Inspector to show balances on parents?Summary: We noticed an interesting phenomena in General Ledger features that are based directly on the balances cubes (Inquire on Detail Balances, Account Monitor, Accou…Thomas De Leeuw 31 views 2 comments 0 points Most recent by Thomas De Leeuw General Ledger & Intercompany
-
Alias tables in SmartviewSummary: How are these created / where are they coming from? Can additional Alias Tables be created? Content (required): In SmartView (Essbase) when switching between Al…Delaney Wastler 42 views 4 comments 0 points Most recent by Bala Murali SV General Ledger & Intercompany
-
Impact of Member Name Path when a Tree includes multiple versionsSummary: Impact of Member Name Path when a Tree includes multiple versions Content (please ensure you mask any confidential information): We have a tree that includes on…
-
How to connect to Oracle Cloud ERP in Smartview using HS Functions?Hi, We are trying to connect to Essbase cube of Oracle Cloud ERP via Smartview. Specifically, we are trying to use HS functions (Example: HSGet, HSset). But when we try …Guntuka VenkataKrishna 31 views 2 comments 0 points Most recent by Guntuka VenkataKrishna General Ledger & Intercompany
-
Hierarchies version is not visible in AllocationsSummary: Hierarchies version is not visible in Allocations Content (required): Hierarchies version is not visible in Allocations Version (include the version you are usi…
-
Is there a way to bulk enabling DFFs instead of one by oneSummary:We have many DFF that will need to enable for BI. Looking for a faster way to enable all at once instead of doing it one by one. Content (please ensure you mask …
-
Changing Accounting Calendar from Fiscal to Calendar Year in Oracle FusionSummary I am trying to change our accounting calendar from Calendar Year to a Fiscal Year. Has anyone been able to do this and are there any downstream impacts?Content W… -
Account Cube UpdateSummary Account Cube UpdateContent I did an update to Account Hierarchy and generate the "Publish Chart of Accounts Dimension Members and Hierarchies" not publishing Hie…
-
Balances are not reflecting in "Inquire on Detail Balances"Summary: Balances are not reflecting in "Inquire on Detail Balances" Content (please ensure you mask any confidential information): Balances are not reflecting in "Inqui… -
How to create a trial Balance either in OTBI or FRC ?Summary: How to create a trial Balance either OTBI or FRC ? Content (please ensure you mask any confidential information): Hello The company would like to have a trial b…Cesar Saveedra 14 views 1 comment 0 points Most recent by Lakshmi Alagappan-Oracle General Ledger & Intercompany
-
Putting primary ledger and secondary ledger into same subeI am using Oracle Fusion General Ledger Cloud Service (Oracle GL). Now, we created primary ledger(PL) for local GAAP and secondary ledger(SL) for another GAAP. Same COA …
-
View Cash Position Report is not fetching the Closed Booked Balance, Inflow and Out FlowCash Management UI View Cash Position we are not able to see the Closed Booked Balance, Inflow and Out Flow amounts. We have executed the below jobs, but still not fetch…Koteshwar Tippani 39 views 2 comments 0 points Most recent by Koteshwar Tippani General Ledger & Intercompany -
Ledger currency for El Salvador during the rapid implementation templateSummary: Some years ago el Salvador changed it country currency now they only use USD Our problem is when uploading the rapid implementation the ledger was created with … -
Key flexfield value(Business Activity) Child value to Remove From All Values And Make It a ParentHello All, One of our key flex field value (Business Activity), we have one of the value as child but no transaction been done on this. Based on the requirement we have …Khaleel Hussain Shaik 11 views 3 comments 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany
-
Can a new dimension be added that can be used in smart view and financial reporting studio?Summary: We are on Oracle Fusion Cloud 23C. There is a requirement to add a new dimension to classify an account as GAAP or non-GAAP that can be used in SmartView or Fin…Daisy.Dabandan DS 22 views 2 comments 0 points Most recent by Daisy.Dabandan DS General Ledger & Intercompany
-
Smartview Hierarchies - Member Selection & naming ConventionsSummary: Using Smartview for Essbase and wondering if naming conventions can be changed and how hierarchy displays are determined. Content (required): In the Member Sele…Delaney Wastler 21 views 1 comment 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany
-
Unable to Assign Legal Entity to Bank Account in HCM Payroll ImplementationSummary: Content (required): Hello all, We are currently implementing HCM Payroll for our customer and have encountered an issue related to creating bank accounts for em…Patrick Chrabieh 23 views 1 comment 1 point Most recent by Mary Ramirez-Oracle General Ledger & Intercompany -
Unable to view Financial Reporting Center icon.Summary: Unable to view Financial Reporting Center icon. Content (required): Hi all, User having Bi Admin custom role and General ledger role (including data access) but…Truptesh Solanki 22 views 2 comments 0 points Most recent by Truptesh Solanki General Ledger & Intercompany
-
Creation and Deletion of GL CubesSummary: Hello, I recently had a clone from P2T where production was a fresh environment. However, my previous cubes and allocation rules weren't deleted. Can anyone gui…
-
How to retrieve data from GL Cube?Summary: How to retrieve data from GL Cube? Content (required): The link below provides some information about the GL Cube (Overview of Oracle General Ledger Balances Cu…RS_CSAA 173 views 4 comments 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany
-
Ability to Encrypt data in FRWSSummary: Ability to Encrypt data in FRWS Content (required): In cloud, when bursting FRWS reports via email option, can pgp encryption be applied to the zip file contain…User_2025-03-28-20-09-35-565 22 views 1 comment 0 points Most recent by Hussian Sharief M-Oracle General Ledger & Intercompany
-
GL Budget upload - BudgetName exceed the maximum length allowedSummary: Content (required): Hi, I'm trying to upload budget to GL cubes. I have created a scenario by the name "MPL Capex Opex Monthly 2023" which is the same as my con…Sheneli98 45 views 2 comments 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany
-
Does Scheduled Process Validate and Upload Budgets cause a GL Balances Cube update, impacting users?Summary: Users in Smartview and General Accounting UI Inquire and Analyze Balances received error messages and lost connectivity to GL data (cube) unexpectedly around th…Carol Fergusson 32 views 1 comment 0 points Most recent by MariCostache-Oracle General Ledger & Intercompany
-
How to connect/download data from Fusion Applications General Ledger Essbase Cube to our databaseSummary: Can we gain access to Financial data cube to develop our internal reports? The current custom report built in FRS needs to be used by users that do not have acc…
-
How to manage General Ledger Essbase Cube in Oracle fusionSummary: Hi Team, Could you please suggest on how and from where can we manage Oracle Fusion General Ledger Balances Cube? Thanks, Palak Singh Content (required): Versio…Palak Singh 176 views 6 comments 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany