Category 81-2
Discussion List
-
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 1 view 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 277 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 33 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 31 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 71 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 155 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 1 view 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 81 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 81 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 42 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 55 views 1 comment 0 points Most recent by Satyabrata Nanda 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…
-
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…
-
Absence type in time card entrieSummary: There is a requirement to fetch the Absence type column in time card entries but in backend the value is not falling for the persons as Absence type is there fo…Shubham Prajapat 123 views 8 comments 0 points Most recent by ASHOKKUMARFUSION-Oracle Workforce Management
-
Mass printing of Performance Documents is not translatedSummary: Our current language on HCM is italian, but the mass printing is in english language Content (please ensure you mask any confidential information): Is there a w…Giuseppe Casalino 21 views 2 comments 0 points Most recent by Giuseppe Casalino Performance Management -
per_availability_details.get_availability_detailsTeam, We have a requirement to get scheduled hours from work schedules for all the assignments which falls in the period passed in parameter time period start date (:TC_…
-
OTBI > Transpose Rows to Columns in OTBI > Ability to Perform Sum Only on One RowSummary: OTBI > Transpose Rows to Columns in OTBI > Ability to Perform Sum Only on One Row Content (please ensure you mask any confidential information): Hello, We want …
-
I need to retrieve previous year performance ratings , which tables can I useSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…PranayBhargava13 1 view 1 comment 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM
-
Possibility to Create Dynamically Different Tabs of The Same Report by Passing Diff. Param’s ValueSummary: OTBI Dashboard > Possibility to Create Dynamically Different Tabs of The Same Report by Passing Different Parameter’s Value Content (please ensure you mask any …Bernard T 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM