BI Publisher
Discussion List
-
USE OTBI TO CREATEPROJECT REPORT DEPEND ON API NEED TO CREATE OTBI REPORT FOR PROJECT PROJECT NAME,SUM INVOICE,SUM PAYMENTS,UNPAID AMOUNTghrbia 16 views 3 comments 0 points Most recent by Amrita Gupta-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 15 views 1 comment 0 points Most recent by Raghavan p-Oracle General Transactional Reporting (OTBI)
-
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 27 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) -
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 12 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle 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 31 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 21 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 132 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 12 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) -
Is it possible to get the Report Job History Output & Delivery details in BIP?Summary Is it possible to get the Report Job History Output & Delivery details in BIP?Content Hello Experts, We have a requirement to fetch the report job history detail…Harish Kumar Kovi 40 views 4 comments 3 points Most recent by KIOMER-Oracle General Transactional Reporting (OTBI)
-
How to generate Dynamic Password Protected BIP report output?Summary How to generate Dynamic Password Protected BIP report output?Content Hi All, I have written a post on How to generate Dynamic Password Protected BIP report outpu…Rajeev Nayan 34 views 1 comment 10 points Most recent by A.JOSH General Transactional Reporting (OTBI)
-
RTF template issueSummary Need to remove the data of 1st page from RTFContent Hi All, If we check the attached test.rtf and test.xml file we can see the 1st page don't have any line value…Rahul R Singh 10 views 2 comments 1 point Most recent by Michael Remisiewicz General Transactional Reporting (OTBI)
-
How to run an OTBI Analysis and save output without having it deliveredSummary How to run an OTBI Analysis and save output without having it deliveredContent Currently in Schedule option of of OTBI analysis , there is option to deliver to e…Shivaji Muttarapu 25 views 8 comments 0 points Most recent by Shivaji Muttarapu General Transactional Reporting (OTBI)