Global HR
Discussion List
-
Termination category field causes blank rows for OTBISummary: Termination category field causes blank rows for OTBI Content (please ensure you mask any confidential information): Hello experts, we are building a custom OTB…Oriana L. 13 views 1 comment 0 points Most recent by Mihnea Savu-Oracle Reporting and Analytics for HCM -
'Signer Address' column in Checklist Real Time Subject AreaSummary 'Signer Address' column in Checklist Real Time Subject AreaContent We are trying to leverage Checklist Real Time subject area to develop reports on the onboardin…User_2025-03-07-21-34-36-848 47 views 5 comments 1 point Most recent by Marcy Hart Reporting and Analytics for HCM -
Subject area/database table for historical manager hierarchySubject area/database table for historical manager hierarchy Client is interested in building dashboards to show different HR metrics for which historical manager hierar…
-
Any reports or Dashboards available for Fusion Applications Performance monitoring?Summary: How to Monitor Fusion applications performance? We are using FAs in more than 30 countries and there are many processes/ integrations/ reports scheduled to run …MandeepGupta 54 views 6 comments 1 point Most recent by Bala Mahalingam-Oracle Reporting and Analytics for HCM -
OTBI Subject AreaSummary Grade Progression Subject AreaContent Hi, Is it possible to extract Progression Grade Ladder, Grade and Grade step, rates values with an OTBI report? If yes, whi…Catherine Varvaressos 80 views 10 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Journey report - display 'Saved as Draft' status in the reportHello, Related to Journey, I want to create a report that shows the task's progress status for each performer. In case of the performer saves the task as "Saved as Draft…Liran 23 views 1 comment 0 points Most recent by BogdanFarcasanu-Oracle Reporting and Analytics for HCM
-
Days of service calculationHi Team, I am using "Workforce Managemnet - Work Relationship Real Time" subject area and I want to calculate "Days Of Service" only for Terminated employees. I want to …Raghu_Nandan 22 views 1 comment 0 points Most recent by BogdanFarcasanu-Oracle Reporting and Analytics for HCM
-
How to Disable/Remove/Hide Inline Attachments in Attachments Category in HR Help DeskSummary: Hello All, We are trying to Disable/Remove/Hide the Inline Attachments in Attachments Category in HR Help Desk SR Request Page. We have checked below Profile Op…
-
Seniority date blank on front end but populated in PER_SENIORITY_DATES_F TableSummary: For many employees Seniority date is blank on front end but populated in PER_SENIORITY_DATES_F Table. I noticed TOTAL_ADJUSTMENT_DAYS is Negative and if I add i…Seema Kalantri 22 views 3 comments 0 points Most recent by Seema Kalantri Reporting and Analytics for HCM
-
How to get the Name equivalents of RECRUITING_LOC_HIERARCHY_ID and RECRUITING_ORG_HIERARCHY_ID?I'm trying to get the Recruiting Type, Recruiting Location Hierarchy and Recruiting Organization Hierarchy from the Areas of Responsibility - Scope section, but I only h…
-
Worker Termination Alert fetching all termination dates (Older ones also)Summary: Hello Everyone, We have developed an alert using alert composer for triggering notifications when termination transaction occurs. But the issue is, we are getti…Dinesh Bodagala 113 views 6 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Person Identifiers for External ApplicationsSummary: For some employees we have updated payroll id under Person Identifiers for External Applications in person management. Content (required): If I need to take tha…Ayesha Iroshani 537 views 10 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Manage Document Security ProfileSummary: We can View the Document Type Security Profiles however we would like to have a report or query to know which document type is associated to which profile. Or j…HeatherD 12 views 2 comments 0 points Most recent by Naveen Jayaraman Reporting and Analytics for HCM -
Get current and future termination EE records in OTBIHi, We are trying to build a demographic file that should pull the data of EEs as of system date and also future terminations in next 7 days. I have tried using the pref…
-
Report of everyone who reported to a terminated managerUsing OTBI, how can I pull a historical listing of all employees who had a specific manager in their management matrix over a specified date range?Mark Petereit 21 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Minimum wages configurationSummary: We have business requirement to show the minimum wage in the salary page (Employee). Apart from grade range, it should show minimum wage for the state, specific…
-
Does anyone know how to pull this address (Manage Locations) in OTBI?Summary: How to pull address (Manage Locations) in OTBI? Content (please ensure you mask any confidential information): Version (include the version you are using, if ap…
-
Rehire recommendation details are inconsistent in OTBI reportSummary: Need help with fetching data for Rehire Recommendation for terminated employees Content (please ensure you mask any confidential information): Hi, We have an OT…Sai.V 115 views 22 comments 0 points Most recent by Rahul.Yarlagadda-Oracle Reporting and Analytics for HCM
-
Need a sample SQL for HDL Summary ReportSummary: I'm trying to create a HDL summary report, where I wanted to fetch the Submission Time, Finish Time and Elapsed Time which I'm unable to find the exact table. P…Sujeeth Chinta 23 views 4 comments 0 points Most recent by Sujeeth Chinta Reporting and Analytics for HCM -
OTBI parameter issueSummary: Hi Experts, I need some assistance. I'm working on the Talent Profile Report and wanted to capture all the details in one report. I picked up multiple values by…
-
Retrieve Person addressesSummary: Do we have any package function to retrieve the person addresses? Please share. Content (please ensure you mask any confidential information): Version (include …MilanMohanty 24 views 1 comment 0 points Most recent by David --Oracle Reporting and Analytics for HCM -
OTBI: How can we run a report with the previous month start and end dateSummary: How can we programmatically run an OTBI analysis report with the previous month start and end date? Content (please ensure you mask any confidential information…SUSAN SANDIFER 150 views 6 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Recruiting OTBI Performance issueSummary: Hi Expert, I need your assistance. I'm trying to combine two subject areas 'Recruiting - Recruiting Real Time' and 'Recruiting - Recruiting Event Real Time' and…
-
Overtime period field on payroll relationshipSummary: What table(s) can I find the Overtime Period field on the payroll relationship. I am being pointed to HWM_RP_TM_PERIODS_TL but this table does not seem to have …
-
I need a query to get the attached images from HR document record and print it in RTF templateSummary: I need a query to get the attached images from HR document record and print it in RTF template Content (please ensure you mask any confidential information): Ve…Farah Alajou 32 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
In OTBI, how to set the filters to fetch data between the last 5 years to the current year?I'd like to create an analysis to fetch employees hired from the last 5 years up to this year based on "Worker"."Enterprise Hire Date". How to set the filters within the…Welsey 76 views 5 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Table name/Report for Structure (Navigation Configuration)Summary : We require a report or table name that contains the configuration for the 'Navigation Structure.' This information will be necessary to ensure consistency in t…Bhupesh 22 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Do we have usage reports for Document of Records categoriesSummary: Are there any reports that summarises number of documents loaded against document categories. Content (please ensure you mask any confidential information): Ver…Chandan Patel 31 views 1 comment 0 points Most recent by Mihnea Savu-Oracle Reporting and Analytics for HCM -
Position Costing with Incumbent ReportSummary: Does anyone have a report that includes both Position costing, with position number, and the position incumbent. We don't have the skills on the team to build a…Jenna Savage 135 views 9 comments 0 points Most recent by Jenna Savage Reporting and Analytics for HCM -
SQL query to fetch all postal codes and their corresposding county, city and state in US legislationHi All, I need an sql query to fetch all the postal codes and their corresposding county, city and state in US legislation. Please help Thanks. SowmyaSowmyaSk18 125 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM