Category 81
Discussion List
-
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 28 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 31 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 113 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 333 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 5 views 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 43 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 55 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 10 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 41 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 59 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 13 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…
-
Which SQL Table store the Activity Information of Time Entry in OTL.Summary: If you have BIP SQL handy. Please share Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable…Ketan-Oracle 20 views 2 comments 0 points Most recent by Ketan-Oracle Reporting and Analytics for HCM -
Female turnover rates of DashboardI'd like to ask that if I select the Female as the Gender, how is the female turnover rates calculated? Is the denominator of the ratio in relation to all employees or o…Chen, Reyna 27 views 2 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
I have developed custom resource alert using workers api but it's not trigger notification for HRSummary: I have developed custom resource alert using workers api to trigger notification to HR if any employee return from maternity leave but it's not trigger notifica…
-
In which case primary flag condition is null in WLF_AR_RELATIONS_F table?I'm trying to fetch course assignment details along with corresponding offering assignment details, in some cases the primary flag is null and for some cases it is 'Y' o…
-
course usage reportHello, I would like to create a report to see course usage to potentially achieve trainings that have not been used for a while. Any suggestions on how to create this re…Sara.Zhao 15 views 1 comment 0 points Most recent by Abdul Rauf Mohammad-Oracle Reporting and Analytics for HCM
-
Time spent per approver in workflow approvalsSummary: We have a requirement to report out how long a specific workflow proves (Approve Job Requisition) remained with each approver within the workflow. Is there a re…Audrea Miller 15 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to Remove Duplicate Rows from Pivot table in OTBISummary: In excel - once you add the data to the row it makes it one to one - in OTBI how would I ensure there are no duplicated rows of data? Content (please ensure you…THawkins_LGI 118 views 10 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Issue with the Custom Data roleHi, We are using a custom role titled "Hub Data Role - Hub Driver Services". Users assigned this role should be able to view all information related to that specfic job …
-
Access to Reports and Analytics section - Roles and privileges requiredSummary: Hi All, We had the requirement to build a custom data role which will give the user the access to Reports and Analytics work area and role should provide access…Sreeram V 5.5K views 10 comments 0 points Most recent by Jose Aguilera Reporting and Analytics for HCM
-
How does your organization use Oracle to comply with the MN Wage Theft law?Summary: My organization is in the process of implementing Oracle and we’d like to understand if other MN-based organizations have a process in place related to MN Wage …Tammi Desens 16 views 4 comments 1 point Most recent by Carolyn K Payroll and Global Payroll Interface (GPI)
-
how to remove blank line appearing at the top of manager and worker comments for employee objectivesWe have a custom BIP report for fetching the employee objectives and values details under performance module. The output of the report is in excel and while exporting th…Shikha Singh 27 views 2 comments 0 points Most recent by Shikha Singh Reporting and Analytics for HCM
-
User who executed or modified a report in Publisher ?Summary: Is it possible to know which user executed and/or modified a report in Oracle Analytics (Publisher) ? Content (please ensure you mask any confidential informati…Eduardo Mendoza 8 views 1 comment 0 points Most recent by Satyam Roy Reporting and Analytics for HCM