Global HR
Discussion List
-
How to report on proxies setupSummary: We have a requirement to report on the proxies information setup (Set Preferences > Proxies). Is there any seeded report or information on building custom repor… -
How to use an OTBI analysis to create a data model with a parameter (prompted?)Summary: I am trying to use an OTBI analysis to create a data model. My data model will be refrenced by Oracle Journeys so there is a requirement that I attach a specifi…Amy Wilson 793 views 7 comments 0 points Most recent by Stefan v. Glabbeek Reporting and Analytics for HCM -
Reporting Prior Month Data SQLSummary: Can we add SQL to the formula to look at the Prior Month data? So tell it to look at the System date - 1(for prior month) and pull 1st to last date of that prio…THawkins_LGI 41 views 12 comments 0 points Most recent by THawkins_LGI Reporting and Analytics for HCM -
What table is storing Change working hoursHi Team, Which table is storing change working hours information? Any sample will be helpful.
-
Unable to get the proper count for Assignment Count when I am using two subject AreasSummary: Hi Team, we have requirement to get the count for Nationality to get this column we are using 'Person Real time' Subject Area. and we also have to filter this c…Ashok Dhara 12 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
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. 12 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 43 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 51 views 6 comments 2 points 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 77 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 21 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 111 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 552 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 111 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 25 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 21 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 152 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 31 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM