Category 81-2
Discussion List
-
OTBI parameter issueSummary: Hi Experts, I need some assistance. I'm working on the Talent Profile Report and wanted to capture all the details in one report. I picked up multiple values by… -
Table name of language Level in skill and qualification sectionSummary: Does anyone know the table name of the language Level table name in the skill and qualification section? Currently, I'm using attached BI query to fetch the oth…
-
Want to change the configuration for salaried employees timecard.Summary: we want to change current configuration for salaried employees whose timecards information going to payroll,we want this to modified in such a way that only abs…
-
-
-
Get Time Card Period (Employee Time Card Details)Summary: We have a requirement to get employee's timecard (timeentry details) ... daywise. We have got the measure (days) from the table hwm_tm_rec using the resource_id…
-
OTBI Report not showing pictures when exported as Web ArchiveSummary: We have an OTBI report that stores images + html values. When extracted as Web Archive, first row displays image just fine, but row2 and row3 are only showing I…CAMIL_Q 12 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI Report Showing Which Cost Center Was Charged For Hours/EarnsSummary: I have a requirement to provide the YTD number of worked hours charged to a specific cost center regardless of the employee's home department cost center. What …JHaden3 47 views 1 comment 0 points Most recent by Srikanth Mandapati Panduranga-Support-Oracle Workforce Management
-
How to calculate number of continuous weeks of Submitted TimecardsSummary: For Casual workers who submit weekly timecards, I need to identify those that have worked 12 continuous weeks. Content (please ensure you mask any confidential …Richard Kemp-Eyre 28 views 1 comment 0 points Most recent by Srikanth Mandapati Panduranga-Support-Oracle Workforce Management -
need build a logic to pull only the approved time cards for that particular month.Hi We need to build a report to get the approved time cards for Payroll processing i can only find hwm_tm_rec which captures the data. How can i consider only approved t…
-
Profile strength report for checking Talent profile completion status reportingProfile strength report for checking Talent profile completion status for the Organisation reporting? I am not able to find the field for profile strength in OTBI or BIRevanth.Rondla 40 views 1 comment 0 points Most recent by Adriana Tudor-Oracle Reporting and Analytics for HCM
-
Time Between Promotion in Oracle Fusion HCMSummary: Time Between Promotion Content (please ensure you mask any confidential information): Hi Team, Please help to create query for Average number of months between …Hitha Harikumar 16 views 2 comments 0 points Most recent by Hitha Harikumar Reporting and Analytics for HCM -
Standard Hours From per_availability_details.get_availability_detailsTeam, We have a requirement to get the standard hours for particular period. We have two parameters. Period Start Date and Period End Date. Ex. We are passing 03-Dec-202…
-
Get Scheduled Hours From Assignment Work SchedulesWe have a requirement to get the scheduled hours from Assignment Work Schedules. We are trying with the below code but its not giving hours. SELECT * FROM ( TABLE(PER_AV…
-
Fetch Employees not a part of Talent Profile SectionSummary: We have created a Custom Section using the Skill Template under the Talent Profile Page. As followed fields HPI.ATTRIBUTE1 AS TRAINING_NAME, HPI.ATTRIBUTE2 AS B…YASHWANTH GOWDA H R 7 views 1 comment 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
query to get details of Potential assessment in talent review which is completed by the Managerneed to know the tables and links between the tables where to get the Manager Assessed Avg Performance, Manager Assessed Risk of Loss, Manager Assessed Potential, Manage…Sanduni Pathirathne 335 views 1 comment 0 points Most recent by Suman Chenumalla-Support-Oracle Reporting and Analytics for HCM
-
How to create analysis for Check-in Documents Created vs. Not Created?I need an analysis to get a list of employees who haven't created their Check-in Documents yet. I'm currently using Workforce Performance - Performance Check-In Real Tim…Welsey 37 views 2 comments 0 points Most recent by Suman Chenumalla-Support-Oracle Reporting and Analytics for HCM
-
OTBI > Ability to AggregateSummary: OTBI > Ability to Aggregate Content (please ensure you mask any confidential information): Hello All, In order to prevent the repetition of the Time Card Commen…
-
Only the latest active assignment details are extracted in Person Profile Real timeSummary: A worker having multiple active assignments, only the latest active assignment details are extracted in the below subject area Workforce Profiles – Person Profi…Suchayan_Garai 35 views 5 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
alert shown in succession planning screenSummary: There is an alert message shown in the Succession Planning screen. Need mapping of the table name and field name to find this information as we need to show thi…
-
OTBI report is taking too much timeSummary: Unable to run Time Card Status Report Content (please ensure you mask any confidential information): We devloped custome OTL report. When we are running for one…
-
Talent HCM Extract: In value set want to return multiple rows.Summary: for each employee under talent profiles there are some languages which person added for each language there is one content_item_code from table 'HRT_CONTENT_ITE…Abhijeet Kambare 45 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
report to show timecards that aren't approved (when the last editor was not the worker him/herself)Summary: Just sharing BI SQL. We have a need to output instances onto a report to show which worker did not re-approve a timecard that was edited by a member of our time…Shant_Sarkissian_WJG 65 views 2 comments 0 points Most recent by Shant_Sarkissian_WJG Reporting and Analytics for HCM -
OTBI/BIPublisher report for searching employees based on Talent ProfilesSummary: I am looking for a seeded or custom OTBI/BIPublisher report where there will be parameters like Language, Qualifications, Skills ,Work Preferences etc. (Talent …Sam2022 75 views 11 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
COUNT in a CASE statement for a calculated field in OTBISummary: Need to create a calculated field using COUNT and CASE statement Content (please ensure you mask any confidential information): I am using this Subject Area: Wo…Pradnya_Pampatwar 171 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Succession Candidate readiness Counts are off in reportSummary: I am trying to get accurate counts of Active Plan candidates (active assignment and active on plan) and while I'm able to pull totals accurately, the candidate … -
Pivot Table > Sorting Date in Ascending Order Not WorkingSummary: Pivot Table > Sorting Date in Ascending Order Not Working Content (please ensure you mask any confidential information): Hello, We want to display the time card…
-
Education Levels in OTBISummary: I'm not able to locate School name shown in the Education Levels section on Person Profile in OTBI. I don't see the Education Levels section under Person Profil…Gala Meyerovich 11 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Is there any way to create bulk users and assign them bulk roles. Also any limitations involved?Summary: Is there any way to create bulk users and assign them bulk roles. Also any limitations involved? Content (required): Is there any way to create bulk users and a…Lucky Sharma 93 views 7 comments 1 point Most recent by CHANDRESHWAR DWIVEDI Reporting and Analytics for HCM -
How do I pull the exact same timecard data that appears on the Oracle Team Time Cards screen?Summary: I need to create a data model that pulls the exact same data that appears on the Team Time Cards screen. We have OTBI reports that use the "Workforce Management…BeachDreamer 93 views 1 comment 0 points Most recent by Mohamed Mahrir Reporting and Analytics for HCM