Announcing a new experience for the Oracle Analytics community coming April 4th!
This category will be read-only as we migrate this space from 3/30-4/4, after which you’ll be able to post as usual. See you there!
General Transactional Reporting (OTBI)
Discussion List
-
Need Primary Key: BICC FscmTopModelAM.DooTopAM.FulfillLineSummary Need Primary Key: BICC FscmTopModelAM.DooTopAM.FulfillLineContent We are relying on BICC to send data to the UCM, where it is picked up by another process and us… -
How to extract the information of fusion approval groups via report or web-serviceSummary read approval groups information and extract to be used outside SaaSContent We have managed to develop approval groups in SaaS like the attached document, And si… -
Syntax to fetch pending transfer details from Data_cache column in hrc_txn_dataSummary Syntax to fetch pending transfer details from Data_cache column in hrc_txn_dataContent Hi, We need to fetch the pending transaction Transfer details like New Loc…
-
How to call Oracle cloud call back web services.Content Dear , I want to show my oracle fusion customized reports data into any other non oracle environment. in which i created web services and successfully transfer m…Mirza Adeel Baig-139547 36 views 1 comment 1 point Most recent by Ramalingam Muthaian Pillai- Support-Oracle -
How to display count(new customer account opened) from lasy year's month-to-date in analysisSummary How to display the amount of new customer account opened in last year's month-to-date, together with this year's month-to-date dataContent Hello Oracle Community…
-
How to create a prompt, Year-Month format, in analysis while not having a "Month" dimension?Summary The goal is to enable end users to look at an analysis by year-month periods (ex. YYYY-MM, 2020-01), but "Month" dimension is not available within the subject ar…
-
Administration & Recruiting ReportingSummary I need to union report on these two environmentsContent I have gone through the other postings and from what I can see, I believe this is not possible, but wante… -
Publish Agent for SubscriptionSummary I need to know the limits of the functionalityContent I used several OTBI Agents to deliver some OTBI Analysis to users. To avoid them to create their own agent,…
-
Scheduled Report JobsSummary Deails of Scheduled Report JobsContent Hi Experts, I would like to know is there any seeded report to pull the complete details of scheduled report jobs in BI or…
-
List of OTBI inefficient ReportsSummary looking for was to monitor OTBI reports performance and Frequency of useContent Hi All, I am looking for ways to monitor the performance of OTBI Reports in fussi… -
Hidden fields in OTBISummary Need to find fields selected as 'Hide' as system default in column propertiesContent We have recently had an issue where one of our users has hidden a couple fie… -
Need a SQL query to list all the scheduled OTBI Analsis and dashboardsSummary We need to review and track all the OTBI reports that are scheduled via agentsContent Having the ability to query this out helps us understand who all have sched…
-
Report for scheduled ProcessSummary Required Report to pull details of Scheduled ProcessesContent Hi Experts, I would like to know is there any seeded report or query available to pull the details …
-
Extract first sets of integer from entriesSummary How to extract the first sets of integer from entries in "New Calculated Measure"Content Hello Oracle Community, In "New Calculated Measure" in Analysis, how can…
-
How to build an inventory analysis coupled with time constrained measure?Summary An analysis, contain info. on on-hand-quantity and open quantity, does not produce results after 15mins of run time. This happens when a time constrained measure…
-
call a procedure on oracle bi publisher 12cSummary oracle bi publisher add Global-Level Element by PL/SQLContent Hello all, How to call a procedure that return multiple parameters on oracle bi publisher data mode… -
Rows overcounting in AnalysisSummary How to only count the number of rows showing in an analysisContent Hello Oracle communities, When I attempt to display the total number of rows shown in an analy…
-
Hide Set at Default button under column propertiesSummary Hiding Set as default button under column properties in an AnalysisContent Is it possible to hide the 'Set as Default' button under the column properties in an a…
-
SQL to Query Report Library - OTBI CatalogSummary Looking for SQL or tables to report a list of all reports, properties and folder locationContent Does anyone have a SQL or know the tables that would contain the… -
Error when using TODATE(REVENUE, YEAR) Oracle SQL functionSummary TODATE function resulted in error, what are possible alternatives to get the needed results?Content Hello Oracle Community, The below error (per enclosed 2 scree…
-
How can I export a list of all active reports we have HCM?Summary I need to have a list of all our reports in HCM BIP (and/or)OTBIContent How can I found out how many reports there are in use at the sys? Who created them, activ… -
Sort drop-down list descendingly in Table Prompts in AnalysisSummary How to sort drop-down list descendingly in Table Prompts in AnalysisContent In OBIEE Analysis, how can table prompts value (per enclosed screenshot) be set to so…
-
How to upload css in a dashoardContent Hello Guys, Sorry for my ignorance, I have seen that it is possible to refer to style sheets when you want to edit sections of the dashboard. My question Is? Whe… -
BI Publisher - Add data labels to chart seriesSummary Not able to add data labels to chart seriesContent We have a use case where we need to show data labels in charts. We are using the following option to set this:…
-
List of AgentsSummary List of Agents in "My Folders"Content Hi Team, Does anyone know how to list a list of Agents that were created by users and saved in their "My Folders"? I believ… -
Unable to introduce new line within an excel cellSummary Unable to introduce new line within an excel cellContent I am from Oracle Service Cloud (OSvC). We are using BI Publisher in our product to export data in variou…
-
Referencing Parameters in the Layout Editor FilterSummary Referencing Parameters in the Layout Editor FilterContent Hi, What is the syntax we should use to reference a parameter in the Layout Editor Filter? BR Hany
-
BICC for GL ExtractSummary BICC for GL ExtractContent Hi, We do have an auditing requirement to extract large volume of data from GL Lines and GL balances which may have more than 3 millio…
-
Include report parameter in bursting output?Content I'm using bursting to control the filename/delivery of a report run as a part of a flow. I'm not actually splitting the data up, so I'm just using the Split/Deli…
-
Report on SocialSummary Need to create a report on Application SocialContent Hi, We have a requirement to build reports on Social. Are there any OTBI Subject area or Tables to select fr…