Category 81-2
Discussion List
-
Plan Balance query - Carryover, Accrual etc ?Summary:I need to create a report that replicates the data from the Plan Balance screen - which tables? Content (required):I need to create a BI Publisher report that ha…ScottHillier 835 views 8 comments 0 points Most recent by ScottHillier Reporting and Analytics for HCM -
Formula for most recent grade name on current assignment?Summary: Subject Area: Workforce Management - Person Profiles Real Time Column: "Grade"."Grade Name" Content (required): Does anyone have a formula to pull in an employe…William_Johnson 41 views 6 comments 0 points Most recent by William_Johnson Reporting and Analytics for HCM
-
Impact Rating Model column filter breaks analysisSummary: Subject Area: Workforce Profiles - Person Profiles Real Time Column: Impact Rating Model Content (required): Hi All, We run into an error under the Workforce Pr…William_Johnson 21 views 2 comments 0 points Most recent by William_Johnson Reporting and Analytics for HCM
-
Need to fetching displayvalue of payroll time type from time entry layout component.Summary: Hi, We want to fetch the display value of the payroll time type from the time entry layout component. I am not able to find it in any OTL subject area. Has anyo…Piyush Pokharkar-Oracle 31 views 2 comments 0 points Most recent by Piyush Pokharkar-Oracle Reporting and Analytics for HCM
-
Query About Column Names for Source Tracking.Summary: I am creating one BI report in which I need to pull application source and application source details. In which table i can find it? I have checked in IRC_SOURC…Rajib_Samanta 71 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Facing issue unable to override Willing to relocate filed by using HDLSummary: We cannot override existing field that is "Willing to relocate " while updating existing field through HDL it is creating one more record. Navigation: Directory…User_2025-07-18-06-45-42-477 31 views 2 comments 0 points Most recent by MandeepGupta HCM Data Loader (HDL)
-
Guys, Do you know the table name that stores the where clause on Manage Value Sets page? Thanks VenSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):VENKATESHWAR GODA 21 views 3 comments 0 points Most recent by VENKATESHWAR GODA Reporting and Analytics for HCM
-
Terms (Leavers) with Most Recent Performance Score and Box AssignmentSummary: We need a report and bar chart that shows terms (resignation and term-invol), NO legal employer changes, with their most recent performance score- the Calculate…Rebekah Gilday 31 views 4 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Terms (Leavers) with Most Recent Box AssignmentSummary: We need a report and bar chart that shows terms (resignation and term-invol), NO legal employer changes, with their most recent box assignment from the Talent A…Rebekah Gilday 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
23A New Feature Summary and What’s NewSummary: 23A New Feature Summary and What’s New are now published to the Readiness site: https://www.oracle.com/webfolder/technetwork/tutorials/tutorial/readiness/offeri…Cindy Klymov-Oracle 161 views 0 comments 4 points Started by Cindy Klymov-Oracle Reporting and Analytics for HCM -
Analyzing Skills and Competencies asked on Job DescriptionsSummary: We are looking for a Reporting or a Tool to expedite the following request from our VP Talent. Content (required): Is there some way we can pull a bunch of job …Alvaro Couto 31 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM -
Need HDL to delete time card those re in entered stateSummary: Need HDL to delete time card those are in entered state Content (required): Need HDL to delete time card those re in entered state. If some has .dat file. It is…Swati U 161 views 1 comment 0 points Most recent by Srikanth Mandapati Panduranga-Support-Oracle HCM Data Loader (HDL)
-
need sample query with time card submission statusSummary: need sample query with time card submission status (Saved,Submitted, Approved etc) Content (required): need sample query with time card submission status (Saved…Ishtiaque AHmed 74 views 1 comment 0 points Most recent by Srikanth Mandapati Panduranga-Support-Oracle Reporting and Analytics for HCM
-
Created Eff for Extra internal info in candidate application details section in a requisition,Summary: I have created a eff under person extra info it is BI enabled . Content (required): I have run the ESS Job Import Oracle Fusion data extension for transaction B…Rajib_Samanta 172 views 4 comments 0 points Most recent by Rajib_Samanta Reporting and Analytics for HCM
-
Goals shared but not added to a planSummary: I'm looking for a way to identify employees that have goals shared with them but not assigned to their goal plan. I understand I can pull which goals are shared…Lauren B. 21 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Recruiting -Recruiting real time report relatedSummary: I have created two reports to fetch candidate details using Recruiting -Recruiting real time . I am getting duplicate data how I can restrict it , Also in one o…Rajib_Samanta 41 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
OTBI on Talent ReviewSummary: I have create a report that mimic the table (Name, Manager, Job, Location, Box Assignment, Performance Rating Model, Potential Rating Model, Risk of Loss, Impac…Ratha Sun 31 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Error in Analysis while trying to add schedule name to time and absence reportSummary: We have created an analysis using "Workforce Management - Processed Time Cards Real Time" subject to fetch employee details, department, and time entries with p…Goutham.Manthri 31 views 5 comments 0 points Most recent by Goutham.Manthri Reporting and Analytics for HCM
-
Hours and WagesSummary: FEMA Reporting Needs Content (required): Hello! Is anyone familiar with a subject area that I would be able to get wage and hour information for a given period …Liz McAllister 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to display URL or attachment in OTBISummary: After adding attachment url from subject area facing this error Content (required): Health and Safety module Version (include the version you are using, if appl…Surya -Oracle 151 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How can I display talent information with job, salary informationSummary: I need to pull current job code and title, salary, salary grade for associates and combine it with their most recent talent meeting results (i.e., date of meeti…User_2025-02-05-22-55-58-511 51 views 8 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Succession Planning duplicate rowsHi All, I would like to resurface a question from the following CCC post from 2020. We are experiencing the same issue where Risk of Loss and Impact of Loss are being re…Nick Dorfner 41 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Steps to create OTBI Report / BI Publisher Report for Planned Schedule → Time ManagementSummary: we need steps to configure Planned Schedule report which can be useful for HR Representatives and HR Admin which provides information of employees whose Worksch…
-
Where to check if employee received a pager unit and their on-call premium?Summary: I'm trying to look where in HCM this information can be visible: Employee received a pager unit and their on-call premium. Thanks!notautomni9 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Missing time card OTBI/BIP report or analysisSummary: Content (required): Is it possible to create an OTBI or BIP report to show employees who have not handed in their time cards? Either standard or customized repo…Nicolas Vahman 463 views 4 comments 1 point Most recent by user5969783 Reporting and Analytics for HCM
-
Careers of Interest - ReportHi, Anyone has sample report for "Careers of Interest" which comes under development goals? Or can anyone help me with the tables? Regards, NivyaNivya Mathire 31 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Where is 'Expedite Payroll' flag stored?Hi All, Summary: I'm trying to find what table is the 'Expedite Payroll' flag on timecards stored? Content (required): this is what it looks like in front-end Thanks!notautomni9 31 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Duplicate Data Issue : HcmTopModelAnalyticsGlobalAM.TimeRepositoryAM.ReportedTimeEntryPVOSummary: We have enabled BICC extract for HcmTopModelAnalyticsGlobalAM.TimeRepositoryAM.ReportedTimeEntryPVO for default column list, the extract data file has duplicate…SukantaBarari-Oracle 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Unable to get DFF and EFF fields in OTBI in Worker AssignmentSummary: Content (required): We are unable to get the following fields highlighted below in OTBI Subject Area "Workforce Management - Worker Assignment Event Real Time":…Vinay Gharge 71 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM