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
-
What HCM table can I use to get the future Line Manager?Summary: I'm checking if I can use the BIP Bursting feature to send details which includes tasks to the worker's future LM once the transfer is approved. The client want… -
Pension and annual salary data in one reportSummary: Hi, We are trying to build a report which provides information on an employees pension and annual salary. The report is built combining subject areas. When comb…
-
Which tables store the Weekly Working Hours data?Summary: Which tables store the Weekly Working Hours data? Version (include the version you are using, if applicable): 23B -
How do we find out the date a leave of absence was approved?Summary How do we find out the date a leave of absence was approved?Content We are using the 'Workforce Management - Absence Real Time' subject area and using the 'Assig…
-
Where can the admin find a saved transaction (departments in this case)?Summary: Where can we find a saved transaction? Content (required): Dear experts, we started creating departments with Manage Departments in FSM and as we missed some de… -
Assignment Start Date Explained?Summary: Could an Expert help me understand how when Adding Assignments to a person, the Assignment Start Date field works in the Workforce Mgmt Subject Areas? The issue…
-
Oracle BI Tables for compensation plan columnsSummary: Content (required): Hello experts, do you know which Oracle HCM BI Tables store compensation plan user-defined columns (custom numeric and text column); Compone… -
How to pull correct Learning Assignment Status valuesSummary: Cannot determine the logic to pull the correct Status value that is displayed in Status column of Learning Assignment Page. The Table has two Status fields and …
-
Extract the ID of a department (going active on 01 october) from FusionHello, In Fusion we have created a department that will become active on the 1st of October. For our integration with Taleo I need the Department ID of this department a…
-
Absence Headcount - Percentage of Employees on Leave by JobSummary: Divide count of employees by total number of employees Content (required): Hello experts, As the title suggests, I was trying to fetch the percentage of employe…
-
Workforce Compensation Plan delivered reports and dashboardsSummary: Content (required): Hello experts, are there any delivered OTBI analysis and dashboards for Workforce Compensation Plan module? If so, please could you share th…
-
Pull all of one HR Action as long as another HR Action doesn't exist afterSummary: Long title after contemplating how to ask this...:) My analysis pulls all HR Actions that equal 'Termination.' What I need to do is exclude any worker who had a…
-
BIP email's font appear diffrent within gmail than outlookSummary: Customized email's fonts appears diffrent Content (required): I'm designing a BIP template with the kind of rtf format. I'm designing one of the journeys OOB re…
-
Learning Table Details to fetch Learning Access Group related fields along with access group membersSummary: I have requirement create BIP report to fetch all learning item along with access group related details like Access Group selection method, Access group Run as,…
-
Query Slower after patch Favoring Full Table Scan (FTS) instead of Index ScanSummary: A report built to get the timecard details (OTL query) is suddenly running for a very long time after the recent patch was applied. It does full table scan rath… -
How can we fetch data under Performance Goals for the field "Manager Rating" in OTBI.Summary: How can we fetch data under Performance Goals for the field "Manager Rating" in OTBI. We are able to fetch data only for the field "Overall Summary Manager Rati…
-
Report shows no results for certain usersHello, We are facing an issue regarding the ability to view a report of the subject Area of Workforce Management - Checklist Real Time. Here is the report that we have c…
-
How to I pull a report on departments that shows the hierarchy level ?Summary: I need an establishment report with position details. Content (required): We have recently migrated to Oracle Fusion and are still getting our heads around it b… -
OTBI report - employees' action and action reasonHi all, we are having difficulty in exporting the Action Code/Name and Action Reason Code/Name for each employee. We can connect 'Person Number - Reason Code' but, canno…
-
Assignment and Person Information for Whole Employee PopulationSummary: Hi - I have created a report that is supposed to pull in a combination of Assignment data, comp data, work relationship and person real time information (4 subj…
-
Is it possible to build OTBI report to show have 0 incumbents for active positions ?Summary: Content (required): Need to build OTBI report to show have 0 incumbents for active positions along with Position HC Version (include the version you are using, …
-
Reflect one row when there are duplicate rows of dataSummary: Request received to have report with multiple rows of data for workers to reflect one row for each worker, but still include all data. Hopefully the screenshot …
-
Why bursting from BI Publisher sends emails to 1 domain and not the other?Summary: Why bursting from BI Publisher sends emails to one domain and not the other? Content (required): I created a BI Publisher report having bursting object on it. I… -
Table name where department set is storedSummary: Table name where department set is stored Content (required): Was looking to build a query based on Department set, which table department set is stored. Versio…
-
How to format thousands with a space in an rtf template for HCM compensation change statements?Summary: How to format thousands with a space in an rtf template for HCM compensation change statements? Content (required): Hello, We are customizing compensation lette…
-
How to query email of a user account which is not linked to any person record?How to query email of a user account which is not linked to any person record? In this case person id can be null in per_users table and we can't join it with per_email_… -
Need an help for SQL queryHello Experts, I need some quick help in for my BI Report which is for Payroll module. I have a report which should return all personal payment method details irrespecti…
-
Oracle functions to calculate third quartileSummary: Content (required): Hello experts, we need to calculate THIRD QUARTILE for a set of employee salary amounts. The calculation should work in this way: For employ…
-
How to get Projected End Date?Summary: How to get Projected End Date? Content (required): Hello, we wrote the follow piece of SQL select pc.* --to_char(PC.CONTRACT_END_DATE,'MM-DD-YYYY') from PER_ALL…
-
Help -> Audit/field Change Reports (Old Value -> New Value) - OTBI or BIPSummary Help -> Audit/field Change Reports (Old Value -> New Value) - OTBI or BIPContent Hello, Looking for a quick help, please. Searched the archives but could not fin…