BI Publisher
Discussion List
-
DATEVALUE Function is not working properly in excel templateAfter using DATEVALUE Function column values are not matching with the actual column values. Please refer the screenshot Not sure what is the issue. Template : Thanks, M…minati_behera-Oracle 21 views 2 comments 0 points Most recent by Aaron Hager Associated Bank Reporting and Analytics for HCM -
% of Employees on Talent Review meeting w.r.t Succession PlanSummary: I am looking to calculate the % of employees on a Talent Review box those who are on Succession Plan. SO for example on the 9-Box matrix box- Future Star we hav…
-
What is the usage & how to use a View Object validation type in Value set?Summary: Content (required): Version (include the version you are using, if applicable): 21D Code Snippet (add any code snippets that support your topic, if applicable):Fraol Wondimu 11 views 1 comment 0 points Most recent by Madhavi-Oracle Reporting and Analytics for HCM
-
How to implement a custom version of a standard BI ReportSummary: How to implement a custom version of a standard BI Report Content (required): Hi, I would like to edit a Standard Performance Notification (the report is the fo…Alberto Barile 1 view 4 comments 0 points Most recent by Paul Campanello Reporting and Analytics for HCM -
on-going resignations report - reporting on approvalsHello, could somebody please tell me how to extract this information from Fusion HCM, either as an OTBI or a BIP report? The business requirements: - we are using the jo…Geraud Andreux 65 views 4 comments 0 points Most recent by Geraud Andreux Reporting and Analytics for HCM
-
Create a report that shows invoice data on day it was loaded?Summary: Hi everyone. I am curious if there is a way to create a report that allows me to collect data from an invoice on the day it was created. Such as Problem Type. I…User_2025-02-10-15-06-52-222 11 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Remove unwanted options from a BIP report which is exposed as a sub tab via application composerSummary: We have created a BIP report, Added the report in Application composer Mash up> Added this mashup as a subtab in one of the object, on clicking this subtab, I c…S.Kumar 41 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
What tables hold the project costs expenditure batch workflow details for creator and approverSummary:Does anyone know if this information can be reported on using BI Publisher or OTBI to view the approval workflow for project cost expenditure batches? This infor…Rich Merkel 281 views 2 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP -
How to apply Line Manager data security in BIP report running from OTBI dashboardSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Vijay Gorania 121 views 12 comments 0 points Most recent by MilanMohanty Reporting and Analytics for HCM
-
Security Slowing Down ReportsContent Hi all - We have a security role, Global Reporting, that allows me to create, edit, run reports and see all data. We give this role out to our report developers …Prudence K 48 views 6 comments 0 points Most recent by Shant Sarkissian_NES Reporting and Analytics for HCM -
ORC: Candidate EIT info Reporting via OTBI Subject AreasSummary: Can we extract ORC Candidate EIT info via OTBI Subject Areas? Content (required): Can we extract ORC Candidate EIT info via OTBI Subject Areas? What will be the…Bhaskar Konar 72 views 4 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Oracle Learning OTBI report files to download?Summary: Where on Customer Connect can I find a list of Oracle Learning OTBI report files to download so I may upload them into our Oracle BI environment? Content (requi… -
Is there a way to see SCORM file transaction details in the DB?Summary: We are new to Oracle and in our old LMS we were able to see the SCORM course transaction details. I don't see that available in Learn. Am I missing something? C… -
Need to Develop Custom Report for "Year to Date" Budget Balance ReportSummary: Need to Develop Custom Report for "Year to Date" Budget Balance Report can i get query for budget control Till now Query i have used select budget_name.NAME ,GL…User_2025-02-12-02-13-49-388 31 views 2 comments 0 points Most recent by Mihaela Cozma GL-Oracle Budgetary Control
-
Can you change the date format in all the columns that have dates so that it filters by year/MonthSummary: we are using excel template to generate the excel output.Can you change the date format in all the columns that have dates so that it filters by year/Month? Thi…minati_behera-Oracle 31 views 2 comments 0 points Most recent by Abhishek Premchandra-Oracle Reporting and Analytics for HCM
-
Restrict Report Folder movements in the BI catalog areaSummary: Hi Experts, How do we restrict Folder Movement (Drag and Drop option) of BI Catalog Custom Shared Folders? Is anyone can advise on this? Recently we had a bad e…Mithun Abhisheka 101 views 2 comments 0 points Most recent by User_2025-03-07-21-51-04-421 Reporting and Analytics for HCM -
Can we print Continuing Education Completion Certificates when a user completes a course?Summary: Our hospital provides continuing education courses for our nurses and other professionals. We need to generate a certificate of completion in the proper format …
-
Custom flow is not producing the dataSummary i have attached custom BI Report to custom flow pattern when we are running the flow output is coming as blankContent Hi Team, we have a requirement to attach BI…User_2025-02-04-07-00-18-658 36 views 4 comments 0 points Most recent by Jon Taylor Reporting and Analytics for HCM
-
OTBI report - export to Excel limitationSummary: We have OTBI reports that will exceed the 50,000 field limitation for exporting to Excel. Content (required): Can you "schedule" an OTBI report to get around th…User_2025-01-28-20-19-02-475 72 views 2 comments 0 points Most recent by Ghanshyam M-Oracle Reporting and Analytics for ERP
-
BIP Excel output always adds additional comma to end of values when saving as csvSummary: Content (required): In BI Publisher, I need to export a simple table report to XLS (not csv) to be used as a template. However, once completed and then saved as…Marcus131975 31 views 3 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
I'm trying to use the concat function in ether OTBI or BI to combine 4 fields.Summary: I have tried using the pipe method (||), the nested method and the case/when. and still can not get this to work. I am trying to to combine cost center informat…RJ Blankenship 331 views 9 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Need to add different images of signatories in the rtf template for a BIP reportSummary: Content (required): I want to add signature's image to the letter which is in rtf template where path of the image is an XML element. As far as i researched im …
-
BI Publisher Integration with Google CalendarSummary: Can we integrate BI Publisher with Google Calendar (i.e.) To make a web service call from BI to Google Calendar API and create and update events. Please share i…Srikanth_M 11 views 1 comment 1 point Most recent by Adam Gates-Oracle Reporting and Analytics for HCM
-
Missing columnsSummary: Not appearing columns heading when records are exported. Content (required): We have created query to export data which has been generated in xml. However, when…
-
How to Restrict Custom BIP Report Business Unit Wise without using Secured Table ViewSummary: How to Restrict Custom BIP Report Business Unit Wise without using Secured Table View Content (required): How to Restrict Custom BIP Report Business Unit Wise w…Ghanshyam M-Oracle 132 views 6 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for SCM -
The BIP Catalog page search box is inoperable.Summary: I've been looking into it for a long time, but I've never figured out why the BIP catalog page search box doesn't work. I tried the same thing in multiple insta…User_2025-10-24-00-15-43-324 13 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for SCM