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
-
Assignment Category was Limbo (PRN) for entire yearSummary: I have a requirement to identify employees with an Assignment Category of Limbo (PRN) throughout the entire year 2025 or until their termination date in 2025. I… -
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… -
How to perform conditional formatting on Excel template when old value is not equal to newSummary: I have built a Changes only extract to get the employee Demographic information and getting data in Excel format in separate sheets. First sheet contains new hi…
-
Error while downloading BIP Report in Excel FormatSummary: We are getting error while run a BIP report and try to export in Excel and other formats. When we do the same in Interactive mode no error is coming IO Exceptio…
-
TimecardApprovalNotificationReportSummary: I am getting the below error when i try to view the data model of TimecardApprovalNotificationReport HCM folder. Can anyone please suggest the solution. ORA-009…
-
Unable to report on Guided Journey QuestionnaireSummary: We've created a guided journey questionnaire as part of the requisition process for hiring managers, however we are unable to report on the data. We've had an S…
-
Excel Export Limit Differences Between Prod and CTN (Dev Environments)Hi all, Would anyone happen to know why we appear to have different limits set for exporting OTBI analyses between our production and CTN environments? We're looking to …
-
Logo not displaying in HTML format in seeded Performance Document Worker and Manager Rating ReportThere was an error rendering this rich post.
-
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…