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
-
Query required to fetch the fields - Resident PSD Code, Resident School District, Work PSD Code.Hi, Does anybody have a query that will fetch the fields - Resident PSD Code, Resident School District, Work PSD Code, Work School District. These fields are present in … -
table/view to list all users with assigned role namesSummary: table/view to list all users with assigned role names Content (please ensure you mask any confidential information): I am looking for an Oracle Table/View name … -
oracle.xdo.template.online.dms.common.XDODmsException: IO Exception was thrown! nullSummary: oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.template.online.dms.common.XDODm…
-
Restrict user to go to Analytics pageIs there a way to restrict user to access to Reports & Analytics page. From Structure i have disable the Report & analytics page from Navigator and springboard. But we a…
-
Problem with scheduling OTBI reports - error messagesContent I've set up loads of scheduled OTBI reports in the last few months. Although they are still coming through by email when they should, if I try to set up any new … -
OTBI Reporting in UTC Time Causing IssuesSummary: Hello, We noticed that employees were showing as Terminated in OTBI before the end of the day (11:59pm) of their last day. The UI still shows an employee as Act…
-
How to Link Payroll Details to Time Entry Data?Summary: Hii team, In the time entry details we are able to see the payroll linked data, like from frontend I can see this details I need to fetch this Earned date, valu… -
Understanding, Extracting, and Correctly capturing Contract Terms in Negotiation RTF TemplatesI need more information about this part of the negotiations, which is the contract terms. In which table and column can I find them? This section is in the file. Second:…
-
In an rtf template the single cell containing image is stretching to next pageSummary: In an rtf template, the single cell containing image is stretching to next page as it is not having any image to display. Whenever , the xml is generating image…
-
Table for additional info of job offerSummary: I'd like to know which table has the info of Additional Info section in job offer as below:
-
Oracle criteria to identify BIP reports with specific column in itHi All, We are migrating to V3 Seniority Date from V1 Seniority dates. This migration is impacting our BIP reports which are using ‘ORIGINAL_DATE_OF_HIRE’ column from 'P… -
Unable to Extract 2026 Holiday EntitlementSummary: Hello there - I'm trying to evidence each workers 2026 holiday entitlement but the standard HCM accrual reports only seem to be set up to report accural balance…
-
Participant Feedback Report SQL Issue - HelpSummary: Hi, can someone pls help check what's wrong with this SQL below. When I add the Performance Document Participant"."Role Type, I receive this error: I want to fi…
-
Difference between 2 dates - BI PublisherSummary: Hello, I'm trying to get the difference between 2 dates in BIP data model. The difference should present number of days between cmp.DATE_FROM and cmp.LAST_UPDAT… -
Data security grant assigned to a custom role is not workingSummary: I created a custom Hiring Manager role and assigned the data security policy "Hiring manager can choose position for positions in their position security profil…
-
Oracle criteria to identify OTBI reports with specific column in itHi All, We are migrating to V3 Seniority Date from V1 Seniority dates. This migration is impacting our OTBI reports which are using ‘Enterprise Seniority Date’ column. S…
-
How to add oracle cloud url in RTF templateSummary: Am trying to add login url( oracle cloud url) from ask_deployed_domains table. when we click on link it is throwing error. {COLUMN_NAME} using this in address o…
-
"Taken Absences" field in "Front-Loaded Plan" shows not-yet-taken as well as taken absencesSummary: We have front-loaded accrual plans for annual leave and have a requirement to report on taken absences at the end of each month. The "Taken Absences" data item …
-
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…
-
OTBI report is erroring outSummary: An OTBI report is giving error. Would appreciate if anyone can share your inputs. Content (please ensure you mask any confidential information): Version (includ…
-
OTBI report for compensation plan is giving errorSummary: An OTBI report developed for a compensation plan is giving below error for few users. For other users, it says there is no data. But in edit mode, the report is…
-
Fusion table for Employee Vacation and Delegation rulesWe want to develop a custom BI Report for Employee Vacation and Delegation rules. However, we are currently facing some challenges in identifying the correct tables that…
-
Role assignment historySummary We have a requirement from the customer to track the history of changes on a user roles. Ex, If a user has been assigned a role on 01-Jan then that user was term…
-
OTBI report prompt to display only direct reports for Line managersSummary: We have created an OTBI report using the subject area - 'Workforce Learning - Learning Management Real time'. We have created a prompt which displays all the Em…
-
OTBI Report to fetch List of Line ManagersSummary: OTBI Report to fetch a List of Line Managers who have at least one direct report and the direct reports(Employees) should be Salaried. Content (required): For t… -
Saved but not submitted Promotability assessment questionnaire responses from Talent assessmentWe are trying to report on 'saved but not yet submitted' Talent Assessment Manager evaluation responses, using multiple avenues but not getting intended results. Subject…
-
Absence Plan: Monthly Accrual That Expires at Month-EndHi, I want to create an absence plan where each employee receives 1 day of leave every month (this part is clear for me). The requirement is that if the employee does no…
-
Populate if an employee is a Manager in HCM OTBISummary: I'm trying to create a report in OTBI with the subject area Worker Assignment Real. And in the Worker Assignment folder there is Manager Flag. However all our p…
-
How to Generate a Unique Reference Number for Each Report in Oracle Fusion HCMHello Oracle Community, We have a requirement to generate a unique reference number for each report generated in Oracle Fusion HCM, specifically for documents like lette… -
OTBI - Checklist Questionnaire ReportingSummary OTBI Reporting on HR Checklist QuestionnaireContent Hello, Did any one try out OTBI report on Checklist questionnaire in 20C update. I have tried one, I am able …