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
-
Fetching list of Absence DBI's and functions (with description)Summary Fetching list of Absence DBI's and functions (with description) that are used in Fast Formulas for AbsenceContent Hello There, We are looking for a report which … -
Cannot use variable :xdo_user_roles in my querySummary ORA-01460 error occurs when using variable :xdo_user_rolesContent Hello, I am trying to use the variable :xdo_user_roles in my SQL query for my data model. Unfor…User_2025-01-28-16-42-42-526 47 views 0 comments 0 points Most recent by User_2025-01-28-16-42-42-526 -
Need to pull last perf review scoreSummary Need to pull last perf review scoreContent Am needing to pull the latest performance score..so wrote this formula but am getting multiple lines of data per emplo…User_2025-01-28-04-05-14-166 43 views 2 comments 0 points Most recent by User_2025-01-23-21-28-55-898
-
OTBI - Dividing two numbers results ZeroContent Hi, We have a requirement to find the percentage of headcounts. In OTBI dividing two values results Zero. For Example 50/100 results 0 but whereas 100/50 results… -
OTBI report with person details, competency name, profile name, profile status code, position code,Content what is the most feasible way to pull data which contains employee details with competency and profile name? I had tried using subject area Workforce Performance…User_2025-01-27-23-54-00-342 143 views 9 comments 0 points Most recent by Raghavendra Raghunath-Oracle
-
Run Gross-to-Net ReportContent Hi All, I got the below error while running the Gross-to-Net Report. After taking so much time I got this error, Please suggest if anyone faced this issue. Navig…
-
Release 11 HCM OTBI Subject Area descriptionsSummary List of Release 11 HCM OTBI Subject AreasContent This spreadsheet provides the list of subject areas with descriptions, business questions answered by these subj…Raghavendra Raghunath-Oracle 279 views 5 comments 6 points Most recent by Raghavendra Raghunath-Oracle -
degrees informations of profiles in tables fusion ?Summary I want to create a report using information of degrees of profiles in bi publisherContent Hello, Someone know please where can I found the information of degrees… -
Dependent parameters on custom reportSummary Dependent parameters on custom reportContent Hi, I need to create custom report using BI Answer, with few parameters. Can we add dependent parameter, Like if we …
-
OTBI - Report to see transactions approved which were initiated by Line Manager in MSSSummary OTBI - Report to see transactions approved which were initiated by Line Manager in MSSContent HR need to have visibility of when the following transactions have …
-
R11 HCM OTBI Subject Area Mapping to Fusion HCM Database TablesSummary Release 11 HCM OTBI subject area database table mapping spreadsheetContent This spreadsheet is published by Oracle OTBI Development. This spreadsheet documents F… -
Report Jam at OHUG OrlandoSummary June 6-8 Salon 18Content We will be running the Report Jam at OHUG (June 6-8 at Orlando) for the third year in a row. If you have a report you'd like us to build… -
Dasboard Prompt not workingSummary Dashboard prompt not working as required. The report does not get filtered based on prompt inputsContent Hi I have created a dashboard containing an analysis fro… -
BI Security - Secured view - real sqlContent Hello, I want to know if there is a way to get the real sql behind the secured view? For example: CMP_SALARY_SECURED_LIST_V or PER_PERSON_SECURED_LIST_V or PER_A…User_2025-01-25-01-33-46-269 169 views 15 comments 0 points Most recent by User_2025-01-25-01-33-46-269
-
Performance Management ReportSummary Performance Management Report for ManagerContent Hello, I want to create a report for Manager and insert it into my Organization tab of Performance Management. I…
-
Report on Development Plan from Performance FormsSummary I'm trying to report on the development plan section of the performance forms. Or removed extra rows from a report exported to excel.Content Has anyone attempted…
-
Manage Benefit Eligibility Profile - Hierarchy IssueSummary Change in configuration - New changes do not appear in the reports. Still reports the old configuration.Content I am doing an audit and corrections for Program /…
-
Where can I find Hire Reason in HCM OTBI/BI Answers?Summary Looking for subject area and field name for Hire ReasonContent I am working on an HCM OTBI/BI Answers analysis and would like to report Hire Reason. Can you tell…User_2025-01-28-17-24-53-863 53 views 6 comments 1 point Most recent by User_2025-01-28-17-24-53-863
-
Need to get Manager Name dynamically in OTBI reportSummary Need to get Manager Name dynamically in OTBI reportContent HI All, We have a requirement need to develop a OTBI report based on the Manager i.e. if manager login…
-
Report on Goal Setting StatusSummary Is there a report / analysis that can track the people by their Goal Setting status in Goal Management?Content Team, As part of the Release 10 uptake, we are pla…
-
Issue with Equations using varying other Analysis Look-upsContent Hello, I am just wondering if anyone else has had this same issue when looking up results from any other analytics? so the query is such, I have a selection of 6…
-
How to get rid of unwanted HTML tags from displaying in my analyses Export ?Summary How to get rid of unwanted HTML tags from displaying in my analyses Export ?Content Hi we have created a Dashboard using Goals Status real time Sbject area which…
-
How to pull APR document through SQL?Summary How to pull APR document through SQL?Content We have a business requirement to pull Annual Performance Document of all employee. Oracle says there is an ER with …
-
Assignment Point-in-Time ReportContent I'm looking to be able to run a report that will pull assignment data as a specific point in time. Does anyone have a catalog they can share with me?User_2025-01-22-19-19-56-324 106 views 6 comments 0 points Most recent by User_2025-01-23-21-28-55-898
-
Help needed - report on employees - start date when employment made permanentSummary How to create a report where I get data on dates when employees employment changed to permanentContent Hi, I need a report from employees whose employment change…User_2025-01-28-07-55-21-868 62 views 5 comments 1 point Most recent by User_2025-01-28-19-49-15-062
-
eTEXT BIP BurstingContent Hi All, I developed SQL Query and eText template as per the requirement. Now I am trying to send eText output to mail through Bursting. When I submit the report …
-
Add BIP reports to flow patternContent Hi All, We developed multiple reports as per our requirements. Here we need to run few reports in a custom flow from Navigator-->payroll-->checklists so I though…
-
Reporting on changes to users and their HCM security profilesSummary need a report to show any assignment changes for people with certain security rolesContent Hi everyone, We are early in our implementation of HCM. One of our rep…
-
Oracle seeded Total Turnover Report available?Content We have delivered a custom report to show the Total Turnover for a business. This can be filtered by a number of options - ie. Date Range, Business Unit, Region,…
-
Bursting BIP QueryContent Hi All, We build BIP report with Bursting as per our requirement. The query which we build on the Performance Management module. If we run the report with Perfor…