Reports
Discussion List
-
OTBI - Dividing two numbers results ZeroContent Hi, We have a requirement to find the percentage of headcounts. In OTBI dividing two values results Zero. For Example 50/100 results 0 but whereas 100/50 results…Surendar Babu S D 43 views 8 comments 2 points Most recent by Surendar Babu S D Reporting and Analytics for HCM -
Run Gross-to-Net ReportContent Hi All, I got the below error while running the Gross-to-Net Report. After taking so much time I got this error, Please suggest if anyone faced this issue. Navig…Visu 114 views 1 comment 0 points Most recent by User_2025-01-24-00-46-32-216 Reporting and Analytics for HCM
-
degrees informations of profiles in tables fusion ?Summary I want to create a report using information of degrees of profiles in bi publisherContent Hello, Someone know please where can I found the information of degrees…User_I6AXL 68 views 2 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Dependent parameters on custom reportSummary Dependent parameters on custom reportContent Hi, I need to create custom report using BI Answer, with few parameters. Can we add dependent parameter, Like if we …User_2025-01-27-23-25-57-688 77 views 3 comments 0 points Most recent by David Kim-19310 Reporting and Analytics for HCM -
OTBI - Report to see transactions approved which were initiated by Line Manager in MSSSummary OTBI - Report to see transactions approved which were initiated by Line Manager in MSSContent HR need to have visibility of when the following transactions have …Ruzwan Akram 117 views 6 comments 0 points Most recent by User_2025-01-28-07-47-26-775 Reporting and Analytics for HCM
-
R11 HCM OTBI Subject Area Mapping to Fusion HCM Database TablesSummary Release 11 HCM OTBI subject area database table mapping spreadsheetContent This spreadsheet is published by Oracle OTBI Development. This spreadsheet documents F…User720640-Oracle 476 views 8 comments 10 points Most recent by User720640-Oracle Reporting and Analytics for HCM -
BI Security - Secured view - real sqlContent Hello, I want to know if there is a way to get the real sql behind the secured view? For example: CMP_SALARY_SECURED_LIST_V or PER_PERSON_SECURED_LIST_V or PER_A…User_2025-01-25-01-33-46-269 167 views 15 comments 0 points Most recent by User_2025-01-25-01-33-46-269 Reporting and Analytics for HCM
-
Report on Development Plan from Performance FormsSummary I'm trying to report on the development plan section of the performance forms. Or removed extra rows from a report exported to excel.Content Has anyone attempted…User_2025-01-25-00-37-41-739 53 views 1 comment 0 points Most recent by Radhika Thiagarajan Reporting and Analytics for HCM
-
Manage Benefit Eligibility Profile - Hierarchy IssueSummary Change in configuration - New changes do not appear in the reports. Still reports the old configuration.Content I am doing an audit and corrections for Program /…
-
Where can I find Hire Reason in HCM OTBI/BI Answers?Summary Looking for subject area and field name for Hire ReasonContent I am working on an HCM OTBI/BI Answers analysis and would like to report Hire Reason. Can you tell…User_2025-01-28-17-24-53-863 51 views 6 comments 1 point Most recent by User_2025-01-28-17-24-53-863 Reporting and Analytics for HCM
-
Need to get Manager Name dynamically in OTBI reportSummary Need to get Manager Name dynamically in OTBI reportContent HI All, We have a requirement need to develop a OTBI report based on the Manager i.e. if manager login…Visu 152 views 3 comments 0 points Most recent by User_2025-01-25-02-26-52-398 Reporting and Analytics for HCM
-
Issue with Equations using varying other Analysis Look-upsContent Hello, I am just wondering if anyone else has had this same issue when looking up results from any other analytics? so the query is such, I have a selection of 6…User_2025-01-28-07-12-45-467 18 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to get rid of unwanted HTML tags from displaying in my analyses Export ?Summary How to get rid of unwanted HTML tags from displaying in my analyses Export ?Content Hi we have created a Dashboard using Goals Status real time Sbject area which…Arun Sharma 116 views 8 comments 2 points Most recent by User_2025-01-28-18-45-54-074 Reporting and Analytics for HCM
-
Assignment Point-in-Time ReportContent I'm looking to be able to run a report that will pull assignment data as a specific point in time. Does anyone have a catalog they can share with me?User_2025-01-22-19-19-56-324 104 views 6 comments 0 points Most recent by User_2025-01-23-21-28-55-898 Reporting and Analytics for HCM
-
Help needed - report on employees - start date when employment made permanentSummary How to create a report where I get data on dates when employees employment changed to permanentContent Hi, I need a report from employees whose employment change…User_2025-01-28-07-55-21-868 60 views 5 comments 1 point Most recent by User_2025-01-28-19-49-15-062 Reporting and Analytics for HCM
-
eTEXT BIP BurstingContent Hi All, I developed SQL Query and eText template as per the requirement. Now I am trying to send eText output to mail through Bursting. When I submit the report …
-
Add BIP reports to flow patternContent Hi All, We developed multiple reports as per our requirements. Here we need to run few reports in a custom flow from Navigator-->payroll-->checklists so I though…
-
Oracle seeded Total Turnover Report available?Content We have delivered a custom report to show the Total Turnover for a business. This can be filtered by a number of options - ie. Date Range, Business Unit, Region,…Rebecca Smith-27468 186 views 4 comments 1 point Most recent by Rebecca Smith-27468 Reporting and Analytics for HCM
-
Bursting BIP QueryContent Hi All, We build BIP report with Bursting as per our requirement. The query which we build on the Performance Management module. If we run the report with Perfor…
-
Filtering Between Two "TimeStampDiff" DatesContent Good Day, I was wondering if anyone has had a similar query and has also found a solution. The query is i want to search between Two Dates and for then for it to…User_2025-01-28-07-12-45-467 91 views 5 comments 0 points Most recent by User_2025-01-28-18-08-05-947 Reporting and Analytics for HCM
-
Detailed data with fields for Reports from BI apps and OTBI vs datasets obtained via catalog managerSummary Detailed reports data with fields from BI apps and OTBI similar to the one obtained via catalog manager in OBIEEContent I am looking for information on detailed …spattisa-Oracle 59 views 0 comments 3 points Most recent by spattisa-Oracle Reporting and Analytics for HCM
-
Salary Change AuditSummary Is there a way to run a report to find out who entered a salary change in Manager Salary and when?Content Is there a way to run a report to find out who entered …Gala Meyerovich 227 views 4 comments 0 points Most recent by Gala Meyerovich Reporting and Analytics for HCM -
Data Model Report in FusionContent Hi, How to create Promotion data model report based on promotion employees regards, nivaethaUser_2025-01-28-00-11-59-141 79 views 3 comments 0 points Most recent by Dr Surlina Yin-Oracle Reporting and Analytics for HCM
-
Is Performance Goal Action Taken available for reporting in OTBI / BI Answers?Summary Need to report Goal Action Taken in BI AnswersContent In the subject area Workforce Goals - Goal Status Overview Real TIme, is Action Taken available for reporti…User_2025-01-28-17-24-53-863 42 views 2 comments 1 point Most recent by User_2025-01-28-17-24-53-863 Reporting and Analytics for HCM
-
Report doubling my values.Summary I have a report which should count every employee as 1, but for some reason counts them as 2.Content Hi, I have a traffic light report which counts employees who…User_2025-01-25-04-51-10-553 31 views 3 comments 0 points Most recent by User_2025-01-25-04-48-26-816 Reporting and Analytics for HCM
-
Remove expired dates from an end date report.Summary End dates of before the current date are appearing on my report.Content Hi, I have produced a report on end dates, such as fixed term and probation end dates. Th…User_2025-01-25-04-51-10-553 45 views 4 comments 0 points Most recent by User_2025-01-25-04-51-10-553 Reporting and Analytics for HCM
-
Line Manager ReportingSummary Cascading reports across the organisation but security set to direct reportsContent Hey We're using R10 and have a vast number of OTBI and BI Publisher reports i…User_2025-01-24-00-44-10-997 158 views 12 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Changes in Hours / Grade / Salary / Organisation / Business Units etcContent Hello, We are looking for a way to create an analytical report or maybe even a dashboard that can show when "Historically" an employee has changed one of these f…User_2025-01-28-07-12-45-467 132 views 3 comments 2 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Reporting on Working Pattern/ Work Schedules aswell as current assignment information in a single reSummary Possiblity of generating a report Including Working patterns/Work and Assignment information within an Analysis/ReportContent Hello, We are currently struggling …Brad Hughes 104 views 4 comments 0 points Most recent by Brad Hughes Reporting and Analytics for HCM -
Manager Name using OTBI Report for a Termination Person using the Workforce Management Worker AssignContent Is is possible to get the manager name for the terminated person using the Workforce Management-Worker Assignment Event Real Time Subject Area. Currently the rep…User_2025-01-25-03-18-49-935 46 views 6 comments 0 points Most recent by Caroline Gladwin-Oracle Reporting and Analytics for HCM