SmartView
Discussion List
-
Remove ASCII characters from text data in Data Management (EPBCS)We are getting "XML Load Error: Invalid Unicode Character" error while refreshing Text data in SmartView for ASO cube as there are ASCII symbols in text data which got l… -
Export and Import to a file Rules, Rule Set and Model's in EPCMSummary: The objective is to automate the creation, alteration and deletion of Models, Rule Set's, and Rules (usual artifact to configure and allocation rule and grup of…Michel_MB_PwC_ADV 102 views 2 comments 1 point Most recent by Michel_MB_PwC_ADV Profitability and Cost Management -
ASO Cube - Drill Down Vs Refresh of BottomSummary: I'm facing a weird use case with our ASO reporting Cube. Our Reporting Cube is very sparse and we have 2 big dimensions : 1 emplyee dimension (around 80k member… -
SmartView Crashes or hangs indefinitely(EPBCS applications).We are using MS Office 365 and SmartView version 22.200 and at times, the excel hangs indefinitely(mostly while refreshing the forms) and then, there is no option to clo…
-
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 …
-
Drill Through Does not return any data when executingSummary: When i Try to drill, the landing pange open and i recieve the follow message: Drill query does not return any data. Data was not loaded to this intersection usi…
-
Smartview - Lock Member SelectionsOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Description (Required): Apologies if … -
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 71 views 4 comments 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
See Report Books in SmartViewSummary: Content (please ensure you mask any confidential information): I have a number of FR Reports books that I have in PBCS. However, I am unable to see them when I … -
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 32 views 2 comments 0 points Most recent by Guntuka VenkataKrishna General Ledger & Intercompany
-
SmartView for non office 365Summary: The customer has a standalone, non-365 version of Microsoft Office suite Content (please ensure you mask any confidential information): Do we have SmartView set…
-
Remove User Permission to Save Forms/Grid into LibrarySummary: Content (please ensure you mask any confidential information): I have users that have been saving ad hoc grids as forms in the library. However, I cannot find a…
-
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… -
How do you install a previous version of Smart ViewSummary: Content (please ensure you mask any confidential information): I have one user whose excel crashes whenever they try to refresh a workforce employee roster form…
-
Unable to connect to SmartView with same credentials as web accessSummary: I could previously connect to Smart View via both shared and private connection, but after the epm login page changed, I am no longer able to connect to Smart V…
-
PBCS Offline formsHey, I'm unable to connect the Offline forms through SmartView More option. For this issue, I had reviewed Oracle Documentation, there I have found this Note: Offline fu…
-
Excel formulas in Strategic Modeling Freestyle reports randomly not sticking in the modelsWe are creating freestyle reports in Strategic Modeling containing a few basic Excel formulas for subtotals or simple calculations. It works most of the time but in some…
-
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…
-
Retrieve Parent of member in SmartView / HSGetHello Experts, Is there any way to retrieve the parent of a member in Excel? I have a file that uses HSGet (it was a necessary evil to achieve the layout i needed), and …
-
Smartview handled unknown exception thrown by Microsoft office.Summary: I received a message every time I open Excel. The message is: "Smartview handled unknown exception thrown by Microsoft office". Has anyone encountered this befo…
-
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 51 views 1 comment 0 points Most recent by Lakshmi Alagappan-Oracle General Ledger & Intercompany
-
Changing Smartview settings via scriptSummary: I had the issue - SR 3-34040867641 : FR - Report doesn't show the arrow - similar to "+" - indicating that the member has children. - and the solution is to cha…
-
Copy Entity data from one period to anotherSummary: It is required to copy Consolidated data for ultimate parent company to another Standalone entity to support Tax computation at Group level. Content (please ens… -
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 49 views 2 comments 0 points Most recent by Koteshwar Tippani General Ledger & Intercompany -
How to identify if a user has been connected : via Web or SmartView ?Hello All, Is it possible to identify how a user has been connected : via Web or via SmartView? Today, we can see if a user put the data in adhoc or directly in a form..… -
Connection Refused Error in Smart ViewSummary: Some users are experiencing an intermittent Connection Refused error in Smart View when attempting to refresh or login. What are some possible reasons for this …
-
Submit data using VBA macros from a hidden worksheetSummary: I'm trying to submit data from a hidden worksheet. I don't want to use HypMenuVSubmitData as it will require unhiding the worksheet. I can't use HypSubmitData a…