Smartview
Discussion List
-
What is the best practice to create intercompany elimination for profit and lossSummary: What is the best practice to create intercompany elimination for profit and loss In our scenario we have 2 legal entitys same country share the same calendar, c…Christian Leon 34 views 4 comments 0 points Most recent by Christian Leon General Ledger & Intercompany -
Change the Accounting Period from Quarterly to Semi-Annual in SmartviewHi, This is to ask from your assistance regarding this matter. Client asked us if there’s a possible way to format/have an options in Smartview from Quarterly basis (Ima…Felipe M. Ignacio II 13 views 4 comments 0 points Most recent by Felipe M. Ignacio II General Ledger & Intercompany -
Suppress rows based on the account prefix postive or negativeSummary: Suppress rows based on the account prefix postive or negative Content (please ensure you mask any confidential information): There is a requirement to have valu…Dian Minshan 3 views 3 comments 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
I need help setting up an account hierarchy to allow business users to view it in the cloud GLHello Support Community, I need help setting up "Account Hierarchy Management" to allow business users to view it in the cloud general ledger. Currently, they have acces…Prakash Vattapalli 32 views 3 comments 0 points Most recent by Rohan Kamat General Ledger & Intercompany
-
Open Trial Balance on SmartViewSummary: It´s possible to open trial balance by Smart View? If so where is this report located? We need to open and work tis information on excel file. Content (please e…Timestamp EPM Team 59 views 1 comment 0 points Most recent by Sharada Beleramane-Oracle General Ledger & Intercompany
-
General Ledger Allocation Rule for DepreciationSummary: How to create Allocation Rules for Depreciation on Capital Stock (converted from Revenue stock) on Oracle Cloud? Content (please ensure you mask any confidentia…
-
ERP Cloud - Smartview ReportsSummary: Content (please ensure you mask any confidential information): Hello everyone, We have a report created in our ERP, however I tried to access it in smartview, b…Timestamp EPM Team 12 views 1 comment 0 points Most recent by Harry Zhu General Ledger & Intercompany
-
Ability to Select multiple dimension members in a single column/row in SmartView Ad-Hoc ReportingWhen creating a SmartView Ad-hoc report. When we choose members from a dimension right now, we are only able to push them across columns / down rows , but we want to pla…k.madaan 14 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
How can we solve the issue of only one parent value showing in member id selection in SmartviewHello Experts, We have noticed that when selecting the member ID in Smartview, only one parent value is shown on the "All Department" member ID, while the other parents …Venkatagiri. K 14 views 4 comments 1 point Most recent by Venkatagiri. K 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 13 views 1 comment 0 points Most recent by Gabriela Patrascu-Oracle General Ledger & Intercompany
-
Error 500 - Internal Server ErrorSummary: What could be a reason for Error 500- Internal Server Error (The server encountered an unexpected condition that prevented it from fulfilling the request)? The …User_2025-07-18-06-16-52-703 158 views 2 comments 0 points Most recent by Shameer Shaik 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.2K views 9 comments 4 points Most recent by Truptesh Solanki General Ledger & Intercompany -
Error: The Character limit exceeds 250000 for SmartView ReportsTeam, We are facing an error in SmartView reports which says that maximum character limit exceeds 250000. How can we extend the limit in the configuration?svishnugupta 13 views 1 comment 0 points Most recent by Richa Arora-Oracle General Ledger & Intercompany -
Unpublished/Inactive Hierarchy is still available in SmartviewSummary: I have 2 questions in the same area relating to unpublished / inactive hierarchies: 1. We used to be able to deactivate a Hierarchy and that would mean it was n…Service Desk Claremont 19 views 3 comments 0 points Most recent by RajendraV-Oracle General Ledger & Intercompany
-
Can we concatenate values from different COA segments and create parent-child relationships?Hello, Can we concatenate values from different COA segments and create parent-child relationships? i.e: 1. BS 101-CC 120234 - Account 51023(Expense) 2. BS 101- CC 12023…svishnugupta 11 views 1 comment 0 points Most recent by Andreea Brem-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
-
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
-
Multiple currencies are visible in SmartviewSummary: On test instance, we see the currencies outside of USD and STAT are disabled under Manage Currencies and are also not listed in Manage Reporting Currencies and …
-
Tree Version Start and End DateSummary: Purpose of Tree Version Start and End Date Content (please ensure you mask any confidential information): Can someone please help me to understand the purpose/o…ramesh.sivapalan 73 views 4 comments 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
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
-
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… -
Smartview query: There are 2 database connections in smartview and both are visible.Summary:Smartview query: There are 2 database connections in smartview and both are visible when we try to connect to Databsase connection. We want to hide one which is …
-
FRS & Smartview Report helpSummary: In the FRS & Smart View report we have ''AccountingPeriod'' dimension where we can see GL Periods and able to select. But our requirement is to select date rang…
-
When I use zoom it on smartview, can the hierarchy open downwards instead of upwards?Summary: When I open the account hierarchy using zoom it, the parent accounts are placed below the child accounts. Is it possible to change this? Parents are ranked firs…
-
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
-
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 -
Best practice for AR Aging to TB ReconciliationSummary: Best practice for AR Aging to TB Reconciliation Content (please ensure you mask any confidential information): Currently we see huge difference between AR Aging…Ajay Hareesh 22 views 1 comment 0 points Most recent by Lakshmi Alagappan-Oracle General Ledger & Intercompany -
Secondary ledger is not available to select on Inquire and Analyze Balances or SmartViewSummary: We are in the process of creating a secondary ledger. The secondary ledger has been created, chart of accounts created, value sets created, primary to secondary…Nicole Croll 114 views 1 comment 0 points Most recent by Andreea Brem-Oracle 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