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
-
How to fine tune OTBI reportSummary How to fine tune OTBI reportContent Hi All - We created an OTBI report using 2 SA's and embedded it on UI using sandbox for line managers. This fetches assignmen… -
Replace CURRENT_DATE in formula to get previous yearSummary Head count by length of service reportContent We currently have a report called Headcount by Length of Service. I am trying to pull the previous years (2019) dat… -
Using analysis as a sub query - many values for the IN predicate errorSummary Using analysis as a sub query - many values for the IN predicate errorContent Hi, Using OTBI analysis as a sub query for a field for the another analysis . While… -
Changing Report Schedule which is running as ExtractSummary Changing Report Schedule which is running as ExtractContent Hi All, I have a report running as an Extract. I want to change schedule of it. Can someone guide me.…User_2025-02-07-19-03-14-525 33 views 2 comments 0 points Most recent by User_2025-02-07-19-03-14-525
-
OTBI - Cross subject area questionSummary OTBI - Cross subject area join issueContent Hi, I am trying to build an analysis using 2 subject areas Using Benefits - Enrollments Real Time and Workforce Manag…
-
The Requirement is to get the Approval history for the Job Offer approvalSummary Approval status and the approval date with the respect to the approver for a job Offer in BIP ReportContent Requirement is to fetch the below for Candidates Job …
-
Need to Know How Filter Results to Last Two WeeksSummary I have a report in OTBI that I need to filter the results to only show the last two weeksContent Hello everyone, I need some help with filtering my results on a … -
Transaction Approvals - Correlation to HCM OTBI subject areasSummary Transaction Approvals - Correlation to HCM OTBI subject areasContent Hi, The July OTBI Office Hours event (https://cloudcustomerconnect.oracle.com/posts/c06d1ba6… -
Compensation Zones in OTBISummary Is it possible to report on compensation zone configuration in OTBIContent Is it possible to pull compensation zone information into an OTBI analysis? Based on t…
-
Underlines coming in PDF even though not in RTFContent In my RTF I don't have any underlines , but in PDF (Offer letter) , Underlines are coming . I am not able to find the reason behind this . Did anyone face this i…
-
People Group Segments Subject AreaSummary People Group Segments Subject AreaContent Hi All, In which subject Area I can find assignment people group segments while creating analysis ? Thanks.
-
OTBI Learning course detailsSummary Need help to find attributes in subject areaContent Hello everyone, I am having trouble to locate the attributes for the following fields in learning subject are…
-
OTBI Learning - Department, job, grade... at enrollmentSummary OTBI Learning - Trying to get department, job, grade... at enrollment date (Offering Start Date) instead of actual oneContent Hello guys, As per title, I am tryi…User_2025-02-05-11-42-08-011 60 views 3 comments 0 points Most recent by User_2025-02-05-11-42-08-011
-
Full-Time Equivalent Measure Will Not SuppressSummary When the Full-Time Equivalent measure was pulled into a Benefits report, the FTE is not suppressing, even though the column properties have been set to suppress.…
-
Performance goals - additional attributes version typeSummary Is there any literature available about this field?Content Hi I have an OTBI report that contains the following field from the Workforce Goals - Goals Status Ove…User_2025-02-05-22-44-35-842 32 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle
-
User Entity for new 2020 W4 FieldsSummary User Entity for new 2020 W4 FieldsContent Hi Experts , Which User Entity provides new 2020 W4 Fields in hcm extracts. Please see below screen for details. Thanks… -
Report on Terminated Employees Sickness AbsenceSummary We cannot report on sickness absence data for terminated employeesContent Hello, We have a requirement to report on the average working days lost for all employe… -
Formula for get the emlpoyees enrolled benefits planSummary Need benefits formula to get the employees who are enrolled the benefits plansContent Hi All, fast formula type : Person Selection rule Rule Criteria: Person who…
-
Number of columns mismatch. Expected: 6 columns. Actual: 7 columns.Summary It is happening while adding "Worker"."Person Number" on groupbyContent Hi, we are facing an error while we are adding "Worker"."Person Number" on groupby. The e…
-
OTBI Based Dashboard OutputSummary Multiple Employees in different Pages in Dashboard OutputContent Hi All I created a Dashboard for Talent Profile using 10 analysis (Each analysis will bring its … -
How to display grade from prior salary change on same lineSummary In a comp history analysis, I need to report on employee's grade as of the salary update immediately prior to the current salaryContent Subject Area: Compensatio…
-
Watermark not coming in HTML ( Email body) outputContent We got a requirement to send an email (not an attachment in email) to user on his/her anniversary. We are trying to use BIP bursting concept to send an email. In… -
Payroll - Element Entries History Real Time - Input ValueSummary Payroll - Element Entries History Real Time - Input ValueContent Hi, I am trying to create an analysis for the subject area Payroll - Element Entries History Rea…
-
Can we create OTBI report for COmpetencies which include audit detailsContent Hi All, We have created competency, in OTBI is only showign the latest update on competency. for example we are changing rating for comp A from medium to Low on … -
Security QuestionSummary Report needs to be run by many usersContent Hi, I have a simple report that runs using a From and To Date prompt that shows all New Hires within the chosen date …User_2025-02-05-22-44-35-842 43 views 2 comments 0 points Most recent by User_2025-02-05-22-44-35-842
-
Emergency Contact Details Report - Required Duty/Data RoleContent Hi All, We have created Emergency Contact Details Report from Person Subject Area to support our Business Continouity agenda (attached). We have two custom roles… -
Fusion Table for BIP informationContent Hello All, Is there any tables available which is holding the information of BIP(Data models, template, etc) details. Thanks Ganesh -
OTBI Analysis Error: Subquery contains too many values for the IN predicate.Summary State: HY000. Code: 42029. [nQSError: 42029] Subquery contains too many values for the IN predicate. (HY000)Content Hi, I have a OTBI report which needs to pull … -
Could not find the lookup HRC_TRANSACTION_STATUSSummary Could not find the lookup HRC_TRANSACTION_STATUSContent Hi Experts, As a part of pulling the Approval Transaction Details, I have used the table HRC_TXN_DATA. Th…
-
Issue passing the date parameter to the date parameter while creating a link to the other BIP reportSummary I have been tryingng to create a link for a custom BIP report in my existing report for which I am passing 3 string parameters which worked fin, while passign th…User_2025-02-07-18-15-37-534 131 views 2 comments 0 points Most recent by User_2025-02-07-18-15-37-534