BI Publisher
Discussion List
-
HDL - Element Entry IDContent Hello, I'm trying to update recurring element entries but am not sure where to find the ElementEntryID so that we can refer the HDL to a specific element entry. … -
How to Embed a BIP Report with Prompts on a DashboardSummary How to Embed a BIP Report with Prompts on a DashboardContent Hi All, I have an existing custom Missing Time Cards report which is built using a custom SQL refere…Vinay Soni 226 views 4 comments 0 points Most recent by Anil Kola-Oracle Reporting and Analytics for HCM -
how to default the date parameter in BIP report with sysdate-1 hourSummary how to default the date parameter in BIP report with sysdate-1 hourContent Hi All, Could any one help me in defaulting the date parameter in BIP report with an h…User_2025-02-06-09-41-56-955 400 views 4 comments 1 point Most recent by Anil Kola-Oracle Reporting and Analytics for HCM -
Data Model for HR Service RequestsSummary looking to report on HR Service Request dataContent Hi, we've recently started using the 'HR Service Request' facility. Was wondering if anyone had built a data …David McLellan 42 views 4 comments 0 points Most recent by David McLellan Reporting and Analytics for HCM -
Eligibility Profile Validation Report for BenefitsSummary A lot of time customer requests to validate Or have the Benefits Eligibility Matrix handy as to query for each plan and combinations using UI is a cumbersome pro…
-
Vertical display of text in titleContent We built a 9-Box using performance tiles and would like to display labels against the Performance boxes. Is that feasible? Thank you!User_2025-02-10-08-27-16-805 22 views 9 comments 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Issue passing the date parameter to the date parameter while creating a link to the other BIP reportSummary I have been tryingng to create a link for a custom BIP report in my existing report for which I am passing 3 string parameters which worked fin, while passign th…User_2025-02-07-18-15-37-534 125 views 2 comments 0 points Most recent by User_2025-02-07-18-15-37-534 Reporting and Analytics for HCM -
CASE statement THEN valueContent I would like to add a case statement logic where if a condition holds true, a column value is displayed. But in addition to the value being displayed from the sy…User_2025-02-10-08-27-16-805 25 views 2 comments 0 points Most recent by User_2025-02-10-08-27-16-805 Reporting and Analytics for HCM -
Ethnicity bar graphSummary Bar graph does not match tabular view.Content I am trying to pull employee ethnicities from the system. I have come across multiple posts on how to bucket employ…User_2025-02-10-08-27-16-805 68 views 6 comments 1 point Most recent by User_2025-02-10-08-27-16-805 Reporting and Analytics for HCM -
Direct Report Headcount in OTBI?Summary Are there any fields in OTBI which can pull a manager's direct reports / headcount, or otherwise indicate that they are a manager?Content Are there any fields in…Monica Fundak 51 views 3 comments 0 points Most recent by Gary Miller-39965 Reporting and Analytics for HCM -
Sample Workforce Compensation BIPContent Hello experts, where could I find sample Workforce Compensation BIP? I need to build a BIP report allowing managers to see their direct/indirect reports for the …Valerio Curzi 49 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
BIP Report Jobs IssueContent Hi all, I asked a couple of weeks ago about changing the privacy of Report Jobs from Private to Public which was answered here: https://cloudcustomerconnect.orac… -
Head Count as of given dateContent Hi Experts, We are looking for a report which has the below data point. The worker subject are giving information as of date and in the current requirement we ne…Kiran Kancherla 34 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Instance identifier in BIP reportSummary We need specific report to run only if it is on specific instance (say Test POD).Content We need specific report to run only if it is on specific instance (say T…Priyanka More-Oracle 178 views 5 comments 1 point Most recent by Priyanka More-Oracle Reporting and Analytics for HCM -
Table for Attachments under position profileContent Hi, Can someone help me with the table contains the attachment information under position profile? Regards, NivyaNivya Mathire 90 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
How to load sample report in Oracle HCMContent Hello experts, I need to load a custom template as example in Oracle HCM. I want to load an image showing a sample performance document. In addition, I have crea…Valerio Curzi 33 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Simple logical sql query fails to load in data modelSummary Simple logical sql query fails to load in data modelContent We were trying to create a data model with Simple query(Name = Any , Data Source = Oracle BI EE, Type…Sreedharan-Oracle 79 views 7 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Question on .catalog filesContent Hello Experts, I got two questions (probably a weird ask) on BI catalog objects. In /analytics (OBIEE), the archive will create a .catalog file instead of a.xdo/…Akash Kiran Jana 161 views 5 comments 2 points Most recent by Akash Kiran Jana Reporting and Analytics for HCM -
How to remove an unwanted character in rtf template (PDF Output)Summary How to remove an unwanted character in rtf template (PDF Output)Content Hi Experts, We are generating confirmation letter with PDF format for this we are using R…Bala Kasineedi 543 views 4 comments 0 points Most recent by Bala Kasineedi Reporting and Analytics for HCM -
How to fetch the deleted goalsSummary How to fetch the deleted goalsContent Hi, We are in REL 13 20 D. Our customer want to fetch the Goals details of the employees which are deleted. Could you pleas…Radha Devi P 94 views 13 comments 1 point Most recent by Radha Devi P Reporting and Analytics for HCM -
Absence Calendar Details Real Time - Incorrect Data in ReportContent Hi Experts, We have created a OTBI report in which we are getting the results as per leave type and for one specific leave type, we are getting very small (Incor…Kiran Kancherla 22 views 1 comment 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Extract Projected Accrual Absence Balance in HCM/BIP reportSummary Extract Projected Accrual Absence Balance in HCM/BIP reportContent Hi Experts,We have a requirement to fetched projected Absence balance of employee in extract t…Rajeev Nayan 718 views 6 comments 3 points Most recent by AshishERPCloud Reporting and Analytics for HCM -
We need to fetch all active records from current Organization Tree for department structureSummary We need to fetch all active records from current Organization Tree for department structureContent Hi Experts, We need to fetch all active records from current O…Balaganapathi Kasineedi 67 views 6 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
How to export OTBI report including Personal Photo?Summary Need to crreate an OTBI with Personal Photo and Export successfullyContent Dear Experts: I have builld an Employee List report with Personal photo as a columon. …Mayi218-Oracle 75 views 1 comment 2 points Most recent by Seiichiro Yasui Reporting and Analytics for HCM -
Organization Levels, Organization Manager Names, and their Effective DatesSummary Organization Levels, Organization Manager Names, and their Effective DatesContent Hi Experts, Good day! Can you please help and guide or redirect me to resources…Raymund Jerome 10 views 4 comments 0 points Most recent by Raymund Jerome Reporting and Analytics for HCM -
Report to show all future approversContent Hi, Does anyone know of a report or way to query, all future approvers in an approval chain for notifications. For example, next approver is person x, then once … -
Need Employee Leave Balance Report ?Summary Need any pointers/hints for building Employee Leave Balance ReportContent Expected Layout Parameters Effective Date : 06-Jul-2015 Employee Leave Balance Report P…AshishERPCloud 734 views 10 comments 5 points Most recent by AshishERPCloud Reporting and Analytics for HCM -
How to get link between Plan, Plan option and Elements for individual compensation plans?Summary How to get link between Plan, Plan option and Elements for individual compensation plans?Content Hi Team, We have a requirement where to fetch all the elements a…Harish Kumar Kovi 155 views 6 comments 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM -
Promotion SpeedContent Hi All! Has anyone had luck working on promotion speed ratios out of OTBI? Diving into this in the next week or two and wanted to see if anyone else has worked o…Lauren Owen 27 views 3 comments 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to replace DATA_CACHE with XML_DATA_CACHE syntax in Oracle BIP Data Models?Summary How to replace DATA_CACHE with XML_DATA_CACHE syntax in Oracle BIP Data Models?Content Hi Experts, We came to know that Oracle deprecated 'DATA_CACHE' column and…Harish Kumar Kovi 115 views 4 comments 0 points Most recent by Harish Kumar Kovi Reporting and Analytics for HCM