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
-
Head Count as of given dateContent Hi Experts, We are looking for a report which has the below data point. The worker subject are giving information as of date and in the current requirement we ne… -
Report on Performance Document AcknowledgmentSummary Is there a table or Subject area to report on employee acknowledgement?Content Is there a table or Subject area to report on employee acknowledgement? We need a … -
Reporting on saved goalsSummary Reporting on a goal before it's been approved by the managerContent Hello, We used to be able to report on goals using Goal Status Overview Real Time. The Versio… -
Hire Date using OTBI Reporting (Not to include Global Transfer Dates)Content Greetings, We recently went live with Oracle HCM Cloud in January and we are trying to figure out how to correctly report a hire date using OTBI Analysis reporti… -
AOR using SQLSummary Display AOR fields by Employee Number and NameContent HI All, I hope someone can help me with a SQL. I want to try and build a common query that we can use in ou…
-
As Of Date reporting and dimensional attributes in OTBIContent Hi, We want to use As Of Date reporting with OTBI. But we are not sure which dimensional attributes will also move to the value at this 'As Of Date'. Will all di…
-
Instance identifier in BIP reportSummary We need specific report to run only if it is on specific instance (say Test POD).Content We need specific report to run only if it is on specific instance (say T…
-
Table for Attachments under position profileContent Hi, Can someone help me with the table contains the attachment information under position profile? Regards, Nivya -
How to load sample report in Oracle HCMContent Hello experts, I need to load a custom template as example in Oracle HCM. I want to load an image showing a sample performance document. In addition, I have crea… -
Simple logical sql query fails to load in data modelSummary Simple logical sql query fails to load in data modelContent We were trying to create a data model with Simple query(Name = Any , Data Source = Oracle BI EE, Type… -
Customize Rating Distribution graphContent Hello, Would like to know using which analysis the graph is generated on this Performance Calibration page. We have a requirement to cutomize this graph and want…
-
Question on .catalog filesContent Hello Experts, I got two questions (probably a weird ask) on BI catalog objects. In /analytics (OBIEE), the archive will create a .catalog file instead of a.xdo/…
-
Infolet Visibility IssueSummary Can we use Assignment's Descriptive field value in Infolet EL expressionContent Hi, We need to set the Infolet Visibility based on Assignment's Descriptive field…
-
How to remove an unwanted character in rtf template (PDF Output)Summary How to remove an unwanted character in rtf template (PDF Output)Content Hi Experts, We are generating confirmation letter with PDF format for this we are using R…
-
Multiple Worksite report is not returning data for TX after 21-A updateSummary Multiple Worksite report is not returning data for TX after 21-A updateContent Multiple Worksite report is not returning any data for Texas or New Hampshire afte…
-
How to fetch the deleted goalsSummary How to fetch the deleted goalsContent Hi, We are in REL 13 20 D. Our customer want to fetch the Goals details of the employees which are deleted. Could you pleas…
-
Report for final year-end performance ratingContent Hello Oracle community, We are looking for a report for final year-end performance rating for each employee. Version 21A
-
CONVERT FF to UDT creationContent hello Experts, I would like to ask for your assistance in converting fast formula - XX_RECOMMENDED_MAX_QUARTILE_FF to a user defined table. This FF is used in BP…
-
Absence Calendar Details Real Time - Incorrect Data in ReportContent Hi Experts, We have created a OTBI report in which we are getting the results as per leave type and for one specific leave type, we are getting very small (Incor…
-
Delegated Roles TableSummary Delegated Roles TableContent Hi All, Is there any other table which stores delegated roles details? I am able to find the table PER_DELEGATED_ROLES but this repo…
-
how to schedule an OTBI Agent using SoftDates such as: {$SYSDATE()$}Summary Scheduling an OTBI Analysis to run for previous month using {$SYSDATE()$} and {$SYSDATE()-30$}Content Hi, We'd like to schedule an Agent to run monthly, on the f… -
Extract Projected Accrual Absence Balance in HCM/BIP reportSummary Extract Projected Accrual Absence Balance in HCM/BIP reportContent Hi Experts,We have a requirement to fetched projected Absence balance of employee in extract t…
-
We need to fetch all active records from current Organization Tree for department structureSummary We need to fetch all active records from current Organization Tree for department structureContent Hi Experts, We need to fetch all active records from current O…
-
How to export OTBI report including Personal Photo?Summary Need to crreate an OTBI with Personal Photo and Export successfullyContent Dear Experts: I have builld an Employee List report with Personal photo as a columon. …
-
Latest Assignment ChangeContent Hello, I'm trying to pull the latest assignment change row using the Assignment Event Subject area, but it doesn't seem to be working anymore. In the past I've u…
-
Organization Levels, Organization Manager Names, and their Effective DatesSummary Organization Levels, Organization Manager Names, and their Effective DatesContent Hi Experts, Good day! Can you please help and guide or redirect me to resources…
-
Join two different Subject areas - Workforce Learning - Learning Management real time and WorkforceSummary I am facing error when I tried joining two different subject areas (Learning and Person)Content In OTBI, I cannot able to Join two different Subject areas - Work… -
21A Enhancement- HR_DOR_REPORTING_LIST_VSummary 21A Enhancement- HR_DOR_REPORTING_LIST_VContent Do you need to update/fix any security roles after this enhancement in 21A? How do you "control this access" with… -
General Preferences OTBI Subject AreaContent Hello All. I am trying to include Language from General Preferences in an OTBI report, but I am not able to figure out which subject area general preferences are…
-
Report to show all future approversContent Hi, Does anyone know of a report or way to query, all future approvers in an approval chain for notifications. For example, next approver is person x, then once …