OTBI
Discussion List
-
BIP Publisher Bursting:Can we burst a consolidated pdf file (having all employee records) to a singlSummary BIP Publisher Bursting:Can we burst a consolidated pdf file (having all employee records) to a single email idContent Hi, In BI Publisher bursting, we usually bu…User_MC37Q 106 views 6 comments 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Link BIP Report to InfoletSummary Can we Link BIP Report to InfoletContent Hi All, Can we Create BIpublisher Report and link to Infolet, and how we can give access to particular user these infole… -
Benefit Double DipSummary Can we tell if someone is double dipping benefit plans?Content Hi - we have been tasked to provide a report that identifies employees who are also dependents of …Prudence K 54 views 4 comments 0 points Most recent by Sarma Yeddanapudy-Oracle Reporting and Analytics for HCM -
Best Practice for reporting team to prepare for Oracle Monthly/Quarterly PatchesSummary Best Practice for reporting team to prepare for Oracle Monthly/Quarterly PatchesContent Hello! We are a team of OTBI and BI Publisher users, new to Oracle HCM. I… -
OBIEE 11.1.1.9.0 Archiving: Difference between 'Keep Timestamps' and 'Keep Permission'Summary OBIEE 11.1.1.9.0 Archiving: Difference between 'Keep Timestamps' and 'Keep Permission'Content Hi, I need to know the difference between 'Keep Timestamps' and 'Ke…User_MC37Q 62 views 2 comments 1 point Most recent by Volodymyr Faranosov Reporting and Analytics for HCM
-
Goal Status Overview Real Time is not reporting Review Period Name after 18C upgradeSummary Goal Status Overview Real Time is not reporting Review Period Name after 18C upgradeContent Hello, We are hitting an issue after last weekend 18C upgrade, while …Suresh Pallapothu 45 views 4 comments 0 points Most recent by Suresh Pallapothu Reporting and Analytics for HCM -
Export Embeded Dashboard to Excel in HCMContent All, Is there a way to export a dashboard that is embedded to page in HCM? The export option seems to be only available when the user is in OTBI...Charles Egegbara 53 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Sql query is not workinkgContent Hi, trying to excute the following sql via BI publisher per support document: Doc ID 2187087.1 Select * from per_assignment_supervisors_f sup, per_all_people_f p…Gal Shani 69 views 8 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM -
How to create a report to pick address fields which have invalid charactersSummary How to create a report to pick address fields which have invalid charactersContent Hi I am working on a requirement to create a report which would pick invalid c…User_2025-01-30-21-52-52-008 43 views 9 comments 0 points Most recent by Sricharan Monigari Reporting and Analytics for HCM -
Users unable to see some report results on an embedded dashboardSummary We have a report on a dashboard with formula and conditional formatting for staff to quickly review their time balances but this is not working correctly.Content…Lee_B 29 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Filter based on selected EmployeeSummary How to pass selected employee Person ID into a filterContent Hi I have a basic Analysis I'd like to place on the Absence self service page (old UI, not the new s…User_2025-01-25-01-23-28-110 52 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Max Coverage Date for Enrollment Results in OTBISummary Looking for the max coverage date by employee and benefit plan/optionContent Hello, I want to report the details of an employee's current enrollment (as of today…Susan Anderson 52 views 2 comments 0 points Most recent by Susan Anderson Reporting and Analytics for HCM -
Hide Catalog and New based on RoleContent Hi All, Is there a way to hide Catalog and New based on User Role? I have a requirement to share reports with other Oracle HCM cloud users, but i want to restric…User_2025-01-30-00-14-06-021 78 views 3 comments 1 point Most recent by User_2025-01-30-00-14-06-021 Reporting and Analytics for HCM
-
save a BI Publisher Output pdf or OTBI Output pdf in Documents of recordsSummary save a BI Publisher Output pdf or OTBI Output pdf in Documents of recordsContent Hello, It is a possible to save a BI Publisher Output pdf or OTBI Output pdf in …Giuseppe 1234 32 views 4 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Performance Management tables: Need to capture evaluations, performance documents, tasks, sectionsSummary Performance Management tables: Need to capture evaluations, performance documents, tasks, sectionsContent Hi, We need information about how to capture the evalua…User_MC37Q 357 views 3 comments 0 points Most recent by Vasanthakumar Ravi Reporting and Analytics for HCM
-
Last chance to tell us how you use OTBIContent https://oraclehcm.influitive.com/challenges/486 Please use the above link to provide us with feedback on OTBI to help us improve our product. The short questionn…Julian Challenger-Oracle 69 views 0 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI - Field to show max effective_start_date by action_codeSummary In OTBI workforce assignments I'd like to show the max effective_start_date of assignment based on action_codeContent Hi all, While working on "Workforce Managem…Pavel Kartuz 122 views 4 comments 0 points Most recent by Pavel Kartuz Reporting and Analytics for HCM
-
OTBI: Need to get details present in database table: HRQ_QSTNR_SECTIONS in Learning Subject areaSummary OTBI: Need to get details present in database table: HRQ_QSTNR_SECTIONS in Learning Subject areaContent Hi, We are creating a Dashboard for plotting the average …User_MC37Q 75 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
How-To Create Distribution Analysis in OTBI?Summary How-To Create Distribution Analysis in OTBI?Content Hi Experts, Do anyone of you have some documents illustrating how to create distribution analysis using OTBI …AshishERPCloud 38 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Need to build a report that show the results of the Payroll Calculation CardsSummary Need help in building a report that show the results of the Payroll Calculation CardsContent Does anyone have an example of a report that shows Payroll Time Entr…Stephen Robinson 144 views 1 comment 0 points Most recent by User_2025-02-04-07-01-46-164 Reporting and Analytics for HCM
-
"Workforce Goals - Goal Status Overview Real Time" issue:-Like and Contains Works , but not Equal toSummary "Workforce Goals - Goal Status Overview Real Time" issue:-Like and Contains Works , but not Equal to/InContent Hi, We are having a dashboard analysis where Goals…
-
Need database table name that stores the Performance Goals that are present in subject area ""WorkfoSummary Need database table name that stores the Performance Goals that are present in subject area ""Workforce Goals - Goal Status Overview Real Time" "Content Hi. Need…
-
ORA-01427; single-row subquery returns more than one row error on data modelSummary Receiving oracle.xdo.servlet.data.DataException: oracle.xdo.XDOException: java.sql.SQLException: ORA-01427: single-row subquery returns more than one row.Content…User_2025-01-31-02-45-52-854 207 views 3 comments 0 points Most recent by User_2025-01-31-02-45-52-854 Reporting and Analytics for HCM
-
Goals not connecting to worker from Goal Status OverviewSummary Some goals disappear when adding the worker dimension in reportingContent We have a case where some workers have created 5 goals in a specific goal plan but when… -
Personal Payment Methods Processing OrderContent HI All, In the Manage person payment method UI is having processing order as 1,2,3 and corresponding column in DB as “pay_person_pay_methods_f” and “priority”. T…Visu 288 views 11 comments 0 points Most recent by Sricharan Monigari Reporting and Analytics for HCM
-
Job Requisition Current Status FieldSummary Trying to locate this fieldContent Anyone know what subject area and folder the current job req status is stored? I'm having trouble locating it.User_2025-01-28-08-47-04-905 30 views 1 comment 0 points Most recent by User_2025-01-28-08-47-04-905 Reporting and Analytics for HCM
-
Latest Person Profile ContentSummary Max(Date From) not working with mutiple subject areasContent We need data from the subject area "Workforce Profiles - Person Profile Real Time" including Person …User_2025-01-30-04-37-05-780 68 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
New Hire Notifications to Manager, Payroll, HR Business Partner, EmployeeSummary Creating Individualized New Hire NotificationsContent Hello, We are currently transitioning to HCM Fusion and we need a New Hire alert that sends out to their Ma…User_2025-01-31-00-25-12-234 143 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Identifying if an assignment change was done with a future, retro or current dateSummary Having trouble finding a way to identify if an assignment change was done with a future date or retro date after the fact.Content Hello, My team is in the proces…Mak-Moose 182 views 4 comments 0 points Most recent by User_2025-01-29-21-12-23-173 Reporting and Analytics for HCM
-
Filter on "Primary Assignment Flag" is dropping few recordsSummary Weird issue specific to few recordsContent Hi, We are facing a weird issue and hoping to get expert guidance. We have an employee as of date report using 2 subje…Suresh Pallapothu 36 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM