Category 81
Discussion List
-
Facing issue in Headcount by department hierarchySummary: My client wants to view the period end active headcount by level 2 and level 3 department hierarchy. I tried to achieve that using the below catalog attached bu…Shreya Datir 11 views 2 comments 0 points Most recent by Shreya Datir Reporting and Analytics for HCM -
In OTBI, when I am using Subject Area, how can I generate XML for the dataI am trying to generate the report using OTBI for a particular subject area. What I want is that I should be able to generate XML of the data so that I can use this in B…
-
Change information in the pop-up notes when adding "Record External Learn"Summary: is it possible to update the pop-up notes "Actual Effort in Hours" when adding "Record External Learn" Content (please ensure you mask any confidential informat…Chris0145 21 views 1 comment 0 points Most recent by Abdul Rauf Mohammad-Oracle Reporting and Analytics for HCM
-
Login Data from Identity Domain in Reporting and AnalyticsHello, Does anyone know if it's possible for login data from Identity Domain to be displayed somehow in HCM? I've tried the "User System Usage" OTBI subject area, and I'…Nick Dorfner 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
View the results in the Absence Calendar Real Time Entry ReportI have followed guidance from the 22B document to 'Generate Daily Breakdown of Absence Details Process' and the outcome of this process is to 'View the results in the Ab… -
How to bursting the BIP report and where we use the bursting conceptSummary: Hi Team, I'm still send the reports through schedule job only but we have butsting concept in BIP reports how can we send through bursting and where we can use …AjayKumar Maddipati 141 views 4 comments 0 points Most recent by Lohit Kad-Oracle Reporting and Analytics for HCM -
GET_VALUE_SET not returning any value in Fast FormulaSummary: Hi, I am using the Value Set of Table type in Absence Accrual Matrix formula but it is not returning any value in Fast Formula though scenario is valid. Expecte…
-
Looking for Last Contacted field for a candidate in Recruitment Module for reporting purposeSummary: Looking for Last Contacted field for a candidate in Recruitment Module for reporting purpose (Hiring à Candidate Search à Details à Key Highlights Content (requ…
-
How to create a link with dynamic user IDSummary: Content (please ensure you mask any confidential information): We have a button inside the Goals page where the manager can give feedbacks to the employee in an… -
CreateException:Index 6 out of bounds for length 6 in BIP reportsSummary: CreateException:Index 6 out of bounds for length 6 when I add 7th RTF template to the report I am getting below error and I am not able to delete extract RTF an…Gorla Shiva 81 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
OTBI analysis - Bar graph in OTBI analysis for acquiring the headcount trend for the past years on mSummary: We want to create a Bar graph in OTBI analysis for acquiring the headcount trend for the past years on monthly basis. For which we need to get active headcount …Shreya Datir 61 views 15 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Is it possible to show the "job" of the manager in the "Assignment Manager (Unsecured)" Dimension?Summary: I am creating a report to look at if employees who are direct or indirect reports for a manager are in the same function area. For example, if a top level manag…Max W 11 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Active Bank Accounts with different Display NamesSummary: I have a request to create an OTBI report which shows the active banks accounts with different Display Names against them, these names are likely to be spouses …
-
How can we replicate the Budget Analysis from Administration report in CompensationHi, We want to replicate as a OTBI Analysis the Budget Analysis from Administration report in Compensation in order to have information about the Overall Budget amount f…Crisenese 21 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to return only the max ID grouped by selected column (SQL)?Summary: Content (please ensure you mask any confidential information): I am working on an OTBI report that uses Advanced SQL to create the analysis. The reason for usin…Giuseppe Cannova 21 views 4 comments 0 points Most recent by Giuseppe Cannova Reporting and Analytics for HCM -
Oracle hcm cloud seeded reports what is the list of reports and their locationHello, I would like to know please, what is the list of Oracle hcm cloud seeded reports ? and where they are located ? for example : employee contact ,employee address ,…Revital Mefano 654 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Inhibition of downloading a specific reportSummary: Hi all, we would like to know if it is possible to inhibit the ability to download a report. Also, it would be helpful to know whether this functionality can be…Alessandro Nesi 21 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
OTBI Data Missing After Excel ExportThere are two instances with OTBI reports where I have gotten the message below that have impacted reports. In one report, hyperlinks are not working, and in another, ro…Alexander George Demczak III 26 views 2 comments 0 points Most recent by Sarma Yeddanapudy-Oracle Reporting and Analytics for HCM
-
Read-only Privileges for General Ledger TasksSummary: Kindly let us know if there are any read-only roles / view roles available for the following tasks: Financial reporting structure: Manage Chart of Account value…Ananya Das 31 views 1 comment 0 points Most recent by Julien_Dubouis Reporting and Analytics for ERP
-
How can we create drill down charts in Oracle BI Publisher (BIP) ReportsSummary: I want to create an interactive or drill down charts in BIP reports, where clicking on a chart updates the data in other charts and tables. Not sure how to achi…Neha Bhatt 211 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Does anyone know how to restrict data in BIP report based on user who will run it?Summary: How to restrict data in BIP report based on user who will run it? Content (required): Hello I am running report in BIP regarding no performance goal plan. Can y…Hazel De Castro 573 views 5 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
We have BI report but need to send custom schedule like 1st monday, 3rd monday in a monthSummary: Hi Team, We have BI report but need to send custom schedule like 1st monday, 3rd monday like this in a month how will send if through burshting how can we send …AjayKumar Maddipati 21 views 6 comments 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for HCM
-
BI Publisher reportingI primarily use OTBI for reporting and then copy the SQL from these reports if I need to create a BI Publisher report. I do this because I find it so difficult to find t…Paul Morrissey 21 views 3 comments 0 points Most recent by Bharat Agrawal Reporting and Analytics for HCM
-
How can we send the report or notification BI or OTBI different languages based on country or personSummary: Hi Team, I'm new to above type of requirement to convert or send the resptive languaes , how can we achive this type of scanario? Thanks, Ajay Content (please e…AjayKumar Maddipati 11 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
which table can store the information about user's parent & child relationship roles in fusion hcmHi All, Thanks for looking into this issue. I am looking for table, which can store the current logged user parent -child roles(for Ex: One big role have more number of …Ravindr-Oracle 101 views 10 comments 0 points Most recent by Rajesh.Vadlamani Reporting and Analytics for HCM
-
EEO-1 report output format in HCM CloudSummary: EEO-1 report output format in HCM Cloud Content (please ensure you mask any confidential information): We are in the process of generating EEO-1 reporting that …Parag Hiremath 21 views 6 comments 0 points Most recent by AlyssiaKing Reporting and Analytics for HCM -
what is seniority date and how will get in report and diffence between seniority date and Hire dateSummary: Hi Team, what is seniority date, how will get in BI or OTBI report and diffence between seniority date and Hire date. Thanks, Ajay Content (please ensure you ma…AjayKumar Maddipati 31 views 1 comment 0 points Most recent by Aliasgar Khambhaty-Oracle Human Capital Management
-
When manager run the BI report only need to get the details of direct or indirect reportiesSummary: HI Team, When manager run the BI report only need to get the details of direct or indirect reporties how can we develop this requirement? Thanks, Ajay Content (…AjayKumar Maddipati 12 views 1 comment 0 points Most recent by Ellen Manthei Reporting and Analytics for HCM
-
Talent Pools - Succession Plan KPI reportSummary: Need to build report using below fields - either OTBI or BIP. Kindly help please. Content (please ensure you mask any confidential information): Column Name Des…Pradnya_Pampatwar 21 views 1 comment 0 points Most recent by Pradnya_Pampatwar Reporting and Analytics for HCM
-
What is the diffrence between Date start and Orginal_Date_of_hire in PER_PERIODS_OF_SERVICESummary: Hi Team, we have to two columns for Hire_Date in PER_PERIODS_OF_SERVICE table what is difference between. if not why two columns given. Thanks, Ajay Content (pl…AjayKumar Maddipati 54 views 2 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM