BI Publisher
Discussion List
-
Email BurstingSummary How to send BI report pdf output as attachmentContent There is a requirement to send the pdf output of a custom BI report to employees. I have added the bursting…Vivek Pathak-71652 94 views 9 comments 0 points Most recent by Mansur Khalil Reporting and Analytics for HCM -
Data PrivacySummary How do you share your reports with your users?Content Hi all - I submitted a post recently about how you share reports with users (through self-service and/or da…Prudence K 89 views 6 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
BIP Schedule ReportsSummary Need SQL query to get the information if anyone change the schedules of the reports.Content Hi All, We scheduled couple of BIP reports based on UTC (Ex: 09:00AM … -
Job Grade ReportSummary Report to connect Job Info to GradesContent I am looking for a way to pull on a single report Job Code, Job Name, Family, Function, Management Level, Job Level, …User_2025-01-23-23-44-45-599 169 views 6 comments 0 points Most recent by User_2025-01-23-23-44-45-599 Reporting and Analytics for HCM -
AutomailerSummary There is a requirement to create an automailer to employees with pdf outputs of two different BI reports as attachmentContent There is a requirement to create an…Vivek Pathak-71652 23 views 1 comment 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
How to display data in one row?Content I created a custom analysis to show performance ratings of employees but it shows manager ratings and employee ratings in two rows for the same performance docum…User_2025-01-28-21-18-43-496 76 views 2 comments 0 points Most recent by User_2025-01-29-23-59-58-976 Reporting and Analytics for HCM
-
BIP Report for Absences Taken & Absences EligibleSummary How do I report on taken absences vs eligible absences?Content Hi all - I have a customer request for reporting on the vacation an employee is eligible to take f…Prudence K 147 views 5 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
Date format 'DD-Mon-YYYY' in OTBI Analysis PromptContent Can anyone please guide how to get the date format 'DD-Mon-YYYY' in the OTBI Analysis prompt. Please see the screen-shot attached, where I want to achieve it.Amrit 232 views 1 comment 3 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
SQL Script for Worker's departmentContent Hi All, I am trying to get the worker's department along with his name, person number, manager etc. I use the following script to get the department; SELECT DIST…Achala Munasinghe 84 views 4 comments 0 points Most recent by Achala Munasinghe Reporting and Analytics for HCM -
BI Publisher - inner joinContent Hello, I have 2 questions about bi publisher data model is there a way to create an inner join between 2 data set in Bi publisher? by default when we create a li…User_2025-01-25-01-33-46-269 62 views 0 comments 0 points Most recent by User_2025-01-25-01-33-46-269 Reporting and Analytics for HCM
-
How security works in case of custom report?Content Hello everyone, When we are using OTBI report it is following the security profile of the user logged in and in case of bip reports we have to use secured tables…User_2025-01-25-06-20-12-259 131 views 4 comments 2 points Most recent by User_2025-01-25-06-20-12-259 Reporting and Analytics for HCM
-
Tables and Views against OTBI Subject AreasContent Hi, Is there any resource available to refer Tables and Views against OTBI Subject Areas? Because referring OER is quite time consuming. Thanks and Regards AchalaAchala Munasinghe 101 views 3 comments 0 points Most recent by Vinit Kumar-47692 Reporting and Analytics for HCM
-
performance document - get date of transferContent Hello, I am trying to find when a performance document have been transferred to a new manager. Is someone know in with table (bi publisher or otbi) I can get the…User_2025-01-25-01-33-46-269 41 views 4 comments 1 point Most recent by User_2025-01-25-01-33-46-269 Reporting and Analytics for HCM
-
Limit Prompt Choice List Values by UserSummary I'd like the choice list values for my prompts to be only the values the logged in user should see.Content My dashboard prompts are Business Unit, Department Nam…User_2025-01-25-00-37-41-739 92 views 2 comments 2 points Most recent by User_2025-01-25-00-37-41-739 Reporting and Analytics for HCM
-
OTBI Report in DashboardContent I need to build a graph for the person headcount for different actions and then embed that graph in the dashboard. I understand that the person having the HR spe…
-
Hierarchy Traversal in BI Data Model ReportContent Please refer to the images attached. Referring to IMAGE1. In column level we want to show business unit in level2(by default on opening the report) from the orga…
-
Report showing Employee's Line Manager and Business Unit DirectorContent Hi All, I am struggling to create a report showing an Employee's direct Line Manager and Business Unit Director. When I create it, I get the hierarchy for that e…Aaron Leggett 106 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Date subtraction in eText templateContent Hi All, I am facing issues in date manipulation in the eText Template. Seeded date functions are not working and traditional date subtraction are not returning v…User_2025-01-25-06-20-12-259 435 views 6 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
Reading file from Content ServerSummary Reading file from Content ServerContent We have a requirement to read a document/attachment from content server and display it on a report as either a link or to…Srihari Murthy 111 views 1 comment 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
Bursting Name Changes Details to EmailSummary Name Changes Only Extract IssueContent Hi Team, We have a requirement to capture all the Name changes (Old and New) happening in the system for Active employees …User_2025-01-23-22-36-48-692 63 views 5 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
Pivot Table - adding a column to total values per sectionSummary adding a column to sum values in each sectionContent We have a goal plan which is sectioned by goal categories. I am creating a report for our goal admins for th…User_2025-01-22-19-28-29-985 70 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Amending Graph DesignsContent Morning all I've built a Performance Dashboard (attached), but had a few questions that I haven't yet found answers to: 1. I'd like to change the colours of the …User_2025-01-28-05-39-23-766 59 views 4 comments 0 points Most recent by User_2025-01-28-05-39-23-766 Reporting and Analytics for HCM
-
Element EntriesSummary Is there a way to report on who modified what element entries?Content Hi all - I have searched through existing posts and do not believe I have found anything th…
-
Need equivalent column in Oracle HCMSummary Need equivalent column in Oracle HCMContent We are creating reports from Peoplesoft HCM to Oracle HCM, we couldn't find few equivalent columns from Peoplesoft HC…Manoj Madhavan 36 views 0 comments 0 points Most recent by Manoj Madhavan Reporting and Analytics for HCM
-
Users doesn't have BI Reports access based custom roles after R12Summary Users doesn't have BI Reports access based custom roles after R12Content Users doesn't have BI Reports access based custom roles after R12. Will be appreciated f…User_AEMC1 55 views 1 comment 0 points Most recent by User_2025-01-22-18-30-18-571 Reporting and Analytics for HCM -
Compensation - which table contains the comments ?Content Hello, In the compensation sheet, you can add a column in which the manager can add a comment. I need to extract all the comments with BI Publisher or OTBI. Is a…User_2025-01-25-01-33-46-269 45 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Reporting on Areas of ResponsibilitySummary Reporting on Areas of ResponsibilityContent Our IT department created a data model to report on Areas of Responsibility, but there is a problem with missing data…User_2025-01-22-19-28-28-240 281 views 3 comments 0 points Most recent by User_2025-01-28-03-49-50-466 Reporting and Analytics for HCM
-
Trigger Extracts from BI PublisherSummary Can BI Publisher trigger HCM Extracts?Content Hello, Can BI Publisher catalog trigger an Extract? We have a working extract already and we want to trigger it usi…Brent Rodriguez 70 views 1 comment 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
OTBI Error: The View Object "HcmTopModelAnalyticsGlobalAM.ManagerHierarchyAM.PersonNameDPVO" is usedSummary OTBI Error: The View Object "HcmTopModelAnalyticsGlobalAM.ManagerHierarchyAM.PersonNameDPVO" is used as the destination of more than one View LinkContent We are …User_2025-01-25-04-02-13-126 37 views 6 comments 0 points Most recent by User_2025-01-25-04-02-13-126 Reporting and Analytics for HCM
-
Error 500 --Internal Server Error - BIP ReportsSummary Error 500 --Internal Server ErrorContent We have created a BIP reports but when we run it we get the following error message. Is there a way to fix it? thank you