Category 81-2
Discussion List
-
Sql query that retrieves the total number of processed hours claimed by an employee in OTLI need sql query that retrieves the total number of processed hours claimed by an employee in Oracle Fusion Time and Labor. -
Need help in creating new Talent Profile printable versionSummary: How to create new Talent Profile printable versionRavindr-Oracle 11 views 2 comments 0 points Most recent by Christine Yokoi-Oracle Reporting and Analytics for HCM
-
Table name or query to get timecard transferred to payroll detailsSummary: We need Table name/ Query/ Report to fetch details of the timecard transferred to payroll status. We have observed that when we run the Load timecard batches fl…
-
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…
-
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…Jinusha Glory 72 views 1 comment 1 point Most recent by Srikanth Mandapati Panduranga-Support-Oracle Workforce Management
-
Transactions Tables are not storing Data for few TransactionsSummary: Hi Team, I am trying to fetch the transaction details for Time Change Request Approval. But I have encountered that there two tables that were not storing any d…Dasari Dileep 283 views 5 comments 0 points Most recent by kanchana venkatasubramanian Reporting and Analytics for HCM
-
Licenses & Certs appearing on OTBI report but not seen in systemSummary: We are seeing a few different scenarios where our OTBI report is pulling in active (not expired) Content Items for employees, but we're not seeing them represen…Jessica D 61 views 5 comments 0 points Most recent by Sivakumaran Muthusamy-Oracle Reporting and Analytics for HCM
-
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…Abhishek Jois 259 views 2 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
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…Nitish Maheshwari 21 views 1 comment 0 points Most recent by Srikanth Mandapati Panduranga-Support-Oracle Workforce Management
-
Attachments - Deeplink in OTBIHi, Is it possible to have a deep link for attachments in OTBI so that the person accessing the report can view the respective attachments, such as PDFs, highlighted in …
-
TABLE/SQL FOR TIMECARD CUSTOM ATTRIBUTESSummary: There are 2 custom attributes created in Time and Labor under Time Layout Sets and it shows in the UI. Time Layout Sets. When entering timecard What specific Or…Mark Jayson Tamaray 33 views 1 comment 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM -
Incomplete Time Card ReportSummary: The Business is running into issues with employees submitting time off through the Absence module that automatically transfers to the Time Card, but the employe…
-
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 1 comment 0 points Most recent by Barbara Fox -Oracle Workforce Management -
Need table names or SQL for Approved OTL timecard details in BIPSummary: Hi Team, I Need table names or SQL for Approved OTL timecard details in BIP. We need particular person entries and along with approver comments. Navigator->my c…Janardhan ACS-Oracle 262 views 5 comments 0 points Most recent by Satyam Roy Reporting and Analytics for HCM
-
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…
-
SQL to fetch the history ratings from talent profilesSummary: Hi, Could any help me with the SQL Query or table names to fetch the ratings from the talent profile. Navigation: Me>career and performance>skills and qualifica…
-
how to update expected hours using learning record HDLSummary: Wanted to update the expected hours for learners using LearningRecord.dat HDL file. But the field is not present to update in the HDL. Content (please ensure yo…Suman S Araleshwar 2 views 1 comment 0 points Most recent by Suman S Araleshwar HCM Data Loader (HDL)
-
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 51 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 11 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 38 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 461 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 - …
-
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 57 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 56 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 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 61 views 5 comments 0 points Most recent by Indushree Reporting and Analytics for HCM
-
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… -
Report on Career AmbassadorHi, is there any Oracle HCM table available to report employees who signed up for Career Ambassador?Francesco Cerioni 21 views 5 comments 0 points Most recent by Francesco Cerioni Reporting and Analytics for HCM -
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 …