Smartview
Discussion List
-
How to get the URL for the connection of Smart View?Summary: How to get the URL for the connection of Smart View? Content (please ensure you mask any confidential information): How to get the URL for the connection of Sma… -
Smart View Drill Through to Go Through GL Inquiry RoleSummary: Smartview Drill Through to Go Through GL Inquiry Role Content (required): Currently Smartview drill through is going through the GL Period Close role assignment…luke.syv8 71 views 8 comments 0 points Most recent by Teresa Cabrita - Capgemini UK General Ledger & Intercompany
-
Impact on Application behavior if we change the FUTURE1 Segment of COA Structure to ZONESummary Impact on Application behavior if we change the FUTURE1 Segment of COA Structure to ZONEContent Hi All, Greetings. Customer is live on Cloud Applications, having…Subramanyam Tumarada-Oracle 136 views 8 comments 1 point Most recent by PratikL General Ledger & Intercompany
-
Example to create Smart view report for elimination IntercompanySummary: Any body can help me to provide me how can create in Smart View the trial balance report consolidate but eliminate the intercompany accounting. Any guide to hel…Christian Leon 1 view 1 comment 0 points Most recent by Christian Leon General Ledger & Intercompany -
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 31 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 11 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 4 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 31 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 61 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 11 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 13 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 12 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 11 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 151 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.3K 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 11 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 31 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 53 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 41 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 27 views 1 comment 0 points Most recent by Lakshmi Alagappan-Oracle General Ledger & Intercompany