Category 81-2
Discussion List
-
Table in HWM similar to HXT_TM_MTRX to fetch attribute values in a single recordSummary: Table in HWM similar to HXT_TM_MTRX to fetch attribute values in a single record Content (please ensure you mask any confidential information): Hi, We understoo…
-
Need SQL Query to fetch degree of the employeeSummary: Hi experts, I need an SQL query to retrieve the degree of an employee. If possible, please provide sample data along with the table and column names to help me …Arti_Priya 15 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Capture in OTBI the Attachment field in a Person Profile Real Time subject areaSummary: Content (please ensure you mask any confidential information): hi there, There is a field "Attachment" out of the box field at the bottom of the Talent Profile …Bobby Jourdan 14 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Time Change Request reportSummary: Hi All, Has anyone Developed a BI/OTBI Report on Capturing Details of Time Change Requests? We have a requirement and working on this. Appreciate if anyone can …Abhishek Bhaskar 20 views 3 comments 1 point Most recent by Peeyush Chandel Reporting and Analytics for HCM
-
How to report on "Job Description" from "Job Profile"Summary: I need to report on job description and effective start/end date within each job [model] profile, but i can't seem to find it from BI. I tried to query few tabl…
-
Submitted Timecard and Web Clock Details ReportSummary: Need to SQL query for view the detail of submitted timecard and web clock's reported hours and schedule deviation with custom attribute. Content (please ensure …Melek Cinar 305 views 6 comments 0 points Most recent by Melek Cinar Reporting and Analytics for HCM
-
How to join a Timesheet Row to an Absence Row (HWM_TM_RPT_ENTRY_V to ANC_PER_ABS_ENTRIES)Summary: If we have a person with 2 timesheet rows on the same day, each representing half day of absence, and we have 2 absence rows each of a different absence type - …
-
Is it possible to access the performance document from the "Prepare Review Content" in Talent ReviewSummary: While preparing the review content, manager should be able to view performance document of their direct reports. This will allow managers to easily assess and r…
-
unable to load competencies due to QualifierId2Summary: I've tried to load Talent Profile Competencies multiple times, but no luck. First time around I tried with no QualifierId2/QualifierCode2 column and then second…User_H77SF 1 view 1 comment 0 points Most recent by Madalina Danis-Support-Oracle HCM Data Loader (HDL)
-
Example Feedback Report query for BI Publisher based on Feedback requests and Questionnaire tablesSummary: Our requirement is to generate a report based on feedback requests and questionnaire (eg. Annual Performance Feedback) tables. Manager will submit Feedback Requ…MadhuLekkala 16 views 2 comments 0 points Most recent by MadhuLekkala Reporting and Analytics for HCM
-
Oracle query to get values on 9 box grid for a person in HCM fusion talent review meeting reportOracle query to get values on 9 box grid for a person in HCM fusion talent review meeting reportDeepeeka Nath 46 views 4 comments 0 points Most recent by Neno Kolonich Reporting and Analytics for HCM
-
BI Report Time card details - Calculated details by earned dateSummary: Team we have a requirement to fetch all the details available in the timecard. (Calculated details by earned date) - Screenshot attached. I am using the below q…
-
Time Entry Audit Report for Reported timecards.Hi Team, I am trying to build a report, where we will show the Time audit details like Person Number, Time Type before change, Time Type after change , Timecard start ti…Khush Tiwari 279 views 7 comments 0 points Most recent by Melek Cinar Reporting and Analytics for HCM
-
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…Rajdip Chavada 31 views 5 comments 0 points Most recent by Indushree Reporting and Analytics for HCM
-
Workforce Management - flexfields visibilitySummary: Claro Guatemala is having issues with flexfields when migrating Absences screens. The issue is those fields were hidden in classic screens but once in Redwood, …Felipe Matallana-Oracle 1 view 0 comments 0 points Started by Felipe Matallana-Oracle Workforce Management
-
Sql query required to identify time card approver and assignee detailsSql query required to identify time card approver and assignee details. We tried to join hrc_txn_header, hrc_txn_data and fa_fusion_soainfra.wftask to get the details. B…
-
How to run the Talent Profile seeded report?Summary: I need to export an XML file, but I won't be able to view all the fields and content sections. See below parameters used: Version (include the version you are u…
-
Table for timecard approval informationSummary: Reaching out for approval information of timecard which we need to fetch from BIP Report. Please advise which table currently holds this information. We underst…
-
Report on Career AmbassadorHi, is there any Oracle HCM table available to report employees who signed up for Career Ambassador?Francesco Cerioni 23 views 5 comments 0 points Most recent by Francesco Cerioni Reporting and Analytics for HCM
-
How to change or migrate the nonunified Time layout sets to unified layout sets?Summary: How to change or migrate the non unified layout sets to unified layout sets? We have configured the nonunified Time layout sets and we need to change it to unif…
-
Certification: Retrive attachments information with OTBI or BI PublisherHello, our customer asks to retrive the information associated to the attachments section of certifications (URL and PDF), is it possible? if so, how? Any advice? Thank …
-
Max Effective Date Record on a Combined Subject Area Report Or Null ValueSummary: We are trying to bring back one row for Performance Task Completion Date, either the Null row or the latest completion date. Using "- Performance Task Status De…Kristin Montoya TWU 1 view 1 comment 0 points Most recent by Sivakumaran Muthusamy-Oracle Reporting and Analytics for HCM
-
Table names to get reported time and calculated time on time card for reportingHi, We need a timecard report comparing the reported time vs the calculated time. Can anyone please share table names to get reported time and calculated time on time ca…
-
Report showing working days per person for a period based on work schedule assignedSummary: Trying to report on working days for people based on Work schedule. Content (please ensure you mask any confidential information): I am trying to create an OTBI…
-
Time and Labor Value Set Issue after 23C on Web Clock_TCF Initialization FailedSummary: Hello, A few weeks ago, we transitioned to version 23C. After 23C I have created new layout set for new HCM group like before. The layout set is working but lin…
-
How can i get Performance current task name in OTBI?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Juhi Kumari 14 views 1 comment 0 points Most recent by Sivakumaran Muthusamy-Oracle Reporting and Analytics for HCM
-
Need a sample query of Team Time Card page, to fetch Reported hours of Calculation Time.Summary: Query to fetch Reported Hours in Calculated time section of Approved Time cards for an individual. Content (please ensure you mask any confidential information)…Sujeeth Chinta 59 views 2 comments 0 points Most recent by Sujeeth Chinta Reporting and Analytics for HCM
-
Performance Manager Not Appearing in AnalysisSummary: We are trying to create a report for our Performance Reviews that is able to show us an individuals Performance Review Status, Score, and other details. As part…Brent_Beardsley 11 views 2 comments 0 points Most recent by Brent_Beardsley Reporting and Analytics for HCM
-
Do we have feasibility to get the employees without performance document attached in OTBI report?Summary: Do we have feasibility to get the employees without performance document attached in OTBI report? This should be work based on Prompt basis like review period, …
-
Page header is showing NULL trying to Change Title Name using Page ComposerHi Team, We are trying to change the page header from NULL to title using page composer, it is effecting all the pages. Can you please guide us how we can change it for …Bhuvaneswari Konduri-Oracle 6 views 0 comments 0 points Started by Bhuvaneswari Konduri-Oracle Workforce Management