Category 81
Discussion List
-
To streamline the alert notification process by ensuring line managers receive a single notificationSummary: To streamline the alert notification process by ensuring line managers receive a single, consolidated email containing all the training due alerts for their dir… -
Request Feedback for Performance EvaluationSummary: We have two performance evaluation in the year. In the middle of the year (CheckPoint) and the end of the year (Final). We start with feedback through Request F…
-
SQL/OTBI query to get the Organization Payment Method and Payment sourcesSummary: SQL/OTBI query to get the Organization Payment Method and Payment sources Content (please ensure you mask any confidential information): We are looking a report…Visu 838 views 5 comments 0 points Most recent by GajavalliKoteswararao Reporting and Analytics for HCM
-
vacation plan accrual balanceHi Team, Please find the attached screenshot below. I’m looking for the balance days of the Accrual Plan Balance in the Vacation Plan. Could anyone please let me know th…Karthikeyan s-Oracle 12 views 5 comments 0 points Most recent by Karthikeyan s-Oracle Reporting and Analytics for HCM
-
How to enable horizontal scroll while creating/editing a xpt reportSummary: How to enable horizontal scroll while creating/editing a xpt report Content (required): Create a xpt report using data model having many columns, while trying t…Bhavna-Civeo 12 views 2 comments 0 points Most recent by PadmanabhamP Reporting and Analytics for HCM
-
Need Table name to pull Time Entry Layout Component in Time and LaborSummary: Need Table name to pull Time Entry Layout Component in Time and Labor Content (please ensure you mask any confidential information): Hi, Need Table name to pull…Sujeeth Chinta 107 views 7 comments 1 point Most recent by Nathan CCC Reporting and Analytics for HCM -
How to Group Payment Transactions Based on Running Total in Oracle BI Publisher E-Text Template?Hi everyone, I’m working on an E-Text Template in Oracle BI Publisher for a payment file, and I’m trying to group transactions based on a running total. The goal is to b…Karthik Adiga-Oracle 2 views 1 comment 1 point Most recent by Sivasekar Narayanan-Oracle Reporting and Analytics for HCM
-
Understanding of columns in PER_SENIORITY_DATES_SETUP for the setup Configure Seniority Date RulesSummary: Hi Team, We need to understand the purpose and use of these TRIGGERING_FIELD_TYPE, SOURCE_FIELD, OBJECT columns under the table PER_SENIORITY_DATES_SETUP for th…
-
need Sql Query of the balances with the below shown fieldsneed the SQl query which as fields like FIT Reduced subject witholdable FEDERAL TAX MARITAL STATUS FEDERAL NUMBER OF EXEMPTIONS STATE JURISDICTION INDICATOR YTD STATE TA…Kande_Likhitha 44 views 5 comments 0 points Most recent by Kande Likhitha Reporting and Analytics for HCM
-
Sql query or Table to fetch Compensation Worksheet data in BIP report based on securitySummary: Sql query or Table to fetch Compensation Worksheet data in BIP report based on the roles assigned to the user. Content (please ensure you mask any confidential …
-
"Last Logged on" Audit clarificationContent (please ensure you mask any confidential information): Summary: Wanting to understand where the "last logged on" value is derived from in the audit tables. For e…Emma Long 2 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
What is the minimum information necessary to update contractsSummary: Trying to create a data model and report to fix contracts that are missing PERIOD_OF_SERVICE_ID.I can run an SQL query on any of the tables, filter by PER_CONTR…Kameron Withak 22 views 3 comments 0 points Most recent by Ram_S06789 Reporting and Analytics for HCM
-
Name of the table that stores the 'Location Based Access' infoSummary: Hi, I'm trying to figure out the table name that stores the 'Location Based Access' info. Navigation: FA → Tools → Security Console → Administration → Location …ganapathysundaramd-Oracle 22 views 3 comments 0 points Most recent by Jun Ye-Support-Oracle Applications Security -
How to restrict user from entering future date in DFFSummary: How to restrict user from entering future date in DFF Content (please ensure you mask any confidential information): Hi All, we created one DFF for child birth …
-
OTBI Dashboard Reverted to Old UISummary: Hi team, We have a dashboard that has reverted to an older UI in both Test and Production environments. However, the same dashboard in DEV looks fine and retain…Josel Pleyto 107 views 3 comments 0 points Most recent by Josel Pleyto Reporting and Analytics for HCM
-
How to identify who removed a role for a specific userSummary: How to identify who removed a role for a specific user Content (required): Which table holds the details of who and when a specific user role is revoked for a p…Vinothkumar Somasundaram 325 views 2 comments 0 points Most recent by User_FPR9R Reporting and Analytics for HCM
-
Tracking Timely TerminationsHi Does anyone have or is aware of a report or dashboard that tracks the termination submitted for processing? We are having issues with overpayments to employees have s…Jose Guerra 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Oracle HCM BI Table to retrieve employees Eligible for a compensation planSummary: Content (please ensure you mask any confidential information): Hello experts, we are building custom BI reporting collecting compensation plan columns at the em…Valerio Curzi 29 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Payroll HCM Extract: Third Party Roll Up User EntitySummary: Would like to inquire if there are User Entities that could retrieve the Third Party Roll Up for Third Party checks in HCM Extract. We have identified that pay_…
-
BIP Report or Dashboard for Data at Security Console with RolesHi Team, I am trying to create a report for the below columns using either Subject Area or SQL Query. Trying to mimic the page of the Security Console as well as include…Swapnil Kashid 52 views 6 comments 0 points Most recent by Iann hick Reporting and Analytics for HCM -
Does anyone have a SQL Query or OTBI report that will list by employee hours worked for the year?We are needing 2024 Paid Hours. We tried running the Periodic Payroll Activity Report but because the data is so large when including hours, it will not complete. I need…
-
Historical report on positions held by active and inactive employee within a date rangeSummary: Looking for a historical report on positions held by active and inactive employee within a date range Content (please ensure you mask any confidential informati…M.Naing 4 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Matrix manager dimension in worker assignment real time subject areaHello Team, I have used attributes in matrix manager dimension of "Workforce Management - Worker Assignment Real Time" subject area to get all direct and indirect report…VMahesh 33 views 6 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
table name for 'Performance Goals and Documents' section in Quick action - Local and Global TransferSummary: Please help me in finding the table name for 'Performance Goals and Documents' section in Quick action - Local and Global Transfer page. Content (please ensure …
-
Remove deep link and suggestions from the bot responseSummary: I want to remove deep link and suggestions for specific users from the response coming from the custom components provided by oracle for HCM Skill. From the ima…
-
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 53 views 5 comments 0 points Most recent by Nick Dorfner Reporting and Analytics for HCM -
Dashboard on Development Area: hrr_tmpl_metric_configSummary: Goodmorning, we're fancing a problema with the Talent Review Matrix in the Dashboard Standard The matrix is empty: analyzing the query from the log, we've seen …AM HRE 11 views 1 comment 0 points Most recent by Sivakumaran Muthusamy-Oracle Reporting and Analytics for HCM
-
Long running BI report send notification message to userSummary: Hi Team, we have couple of reports are running in production environment are very long running its not throwing an error can you please suggest how to set the l…