Global HR
Discussion List
-
Problem when filtring on OTBI to take MAX(date) for many userSummary I want to filter for max(date) for many users , It works only for one user .Content Hello, I create a report to display person id with a item_text,but for each i…User_I6AXL 98 views 7 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Term with RehireSummary When adding additional subject area, termination category is blank.Content I have a termination report with the Worker Assignment subject area, worked great. How…User_2025-01-29-01-42-29-093 58 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Ability to report on historic versions of the Org Tree using OTBISummary Ability to report on historic versions of the Org Tree using OTBIContent Hello Team, Does OTBI has the ability to report on historic version of Org tree? I tried…Suveer Tn 83 views 3 comments 0 points Most recent by AshishERPCloud 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 94 views 4 comments 0 points Most recent by Achala Munasinghe 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
-
Job Competency ReportContent Morning all, I'm looking to build a basic report that shows the competencies we have built against each job profile, but I'm struggling to find what subject area…User_2025-01-28-05-39-23-766 57 views 2 comments 0 points Most recent by User_2025-01-28-05-39-23-766 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 511 views 6 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
"All" value in Graph PromptContent I've built a basic Performance Document summary (see attached) It uses a Column Selector for Division / Department / Business Unit / Location, and I've also adde…User_2025-01-28-05-39-23-766 81 views 2 comments 0 points Most recent by User_2025-01-28-05-39-23-766 Reporting and Analytics for HCM
-
Employee's Management Level in the OrganisationSummary Employee's Management Level in the OrganisationContent Hello, Can anyone please help me? I am trying to build a report in OTBI which gives the list of employees …SantoshKumarBhairi 65 views 2 comments 0 points Most recent by SantoshKumarBhairi 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 -
Report to capture complete reporting lineSummary Supervisor hierarchy ReportContent Hi everyone - Has anyone here had a requirement to pull out the complete reporting line of one manager? We are trying to creat…Roy Paolo Paunlagui 87 views 2 comments 1 point Most recent by Roy Paolo Paunlagui Reporting and Analytics for HCM
-
Rel12 PB8: OTBI HCM Prompts subject areaSummary A new subject area has been added to the list of HCM OTBI subject areas. The purpose of this subject area is to setup dashboard prompts and use them in the dashb…Raghavendra Raghunath-Oracle 164 views 1 comment 6 points Most recent by AbulKhair Reporting and Analytics for HCM -
GUID codes in OTBISummary Can i obtain specific GUID codes from OTBI?Content Hi, Can I use OTBI to extract the GUID codes for specific data fields? For example, I would like the GUID for …User_2025-01-28-05-39-23-766 66 views 7 comments 0 points Most recent by User_2025-01-28-05-39-23-766 Reporting and Analytics for HCM
-
R12 Upgrade: OTBI Reports are not runningContent Since the R12 upgrade when trying to run any OTBI Report by clicking on Apply or OK, nothing happens in the page, and the report does not generate. Open the repo…Rebecca Smith-27468 60 views 8 comments 0 points Most recent by User_2025-01-28-05-39-23-766 Reporting and Analytics for HCM
-
Unable to see Infolets I've CreatedSummary No Infolets visibleContent I have created several Infolets in Business Intelligence - but none of them show up on the Infolet Repository - only Competitions show…User_2025-01-29-19-59-40-005 151 views 6 comments 0 points Most recent by User_2025-01-29-19-59-40-005 Reporting and Analytics for HCM