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
-
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 205 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… -
Analysis Total is Rounding to ThousandContent Hi Champions, I have created Headcount Analysis in my Custom Dashbaord ( Like Count(worker.person_number) to get exact number of employees working in a particula…
-
Compound sort in OTBIContent Hi All, Is it possible to do Sort on 2 columns in OTBI? Ex. First Sort on BU and second sort on LE in same report. Thanks, VijayUser_2025-02-07-19-03-14-525 40 views 2 comments 1 point Most recent by User_2025-02-07-19-03-14-525
-
Getting Error When Click "Drill to Transaction Detail"Content Hi Experts, When I'm clicking on link "Drill to Transaction Detail" from HeadCount Analysis ( I copied it in my custom Dashbaord) I'm getting following error. Er…User_2025-02-07-19-03-14-525 34 views 3 comments 0 points Most recent by User_2025-02-07-19-03-14-525
-
Learning -> How to achieve Fusion Security into Custom BIP Reports through SQL?Summary Apply fusion security into custom-sql reportsContent Hi, Can anyone please help? I am in the process of developing a few custom reports using sql/bip option and … -
Is it possible to write a validation query against excel/csv data source in data model?Content I have created 2 data sets using excel and csv as data source. I want to write basic query to validate data from these files. Is it possible to validate excel da…
-
Removing Nulls from Limited Dashboard PromptsSummary Limiting dashboard prompt by other values while removing the null optionContent Hello, I've created a dashboard prompt where we're trying to limit the values of … -
Duplicate Manager Data Integrity ReportSummary Duplicate Manager Data Integrity Report not workingContent Hi All, We have a data integrity report that we would like some help troubleshooting. This report is i…User_2025-02-07-16-42-37-187 32 views 4 comments 0 points Most recent by User_2025-02-07-16-42-37-187
-
How to setup private key authentication with sFTPContent Hi all, I'm trying to setup a sFTP connection to a vendor using private key authentication. I'm being told that Oracle needs to have a password setup, but the ve…
-
Printing the Entire Dashboard PageSummary Print the entire dashboard page on the My Team DashboardContent We have pushed out some dashboard reports for our end users. We have placed these reports on the …