Reports
Discussion List
-
How to use Listagg functionality in OTBI AnalysisSummary Listagg in OTBI reportsContent Hi Team, Listagg function in OBIEE reports is used to display multiple lov's in a a single row with (,)separator. How can we achie…Kalyani Koylada 873 views 8 comments 0 points Most recent by Tonya H Reporting and Analytics for HCM -
Only display the row with the earliest seniority dateSummary: Hi I'm creating a basic staff list which has seniority date on (some of our staff have protected service from a previous company) and I need to be able to show …HRJon 42 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Payroll - Calculation Cards Real TimeContent Good Morning, We are trying to find granular details with regards to Pension details. On the front end we can see in a sub-folder called 'Calculation Component D…User_2025-01-28-07-12-45-467 188 views 7 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM -
Report to get employee default expense accountSummary Report to get employee default expense accountContent Hi is there any report which can get what is the default expense account attached the employee please? this…User_2025-01-29-02-09-34-137 104 views 13 comments 1 point Most recent by Isabela Radivoi Reporting and Analytics for HCM
-
In past we get all questions from prescreen questions report but now two questions missing ?Summary: HI Team, In past we get all questions from prescreen questions report but now two questions missing ? any refrence and help me on . Please find issued SQL file.…AjayKumar Maddipati 21 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Report to get list of users who are lockedSummary I need to get a list of locked user accountsContent I looked at the 'Reporting on Application Users and Roles' section the Oracle documentation, but none of thos…David Villegas 1.6K views 17 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Identifying global transfer records, hire/rehire records from per_periods_of_serviceSummary: Identifying global transfer records, hire/rehire records from per_periods_of_service Content (please ensure you mask any confidential information): Hi All, Empl…Gayathri K M-Oracle 677 views 5 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Is there a way to show only data for a user that is running a dashboard?Summary: I have created a dashboard for several reports. It shows the user that last updated a record. Is it possible for the user that runs the dashboard to show only r… -
Can we dynamically change paramters value in each execution run of scheduled BI report.Summary: We want to change the report paramter value in each execution run of scheduled BI report. Content (please ensure you mask any confidential information): Version…Sourabh_Patial 32 views 4 comments 0 points Most recent by Sourabh_Patial Reporting and Analytics for HCM
-
Is there a way to get date tracked data for Per_periods_of_service tableI'm trying to figure out the date when the "Actual Termination Date" is changed, but Per_periods_of_service table has top of the stack record only. Is there a table that…
-
We can able to load the data in User-Defined Table Business objects but not able to see in frontSummary: We can able to load the HDL data but we can't able to see the data but in backend we can able to see the data. Note: If we entered manually in UDT then we can s…Ravindr-Oracle 70 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
To check if the requisition has Suspended state completion eventsHi, We had an issue in FAW, where for some requisition the suspended completion duration is missing. While debugging this issue, we are trying replicate the same in FA, …
-
Enabling HCM seeded Infolets in R11Summary We are in R11 and trying to enable Infolets by creating a Sandbox > Structures > Set system options and enable InfoletsContent We are in R11 and trying to enable…GopiKAutomus 189 views 4 comments 4 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Passing values from the UI to parameters in a BI Publisher reportSummary Looking for a method of passing values shown in the UI to parameters in a BI Publisher reportContent I have a requirement to filter a BI Publisher report based o…Ron Nelson 194 views 14 comments 0 points Most recent by Jaison Joseph-Oracle Reporting and Analytics for HCM
-
How to make hyper link in one of the column values in BIP reportSummary: I have to establish link between MEANING Column values to the respective bip report . Thanks For Your Help!! RavindraRavindr-Oracle 42 views 3 comments 0 points Most recent by Ravindr-Oracle Reporting and Analytics for HCM
-
How to improve the performance of OTBI dashboards and reportContent Hi, We have created a custom dashboard. And few reports are taking long time to respond. Can someone tell me how can I improve the performance of Dashboards and …Nivya Mathire 93 views 12 comments 0 points Most recent by Rizwan Basha Reporting and Analytics for HCM -
Not showing data in OTBI for other line manager type, how can we fix this?Summary: Right now, individuals with the manager type "Cross-Functional Manager" can't access any data about their direct reports in OTBI. The UI is behaving correctly; …Martijn van den Berg 22 views 2 comments 0 points Most recent by Martijn van den Berg Reporting and Analytics for HCM -
BIP| How to link two data sets/source using outer join.Content Hi, I am working in a report where I have two different data sets A and B . There is a column which is common in both the data sets. I can link both sets using t… -
Round to nearest 0.5 decimalSummary: Leave balance in hours, converted to days to 2 decimal points. Content (required): My formula is FLOOR("Front-Loaded Plan"."Accrual Balance"/7.4) however for so…Dawn Cawston - CPS 74 views 4 comments 0 points Most recent by Narendar Rao Naineni Reporting and Analytics for HCM -
We have OnBoarding_15Days_Report but timeout error coming on below querySummary: Hi Team, we have OnBoarding_15Days_Report its runing ok but few days onwords we getting error is timed out error, we apply one year durationand even schedule al…AjayKumar Maddipati 42 views 2 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
Fetching column for employee Feedback(in PD) whether it is completed/bypassed in OTBI reportsSummary: I have a requirement to add one column in OTBI report to fetch the status of employee feedback if is completed or bypassed. Can we use SQL query to fetch the de…Kamini Kaushik-Oracle 11 views 2 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM
-
In Salary report one employee showing two records, difference is one is old salary second new salarySummary: HI Team, In Salary report one employee showing two records, only difference is one is old salary and second one new salary , how can we get latest record (New s…AjayKumar Maddipati 63 views 8 comments 0 points Most recent by Amol Patil HCM-Oracle Reporting and Analytics for HCM
-
Need a sql to get "extra info" on "position details" pageHi All, I'm trying to find SQL tables and joins behind getting "Regulatory Licence Information" under Extra Info Section of Position Details. Navigation : Set up and Mai…
-
SQL to retrieve employee name,person number,department name and department DFF detailsSummary: SQL to retrieve employee name,person number,department name and department DFF details Content (required): Hi All, Please share SQL to retrieve employee name,pe… -
How to create User defined table (UDT)Summary: How to create User defined table (UDT) with screen shorts. Requirement: i want to store the below data in User defined table & which table can store this inform…Ravindr-Oracle 11 views 3 comments 0 points Most recent by Ravindr-Oracle Reporting and Analytics for HCM
-
Enhanced Analysis with parameters changesSummary: Created a Reports and Analytics Analysis which others users can run. Then I made modifications to the Analysis, saved it and now the others can still only run t…David Kubiak 12 views 3 comments 0 points Most recent by David Kubiak Reporting and Analytics for HCM
-
How to return Geographies using OTBISummary: We want to return Geographies (State, County and City) using OTBI. But the data should not return the geocodes but should return the actual name. Ex: State: LA …RenzelkeithCoquia 2 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
csv output giving multiple date format while using etext templateSummary: I have built a report to display a date column in dd-mm-yyyy format using etext template. the report output is displayed in text or csv. In both the cases when …Nisha_Hegde 74 views 9 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
How to filter the column values by another column?Summary: I'm currently creating an OTBI report under this Subject Area: Workforce Management - Checklist Real Time I want to filter employees which have these Response A…
-
Coding Conditional Formatting into LSQL?Summary: Logical SQL Conditional Formatting OTBI Content (please ensure you mask any confidential information): Hi All, When building a report in LSQL - I apply the SQL …William_Johnson 22 views 4 comments 0 points Most recent by William_Johnson Reporting and Analytics for HCM