BI Publisher
Discussion List
-
report to get list of direct reports for a managerContent Hi Experts, I am looking for a query where the manager can get the output as the name of all direct report specific to them, I am able to achieve it in analysis …GauravSushant 971 views 3 comments 1 point Most recent by User_2025-03-07-00-53-57-686 Reporting and Analytics for HCM -
Analysis or Report not returning any resultsContent I'm hoping there is something obvious I'm not doing right, but every time I try and run an Analysis or Report in BI Publisher, it returns No Results as per the s…User_2025-02-05-23-39-39-057 56 views 6 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Headcount in Fusion ProfileSummary Do you know what table does Headcount belong to in Fusion>Person Management>Manage Person.Content Do you know what table does Headcount belong to in Fusion>Perso…Mark kristan De los Reyes 29 views 1 comment 0 points Most recent by Aaron Leggett Reporting and Analytics for HCM -
OTBI Report Shared to Supervisor does not show parameterContent Hello Everyone, I have added a tab to 'My Team' to show reports to Line Managers. I have added an OTBI report to this tab using personalization. However, when ru…Hetal Vaghela 28 views 2 comments 2 points Most recent by Hetal Vaghela Reporting and Analytics for HCM -
Has anyone seen custom reports timing out after 20A upgradeSummary BIP Reports timing outContent We have a custom BIP report built off a SQL data model. It used to run about 15 minutes. After upgrading to 20A in all our developm…TonyWo 38 views 3 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM -
Workforce Map - ReportSummary Looking to see if the Workforce Map we use can be replicated in OTBI or BIPContent Hello We are soon to move from a partial cloud installation to a full cloud of…Andrew Braid 56 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
BIP Report: Converting multiple row & multiple column values into single row and multiple column valSummary BIP Report: Converting multiple row & multiple column values into single row and multiple column valueContent Dear Experts I am working on a BIP report (SQL quer…Karthik K-Oracle 311 views 1 comment 0 points Most recent by Karthik K-Oracle Reporting and Analytics for HCM -
Changing Security on A BIP Report so that it displays whole organization data instead of just the daContent Hi All, Does anyone know the best way to modify a BIP report that's built to show manager's hierarchy view only so that the report shows full organization data? …Lauren Owen 20 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
ORA-01489Summary error when running a reportContent Hello. I built a report in BIP where I had to concatenate columns into rows and it runs as expected. However when I try to for…
-
How to provide the secure access to folder using custom role to employeeSummary How to provide the secure access to folder using custom role to employeeContent Hi Expert, Want to provide the report folder access to the set of employee who is…User_2025-02-05-01-04-36-989 28 views 3 comments 0 points Most recent by Thiru Ch Reporting and Analytics for HCM
-
I can't see any secured reportsContent Hello Guys,The technical department has secured the reports in BI. My users cannot view the reports anymore, it seems as if they no longer exist. Is there any ro…Giuseppe Iacono 38 views 2 comments 0 points Most recent by Tom Strudley Reporting and Analytics for HCM
-
Can I report on System Entry Date?Summary How can I report on the system entry date of an action? Not the creation date or last update date.Content Hi all, Has anyone found a way to report on the actual …User_2025-01-31-22-36-07-589 92 views 5 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM
-
Create a report for Areas of ResponsabilitiesContent Hi Guys, I need to realize a Report in order to extract: Person ID, Employee Name, Area Of Responsibility Name , Responsibility Type and Scope Of Responsibility.…Giuseppe Iacono 65 views 3 comments 1 point Most recent by Rambabu Laveti-Support-Oracle Reporting and Analytics for HCM
-
Adding metadata to PDF output generated through BIP burstingSummary Can we add metadata/Properties such as author, tags to a PDF output file through BI PublisherContent Can anyone tell me if I can add metadata to pdf output gener…Prateek Parasar - GTUK, ACE Pro 37 views 1 comment 3 points Most recent by Mihaela M Reporting and Analytics for HCM -
Using Multi-threading in BI Publisher Data ModelSummary Using Multi-threading in BI Publisher Data ModelContent Hi Experts, In order to improve performance , I see that BI publisher has option in Data Model Properties…Aloka Bhattacharya 603 views 1 comment 0 points Most recent by Mihaela M Reporting and Analytics for HCM -
Using WITH in SQL versus sub-query-which is better?Summary Using WITH in SQL versus sub-query-which is better?Content Hi Experts, Can someone help me understand if using WITH in SQL query really improve performance versu…Aloka Bhattacharya 112 views 1 comment 0 points Most recent by Mihaela M Reporting and Analytics for HCM
-
Error on Technical Summary Report under /Shared Folder/HCM/Setup and Maintenance/ConfigurationSummary Getting data model error while running Technical Summary Report under /Shared Folder/HCM/Setup and Maintenance/ConfigurationContent Hi All, Does anyone know what…
-
Making Changes to Standard Notification TemplatesSummary Is there a delay between a customized BIPublisher report and the workforce Notifications?Content Hello Experts! We've recently started venturing into changing so… -
Weekly & Monthly Team Calendar View for Employees & ManagersContent Hello! I don't think a day goes by where we are not asked for weekly and monthly team calendars to allow our managers to make informed decisions around holiday r…Kevin M Storrie 98 views 2 comments 0 points Most recent by Kevin M Storrie Reporting and Analytics for HCM -
Dashboard Prompt using BI Publisher/DataModelSummary Using a prompt on a dashboard for a BI ReportContent I have placed a BI Publisher report on a dashboard. This report is built from a data model that contains a p…Shelly Feyerherm 61 views 2 comments 0 points Most recent by Sandeep S. Chauhan-Oracle Reporting and Analytics for HCM -
Report sorting based on supervisor hierarchy 1 followed by hierarchy 2Summary Requirement: Report sorting logic required to sort based on Supervisory Hierarchy 1 followed by Supervisory Hierarchy 2 as displayed in the table above. Kindly l…
-
BI Publisher data model filter manager typeSummary Recently implemented second manager type which is causing multiple lines on BIP reportContent We have a daily BIP report that sends employee data based on action…Rob Stahly 25 views 4 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Oracle BI to HCM NavigationSummary Oracle BI to HCM NavigationContent Hello, Is there a smart navigation that will allow users to navigate from BI back into HCM without a new web browser being gen…User_2025-01-29-01-38-03-243 32 views 3 comments 1 point Most recent by Tom Strudley Reporting and Analytics for HCM
-
Steps to audit BI folder changes?Summary In what way can we identify what user moved heh folder in BI Catalog?Content In our PROD pod, we have several folders under the custom folder location that inclu…User_VR8E0 68 views 5 comments 3 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
Union ContactsSummary BI Publisher table for union contactsContent I am building a report in BI Publisher that requires union contact name but I am unsure of which table this informat…
-
BIP No Output MessageContent Hi all - I am familiar with how to set the no output error message on an OTBI report, but am unsure how to do so with a BIP report. What I am trying to solve is …Prudence K 40 views 3 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM -
Geography query for Country, state, city and postal code for all countriesSummary Geography query for Country, state, city and postal code for all countriesContent Hi All, We need to create report for Country, State, City and Postal Code using…User_2025-02-01-06-07-07-886 1.9K views 3 comments 0 points Most recent by Chris Campbell Reporting and Analytics for HCM
-
Mobile App in BI analyticsContent Hi, Can someone tell me what is the use of "Mobile App" in BI Analytics and how to use the functionality? Please share any documentation if you have any. Regards…Nivya Mathire 27 views 2 comments 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM -
Intermittent error accessing a data model I createdSummary Intermittent error accessing a data model I createdContent I am sometimes get an error when accessing a data model i have copied to a particular folder as per at…Ruzwan Akram 15 views 3 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
20A Documents of Record Real Time - 4 fields decommissioningContent Hello, Just reading the release notes and see a line around 4 columns to be removed from this area, any particular reason why? Are these fields remaining on the …Kevin M Storrie 44 views 2 comments 0 points Most recent by Kevin M Storrie Reporting and Analytics for HCM