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
-
Group By Function ErrorContent Hello, I'm trying to used the ranked last function and group by Person Number to pull the employee's latest assignment, but I keep receiving the below error. I'v…User_2025-01-31-00-25-12-234 41 views 2 comments 0 points Most recent by User_2025-01-31-00-25-12-234 -
Report OTBI based on role and delegationContent Hi All, Do you know if is it possible to create an OTBI report that extracts all delegations done through the functionality role and delegation? I saw that these… -
Show Field Data in Column instead of in RowsSummary Working on this in OTBIContent Hi All, I am trying to pull in the last 2 dates an employee was paid. Currently the data appears as 2 separate rows. I am using ra… -
Line Manager Dashboard PromptsSummary AsOfDate not working in my customised versionContent Hi, I have been trying to copy and then customise the Line Manager Dashboard to suit our organisation which …User_2025-02-05-22-44-35-842 69 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle
-
Need to Use Result of One Column in Formula for Next ColumnContent Hello there Reporting and Analytics experts. I am hoping one of you can help me out with an analysis I am working on. I am trying to get our FTE reports up and g… -
Error while using FILTER/DESCRIPTOR_IDOF in formula with multiple subject areasSummary The logical column referenced by DESCRIPTOR_IDOF does not specify a Descriptor ID columnContent I'm trying to summarize Headcount based on Gender, Ethnicity and …
-
Report to show latest demographic infoSummary Report to show latest demographic infoContent Trying to report on latest demographic info for a population but duplicate rows are being returned when I only want…
-
Creating a line graph of headcounts across the past 6 months (for each country)Content Hi, How would one create a line graph of historical headcounts for each country? The date should be on the x-axis and the FTE headcounts on the y-axis, with the …
-
Generating FTE Headcounts for the past 12 months based on each region/business unit - OTBISummary Generating FTE Headcounts for the past 12 months based on each region/business unitContent Hi, How would one generate a time-series plot of the FTE headcounts ac…
-
OTBI: is there a restriction in OTBI reports that it can return onlySummary OTBI: is there a restriction in OTBI reports that it can return only Content Hi, Had a question: is there a restriction in OTBI reports that it can return only -
Recruiting - Reporting on a candidate source when added by a recruiterContent HI experts, I need your help if possible. We haven't been using agency recruiting in ORC because of a system functionality issue so have had to resort to a worka…
-
User Prompt Results Causing ORA-01795 Error (IN statement 1000 expression max limit)Summary Need solution to get past ORA-01795 error caused by expressions returned from user prompts into an IN statement when selecting AllContent Hello, Appreciate any h…
-
Remove DuplicatesSummary Remove DuplicatesContent How to remove duplicates from Excel template? Regards, Reddykrishna -
Historic Position, Dept, job detailContent I have opened an idea ticket, but just checking to see if anyone has figured our how to create a assignment history report that brings in the position, job, dept…
-
OTBI report to get former and current job title, job code, department, business area for internal hiSummary I would like to create a report that can be run by work relationship start date which will provide information on an internal transfer candidate who moves from o…
-
Error in OTBI Analysis Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65PContent Hi All, I have a OTBI analysis with Graph. When I move my cursor over the graph I see Hand means it's clickable. When i click I get following error, Can someone …User_2025-02-07-19-03-14-525 206 views 4 comments 0 points Most recent by User_2025-02-07-19-03-14-525
-
Custom Dashboard HeadcountContent Hi, I have created custom Dashboard and created 3 different Headcount Analysis for 3 BU head count. When I run my dashboard first time it shows correct count for…
-
Send a system notification for all employeesSummary Send a system notification(Not an email) to all employees of their previous day attendance reportContent My requirement is , need to send a system notification t… -
What date format do I need to use in order to calculate the days between one date and another?Summary What date format do I need to use in order to calculate the days between one date and another?Content Hello I am busy creating a data model for a BI report. In t… -
Need a SQL query to fetch Previous salary and previous assignment working hours of an employee.Summary Need a SQL query to fetch Previous salary and previous assignment working hours of an employee.Content Hello, I have a requirement to fetch Previous salary and p…User_2025-02-10-16-28-01-402 1K views 2 comments 0 points Most recent by User_2025-02-06-20-13-56-572
-
SQL Code to Extract Setup Grade Rates with Grade NameSummary SQL Code to Extract Setup Grade Rates with Grade NameContent Team, I have a similar requirement. I am trying to fetch the setup data of Grade Rates with Grade na…
-
Unable to get Min and Max values in Compensation OTBISummary We are struggling to use the min and max function to get proper valuesContent Hi folks, Trying this channel and hoping to find some help and support from custome… -
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 … -
Changes Report - What are your practices?Content Currently we are modifying the changes report that we had using BIP and we stumble this difficulty How's your company show changes in the changes report? We have… -
Save file directly to oracle import and export folderSummary Save file directly to oracle import and export folderContent There is the possibility to save the file generated by Otbi in the Oracle import and export file pat… -
BIP Bursting to email: how to embed a link to the application in the emailContent Hi, we created a bi publisher report with an RTF template. in the report we created a form field and in the bi publisher property we set: View the column NEW_L… -
Resignation Submitted dateContent Hi All, We had a predefined report which use to give Resignation Submission date along with the Employee last working date. Few days back the report stopped work…
-
How to exctract the AddressId in OTBI (PersonAddress)?Content Hello experts, is there a way to extract the Person Address Id in OTBI? In case, do you have the SQL Query to extract the AddressId? Thanks in advance for your t… -
OTBI - prefix for current date minus daysSummary How can I define prompt for an OTBI report which is the current date minus variable of daysContent Hi, I'm trying to create a prompt of number, so if the user wi…
-
Restrict access to Reports and Subject areaContent Good day, everyone! Could you please tell me if there is an option to restrict access to reports based on roles? I also wondering if is possible to restrict acce…