Essbase
Discussion List
-
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.5K 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 52 views 4 comments 0 points Most recent by Bala Murali SV General Ledger & Intercompany
-
Drill through on parent of shared membersSummary: We have an Essbase 21c drillthrough report defined with filters set up to allow us to pull level 0 members of any dimension and pass them to Essbase drill throu…
-
Calc Script for YTDSummary: I am trying to create a separate dimension in Planning called "View" using a member formula to calculate MTD, QTD or YTD values based on the selection made in t…
-
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…
-
Intelligent agg with ILANCESTORSRe-posting my question here because it might be more appropriate than the Planning forum I have a data form with two sparse dimensions on the row (CC, Product). Groovy d…
-
Error using summation in MDX querySummary: I'm trying to pull data from Essbase using a group of members that I need to sum up. To do it, I'm using WITH statement that looks something like that: With Mem…
-
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 …
-
Journal Posting errorJournal Posting error : No sequence version is enabled or defined for sequences with an expiration date of 01/31/24.
-
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…
-
Essbase certificationsSummary: Hi, should we expect Essbase certifications to be back on Oracle University. And when ? Same question for Essbase etraining on Oracle University. Content (requi… -
Passing parameters to Report Writer scriptSummary: I'm trying to create a universal data extraction process that will utilize Report Writer. The idea is to have a standard extract layout (placement of dimensions…
-
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… -
Essbase Report Writer decommissioningSummary: Are there any plans to decommission Report Writer, and if "yes" - when? Thanks!
-
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 52 views 1 comment 0 points Most recent by Lakshmi Alagappan-Oracle General Ledger & Intercompany
-
Looking for the easiest way to view an essbase outlineI'm trying to debug an issue with a current cloud planning and have the outline extracted from the essbase data artifact. I'm looking for the easiest way to view it. Are… -
Essbase Error (1270073) Failed to read data from file.Summary: In ERP, when posting a Journal, it ended in error 1270073.- Failed to read data from file .../temp/ess00001.dat, does someone know the reason? We must explain i…
-
Is there a way to facilitate loading over a billion records into a cube on Essbase 21c?Summary: I have a cube where I will need to load a billion records in a timely manner. Are there any efficiencies that I might gain by employing something like Cameron d…
-
Essbase Error (1270073) Failed to read data from file.Summary: Essbase Error (1270073) Failed to read data from file. What is the reason? or what does this error mean? Content (please ensure you mask any confidential inform…
-
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 41 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 … -
Line numbers don't match in audit files ATX & ALGSummary: The line numbers in both .atx and .atx don't match with each other Content (please ensure you mask any confidential information): Until lately, the line numbers… -
QR Code Scanning in Fusion BI ReportHello All, We have developed an invoice print report for one of our clients and embedded QR Code in it. Now our requirement is to get the report output along with QR Cod…
-
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 21 views 2 comments 0 points Most recent by Daisy.Dabandan DS General Ledger & Intercompany