Global HR
Discussion List
-
Generate Employment Letter after approvalSummary: Employment letter can be generated using BI Reports but client wants certain letters to generated once manager/hr approves Content (required): Is it possible to…VivekHCM 45 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
LSQL with Prompts inputs not workingSummary: I've got a combined subject area LSQL which looks at 3 possible input prompt which can be blank or filled with values by end users. I'm passing the prompt input…Rohan Fernandes 24 views 2 comments 0 points Most recent by Rohan Fernandes Reporting and Analytics for HCM
-
Reporting on real trends in headcount by hierarchy excluding impacts of reorganisationsSummary: We need to provide headcount trend data to our business leaders and managers for their respective organisation without the impact of reorganisations being visib…User_2025-03-07-20-15-16-297 33 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI Turnover Dashboard for Line ManagersSummary: I would like to provide a Turnover Dashboard for Line Managers in OTBI but the seeded / sample dashboards provided by Oracle are not returning data when logging…User_2025-03-07-20-15-16-297 131 views 13 comments 0 points Most recent by User_2025-03-07-20-15-16-297 Reporting and Analytics for HCM
-
How to get data in 2 fields for Payroll Relationship -> 'Time Card Required' ?Summary: There are two fields for 'Time Card Required' on the Payroll Relationship responsive page. One is at the Payroll Association level and other at Payroll Assignme…Vinay Hardas 135 views 4 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM
-
Using Variables in Etext templateSummary: Hi Team, I was reviewing a oracle guide for etext template. For one of my requirement I am trying to use Variables in etext template. GetVar(var-name) ResetVar(…Mohan Murali 1.7K views 6 comments 0 points Most recent by Mohan Murali Reporting and Analytics for HCM
-
Turnover Analysis - Line Manager DashboardsSummary Count fields - Termination Headcount, Voluntary Termination Headcount under Subject Area "Workforce Trends" are not reflecting correctContent Hello, We are looki…User_2025-02-05-07-43-29-505 138 views 9 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Fiscal Year HR ReportingSummary Needing to have reports such as a Turnover Report that is based on Fiscal Year vs Calendar YearContent Does anyone have any experience or examples on how i could…Rob Stahly 92 views 8 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Is there any way to identify which roles have security profiles?Summary: Is there any way to identify which roles have a View All Document Types and View All People person security profile, and who these are assigned to? Content (req…Abhimanyu Kumar27 52 views 3 comments 0 points Most recent by Rachel Martorelli-Oracle Reporting and Analytics for HCM
-
Aligning a physical or alternate location to virtual employees (mostly for communications)Summary: Now that a larger number of employees have switched to virtual work at home or hybrid, requirements mostly centered around communications have arisen concerning…Shawn Gertler 23 views 1 comment 0 points Most recent by Julian Challenger-Oracle Human Capital Management
-
Gender Pay Gap ReportSummary Has a Gender Pay Gap report been release for HCMContent I am trying to find the equivalent Gender Pay gap report that existing in EBS. Is there one? If not what …User_2025-01-23-23-03-09-078 179 views 15 comments 4 points Most recent by TarunAggarwal Reporting and Analytics for HCM
-
Login In, Login Out and Login Duration of a user in an OTBI analysis.Summary Login In, Login Out and Login Duration of a user in an OTBI analysis.Content Hi, We need to find a subject area that gives the login time of the user into fusion…User_MC37Q 304 views 3 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Bursting - Multiple Templates - Multiple DestinationsSummary: Bursting Query for sending email notifications to an employee and line manager, each with their own template. Content (required): Hello, We have a requirement w…
-
Getting the Period Start Active Headcount to equal the previous months Period End Active HeadcountSummary: Getting the Period Start Active Headcount to equal the previous months Period End Active Headcount Content (required): We need to get the Period Start Active He…Rebekah Gilday 65 views 6 comments 0 points Most recent by Rebekah Gilday Reporting and Analytics for HCM -
Seeded HR Reports not returning any resultsSummary: Hi , We actually have to run all the seeded HR reports and present the output to the client . Now I got the list of the seeded reports but when I am trying to r…Gaurav Rath- PGC 42 views 13 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Sql query for employment term numberSummary Does someone have a query for the employment term number?Content Hi, I'm really need an sql query for that shows the person number, person f.name, person l.name,…
-
How to get Department of Level1 , level2 and level 3 position in position HierarchySummary: We have a requirement to fetch following fields in OTBI, Person Number Assignment Number Position Name Level1 Org: Populate department of the position One level…Raghavendra M 538 views 10 comments 1 point Most recent by Raghavendra M Reporting and Analytics for HCM -
How to CAST Char to DateSummary CAST Presentation Variable of Text to Date Prompt in FormulaContent Age Band on Line Manager Dashboard is based on CURRENT_DATE rather it should based on Dashboa…User_UM4C6 52 views 4 comments 0 points Most recent by Aslam Khuajah Reporting and Analytics for HCM
-
State: HY000. Code: 27047. [nQSError: 27047] Nonexistent table: "SET". (HY000)Summary: I am trying to create 2 reports: 1) Workforce Management - Worker Assignment Event Real Time:- Picking all person numbers with action names and effective date b…
-
Defined Flex Field (DFF) & Person Count and Head CountContent We have created a defined flex field (DFF) for gender as we use different values from the default HCM gender field. The DFF has been placed into Workforce Manage…User_2025-02-04-10-47-55-876 68 views 3 comments 1 point Most recent by Harry Oracle Reporting and Analytics for HCM
-
Query to fetch existing and proposed information of pending transaction in oracle hcmSummary: We have a requirement to develop a BIP report to display the existing and proposed information of pending transaction like Promotion. Content (required): Need t…Meenakshi K 530 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Max Effective Date Record on a Combined Subject Area ReportSummary: I need to be able to report on most recent employee addresses (HOME and MAIL) based on their maximum effective date from the Person Real Time Subject Area in an…Rohan Fernandes 15 views 4 comments 0 points Most recent by Rohan Fernandes Reporting and Analytics for HCM
-
Agents sending out from test instanceSummary: We just received our 22A and received our first refreshes since. We applied the administrative settings to override the email and set notifications to none but …Shanna Oppenheim 23 views 6 comments 0 points Most recent by Gaurav F Reporting and Analytics for HCM -
Does anyone have a report for Checklist Real Time and Transaction Administration Real Time?Summary: I am looking for a report/trying to build one for Checklist Real Time and Transaction Administration Real Time to try to report on when a Checklist has been rea…prjohnson 43 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
How to fetch the translated value from an Independent Value set in Oracle Fast FormulaSummary: How to fetch the translated value from an Independent Value set in Oracle Fast Formula Content (required): How to fetch the translated value from an Independent…Meenakshi K 66 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Business Title Not Pulling CorrectlyContent We are currently migrating to use the delivered business title field, but I'm having some difficulty pulling it into an OTBI report. If I don't add any employee …User_2025-01-31-00-25-12-234 28 views 3 comments 0 points Most recent by Gabriele Falso-Oracle Reporting and Analytics for HCM
-
What filter can I use to only list the Last Assignment details for employees and not duplicate rows.Summary: Hello Community - I need assistance listing employees "Last Assignment" or "Latest Assignment" details. If someone was Rehired, or Terminated more than 1 time, …User_2025-03-07-05-24-33-733 31 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
How to split in two different columns an information through OTBISummary: Need to create an additional column for "Email type" Content (required): Need to have two different column for work email + personal email and not different row…Virginia M. Calvi 159 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Performance Tile counting assignments based on the sum of a flex field by assignment.Summary: Since upgrading to 22A we're having trouble with a performance tile used to count assignments based on the sum of a flex field we've designed and I'm looking fo…Rob F 22 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Workforce Trend Real time subject are not giving the dataSummary: I am using workforce trend real time subject are and it is not giving the correct data when we migrate it to another instance. Content (required): We have migra…Raghavendra M 21 views 9 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM