Category 81-2
Discussion List
-
Time card approval history tables in Oracle HCM CloudWhat are the table names that store approval information for Time and Labor? Looking for timecard approvers names, dates and times as well as the status of the timecard. -
Database Table name for Approval DelegationsSummary: We have a requirement to build a report for approval delegations, thus need the database table name for Approval Delegations. Navigation: Person Management > Se…
-
Week Number calculation for OTL Overtime report if week starts from saturday and end on fridaySummary: Hi Team, We need to calculate the weeknumber for a overtime card report. Week will start from saturday and end on friday We need to pass "from week" and "to wee…
-
Table for Payroll Transfer Status and Payroll Processing StatusWe need to get Payroll Transfer Status and Payroll Processing Status. Where are these information gets stored? Please share if you have any inputs. We have tried using p…
-
Oracle Fusion BI Publisher - Excel Template - Generate Multisheet Report Excel OutputSummary: Hi Team, We have a requirement where we need to generate an excel output with 3 tabs in the output file. Sheet1 name: Static value as "Parameter" and it has to …
-
Is there a table that store calculated time in time cardHello, I would like to ask whether this information is stored directly in a specific table or if it is derived through a calculation. Kindly advise. I've seen this view …
-
How to Default Assigned Project to Web Clock and Time Card Based on Project Execution AssignmentSummary: Hello, In Oracle Time and Labor, we want the Project field in both Web Clock and Time Entry Layout (Time Card) to be automatically defaulted with the project th… -
Absence Type and Absence Reason not visible on employee's timecardSummary: Hi, has anyone here encountered an issue where, when an employee logs an absence with a reason, the timecard shows nothing? I have set up the absence reason and…
-
Analysis showing projected absence accrual at year endSummary: Hi We have a periodic accrual scheme for annual leave which accrues monthly at the month end. However we give our employees their entitlement up front (e.g. Mr … -
enhanced talent profile HDLSummary: Hi everyone, In Redwood,We cant update the existing talent profile item values. To update existing values we need to populate learning or certificate label.Plea…Krishna Manmohan 11 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
SQL Query to get calendar attached to employee .Summary: Dear Team: We need to get the calendar details for an employee. Navigation is Login as an employee→Time and absences→Calendar Content (please ensure you mask an…
-
While running the talent report the technical competencies are not fetching for one employee.Hi Team, Need assistance on talent report, the report not fetching the technical competencies for one employee. But when we run the data model the data is coming. Thank …xbyz-Oracle 1 view 1 comment 0 points Most recent by Soumya Suravita Reporting and Analytics for HCM
-
Oracle HCM Fusion Table to find Business capability in Oracle content ItemsDear Team, We are trying to fetch the business capability field from below navigation: Navigator > My Client Group > Profile > Item Catalog > Search for Skills Library >…
-
SQL query for Planned Schedules on Time ManagementHello! I need help in developing an SQL query for generating the Planned Schedules for employees on the Time Management navigation: My Client Groups>Time Management> Pla…Hassan Mohsin LC 31 views 6 comments 0 points Most recent by ganesh_b-Oracle Reporting and Analytics for HCM
-
subject area for learning item in Development PlanSummary: Hi all, I am trying to retrieve the subject area for a specific section of Development Plan. 1. 2. So far I have retrieved all table info related to "Basic info…Silvia Stangarone CAI 11 views 0 comments 0 points Started by Silvia Stangarone CAI Reporting and Analytics for HCM
-
In Oracle Fusion TEST, Profile Codes shown in front end but not in HRT_PROFILES_B table.Summary: In oracle fusion TEST instance, am able to see the Profile Codes for Talent Profiles in front end, but am not able to see it in HRT_PROFILES_B Table. Whereas I …Gopika Prem Kumar 11 views 0 comments 0 points Started by Gopika Prem Kumar Reporting and Analytics for HCM
-
Table for Time Type in TimecardWe have a requirement to fetch the time type from timecard. pay_payroll_time_type from hwm_tm_rep_m_ptt_atrbs_v is not returning any value. Could someone guide me on thi…
-
'Time type' field column mapping from which table to fetch itSummary: Hi All, We are creating one report to get the employee overtime unpaid overtime details. we are looking for 'Time type' field column mapping from which table to…
-
Time card details query in Fusion OTLSummary: Hi All, We are creating one report to get the Time card details. we are looking for 'Time type' and 'Override dept costing' fields. We couldn't able to find the…Sai Krishna Chelikani 3.6K views 7 comments 0 points Most recent by Sri N Reporting and Analytics for HCM
-
Ability to Report on Person Profile Competency Rating vs. Model ProfileSummary: Hello, I need guidance on whether it's possible to generate a single analysis that compares an employee's rated competency with the competency level associated …Emily Cox 111 views 8 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
hwm_timecard_report.timecard_totals - Specification (Oracle Fusion)An Oracle Fusion seeded report for displaying bulk timecard approvals is executing the TimecardApprovalNotificationBulkReport which displays a PDF on screen. The data mo…Scotty C 63 views 1 comment 0 points Most recent by Srikanth Mandapati Panduranga-Support-Oracle Workforce Management
-
Filter Talent Review 9-Box to Most Recent RatingSummary: Measures calculating percentage of employees by 9-box rating are including old ratings that have been filtered out of the analysis. Content (required): We have …
-
filter out html imputs in columnSummary: Im making a reporting for talent and need to filter out de html inputs in the Description field of the table HRT_CAREER_STATEMENT_ITEMS_V. is there a better way…Lucas B Maciel 11 views 0 comments 0 points Started by Lucas B Maciel Reporting and Analytics for HCM -
Max Effective Date Record on a Combined Subject Area Report Or Null ValueSummary: We are trying to bring back one row for Performance Task Completion Date, either the Null row or the latest completion date. Using "- Performance Task Status De…Kristin Montoya TWU 1 view 2 comments 0 points Most recent by Gretch Atienza Reporting and Analytics for HCM
-
Display Value for Time Entry Layout Component fieldSummary: Display Value for Time Entry Layout Component field Content (please ensure you mask any confidential information): Hello, I have a time entry layout component o…Irina Erhan 123 views 7 comments 0 points Most recent by Rob Williams Reporting and Analytics for HCM
-
Time Entry Audit Report for Reported timecards.Hi Team, I am trying to build a report, where we will show the Time audit details like Person Number, Time Type before change, Time Type after change , Timecard start ti…Khush Tiwari 368 views 8 comments 0 points Most recent by Debasmita Das Reporting and Analytics for HCM
-
Is there a way to add field of Responsibilities under Work Experience when printing the candidate?Is there a way to add the field of Responsibilities under Work Experience when printing the candidate details?Shaina_Manalo 11 views 1 comment 0 points Most recent by Jessica Reilly-Oracle Recruiting, Opportunity Marketplace
-
PER_PERSON_SECURED_LIST_V showing own recordsSummary: Hi, We have some reports created with PER_PERSON_SECURED_LIST_V one employee is from a country A with AoR from country B, on person management the employee cant…Lucas B Maciel 12 views 3 comments 0 points Most recent by Nidhi Prasad2 Reporting and Analytics for HCM
-
hcm group evaluation process displaying in running status from long timeSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
How do I source: profile item id for spreadsheet loaderSummary: Talent profile upload - ProfileItemId issue Content (please ensure you mask any confidential information): I need to create an HDL for talent profile and one of…