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
-
SQl query to find Default and Override Formula in HCM Compensation planSummary: SQl query to find Default and Override Formula in HCM Compensation plan Content (please ensure you mask any confidential information): Version (include the vers… -
How to create custom employee role that only gives read-only access to payroll documents of record?Summary: We have a requirement, for a specific group of employees, to create a custom employee role that solely gives read-only access to payroll Documents of Record (th… -
Convert Double Data Type to Words in OTBISummary: I am trying to build a report (OTBI analysis) where a double data type field (the Amount column) needs to be displayed in words. For example, if the amount is 3… -
Generate Payslip - Archive Information and Generate Report ErrorSummary: When i ran Generate Payslip, The Archive Information and Generate Report log status are Error. Content (please ensure you mask any confidential information): I … -
Manager not appearing in Termination reportContent Hi, We just recently implemented Oracle Fusion HCM and still trying to work some issues out. One of the issues when I try to pull a termination report that I cre… -
Logical SQL not returning dataSummary: I have built a report using logical SQL is not returning expected data - possible subquery issue Content (please ensure you mask any confidential information): … -
Custom report is not triggering automatically after the Make EFT Payment process is completedSummary: Actual Behavior: Custom report is not triggering automatically after the Make EFT Payment process is completed (following upgrade to 25C). Expected Behavior: Re… -
Can you help me with sql query to fetch performance feedback comments ?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
Unable to show the image file from UCM server in BIP report in pdf output (in html its comming )Summary: We are storing signatures in Document of records and we need to pull these signatures in the report output which is in pdf format. Content (please ensure you ma… -
The value is not falling in the backend tables for Extra Withholding column in calculation card.There is a requirement to fetch Federal Tax form details from My Workforce > Payroll > Calculation Card > Tax Withholding. In this section, there is a specific column na… -
Tables for Helpdesk Service Request to capture Journey assignedSummary: Hi All, We recently implemented Journey's integration with Next gen helpdesk in which agents can assign journeys to end users. We have used Journeys to send a h… -
HY000. Code: 60009. The user request exceeded the maximum query governing executioContent We have created an analysis with BI Admin role. When we are running this analysis with BI consumer/author role. we are getting error: HY000. Code: 60009. [nQSErr… -
[Sharing_BIP Report]: Redwood Profile Option Code listSummary: Extract list of Redwood Profile OptionCodes with value Content (please ensure you mask any confidential information): Some customers ask if there is any report … -
OTBI report created using the subject area "WFM - Document of Records Real Time" is not showing dataSummary: I have created an OTBI report using the subject area "WFM - Document of Records Real Time" which is not showing all the data, no filters applied still only one … -
How to audit managers/employees comments on a Performance DocumentSummary: Using Audit Reports I am unable to see comments on Performance Documents, is this possible via this or reporting? Content (please ensure you mask any confidenti… -
Is there a way to view user role history in Oracle Fusion—specifically, to see which roles were assiHi Everyone, Is there a way to view user role history in Oracle Fusion—specifically, to see which roles were assigned to a user and when? Or Any suggestion for seeded re… -
Learning reports / dashboards - any good examples to share?Summary: Any learning reports or dashboards that people would like to share? Content (required): My company is moving from managing all training administration on spread… -
Users Record History in fusion HCMSummary Users Record History in fusion HCMContent Hi Everyone, Do we have any diagnostics report where we can get user records history ,complete changes happened on user… -
Adding Prompts to BI Publisher Data Models that are based on OTBI ReportsContent Hello, We are implementing OLC and are making certificates in BI Publisher. To make it a little easier we've build the data model off an OTBI report, but we are … -
JOB_ID Date_Published Organization_Name Location_Name Job_Family Travel_RequiredSummary: provide a data model for the above fields Content (please ensure you mask any confidential information): Version (include the version you are using, if applicab… -
Learning Calendar not showing in reportHi All We've adjusted and using Learning calendar from Demo environment report and using it for almost year. But in the last 1-2 months the calendar is no longer showing… -
Requirement to show Previous incumbent show on requisitionSummary: Before creating a new requisition, the system must show who previously held that position. Has anyone found a solution or workaround for this? Content (please e… -
Person real time and Assignment real time securityWe have an OTBI analysis for passport and visa details. It combines the Person Real Time and Assignment Real Time subject areas. One employee has a current assignment in… -
Missing current month data in OTBI for payrollSummary: Missing current month data in OTBI for payroll Content (please ensure you mask any confidential information): We have facing an issue where the current pay peri… -
Employee Access to Payroll Documents from Year-End Documents Page Not Recorded in PER_SENSITIVE_DATAWe have a requirement to build a BIP report that shows when employees view Payroll Documents. We are currently using PER_SENSITIVE_DATA_AUDIT, which records audit activi… -
Which table to get the Plan Period Start DateSummary Plan Period Start DateContent Dear Expert, Which table to can we get the 'Plan Period Start Date' in the 'Accrual Plan Balance' Screen. Please find the attached … -
Need document on how to migrate Value Set from HCM Extarct to from one instance to another instanceSummary: Need document on how to migrate Value Set from one instance to another instance Content (please ensure you mask any confidential information): Hi Team, I am usi… -
-
BIP Report is taking more time while Using Bursting, Without Bursting it completes in 10 minSummary: Custom BIP Report is running for more than an hours and it is not bursting output to FTP(secure) while using bursting query. But when we are running the same re… -
default time zone when scheduling BI reportsSummary: is it possible to set a default time zone when setting the date on a scheduled BI report? our default time zone is London but when we open the calendar it defau…