Category 81
Discussion List
-
Performance Task Status data is emptySummary: Workforce Performance - Performance Task Status Real Time returns the 'No Results' error. I checked and confirm that my role has the FBI_PERFORMANCE_MANAGEMENT_…George Chernikov 3 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
OTBI Report Is Not Showing Any Employee's Absence DataHello Everyone Summary: We developed an OTBI report to extract employee absence details (leave balance, unapproved leaves, total leaves taken, etc.) using the Workforce …Andriampeno Odilon 36 views 5 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
How to Query Reported Time for Specific Payroll Time Types Based on Time CategorySummary: I'm trying to query reported time entries for specific Payroll Time Types that belong to a particular Time Category — in my case, the category is called "**** T… -
Employees With or Without Goals Report - Missing dataSummary: Hello again, I need some help on my report. I need a report of Employees With or Without Goals. I created case statements for Total Employees, Goal Status (With… -
Need Help Identifying Tables for Custom Oracle Audit Report with Product, Business Object TypeSummary: Hello Oracle Community, I'm trying to build a custom audit report similar to Oracle's standard audit output with the following columns: User Product Event Type …Vishal Purohit 9 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Guidance to optimize OTBI HCM Cross-SA Reports having static report filters1- Some Cross subject area reports may be costly in terms of response time, if they are not designed correctly. It is always recommended to use (i) at least one common d…Abhishek Dixit-Oracle 136 views 2 comments 4 points Most recent by UdayrajSingh Reporting and Analytics for HCM -
Report Date Parameters needed START: (First_Day of Last month) END: (Last_Day of Last_month)Summary: Hi Forum: I'm looking to use below to accomplish General tab for Scheduling a report START: Last_Day(ADD_MONTHS(SYSDATE,-2))+1 First_day END: Last_Day(ADD_MONTH… -
How to gather data of update interest tab from all employees?Summary: We need to create a report which shows all the data user has entered in Update interest page. Basically we want to gather employee interest so that recruiter ca…Vaidehi Desai 9 views 2 comments 0 points Most recent by Vaidehi Desai Reporting and Analytics for HCM
-
No results if no filter is appliedSummary: Hi, We have an HR role with access to a compensation OTBI report. In order for the results to be displayed, HR must filter by at least one BU. However, if I ass…
-
how to call BIP report using REST webserviceSummary: I want to get the BIP report output using REST webservice REST API for Oracle BI Publisher - Run report I have followed oracle doc and this Run Oracle BI Publis…Ketan- 323 views 10 comments 0 points Most recent by Catherine Alequin Reporting and Analytics for HCM -
How to get Employees Annual Performance score in OTBI reporSummary: How to get Employees Annual Performance Overall Score rating in OTBI report. Content (please ensure you mask any confidential information): Version (include the…Ramani K 5 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Work Email is visible but Personal Email is blank for specific usersHi, We are experiencing an issue in Oracle HCM where a report that includes both Work Email and Personal Email behaves differently depending on the user running it. When…
-
ORA-64203: Destination buffer too small to hold CLOB data after character set conversion.Summary: How to solve ORA-64203: Destination buffer too small to hold CLOB data after character set conversion. Content (please ensure you mask any confidential informat…Stefano_Mazzocca 91 views 3 comments 0 points Most recent by User_FR8AH Reporting and Analytics for HCM -
SQL query to Backend table for Filtered List under Learning ManagementSummary: Hi Team, We need a backend table or SQL query to get Filtered Lists in Learning Management module. Navigation: My Client Groups → Show More → click Filtered Lis…
-
Time card details based on payroll flow - Load Time Card BatchesHi Expects, Requirement : Need to fetch time card details based on payroll flow - Load Time Card Batches. basically OTL report , based on payroll flow parameter. when we…Rajdeep Chavda 72 views 6 comments 0 points Most recent by Om Shukla-Oracle Reporting and Analytics for HCM
-
Hide Schedule and Job option from reportSummary: Hide Schedule and Job option from report Content (please ensure you mask any confidential information): Hello experts, does anyone know how to hide the followin… -
Looking for the Checklist Task Sequence in the Workforce management Checklist Real TimeSummary: Looking for the Checklist Task Sequence field in the Subject Area Workforce Management - Checklist Real Time Content (required): We are looking to add the Check… -
REST API to get worker assignment historySummary: How to fetch Worker Assignment History details using REST API Content (please ensure you mask any confidential information): The requirement is to fetch Worker …
-
extract element type id from xml cacheSummary: How to extract element type id from xml cache: When I try to extract the value , it is always throwing error : extractValue(value(ElementEntry), '//ElementTypeI…
-
Comment Column is splitting into multiple rows in Excel outputComment Column is splitting into multiple rows in Excel output for online BI template.
-
How to change the date format in OTBI promptSummary: How to change the date format in OTBI prompt. currently we are trying to change the accounting date column to mm-dd-yyyy format but we are getting syntax issue.…User_U4A6A 53 views 3 comments 1 point Most recent by Kuldipsinh Rajput Reporting and Analytics for HCM
-
Building an OTBI report using OTL data. Can't find Project RoleSummary: We are building an OTBI report to show all timecard entered for the week. We are project based company so our timecards include Project and task information, in…Anjula Mittal 25 views 3 comments 0 points Most recent by John Finnegan-Oracle Reporting and Analytics for HCM
-
Query to get interview details for a job requisition using BI ReportSummary: Hello Team, I am trying to get interviewer details (Interviewer person number and email address) using below query but I am not getting the right results. Can a…
-
Custom BIP reports - Security access to view scheduled job outputsSummary: Hi All, We have 5 custom BIP reports, which are shared via scheduling to 5 different groups of people in our organization. We are not sending the output via ema… -
Need Privilege to Edit or Add Location Details (Building, Floor etc) on Assignment PageSummary: Hello Team, We’re looking to identify the exact security privilege required to edit or add Location Details (Building, Floor, Office Number, Mail Stop) using th… -
What is the SA to use for Goals' Published Flag ?Summary: Hello, We need to display in an OTBI report the Performance Goals along with their Shared and Published flags. We are using Workforce Goals - Goal Status Overvi…
-
APISummary: Hi Expert, How to get the ( additionalInformationDetailsUniqID)? I have only URL and Offer ID how shall i get the additionalInformationDetailsUniqID? /hcmRestAp…
-
In the BI Report Need to remove the schedule, jobs and jobs history from the setting option.In the BI Report Need to remove the schedule, jobs and jobs history from the setting option.
-
Need to find the details associated with the Last Update Login value in fusion HCM.Summary: Content (please ensure you mask any confidential information): Hi all, I noticed that in my table, the Last Update Login column contains a key value (for exampl…gimhani nanayakkara 10 views 0 comments 0 points Started by gimhani nanayakkara Reporting and Analytics for HCM
-
Issues with section-level guided journey for the Assignment step in employment infoWe are having Issues with setting up- section-level guided journey for the Assignment step in Redwood employment info pages We are trying to follow steps under -https://…