Global HR
Discussion List
-
Bulk fetch failed. (HY000)Summary While casting date in the filter criteria getting error for BulK Fetch Failed - OTBIContent Requirement - Service Anniversary report (Need to get the Employees d… -
Monthly Headcount by Assignment Status for each MonthSummary Monthly Headcount by Assignment Status for each MonthContent The business is looking for Headcount by Month by Assignment Status. I tried using the Workforce Tre…Preston Schultz 53 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Auditing Hierarchy Loops in Department TreesContent Hi Guys, Does anyone happen to have a report that is able to show hierarchy loops within a department tree? We do currently have a report that shows which manage…Ivy__Valverde 35 views 3 comments 3 points Most recent by Ivy__Valverde Reporting and Analytics for HCM -
Autopopulated Prompt with Current_Date (SYSDATE)Content Hello everyone, We have a OTBI dashboard that contains analysis that is running As-Of date parameter. As-Of reporting was set up by adding SET VARIABLE PARAM_EFF…User_KOLMZ 201 views 7 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Backend Table column value for Ethnicity "Not_disclosed"Summary Ethinicity "Not_disclosed" backed table column valueContent Hello, Im trying to find Backend Table column value for Ethnicity "Not_disclosed". Attached is the sc…
-
OTBI Report MigrationSummary How to migrate OTBI Reports from one company's environment to anotherContent Currently company "ABC" is using OTBI tool for analytics purpose over HCM cloud data…Abhirup Nayak 46 views 3 comments 0 points Most recent by Varun Kota-112528 Reporting and Analytics for HCM
-
Headcount vs. Head Count DefintionsSummary There are at least 14 different headcount presentation columns in OTBI - when do you use whichContent I am new to OTBI and trying to understand when one would us…Brian Yu 136 views 2 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Custom Subject Area Content in Analysis / DashboardsSummary Receives errors when sharing an analysisContent So I built some analysis by using some custom subject content areas, i.e. Regions built from multiple locations. … -
How to use Choose and when condition in fusion hcm bip rtf templateSummary How to use Choose and when condition in fusion hcm bip rtf templateContent Hi Team, We have created BIP Report to send notifications based on legal employer wise…Bala Kasineedi-110368 66 views 7 comments 0 points Most recent by Bala Kasineedi-110368 Reporting and Analytics for HCM
-
REST API for Oracle BI PublisherSummary REST API for Oracle BI PublisherContent Hi. We are using webservices to use the REST API, we´re having an error with the URL for getting the PATch, postman gives…JAVIER COLLADO-125113 107 views 3 comments 2 points Most recent by User_IYN7Q Reporting and Analytics for HCM
-
How to hide Oracle HCM Seeded Report FoldersSummary Hide Oracle HCM Seeded Report FoldersContent Hello Everyone, Does anyone know how to hide Oracle HCM Seeded Report Folders? Attached is the screen-print for refe…
-
HR_LOOKUPS vs HCM_LOOKUPS ViewSummary Need to know the difference between HR Lookup and HCM Lookup viewContent Can anyone let me know the difference between HR Lookup and HCM Lookup view. From view S…Parthiban Vaithiyanathan 168 views 1 comment 0 points Most recent by Janardhana K Reporting and Analytics for HCM
-
Cant see reports saved in My FoldersSummary Cant see reports saved in My FoldersContent User has same roles and OBI privileges as me. When i save any personal analysis reports to My Folders i can see them …Junade Shujaat-143572 47 views 3 comments 0 points Most recent by Junade Shujaat-143572 Reporting and Analytics for HCM
-
BI Publisher model to find stuck transactions in HCMSummary Has anyone a data model that will find stuck transactions within the HCM moduleContent Has anyone developed a data model that will find all of the stuck transact… -
Back end table name for "Hourly Paid or Salaried"Summary Backend table and column name for Oracle HCM data element "Hourly Paid or Salaried "Content Good Afternoon, Does any one know back end table and column name for …
-
Manager HierarchyContent Hi , Iam trying to create a employee hierarchy report (display complete employee hierarchy in a single row) using "Parent Manager" . Iam getting a lot of blank e…Manish Sharma-24619 121 views 17 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Worker Assignment Event history - job title "as of" assignment effective dateSummary Pulling data relevant to the history effective datesContent We have a report that is pulling all assignment events for an employee -- essentially a full summary …Cheryl Burwell 137 views 4 comments 1 point Most recent by Cheryl Burwell Reporting and Analytics for HCM -
Limiting Results of Reports Based upon Data Security Level DefnintionSummary Limiting Results of Reports Based upon Data Security LevelContent We have custom HR roles which limit some users from functions and AORs used for approvals. Is i…donna dantzler 82 views 3 comments 1 point Most recent by Rahul Bedia Reporting and Analytics for HCM -
Probation Confirmation letter Automation in Oracle fusion HCMSummary Probation Confirmation letter Automation in Oracle fusion HCMContent Hi Team, I have to create the bursting report, in which whenever probation status for an emp…nitin Sharma 71 views 5 comments 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Dashboard prompt returned error (Failed to load (Odbc driver returned an error SQLExecDirectW).)Content Currently I am using SQL Results option to populate value of a dashboard prompt called "Global Job Band".I am using below SQL code for this : Select SUBSTR ("Gra…Abhirup Nayak 46 views 2 comments 1 point Most recent by Abhirup Nayak Reporting and Analytics for HCM
-
Extract all values from Person Profile Content Type in single cellSummary I want the entire contents of an employee's "Skills / Areas of Expertise" in one cellContent Hello I'm looking for a way to combine everything an employee entere…Ryan Davis-43690 91 views 1 comment 0 points Most recent by Gabrielle Ungaro Reporting and Analytics for HCM
-
probation confirmation Letter automation in oracle fusion HCMSummary Probation Confirmation letter Automation in Oracle fusion HCMContent Hi Team, I have to create the bursting report, in which whenever probation status for an emp…nitin Sharma 513 views 2 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI Need subject areas with Representative Name to be pulled into reportContent Hi Team, We have captured HRBP in the representative section of Manage Employment. Now I want to capture that information in my OTBI report. But I am not able to…User_DYMHE 169 views 2 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Display Number as Number in Excel output of BI publisher reportContent I have a report which displays employee ids as part of the report. Now when I export that excel output it shows as Number stored as text and it comes with that y…
-
Audit report to see pending approvals on new hireContent I am looking for a report in which you can see status, whether it is in approved, pending or reject for a new employee hiring process. Also to see if there is an…User_WHB5J 74 views 2 comments 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM
-
“Top Manager” prompt removing data from outputSummary “Top Manager” prompt removing data from outputContent We have a Goal Alignment report using the "Workforce Goals - Goal Status Overview Real Time and "Workforce …Shawn McDonald 44 views 5 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Combining cost allocation and FTESummary Combining cost allocation and FTEContent Hello does anyone has experience merging * FTE coming from Workforce Management - Worker Assignment Real Time and * Cost…Jean-Francois Prevost 55 views 1 comment 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM -
HCM InfoletsSummary I assume their are delivered HR Infolets but am unable to figure out how to configure / enable themContent I assume their are delivered HR Infolets but am unable…amy markovitch 152 views 3 comments 0 points Most recent by Mark_Daynes Reporting and Analytics for HCM
-
Date Issue in Oracle fusion HCM BIP Excel templateSummary Date Issue in Oracle fusion HCM BIP Excel templateContent Hi All, We have created new report to get employee nominee details using Excel Template. Report Output …Bala Kasineedi-110368 48 views 11 comments 0 points Most recent by Bala Kasineedi-110368 Reporting and Analytics for HCM
-
Workforce Trend with Colleague Real TimeSummary Calculate turnover based on Passport Type that sits within Colleague Real TimeContent Hello, I have been able to calculate turnover based on colleague gender, et…Lauren Emberton 27 views 2 comments 1 point Most recent by Lauren Emberton Reporting and Analytics for HCM