Category 81
Discussion List
-
How to know whether a position is vacant or not in Oracle? from which oracle fieldSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Gleamy Mishra 21 views 5 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Report for all direct and indirect reportsSummary: I need to write a report for all employees that role up to each VP. Content (required): I need to write a report for all employees that role up to each VP. I wi…Donna Valentine 202 views 5 comments 1 point Most recent by Girishbabu800 Reporting and Analytics for HCM -
How to get the Unique values in the table based value set query ?Summary: I need to get the List of unique manager name based on all the associates. But I couldn't use the distinct or any to get the unique value. Is there a way to han…
-
How to create sub departmentSummary: How to create sub department Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Sni…Gleamy Mishra 80 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
OTBI REPORT- ERROR WITH COMPENSATION SALARY REAL TIME DETAILS SUBJECT AREASummary: Hi All, when I try to add the Annualized salary and salary currency to an employee with a changed salary we find the following issue: 1. adding only the annuali…GiovanniD 44 views 13 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Compensation Plan Worksheet with notesSummary: I have created a report to pull compensation worksheet with notes. I am facing the following issues: 1) It only picks up employees with Notes. I need to pull th…
-
How to develop a report using year-to-date balance dimensions for payroll balancesSummary: We need to be able to generate effective OTBI reports delivering year-to-date information on payroll balances. When looking at Payroll Balance Results in the UI…Len M. 363 views 9 comments 0 points Most recent by Kishoor_R-Oracle Reporting and Analytics for HCM
-
Is there syntax in OTBI I can use to round down?I have age in years as 22.6 which I need rounded down to 22. Using ROUND rounds up to 23; applying data formats rounds up. e.g: ROUND((CURRENT_DATE - "Workforce Manageme…Clare Murtagh 35 views 2 comments 0 points Most recent by Clare Murtagh Reporting and Analytics for HCM -
Filter not working for case statementSummary: I am creating a HDL formatted report to produce a list of employees that require termination from HCM. I have managed to produce a list of all the employees tha… -
OTBI Agent sends spoiled action linksSummary: OTBI Agent sends spoiled action links Content (please ensure you mask any confidential information): Hi experts, I am working on the new job applications list O…Volodymyr Faranosov 11 views 2 comments 0 points Most recent by Volodymyr Faranosov Reporting and Analytics for HCM -
OTBI-Dashboard promt values not showing in Dashboard after added the new oneSummary: HI Team, We have new enhancement requirement in old dashboard that is needed to change the check task name from HR Questionnaire First 2-weeks check into Onboar…AjayKumar Maddipati 23 views 9 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
FIlter on Excel BI Publisher TemplateSummary: FIlter on Excel BI Publisher Template Content (required): We want to apply a filter on a column in the excel template. We have a report showing all employee of …A.Ferraro 322 views 3 comments 0 points Most recent by Rajdeep Chavda Reporting and Analytics for HCM -
Performance Document Changes Audit ReportHello, We have a need to audit our Performance Documents to understand who all made changes on a performance document. Each time a rating is changed we want to generate …Nick Dorfner 291 views 7 comments 0 points Most recent by Andrew Gillibrand-Oracle Reporting and Analytics for HCM -
Report on Role MappingsSummary: I'm looking for a way to pull all Role Mappings currently set up. Is there a delivered one I'm missing? Or, does someone have a sample to share, please? Content…
-
How to Filter for Calculation Component Details in OTBISummary: Business requires a report to pull all current information on the Reporting Information Calculation Card where the Calculation Component Detail = Third-Party In… -
For impact analysis on BIP data models which meta data table is used in Fusion HCMSummary: As a part of impact analysis how can we find particular field is getting used in which BIP data models. Content (please ensure you mask any confidential informa…Siddhesh Nisal 24 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
BIP Report Tagged to OTBI Dashboard is taking long time and error outSummary: BIP Report is developed and tagged to OTBI Dashboard. Taking longtime more than 10 minutesand then error out Content (please ensure you mask any confidential in…Anjan Polimera 45 views 3 comments 0 points Most recent by LakshmiCharitha Cherukuri-Support-Oracle Reporting and Analytics for HCM
-
Extract text data from "SuccessCriteriaText" in "XML_DATA_CACHE" column "HRC_TXN_HEADER" tableSummary: Does anyone know how to extract text data from "SuccessCriteriaText" column in "HRC_TXN_HEADER" table? Although I could extract some text data such as GoalName,…S.Watanabe0110-Oracle 141 views 1 comment 0 points Most recent by GajavalliKoteswararao Reporting and Analytics for HCM
-
COUNT in a CASE statement for a calculated field in OTBISummary: Need to create a calculated field using COUNT and CASE statement Content (please ensure you mask any confidential information): I am using this Subject Area: Wo…Pradnya_Pampatwar 152 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
BI report - rejected by in Job RequisitionWe are building a report to check the rejected job requisitions and we can't find the field for who rejected the requisition. The field IRC_REQUISITIONS_VL.LAST_UPDATED_…Marta Martinho 12 views 3 comments 0 points Most recent by LakshmiCharitha Cherukuri-Support-Oracle Reporting and Analytics for HCM
-
Query to get assessment questionnaire responses for an employee from learn moduleSummary: Query to get assessment questionnaire responses for an employee from learn module Content (please ensure you mask any confidential information): Hello, I'm tryi…Manisha Rajupeta 238 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Courses Link table name for LMS reportFrom which table we can get the course link in bi reports. Can anyone help me with the table name. Thanks, Dara NagasaiDara Nagasai 1 view 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Audit of BIP Report ChangesSummary: Audit of BIP Report Changes Content (please ensure you mask any confidential information): Hi Team, Greetings! Is there any available feature to track or audit …Parag Hiremath 33 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
We want to remove Submit Information and Add comments in the goal approval notificationWe have a goal plan approval process where the below is the scenario Employee Creates the Goal > It goes to manager for approval > Manager can either approve or Request …
-
Succession Candidate readiness Counts are off in reportSummary: I am trying to get accurate counts of Active Plan candidates (active assignment and active on plan) and while I'm able to pull totals accurately, the candidate … -
Learning Specialist Not able to see employees dataSummary: We have built a custom OTBI report using the subject area - Workforce Learning - Learning Management real time , but when we run the report the Learning special…Veena P 165 views 4 comments 0 points Most recent by Saurabh Pratap Singh Reporting and Analytics for HCM
-
Pivot Table > Sorting Date in Ascending Order Not WorkingSummary: Pivot Table > Sorting Date in Ascending Order Not Working Content (please ensure you mask any confidential information): Hello, We want to display the time card…
-
Education Levels in OTBISummary: I'm not able to locate School name shown in the Education Levels section on Person Profile in OTBI. I don't see the Education Levels section under Person Profil…Gala Meyerovich 1 view 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Issue with line manager dashboardSummary: Content (please ensure you mask any confidential information): Hello experts, in all delivered dashboards, in my case compensation plan, line manager can look f…Valerio Curzi 12 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM