Global HR
Discussion List
-
Possibility to Create Dynamically Different Tabs of The Same Report by Passing Diff. Param’s ValueSummary: OTBI Dashboard > Possibility to Create Dynamically Different Tabs of The Same Report by Passing Different Parameter’s Value Content (please ensure you mask any …Bernard T 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Calculated Field in OTBI PromptSummary: Wish to have Calculated field in OTBI prompt. I want to have 3 prompts based on the given table data below: Assignment Last Update Date Grade Change Flag Grade …Pradnya_Pampatwar 31 views 8 comments 0 points Most recent by Pradnya_Pampatwar Reporting and Analytics for HCM -
Can you secure objects in Subject Areas?Summary: Can you restrict certain objects contained within a Subject Area? Content (please ensure you mask any confidential information): Hi Community, I have a requirem…Matthew Hancock 41 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Help reporting on Veteran, Disability, and DiversitySummary Looking for a way to report on Veteran, Disability, and Diversity dataContent Hello All, I would like to create a report in Fusion to include veteran, disability…User_2025-01-22-19-24-11-575 369 views 4 comments 0 points Most recent by Shant_Sarkissian_WJG Reporting and Analytics for HCM -
case statement was producing only 3 records instead of 6 records in FINAL_PATH ColumnHi All, need help on below case. i am concatenating the different structure of Reports Url's (BIP,OTBI,DASHBOARD) with POD url along with report path. Here FLV.DESCRIPTI…Ravindr-Oracle 11 views 4 comments 0 points Most recent by Ravindr-Oracle Reporting and Analytics for HCM -
How to increase the length of the Description column more than 1000 pixels in lookup tablesHello All, Currently, I am facing issue with Description column in lookup tables. i wanted to store the Bip report path in Description column but it is truncating some p…Ravindr-Oracle 23 views 2 comments 0 points Most recent by Ravindr-Oracle Reporting and Analytics for HCM -
HCM Extract Parameter LOV is visible to some users while null for othersSummary: In an Extract the LOV in a Parameter is visible to some users while it is null/blank for other users. The parameter is made out of a Value Set. There are no sec… -
How do we control Grant/Restrict access to OTBI > Jobs > Report Job HistorySummary: Hello All, We Would like to understand how can can we grant or restrict access to "OTBI > Jobs > Report Job History". Do we have a role or Privilege with contro…tawfeeq.k 61 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
How to Automate BACS file to be placed in UCM server?Summary: We have a requirement where BACS File generated using "Make EFT payments process" should be automatically sent to UCM(Oracle WebCenter Content). If anyone has f… -
How to fetch Level 1 department for a person via SQL codeWhats the sql code behind level 1 department in Worker assignment real time subject area? -
How can I optimize/simplify my KPI formula in order to reduce the time of the report to load?Summary: It takes 13mins to load my report using the formula since I have to add 2 values on my KPI formula before getting the percentage. Is there a way to optimize my …John Patrick Diaz 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Restrict/Hide "CORRECT" option in Person Assignment screenSummary: Looking for an option to restrict or hide the "CORRECT" Option available in the Person Assignment screen thereby not allowing business users to modify any perso… -
Report for Changes OnlySummary: We are currently not able to pull out a report with the last change done for a person in the system. Content (required): We have multiple reports in Oracle base… -
Time and Labor -- Calculated time card entries for a date range or pay periodSummary Calculated time card entries for a date range or pay periodContent Hi Friends I have been working on a report for Calculated Time Card Entries and so far i have … -
Person Real Time Subject Area and Future Hire DateSummary: I have a simple report/analysis using the subject area Workforce Management - Person Real Time. This report is used to extract 2 custom Extra Information fields… -
Report Usage Metrics OTBIContent Does anyone know how I can pull usage metrics of reports run by users in OTBI. I've searched for some time on this online, both here and Google. I see there was …User_2025-02-01-05-53-06-489 124 views 7 comments 0 points Most recent by erpexpert03 Reporting and Analytics for HCM -
Is it feasible to Print an Entire Dashboard (with multiple pages)?Summary: Is it feasible to Print an Entire Dashboard (with multiple pages)? Content (please ensure you mask any confidential information): I would like to print an Entir…Harish Malik 33 views 4 comments 0 points Most recent by Harish Malik Reporting and Analytics for HCM -
Measuring the Completeness of Onboarding Task by EmployeeSummary: Measuring the Completeness of Onboarding Task by Employee Content (please ensure you mask any confidential information): In the Onboarding report use the Checkl…Thulasi Ram 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
AccidentAccidentally created....Justin Hittell-14055 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Returning information from the middle of the valueSummary: Hi our work location fields are in the format "UK-[city]-[street address]", but when I run an analysis I only want to return the city name. Is this possible? Is… -
Create an OTBI Analysis with information about all transactionsSummary: Hi all, I'm trying to extract information from the transactions subject area "Human Capital Management - Transaction Administration Real Time". The customer wou…teresa.marciano 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Standard report to track dashboard and reports accessesHi, is there a standard report that is useful to track users accesses in Dashboard HR and also the detail on which reports in this dashboard they access? We configured t…Mara Tammaro 11 views 2 comments 0 points Most recent by Mara Tammaro Reporting and Analytics for HCM -
Table to extract BPM Approval Groups InformationHi, I cannot see any data when querying the tables below. Could it be due to the role? What could be the reason? I think it should be recorded in these tables. fa_fusion…Cansel Karasoy 24 views 4 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
ESS Job Report with link between parent and child requestsSummary: ESS Job Report with link between parent and child requests Content (please ensure you mask any confidential information): Hi Team, We use the different reports …Parag Hiremath 555 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Supervisor Hierarchy (Top/Down) Managed departmentsSummary: Supervisor Hierarchy (Top/Down) spanning multiple departments Content (required): We are trying to develop an OTBI report displaying reportees spanning multiple…Manoj.Gupta 75 views 3 comments 6 points Most recent by Gloria Brewster Reporting and Analytics for HCM -
OTBI - change field from text to numberSummary Changing text format fields, which include number values, to number formatContent Hi :) I have a report which shows information on Element Entries. The input val… -
Grade Step DetailsContent Good Day, Within Report creation in OTBI we are trying to report on all Grade Step Levels from Grade to Step to Ceiling etc. But we are unable to find the "code"…User_2025-01-28-07-12-45-467 130 views 8 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Grade Step in OTBISummary Workforce Management - Worker Assignment Real Time does not display current gradeContent Hi, Does anyone know which subject area would give me Grate step values …User_2025-01-31-00-03-33-089 301 views 25 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Unable to get results when pulling Grade data in with Job Structure dataSummary Report fails when fields from Grade Rate Real Time are pulled inContent Using two subject areas: Workforce Profiles - Model Profile Real Time and Workforce Manag…User_2025-01-28-20-43-56-568 37 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Joining Grade/Grate Rate with Job and PositionSummary Joining Grade/Grate Rate with Job and PositionContent I am looking to report Midpoints for Jobs and Positions. Is there a way to join "Grade Rate Real Time" Subj…Andrew_Schmitz 95 views 8 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM