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
-
Person Address HistorySummary Need to pull all addresses for specific personsContent We are finding all sorts of errors with our addresses; no end dates, multiple addresses of same type I am …User_2025-01-23-21-24-21-434 302 views 5 comments 2 points Most recent by User_2025-01-23-21-24-21-434 -
How to Join the AoR (Area of Responsibity) table columns in OTBI logical SQLContent Hello All, As per my knowledge and got the information from other resources, OTBI does not currently support Areas of Responsibility (AoR) and there is no any su… -
How to enable two bursting queries at a time in the BI report while scheduling.Summary How to enable two bursting queries at a time in the BI report while scheduling.Content Hi , I have a requirement that to send resignation alert with checklist to… -
Parameterised Dates in OTBISummary Need to get Tax year start and end dates relative to current dateContent I need to get the UK tax year start date (April 6th) applicable to current date, the rep…
-
Need to hide unnecessary folder for Custom Report ViewerSummary Need to hide unnecessary folder for Custom Report ViewerContent Hi, In Shared folder there exist lots of unnecessary folder related to different module. My HR us… -
How to get the previous performance task name in OTBIContent Hi All, I am trying to get the results for current Performance Task name and previous Performance Task name using the Subject Area: "Workforce Performance - Perf…
-
Table name for Element Frequency RulesSummary Table name for Element Frequency RulesContent Hi, Any inputs on how to pull Frequency Rules setup on Element definition? I'm trying with the below tables PAY_ELE…
-
Table name to check Password Expiration Date of userSummary Table name to check Password Expiration Date of userContent Hi All, Can any one please help me to find the table name where i can get password expiration date of…
-
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 … -
How to create dependent LOV Parameters for custom ESS Jobs using view criteria in cloud?Summary How to create dependent LOV Parameters for custom ESS Jobs using view criteria in cloud?Content How to create dependent LOV Parameters for custom ESS Jobs using …
-
How to get R13: Oracle HCM Cloud - Subject Area DocumentationContent Hi, Got the Oracle HCM Cloud - Subject Area Documentation from the link 'https://www.oracle.com/technetwork/documentation/otbi-hcm-2225528.html' and these for Re…
-
How to get the manager's manager name in OTBIContent Hi, I got the employee manager name in OTBI subject area's and we need manager's manager name in OTBI. Please let me know the presentation table and column for t…
-
Employee's AOR Rep and roles assigned to that employeeSummary AOR Rep, Assigned Role To EmployeeContent Do we have any report that lists Employee's AOR Rep, Manager, other assignment details and roles assigned to that emplo… -
BI Report fails with custom security roleSummary User can't run report as he is assigned to security roleContent Hi Team, BI report runs for Admin but does not run for the user. Narrowing down the roles we foun… -
Using Contains in a Custom ColumnContent Hello, Does anyone have any experience using a contains function in a custom column? I'm working on a Benefits report that returns both Employer and Employee cos…User_2025-01-31-00-25-12-234 28 views 6 comments 0 points Most recent by User_2025-01-31-00-25-12-234
-
BI Bursting Mail - Need to Send Mail from a Generic Mail BoxSummary BI Bursting Mail - Need to Send Mail from a Generic Mail BoxContent Dear All, We have created a Generic Mail Distribution List Say "HRServices@ABC.ae". In the BI… -
How to use FND Archive tables to get all HCM Transaction details of WorkflowSummary Need to report, both active , recent completed and histroical Workflow transaction details.Content Hi I am currently using this tables to get Active and recently…
-
Time Card Approver DetailsSummary Time Card Approver DetailsContent Hi Experts, Which table holds the information of who approved the time card. #1.HWM_TM_REC is having time card details. Whether… -
HR Reporting ProxyContent Hi - I have a report that we pull location information from our work structures area. Fusion > Workforce Structures > Manage Locations | scroll down to Legislati… -
BI Publisher reportsSummary Version ControlContent Hi Team, Can someone suggest a control version for HCM SaaS for BI Publisher reports? What are our options? Thank you, Alvaro Couto Versio…
-
Add Column to Reflect whether Measurement is Present in an Employee's GoalSummary There needs to be 1 column added to a Goal report namely "SUCCESS_MEASURE_EXISTS" which will reflect any of the following values: Complete, Incomplete, PartiaCon… -
OTBI Agent Returns 25,001 RecordsSummary OTBI Agent Returns 25,001 RecordsContent I created an OTBI analysis. Then, I created an agent that runs the analysis. I schedule the agent and request the format…
-
Grade on Worker vs Grade on JobSummary We need a report that shows employees grade on worker level and grade on job levelContent I need a report like NAME | Grade (at worker level) | Grade (job level)…
-
Report Jam at Collaborate 2019, San Antonio TX - Building Your Reporting ConfidenceContent That's right! Report Jam has moved from OHUG to Collaborate conference in 2019! More details to follow. -
Burst to Documents of RecordSummary BI publisher report bursting to DoR possible?Content Hey, We would like to create a BIP report (containing the approved notice period and other relevant data) in… -
Manage Seniority DatesSummary Difficulty trying to report on Manage Seniority Dates V3Content Hi we are experiencing issues trying to locate the manage seniority V3 fields which are held in H…
-
Time to Run Reports to Prevent Daily DuplicatesContent Hi all - I am experiencing an issue here and need some help. I have a report that we run daily for our new hires. Each day the report contains data for that day …
-
Can we change the Date format to Text in OTBISummary Can we change the Date format to Text in OTBIContent Hi I would like to know to know if we can use any of the functions in OTBI to change the date format to Text…
-
Length of Service BandingContent I am trying to Band together number of employees within certain Length of Service Banding. Our Length of Service is from "Enterprise Seniority Date" But the Repo… -
How to embed a OTBI Report in the landing pageSummary How to embed a OTBI Report in the landing pageContent How to embed a OTBI Report in the landing page - Need to access the OTBI Report from Landing page directly …