Essbase
Discussion List
-
Can we load custom excel data via rules files in Essbase 21c?Summary: Hi All, As per Essbase 21c documentation Microsoft excel is listed as one of the data source types supported. Apart from the standard dimension/data import ment… -
How to change the length of the subinventory, which currently only supports 10 bitsHow to change How to change the length of the subinventory, which currently only supports 10 bits
-
API interface push create transaction processing error, AR moduleYou must enter a valid account classification. Valid account categories include: Accounts receivable, revenue, taxes, and freight. (AR-857782)
-
How to run MDX query with multiple Select statementsSummary: I'm running an MDX query that times out with the following error message: I'm trying to circumvent this limitation by breaking down the query into two smaller o…
-
Essbase Calculate Script: How to define the prompts in a specific orderSummary: As shown in the screenshot, the order of the prompt is not optimal - it is confusing to the users. I would like to know if it is possible to define the prompts …
-
Error trying to run MDX query via VBASummary: I'm trying to run MDX query using HypExecuteMDXEx function. Just took a sample from the book, put in my parameters and a database, and when I tried to run it, g…
-
Smartview retrieve file gets very large on saveSummary: Hello, We have one user, when he Smart View retrieves on 5 different template files, the retrieve works fine, but when he saves, the Excel file will grow to a v…
-
Execute Maxl commands and scripts from Essbase 21 consoleSummary: Content (required): Maxl statements or scripts cannot be executed from Essbase 21 console. Please add this feature as it currently exists in v11.x Version (incl… -
Can we update Child Account segment value to a Parent segment value?Summary: Can we update Child Account segment value to a Parent segment value? Content (please ensure you mask any confidential information): We have two Account segment …ramesh.sivapalan 47 views 6 comments 0 points Most recent by ramesh.sivapalan General Ledger & Intercompany
-
Essbase Marketplace: best practice for log rotation and /tmp and /u01/tmp cleaningSummary: Hi, I am used to deploy Essbase 21 Independent Deployment and Marketplace version, and I am seeking best practices for the following points. I already searched …
-
Recording SmartView report's "Last Retrieved" timeSummary: I have a SmartView report (Version 23.200). The report has about 50 data pull sheets and one control sheet where I define parameters (such as Product and Entity…
-
check if essbase database has any data load, or calculation running?Summary: Hi Team, Is there a way or maxl command to check if essbase database has any data load, or calculation running? Our requirement is to check if any Calculations …
-
JExport in Essbase21 CWe recently upgraded from Essbase 11.2.5 to 21C and are having trouble using some of the udf functions. Just wanted to check if anyone has used JExport with Essbase 21C?…
-
Rolling SumHi, I am trying to get the Rolling Sum of 24 months using ASO MDX query. Need help. Thanks, Nandakishore
-
it there way to know if values added in value set values for COA, are not defined into a hierarchy?Summary: Customer needs to know if all the nueve value set values created have been assigned to an accounting hierarchy through some task or scheduled process Content (p…Arturo Benitez-Oracle 11 views 2 comments 0 points Most recent by Antima Rai-Oracle General Ledger & Intercompany
-
In FRS Report, Balances need to calculate with Conversion rate or User Enteted rate.Summary: Customer don't have reporting currency ledgers but only have primary ledgers for all countries. He has reporting requirement that Local Reporting in INR and Glo…raviteja.v 21 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
(AP-810825)Fusion call exception: You cannot do this because there is no valid invoice with the information provided. (AP-810825)
-
User role access to application file systemHi, let me bring to your attention that users with User role are still able to access application files system and then download sensitive files such as data exports. We…
-
Why allocation formula don't get transferred during a clone?Summary: Why allocation formula don't get transferred during a clone? Content (please ensure you mask any confidential information): We cloned our PROD environment to ou…ramesh.sivapalan 11 views 2 comments 0 points Most recent by ramesh.sivapalan General Ledger & Intercompany
-
Is there a way to massively update the financial category in the natural account?Summary: Is there a way to massively update the financial category in the natural account values registered in the coa? Content (please ensure you mask any confidentia…Arturo Benitez-Oracle 11 views 1 comment 0 points Most recent by CristinaV1-Oracle General Ledger & Intercompany
-
Oracle Analytics Publisher Desktop installation failSummary: Good evening experts, I'm trying to install Oracle Analytics Publisher Desktop 7 on my workstation Before this attempt I made another one, but stopped it. Now w…
-
Ability to export all Allocation Rules with Formula in excelSummary: Currently we have many allocation rules and there is no report currently that lists all the allocation rules with the formula lines. We need to get that extract…
-
Is it okay to use single quotation mark in Chart of Account Name?Is it okay to use single quotation mark in Chart of Account Name?
-
How to update the Alias table name in ERP smartview?How to update the Alias table name in ERP smartview? We have loaded the Swedish description and the same is visible in Alias Table as "Language_S". We need to update the…Rishika Menezes 1 view 1 comment 0 points Most recent by Gabriela Patrascu-Oracle General Ledger & Intercompany
-
abc costing using allocation in oracle fusionSummary: We need to use allocation to generate abc costing based on activities, need to distribute the salaries and some expenses. Any body have idea how can process. No…Christian Leon 11 views 1 comment 0 points Most recent by Gabriela Patrascu-Oracle General Ledger & Intercompany -
Our business has a requirement of loading 300 FBDI Journal files in single daySummary: Our business has a requirement of loading 300 FBDI Journal files in 20 hours with million lines in one file. There is no way to extend timeline of 20 hours as i…Prasad Sawant 1 view 1 comment 0 points Most recent by Laura Petre-Oracle General Ledger & Intercompany
-
Can use GL's rapid implementation to create a new enterprise structure (LE, Ledger, Calendar, COA) iSummary: I have to create a new gl enterprise structure (primary ledger, COA, calendar) in a cloud instance where the customer already has other structures created. I ca…Arturo Benitez-Oracle 11 views 2 comments 0 points Most recent by Julien_Dubouis General Ledger & Intercompany
-
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.4K views 9 comments 4 points Most recent by Truptesh Solanki General Ledger & Intercompany -
How can I use HypUIConnect without a friendly name?Summary: I need to convert multiple Smart View reports to point to a different database. The "from" and "to" database have different number of dimensions; some dimension…
-
How can you Dynamically copy multiple smart list members into single member in the same dimension?Summary: I need to copy allocated data into an unallocated member for two dimensions. Content (please ensure you mask any confidential information): I want to move data …