BI Publisher
Discussion List
-
How to Fetch more than 1000 records with BIP or OTBI reportSummary: Fetch more than 1000 records with BIP or OTBI report. Content (required): Hi, How to fetch more than 1000 records with BIP or OTBI report. I tried with Paramete…Sudheer YN 33 views 6 comments 0 points Most recent by Rich Merkel General Transactional Reporting (OTBI)
-
Any one help Skills ReportSummary: Hi Team, we need skills report in Bi or OTBI Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets…AjayKumar Maddipati 11 views 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle General Transactional Reporting (OTBI)
-
Clean up html formatting stored in table columnWe are using notes to store data in an application table (Oracle Cloud PPM, Project setup); users are copying and pasting data from an html page and inadvertently pastin…erp_expert03 21 views 3 comments 0 points Most recent by Venkat Koduvayur-Oracle General Transactional Reporting (OTBI)
-
Fusion BI Catalog Folder Management Best PracticesSummary A white paper on Fusion BI Catalog Folder Management Best PracticeContent This white paper provides the best practices for working with BI catalog folders, and s…User720640-Oracle 108 views 1 comment 9 points Most recent by HarishVummidi General Transactional Reporting (OTBI)
-
Does anyone know what tables are needed to create OTBI report "Transactions awaiting my action"?Summary: Indirect Procurement stakeholder wants to create an OTBI report for "Transactions Awaiting My Action". This would be used to review POs that were not successful…MarysueMcCracken 11 views 4 comments 0 points Most recent by Gaurav Bharadwaj-Oracle General Transactional Reporting (OTBI)
-
Report Location of following seeded reportsHello - We are having a request to implement/customize the following reports but will have to analyze first the complexity of each report. Unfortunately, we are unable t…ZenG 21 views 2 comments 0 points Most recent by Gaurav Bharadwaj-Oracle General Transactional Reporting (OTBI)
-
USE OTBI TO CREATEPROJECT REPORT DEPEND ON API NEED TO CREATE OTBI REPORT FOR PROJECT PROJECT NAME,SUM INVOICE,SUM PAYMENTS,UNPAID AMOUNT
-
Populating OTBI Reports onto My DashboardSummary: I have created a number of OTBI dashboards and analyses that I would like to appear on the My Dashboard section of Oracle Cloud Fusion Applications. Content (re…rabarthel 21 views 3 comments 0 points Most recent by RichardChan General Transactional Reporting (OTBI)
-
Table name to capture reverse termination date & its details for reverse terminated employeesSummary Table name to capture reverse termination date & its details for reverse terminated employeesContent Hi All, In which table I can find the reverse terminated dat…Nirmal Kumar L 20 views 1 comment 1 point Most recent by Parag Hiremath General Transactional Reporting (OTBI)
-
Table to retrieve records from Audit reports in Oracle Cloud Fusion ERP 22ASummary: Table to retrieve records from Audit reports in Oracle Cloud Fusion ERP 22A Content (required): Which table in SaaS stores information for Audit Reports? Table …Abhilash K - Deloitte USI 12 views 2 comments 0 points Most recent by Abhilash K - Deloitte USI General Transactional Reporting (OTBI)
-
View Previous run history of an agentSummary View Previous run history of an agentContent Hi I have created an agent to run a report in Oracle BI. I have scheduled the agent . It seems last run has failed b…Ritwick Chatterjee 46 views 6 comments 2 points Most recent by Andrew_Schmitz General Transactional Reporting (OTBI)
-
Adapting Previously Used SQLSummary: Amending a BIP Report we have that's not pulling the correct results back Content (required): Hi all, Apologies if this is the wrong place to ask. I've been ask…
-
Unable to open public job historySummary: Has anyone seen this error before. I have a user that is trying to view the results from the Job History and getting the attached error screen with message HTTP…Chris Diekvoss 1 view 1 comment 0 points Most recent by Noelle Bartlam-Oracle General Transactional Reporting (OTBI)
-
How do we customize pre-defined reports to add more parameters and display fields on OTBISummary: Trying to add more parameters for a custom AR aging report Content (required): Accounts Receivable Aging Report Version (include the version you are using, if a…Abhinav Gaddipati 41 views 6 comments 0 points Most recent by Abhinav Gaddipati General Transactional Reporting (OTBI)
-
Formula to get Top 5 categories based on a criteriaSummary: Content (required): Hi Experts, We have a requirement to get Top 5 Expenses based on the balancing segment value. The Top 5 expenses can be obtained using the b…231094 11 views 3 comments 0 points Most recent by Amrita Gupta-Oracle General Transactional Reporting (OTBI)
-
How can I find all reports using the same BI Publisher Data ModelSummary I need to be able to identify all the reports that are using a Data Model before I make changes to the DM.Content Bi Publisher Data Model has been created, I now…Sarah Munro 12024679 32 views 8 comments 2 points Most recent by Frank Davidson General Transactional Reporting (OTBI)
-
List of BPM PVOs available in Fusion or accessible through OTBISummary: Would like to know the list of available OTBI PVOs which hold BPM related information to be able to cater to some reporting scenarios - for e.g. - how long does…Amit Garg-Oracle 1 view 1 comment 0 points Most recent by ravikiran goda-Oracle General Transactional Reporting (OTBI)
-
Repeat Column Headers in BI Publisher Excel TemplatesSummary Repeat Column Headers in BI Publisher Excel TemplatesContent Hello Everyone, I have a requirement to repeat column headers in BI publisher excel templates when t…Dhanuka Chamal 40 views 5 comments 2 points Most recent by ravikiran goda-Oracle General Transactional Reporting (OTBI)
-
How To Restrict Values In OTBI Dashboard Prompt Based On SecuritySummary:Want to Restrict Values in OTBI Dashboard Prompt based on Security Content (required):You have a role that has access to an OTBI Dashboard, and the data in the r…vjsalve 41 views 2 comments 0 points Most recent by Amrita Gupta-Oracle General Transactional Reporting (OTBI)
-
View/Table details for Data SecuritySummary: Hi Everyone, We have built some custom pages and are looking to apply Fusion security on those pages. In order to do so, we require the Secure View/ Table detai…Maruvada Sanat Kumar-Oracle 11 views 2 comments 0 points Most recent by Amrita Gupta-Oracle General Transactional Reporting (OTBI)
-
The content is blocked contact the site owner to fix the issue. OTBISummary: We have created a custom report using SQL based data model and gave permissions to the user for running it. But, they are receiving this error when trying to ru…Goutham.Manthri 251 views 8 comments 0 points Most recent by Gaurav Bharadwaj-Oracle General Transactional Reporting (OTBI)
-
how to remove HTML markup from columns of an OTBI reportSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Abhishek Bagh 21 views 3 comments 0 points Most recent by Gaurav Bharadwaj-Oracle General Transactional Reporting (OTBI)
-
oracle cloud HCM OTBI Dynamic File Name and TitleSummary: Output File naming :-YYYY-MM-DD – [Business Unit] – [Last Name], [First Name} [Incident Event Type] Title: Safety Incident Report for [Incident Number] [Inciden…Surya -Oracle 11 views 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle General Transactional Reporting (OTBI)
-
Does anyone know how to convert dynamic timezone in Oracle SQL via Data Model?Summary: Is there a way to dynamically convert timezone based on what timezone is being set in UI? (specifically in learning activity start time and end time) Content (r…Hazel De Castro 1 view 2 comments 0 points Most recent by Bhaskar Konar General Transactional Reporting (OTBI)
-
Using BIP Rest API in Oracle HCM CloudSummary: Using BIP Rest API in Oracle HCM Cloud Content (required): Hi experts. Does anybody know if it is still impossible to use BIP Rest APIs within fusion apps? A BI…Volodymyr Faranosov 1 view 3 comments 1 point Most recent by Gaurav Bharadwaj-Oracle General Transactional Reporting (OTBI)
-
Has Bursting SQL Functionality Changed with 22B?Summary: Bursting SQL not working as it did before upgrade to 22B Content (required): Simple bursting sql to send email when running a report. Worked fine up until 22B. …jeffMA71 11 views 2 comments 0 points Most recent by Gaurav Bharadwaj-Oracle General Transactional Reporting (OTBI)
-
Can we schedule Dashboards ?Dear , My requirement is to schedule a dashboard same like reports. I successfully schedule a reports but i cant see a option to schedule dashboard can any one guide me …Mirza_Adeel 11 views 7 comments 0 points Most recent by Shashank Verma-Oracle General Transactional Reporting (OTBI)
-
Can we restricted Report data on a users basis?Dear , We need to restrict reports data to a user base. Some user see all data which have been in report and some users see only his data. How can we do this . we need t…Mirza_Adeel 1 view 8 comments 0 points Most recent by Shashank Verma-Oracle General Transactional Reporting (OTBI)
-
OTBI report gives an error when add Workforce Management - Person Real time subjectDear , I have an OTBI report which works fine on subject Workforce Management - Worker assignment Real time but i need two more column which is in Workforce Management -…Mirza_Adeel 1 view 9 comments 0 points Most recent by Bhaskar Konar General Transactional Reporting (OTBI)
-
Text AnalyticsSummary step by step procedure to proceed Text Analytics in OBIEE 11gContent Hi, I need step by step procedure to proceed Text Analytics in OBIEE 11g. I'll be happy to r…Andrews J Stanley 21 views 2 comments 0 points Most recent by Nathan CCC General Transactional Reporting (OTBI)