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
-
Transaction Console Subject AreaGood Day Experts, May I know what subject area to use to get processes from Transaction Console? The following are the process name: - Manage Salary - Change Personal In… -
OTBI error when running reportSummary: Hi all, Is anyone able to help me understand why this error message is being displayed when a HR user tries to run this report showing details of a particular e…
-
Duty travel resumption report is showing for employee not for contingent workerUser A who is a cwk and User B is a emp, both of them are having exact payroll roles. But for user A the Duty travel resumption report is not populating the data only co…
-
SQL Query to get balance value for a balanceSummary: Hi Team, I am looking for a SQL query to get balance value for a balance as of effective date. For example:- I need to get balance value as of 16th June 2025. F… -
Require User Account Status update history.Summary: Dear Oracle Community, We got an issue regarding the Users Account status. There's statuses turned to Inactive. We want to know who has made changes to the acco…
-
Enrollment Coverage Through Date in the Benefits subject area is showing 12.31.4712Summary: When creating a open enrollment report for 2026 using Benefits - Enrollments Real time, Enrollment Coverage Through Date is 12/31/4712. Because of that it's sho…
-
How to identify records in ASSIGNMENTNODE PVO that do not appear in Employee's History?Summary: When using the ASSIGNMENTNODEPVO, I see records for employees that I do not see in their history in HCM. For example, an employee resigned and this was entered … -
i need query for approved by nameSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Duplicated records on OTBI Report linked to different assignments on Person dataSummary Duplicated records on OTBI Report linked to different assignments on Person dataContent Duplicated records on OTBI Report linked to different assignments on Pers… -
Bursting files by department code in .csv formatSummary: Bursting files by department code in .csv format is running into error. Content (required): I'm using this query to burst files by Bursting Key = department cod… -
Can we extract personal information occupancy in bytesNeed to extract personal information of candidate and employee from a certain country in bytes. Is this achievable? If yes, please share the steps to get the info.
-
OTBI report for role , Security Context & Security context Value access assigned to userSummary: Creation of OTBI report for role , Security Context & Security context Value access assigned to user Content (required): HI Team, We have one requirement to cre…
-
Job Change Report - Assistance Adding Two new AttributesSummary: I have a Job Change Report but I am having trouble adding columns to looking for changes in The Full-Time/Part-Time Status and the Salaried/Hourly status. Any i…
-
write a sql query to fetch average cycle time for each compensation planSummary: write a sql query to fetch average cycle time for each compensation plan Content (please ensure you mask any confidential information): write a sql query to fet…
-
write a sql query to fetch average percentage of budget utilizationSummary: write a sql query to fetch average percentage of budget utilization Content (please ensure you mask any confidential information): write a sql query to fetch av…
-
Date format in OTBI PromptSummary: How to change prompt values from datetime to date. Instead of "11/12/2024 00:00:00" I want "11/12/2024" Content (please ensure you mask any confidential informa…
-
Sql query to find the pending document of record detailsSummary: I am looking for query to find the pending document of record details. I can see the approved once in table hr_documents_of_record. Content (please ensure you m…
-
BI Catalog change audit dataSummary: Is there a way to audit the changes done on BI catalogs in Oracle Fusion Cloud? Content (please ensure you mask any confidential information): Version (include …
-
How to get the XML data for TimecardApprovalNotificationReport seeded reportSummary: Hi Experts, we have a requirement to get the XML data out of the TimecardApprovalNotificationReport to troubleshoot how data is displayed in the report, does an…
-
Assistance Required: How to obtain the history of when a role is assigned and revoked to a userHi Team, For audit purposes, we’d like to know if there’s a way to track when a specific role was assigned to a user and when it was revoked. Currently, we can only revo…
-
Need to skip HTML tags while displaying in the outputContent Hi All, We are facing an issue in Performance Management in Fusion Cloud. In the back end database table in one of the column (HRA_EVAL_RATINGS -- COMMENTS) whic…
-
How can I ensure my BIP report for line managers only returns results of their reporting line?Summary: I've built a BIP report and made it available to managers as a link (static URL page entry in My Team) and it works perfectly except it returns results for all …
-
How to get Questionnaire Answers on a Single Row in OTBISummary: Create an analysis with Checklist questionnaire answers/responses on a single row in the analysis Content (required): I have created an analysis using the Workf… -
Does anyone have a BI report query available that extracts data in the 834 ANSI HIPAA format?With template it would be nice to have. -
span of controlSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
How to identify if a goal has been added from the goal library?Summary: I have created two basic reports showing employee performance and development goals. I want to know how many of those goals have been added from the goal librar… -
Why are some column headers clickable links in my OTBI report? What is the functionality of these liContent Hi, I would like to know why some of the column headers in my OTBI report are clickable links and others are not. I would also like to know the purpose of these …
-
How to fetch the contract end date of a future contract extension using OTBI?Summary: Hi All, We have a requirement to fetch the Contract End Dates of contract extensions that have a start date in the future. OTBI only seems to fetch the Contract… -
Issue in Dynamic URL in StructureSummary: We are trying to use dynamic url in structure tab in instance (https://ehzq-dev14.fa.ocs.oraclecloud.com/) to navigate to the report folder but the web applicat…
-
Disability status of My Contacts (People to Cover)Summary: Hi Experts, We have requirment to send email notification to employees when Employee added Contact Relationship (Me→Benefits→Before you enroll→My Contacts) with…