BI Publisher
Discussion List
-
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 774 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 74 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 745 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 161 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 123 views 4 comments 0 points Most recent by Harish Kumar Kovi Reporting and Analytics for HCM -
Combining Oracle HCM and data from external sourceSummary How to create a data model for BI report using combination of Oracle and external dataContent Hello All, I need to generate a CSV file, to be sent periodically t…User_K90ZS 46 views 6 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM -
BI excel template xsl when otherwise tags giving data in different format with extra spacesSummary BI excel template xsl when otherwise tags giving data in different format with extra spacesContent Hi All, In one of the custom BI report we are using excel temp…User_XT9HW 35 views 1 comment 0 points Most recent by Pradeep Sharma-14802 Reporting and Analytics for HCM -
Table and Column for Override Average Weekly Earnings field on Maternity LeaveSummary Table and Column for Override Average Weekly Earnings field on Maternity LeaveContent Hi Experts, We have a requirement to fetch the Override Average Weekly Earn…Rajeev Nayan 69 views 2 comments 0 points Most recent by Rajeev Nayan Reporting and Analytics for HCM -
BIP Report Scheduling IssueContent Hi all, I'm currently in the process of scheduling the reports we've built using BIP data models, but we've noticed that all schedules that I've created only sho… -
Restrict to run reports for delivered Employee RoleSummary How to restrict with delivered Employee Role to run reports from BIContent Hi Experts, We have noticed that general Employees have access to run reports (like Pa…Rakesh Ankusham 59 views 6 comments 1 point Most recent by Aaron Leggett Reporting and Analytics for HCM -
Behaviors tagged under each competency in Talent profileContent Hi, Can someone help me with the database table where we get the Behaviors tagged under each competency? Regards, NivyaNivya Mathire 6 views 4 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
HEX values for seeded pie chart colorsSummary HEX values for seeded pie chart colorsContent I have built a pie chart for Performance ratings for a Dashboard. The systems default to 3 colors - Yellow, Blue an…User_2025-02-10-08-27-16-805 20 views 2 comments 2 points Most recent by User_2025-02-10-08-27-16-805 Reporting and Analytics for HCM -
Trouble with Template Builder for WordSummary Can't get the template builder for Word to properly installContent Hi - I have been having issues getting the Template Builder for Word to install properly. I tr… -
BI Publisher password is cleared from Formatting section post upgradeSummary The passwords for my BI Publisher reportsContent Hello I have some password protected BI Publisher reports on a weekly schedule and have noticed that after an up…User_2025-01-28-08-42-56-900 27 views 7 comments 0 points Most recent by User_2025-01-28-08-42-56-900 Reporting and Analytics for HCM -
Performance goals report - which should iclude all stages of goal details (Approved,Saved,Sumitted)Summary Need to develop a BI report for the Goal Plan Goals which are in saved state and submitted state and approved state.Content When employee runs the report , the r…User_2025-01-30-17-37-30-647 80 views 5 comments 0 points Most recent by User_2025-02-07-19-03-14-525 Reporting and Analytics for HCM -
Need the logic to convert English to Chinese language in SQLSummary Need the logic to convert English to Chinese language in SQLContent Hi Team, I have a BI(SQL) report and some of the fields like 'Legal Entity, BU, some EIT fiel…User_2025-02-01-03-43-13-079 96 views 4 comments 0 points Most recent by User_2025-02-01-03-43-13-079 Reporting and Analytics for HCM -
Detailed report for pie charts does not work with dashboard promptsContent We are building a dashboard for Talent Profiles and have successfully built a chart that accurately pulls data from Talent Profiles. The chart works well with th…User_2025-02-10-08-27-16-805 36 views 2 comments 2 points Most recent by Anil Kola-Oracle Reporting and Analytics for HCM -
Table in Data Source: AuditViewDB where it contains the names and employee number of employees.Summary I'm currently using the Data Source: AuditViewDB for some audit purpose. I need the table from that data source that contains the names and employee number of em…Mark kristan De los Reyes 39 views 4 comments 1 point Most recent by Anil Kola-Oracle Reporting and Analytics for HCM -
BIP report to have attachmentSummary Attachments in BIPContent Hi Team, We are trying to download CV in Bulk from Oracle Recruiting Cloud. I was able to bring in the URL from UCM for the attachment …Varun Kumar Kota 68 views 3 comments 1 point Most recent by Hariharan Sekaran Reporting and Analytics for HCM -
Help with BIP Error ReportContent Hello, I'm working through an Error on the diagnostic logs from a Bursting BIP publisher report and it looks like it timed out at 5 minutes, but we have other re…User_2025-01-31-00-25-12-234 47 views 4 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM -
can we group the output using any templateSummary my report is displaying 300 rows but user needs to display the output in grouping ,example each 100 rows as one group ,is it possible to using templateContent Hi…User_VR8E0 20 views 1 comment 1 point Most recent by Pradeep Sharma-14802 Reporting and Analytics for HCM -
Convert UCM image into base64Content Hi, Can someone tell me how to convert UCM image to base64 in Fusion? or how do I call the UCM image into rtf template? Reference : Oracle Fusion BI Publisher: H…Nivya Mathire 236 views 4 comments 1 point Most recent by Anil Kola-Oracle Reporting and Analytics for HCM -
oracle.xdo.dataengine.datasource.plugin.DataAccessException: java.net.SocketTimeoutException: Read tContent Hi Experts, I have Anniversary BI Report using OTBI analysis. Which has following filter criteria CONCAT(CONCAT (CAST(MONTHNAME("Workforce Management - Person Re…User_2025-02-07-19-03-14-525 470 views 2 comments 0 points Most recent by User_2025-02-07-19-03-14-525 Reporting and Analytics for HCM -
Workforce Compensation Report -Acttion Required,Hierarchy Level,Manager statusContent In Workforce Compensation not able to find these columns Acttion Required,Hierarchy Level,Manager status Fields in OTBI (Compensation - Workforce Compensation Re…User_VR8E0 25 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
OTBI vs BIP filtering clarificationSummary HOw OTBI handles filtering verse BIPContent Hi, Seeking clarification/advice on the following scenario. We have an OTBI report that pulls in a person's work exte…Denise Izzi 30 views 12 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM