Reports
Discussion List
-
Conditional Formatting in a BIP GraphSummary Conditional Formatting in a GraphContent Hi I have the requirement of conditional formatting to graphs in a Report, e.g., if the amount outstanding is less than …Misael Gutiérrez-Oracle 48 views 4 comments 0 points Most recent by Misael Gutiérrez-Oracle Reporting and Analytics for HCM -
How does per_ldap_users table get populated?Summary How does per_ldap_users table get populated?Content Two user accounts were created manually and assigned roles. I see that both of them are available in PER_USER…Naveen Bitra 97 views 3 comments 1 point Most recent by MandeepKGupta Reporting and Analytics for HCM -
SUCCESSION PLAN CANDIDATE READINESSSummary SUCCESSION PLAN CANDIDATE READINESS column detailsContent Hello Everyone, How to find current active record for the succession plan candidate readiness, as per o…VarunG 71 views 4 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Time to First PromotionContent Hi All, We're trying to measure time to first promotion (or the tenure an employee has on average before they're first promoted). Wondered if anyone has had luck…Lauren Owen 52 views 6 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Regarding e-text template used in HCM extractsSummary Regarding transformation on e-text templateContent Hi, We need to transform the date on the text template used in an extract.What we need is to add + 1 day in th…Nirmal Khanduri 52 views 1 comment 0 points Most recent by Nirmal Khanduri Reporting and Analytics for HCM
-
Query to get non person account detailsSummary Query to get non person account detailsContent Using the below query to get the non person account details but for few users the first name, lastname and email a…SuryaMuralidharan 64 views 2 comments 0 points Most recent by Janardhana K Reporting and Analytics for HCM
-
how to avoid multiple rows in OTBI ReportsSummary how to avoid multiple rows in OTBI ReportsContent Hi Team, we have a requirement to pull "Work E-mail" so i have written case statement with email type code as "…Chaitanya Jogi 112 views 12 comments 0 points Most recent by Praveen Kumar-146357 Reporting and Analytics for HCM
-
Report with two different As-Of-Dates to calculate Delta variationsSummary We need to pull two lines for employees, one referring to CURRENT_DATE and the other to the previous monthContent Hi All, we do need to calculate, for Payroll pr…Giorgio Innocenti-81771 28 views 4 comments 0 points Most recent by Giorgio Innocenti-81771 Reporting and Analytics for HCM
-
Need Subject area to get the Person Identifier number for external applicationsSummary Need Subject area to get the Person Identifier number for external applicationsContent Hi Team, Does any one have an idea on which subject area to use for gettin…Chaitanya Jogi 122 views 2 comments 0 points Most recent by Chaitanya Jogi Reporting and Analytics for HCM
-
Global Transfer ReportingContent Hi all - we have come across an issue for reporting that we need your expertise on. Recently, we found that a Global Transfer action-action reason can be correct… -
Prompt Filter - Date Format ChangeSummary We can't change filter's Date Format at promptContent Hi All, I added date filter with using Prompt for analysis. In Analysis, I can change date format as I want…Burakcan Sencan 93 views 12 comments 2 points Most recent by Burakcan Sencan Reporting and Analytics for HCM
-
Identify ALPHABETS in STRINGS in OTBIContent Hi All, We have an report where we need to identify ALPHABETS from a values coming up in the report as a filter criteria. For examples, pick all the Account numb…Vibha Pandey - Oracle 33 views 4 comments 0 points Most recent by Vibha Pandey - Oracle Reporting and Analytics for HCM
-
Payroll Check Details ReportSummary We have a requirement to pull out Payroll Check Details for an employeeContent Hi, Can anyone help me with a Sample query which will give Payroll Check Details (… -
Report for users with current rolesSummary Not able to pull all users for above reportContent Hello Folks - We have been using below report to satisfy one of our downstream system for periodic audits. Req…Naveen Bitra 49 views 6 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Audit report for user roles in HCMSummary Audit report for user roles in HCMContent Hi When I tried to pull the User roles report form the delivered LDAP report it is displaying roles which are currently…Kanishk Manda 208 views 3 comments 0 points Most recent by Naveen Bitra Reporting and Analytics for HCM
-
Entitiy Model/relationship diagram for HCM CloudContent Please could someone point us to the entity model / entity relationship diagram for the Bi reporting tables for HCM Cloud ThanksRebecca Smith-27468 78 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Is it possible to create a Data Model In Oracle HCM Cloud Using Multiple Datasources (One as SQL QueSummary Is it possible to create a Data Model In Oracle HCM Cloud Using Multiple Datasources (One as SQL Query Data Set and other as Static Excel Spreadsheet)Content Hi …AshishERPCloud 178 views 15 comments 0 points Most recent by Kalyan Amaravathi Reporting and Analytics for HCM -
'Column format - Suppress' do not work in OTBI Direct Database request reportSummary Suppress property in OTBIContent Hi All, I have created a direct database request report where I want to suppress a field 'Year' if the values are repeated. I us…SuryaMuralidharan 63 views 2 comments 0 points Most recent by SuryaMuralidharan Reporting and Analytics for HCM
-
Choosing All options from filter at the TableSummary We have department filter at one Table. We can't choose All.Content Hi All, How can we choose All options from one filter at the table. It allows only declared d…Burakcan Sencan 33 views 6 comments 1 point Most recent by Timothy Orrange Reporting and Analytics for HCM
-
Employees by Tenure and Age BandSummary Employees by Tenure and Age BandContent Hi I am looking for a report which has the Employees by Tenure and their Age band for the last 4 years. Could you please …Mansur Khalil 73 views 5 comments 0 points Most recent by Mansur Khalil Reporting and Analytics for HCM -
Unable to generate EEO-1 (Type 3 and Type 4 ) ReportSummary Unable to generate EEO-1 (Type 3 and Type 4 ) ReportContent I We have configured the EEO as per the note "Fusion US Payroll: How to Setup EEO-1 Report. Also appl…Venkat-ACN 111 views 1 comment 0 points Most recent by Tony Johnson-Oracle Reporting and Analytics for HCM
-
Analysis of seeded HR dash boardContent Hi Team, Can any one know where to find the analysis of seeded HR dashboard ? We have checked all the folders in reports and analytics.User_4VVG2 76 views 6 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Element Entry ReportSummary Element Entry ReportContent Hello Experts, Wondered if anyone could help with xml/sql that will help me pull out all the element entries against all employees (i…Ramson Maseko 339 views 3 comments 0 points Most recent by User_BO6Q8 Reporting and Analytics for HCM
-
Totals for Amount fieldSummary How to subtotal a field that does work when using "Totals After"Content Hello Experts, I am trying to create a subtotal of a field called "Amount" from "Benefits…Ewelina Januszewicz 51 views 6 comments 0 points Most recent by Ewelina Januszewicz Reporting and Analytics for HCM -
Query to get active and active uses in the systemSummary Query to get active and active uses in the systemContent Query to get active and active uses in the system.We have Crosse verified the per_users table but didt g…Koteswararao Yenikepalli 78 views 3 comments 0 points Most recent by Jagdish Varadraj Reporting and Analytics for HCM -
Using Distinct for OTBI reportsSummary We want to see only one result for specific areasContent Hi All, I have one report about absences and balances which belongs departments. We used Sum for some sp…Burakcan Sencan 888 views 6 comments 1 point Most recent by Burakcan Sencan Reporting and Analytics for HCM
-
Recreating HR dash boardContent Hi Team, Since the HR dash board willnot availabe after the latest patch, We are recreating it. We are facing following issue, 1. In one of the choice list "maxi…User_4VVG2 29 views 1 comment 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Query/Table to view BPM commentsSummary Query/Table to view BPM commentsContent Hello All, We have requirement to capture the Approver comments in a report. Let us know if you are aware of table/query … -
How to link Data Sets belonging to different Data Sources in Oracle BI Publisher in HCM CloudSummary Approach to link data sets created from WebServive and SQL Query Data SourcesContent Hi All, We have a requirement to build reports on data from external data so…Kalyan Amaravathi 49 views 3 comments 0 points Most recent by Ashish Shrivastava-Oracle Reporting and Analytics for HCM
-
Delivered Analytics on Pay Equity InformationContent Hello again customer connect community! I'm looking for information regarding delivered analytics in cloud HCM OTBI or your experiences reporting on pay equity. …