Category 81-2
Discussion List
-
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 41 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 22 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 31 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 11 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 2 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 132 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 32 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 31 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 32 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 51 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 63 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 75 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 4 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 82 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 83 views 1 comment 0 points Most recent by Mohamed Mahrir Reporting and Analytics for HCM
-
Analytics > Administration > Manage Sessions > Ability to Trace Sessions for BI Publisher ReportsSummary: Analytics > Administration > Manage Sessions > Ability to Trace Sessions for BI Publisher Reports Content (please ensure you mask any confidential information):…Bernard T 15 views 1 comment 0 points Most recent by LakshmiCharitha Cherukuri-Support-Oracle Reporting and Analytics for HCM
-
How to query the Effective Start and End dates of job on job profileSummary: How to query the Effective Start Date and Effective End Date of Job Name/Code added to a Job Profile in OTBI. Content (please ensure you mask any confidential i…Vis Perera 36 views 1 comment 0 points Most recent by Satyabrata Nanda Reporting and Analytics for HCM
-
OTBI Talent Review Rating HistoryHello, I need to pull a historical record of Talent Review ratings. I know it's possible to pull Performance Document rating history, but I'm specifically being asked fo…Nick Dorfner 13 views 2 comments 0 points Most recent by Nick Dorfner Reporting and Analytics for HCM
-
how to read webcenter files using python script and extract informationcan we read the files which we uploaded through bi reports bursting into webcenter servers. while i'm the downloading the files in the webcenters they are not readable.Dara Nagasai 11 views 3 comments 0 points Most recent by Aaron Leggett Reporting and Analytics for HCM
-
Document of Records OTBI Subject Area not displaying dataSummary: Document of Records OTBI Subject Area not displaying data. Do we need to run any processes? Content (please ensure you mask any confidential information): Tryin…tiffnyc 34 views 6 comments 0 points Most recent by Linda Chirash-110035 Reporting and Analytics for HCM
-
Succession Plan Candidates dropped when Readiness Level Date From field is addedSummary: Content (required): I need to have the Readiness level effective date (Date From) included on a OTBI analysis. I'm using Workforce Succession Management - Plan …Gala Meyerovich 41 views 10 comments 0 points Most recent by Gala Meyerovich Reporting and Analytics for HCM
-
Talent Profile report not printing few valuesHi, I am looking to extract license and certifications, career preferences values in print profile Navigation: My career->My profile->skills and qualifications -> action…