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
-
BI Publisher Sending a report to FTP Server with SSHSummary: How do I schedule a report to be delivered to a destination configured with SSH authentication? Content (please ensure you mask any confidential information): H… -
Issue with formatting totals in OTBI Analysis TableSummary: I have a simple analysis coming out of the Benefits - Enrollments Real Time Subject Area. I have set the Department Name as a Table Selection. I have formatted … -
Fast Formula for Matrix Manager in Compensation Plan HierarchySummary: Hi, We have the below requirement for Compensation hierarchy: If Country of the Employee is Poland, the hierarchy should be the other manager type (Comp manager…
-
Drill Down in the OTBI does not work correctlySummary: Drill Down in the OTBI does not work correctly Content (please ensure you mask any confidential information): Hi, we created an OTBI report. The extracted data …
-
Benefits Override Eligibility reportSummary: Is there a way to report on the employees and benefits that have been Overridden using the Override Eligibility in Benefits please. Content (please ensure you m…
-
OTBI skills proficiency levelHi all, We need to take the gap between the Proficency Rating and the Required Proficency Level for the employees. We are looking for this fields in the OTBI: We are usi…
-
How to get the assignment name for an OTBI analysis?Summary: I need to know which subject area and fields I need to use, to get the employee assignment name for an OTBI analysis. Content (required): Assignment name Versio…
-
AAP Promotions ReportSummary: We have a requirement to report on employee promotions. This report should export on one line what their previous job/position was, and what their new/current p…
-
Making All value selectable in date parameter definitionI have an absence start date parameter in the report and its definition is as seen in the screenshot below. It works like this: First, the registry number is selected, a… -
People Leaders Workbench DocumentationSummary: Hello, A team member was at Oracle Cloud World and asked me to research how to get more information related to the People Leaders Workbench (see screenshot). I'… -
How can I get the Home Address from the Person Management\Person area on a ReportSummary: I have the mailing address, but need the home address. Content (please ensure you mask any confidential information): Version (include the version you are using… -
SQL query will not return an expected row in larger reportSummary: I have a report that returns employees who were referred and by whom, connected to their application and based on the referral to a specific job. There is an od…
-
What table holds the future incumbents details?I am trying to pull the person number of a future incumbents but i'm not sure what table holds that info. Does anyone know? TIA. 😊
-
HCM Experience Design Studio ReportSummary HCM Experience Design Studio ReportContent Does anyone know if there is a Subject Area or Table that contains the Rules created in the HCM Experience Design Stud… -
How to put image as a background and create a birthday report?Summary: How to create a birthday card which need to put image as a background and make it staff name and birth date appear on top of the image?
-
Are there agreed standards used by the community when reporting dates?We have adopted the US format for all reporting with users then setting preferences at an account level. Are there any standards which are adopted by customers as best p… -
BI Impersonator roleSummary: We are trying to connect OTBI through OAC. To implement this, we need to know what privileges should 'BI Impersonator' have. As of now BI Impersonator role not …
-
Report on Benefits GroupSummary BEN_BENFTS_GRPContent Hello. I am trying to link the table BEN_BENFTS_GRP (name field) back to the employees (person_id or person_number). I have tried linking i…
-
Subject Areas for Employee dataSummary: I am trying to create a report of the employees in Fusion (we don't use HCM), but I can't get the data out of the system. I can see the worker's name and primar…
-
Job description report to add inactive and active job codesSummary: We are trying to add inactive and draft job codes in the job description report through SQL, we added the flags Active, Inactive and Draft in the SQL, still we …
-
Birthday alert with Background imageSummary: i have a birthday alert requirement and whenever i try to put the image as background using watermark option, rtf file size is getting increased and getting bel…
-
OTL - Workforce Management - Reported Time Cards Real Time subject area missing entriesSummary: The subject area Workforce Management - Reported Time Cards Real Time does not return accurate time entries when we try to query the custom attributes from the …
-
How to show amount of times a report has been run?Summary: The 'OTBI usage real time' subject area can't show usage of reports - how to report on this? Content (please ensure you mask any confidential information): We h… -
Multiple Proficiency Level records per Competency HCMSummary: We have multiple Proficiency Level rows per Competency. It is not clear which proficiency level in the report is the correct one. We expect the report to show o…
-
How Do I get access to the WebCenter Content serverSummary: I have SQL provided by Oracle that give me the Content Server URL. When I click it, I get directed to the Content Server, but I do not have access to the file. …
-
How to set a Presentation Variable in a Dashboard Prompt as a DateSummary: How to set a Presentation Variable in a Dashboard Prompt as a Date Content (please ensure you mask any confidential information): Hi, we created a Dashboard, wh…
-
How can we pass date parameters into the List of values to fetch the data based on the date rangeHow can we pass date parameters into the List of values to fetch the data based on the date range? Based on the dates the recoded should get refreshed in the parameter n…
-
query to fetch global transfer employees in fusion hcmSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Workforce Management - Worker Assignment Realtime, Work Assignment, FTE returns >1 incorrectlySummary: The attached analysis returns an FTE value greater than 1 for 49 records. We believe the calculation for FTE should be FTE = ((standard hours * headcount) / nor…
-
EEO-4 Category table nameSummary: Hi, everyone. would like know where I can found this columns. Regulatory Response Ethnicity - TEXT → I can't found the string data data type. EEO-4 Category → E…