Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for HCM
Discussion List
-
Fields in ESS e.g. NI Number, Nationality, DOB, GenderSummary Fields in ESS e.g. NI Number, Nationality, DOB, GenderContent When I navigate to About Me -> Personal Information -> Biographical Information I see the fields in… -
Analysis Report to get the salary in USD from local currencySummary Salary detain in USD from local currencyContent Hi All, I am trying to create one analysis report in which I need all the salary record in local currency i.e sal… -
Report to Include Employees Who Have Gone from one Employee Type to anotherContent I need to create a report that shows me all employees who have moved from person type = Employee to person type = Manager (in Assignment Details). How do I compa…User_2025-01-25-03-28-26-914 36 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle -
Print EE photo, ID badge?Summary Has anyone used the loaded EE photo to auto-generate employee ID badges for printing?Content Has anyone used the imported/loaded employee photo to generate and p…
-
Field is not pulling out the data for a particular roleSummary Field is not pulling out the data for a particular roleContent Hi Experts, In the front-end the field Phone contains data. We have created the report with the fi…
-
How to add a custom column in OTBI?Content Hi, I just want to know how to add a custom column while creating an analysis? e.g I have 2 cloumns A & B, and I want to add a new custom coloumn C, which displa… -
In search of a basic termination reoprtSummary I am looking to create a standard termination report for the HR teamContent Our company is new to Oracle and we were not provided what I'd consider a basic termi…
-
Report automatically sorting Month column in ABC orderSummary I want the 'Month' column to reflect appropriate order (Jan-Dec)Content I have a report created that pulls # of monthly transactions. I pulled in the "Month" fie…User_2025-01-28-20-43-56-568 49 views 4 comments 0 points Most recent by Raghavendra Raghunath-Oracle
-
Tip:Blank Infolet but Underlying Catalog is returning output - What to do ?Summary Tip:Blank Infolet but Underlying Catalog is returning output - What to do ?Content For Viewing data in the infolets , its same as permissions on the subject area… -
How to avoid line managers modify their own job related detailsSummary How to avoid line managers modify their own job related detailsContent 1) We designed OTBI reports for line managers in Workforce Compensation. when the launch r…
-
Promotion Headcount Measure: Worker Assignment Event Real TimeSummary How is the promotion headcount calculated?Content Hello - I am reporting on the Worker Assignment Event Real Time Subject Area, Promotion Headcount and some rows…
-
Tip: SQL Query to check existence of HCM EnterpriseSummary Tip: SQL Query to check existence of HCM EnterpriseContent Tip: SQL Query to check existence of HCM Enterprise ,which can be used in data model. select name,orga…
-
Absence Data Parameter ReportSummary How to create an absence report only capturing absences between a certain periodContent I would like to add some date parameter fields onto my Sickness Absence R… -
Security and OTBISummary Provide access to run specific data reports without provisioning access in FusionContent I need to provide access to an employee group to access an emergency con… -
Number of current contracts in the actual month and in the previous MonthSummary Number of current contracts in the actual month and in the previous MonthContent Hello, I want to create report displaying number of employees by the contract ty… -
Resource for HCM field definitionsSummary Online resource for looking up definitions at the field levelContent Good afternoon. I am able to find online resources on HCM Subject areas, Folders and Tables.… -
OTBI vs BIP SecuritySummary How does security work for each of these report types?Content Hi all - does report security for these report types work the same? For example, I have an employee… -
How To Pull Effective Date of Change Of Assignment Category in HCM ExtractSummary How To Pull Effective Date of Change Of Assignment Category in HCM ExtractContent I have a requirement to pull Effective Date of Change Of Assignment Category in…User_2025-01-28-20-47-34-889 62 views 2 comments 0 points Most recent by User_2025-01-28-20-47-34-889
-
All - Data Visualization for Oracle SaaS Customers: September 13, 2017, 9 a.m. PT - Submit QuestionsContent Submit your questions for the All - Data Visualization for Oracle SaaS Customers session to have them answered during the live event. Post your questions by post… -
BI publisher - How to use conditional statement in SQL queryContent We have a payroll report, which accepts startdate and enddate from users. So there are 3 scenarios this report is generated: 1. Startdate is first of the month a…
-
Blank Infolet : Otherwise Full Data in analysis/CatalogSummary blank Infolet : Otherwise Full Data in analysis/CatalogContent Hi, Please advise on below - I have created a simple Analysis\catalog of person count and country.…
-
How to Include Ampersand in StringSummary How do I use an ampersand in a stringContent Hi all - we are reviewing a report today and ran across an error that we are not familiar with. When we create a new…
-
Need table details for "Associations"Content Hi All, Please suggest in which tables holds the "Associations" details and find the attached screen shot for your reference. Navigation: Person Management-->Man…
-
Managers unable to access reportsSummary Reports reflect 'No Results' when a manager attempts to open a reportContent I have created several reports and assigned permissions to the manager role. They ar…
-
BI - using CASE statement in WHERE clauseContent We are creating a report in BI and it takes parameter from a dropdown list that populates based on SQL. And we need to use that parameter in the WHERE clause. Ex…
-
Error running OTBI reportContent I have created an OTBI report using custom query (by clicking the "New Analysis" from the Advanced tab) And I am able to run the report fine ( I have the admin r…
-
In which Subject AreaContent We need to create a report to bring Vacation accruals and balances. I am looking for the Subject Area in which the Current Vacation Dollars Accrued is stored. An…
-
Vacation Hours Accrued (May to date)Content I am creating a payroll vacation report (in OTBI) and one of the columns is the Payroll vacation hours accrued from May to date. I am not able to map the balance…
-
Adding an "as at" date prompt into a salary analysisSummary Adding an "as at" date prompt into a salary analysisContent Evening all I need to create an OTBI report that returns the salaries of employees at an entered date…
-
Dashboard Prompt: Not show Inactive values in Search selectionSummary Control dashboard prompt to not show the Inactive values for users in search selectionContent Hi All, We have built a dashboard with dashboard prompt for 'Goal P…