SQL
Discussion List
-
Payroll Report HelpI'm working on updating a Payroll Last Row Validation Report. It is currently pulling the wrong assignment manager for the last effective dated change on their employmen…Nicole A. 1 view 1 comment 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM -
exceeds the maximum limit error even after using filterSummary: exceeds the maximum limit error even after using filter Content (please ensure you mask any confidential information): Hi Team, Greetings! We are getting below …Parag Hiremath 1 view 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
How can I report on a specific pay element in OTBI?Summary: I need to be able to include a specific pay element but OTBI excludes anyone who doesn't have this Content (please ensure you mask any confidential information)… -
Query to fetch Run Result Element Entries & Balances for particular time periodSummary: We have a requirement to pull element entries & balances from Run Results for the particular time period. I have written the below query but which is giving mul…Manoharan 8.4K views 6 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
BI Publisher report that shows learning activities scoreSummary: Activity score not showing in BIP Content (required): Hi, I'm trying to build a BI Publisher Report with information about learning activities inside courses. I…Vasco 397 views 10 comments 1 point Most recent by Prasanth Subbaiahh-Oracle Reporting and Analytics for HCM
-
Personal Payment Method Processing OrderSummary: Hi all So I've seen this asked before on another post but there wasn't a solution. The processing order for Personal Payment Methods doesn't appear to match up …SimonG 51 views 6 comments 0 points Most recent by Gopikrishna Nerella Reporting and Analytics for HCM
-
Report to trace the elements costed from Journal entries along with transaction numberSummary: Report to trace the elements costed from Journal entries along with transaction number Content (required): Hi Team, Greetings! Once the entire payroll cycle is …Parag Hiremath 22 views 3 comments 0 points Most recent by Fazal Subhan Reporting and Analytics for ERP
-
Query to get Goal Approval StatusHello, For our report, we already have performance goals being listed in each row for every person. For each goals, we would require their approval status. However, when… -
Absence Balance MismatchHi All, Several employees have a balance discrepancy between the plan level and the accrual level. Is there a query available to retrieve this information and identify t…
-
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 716 views 5 comments 0 points Most recent by GajavalliKoteswararao 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 97 views 7 comments 1 point Most recent by Nathan CCC 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 41 views 5 comments 0 points Most recent by Kande Likhitha 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 21 views 3 comments 0 points Most recent by Ram_S06789 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 2 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 22 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to extract person images in .jpg format from Oracle HCM Cloud?Content I have a requirement to extract the person images from the Oracle HCM Cloud in the .jpg format. Please can anyone guide on this. -
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 51 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…
-
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…
-
MilanMohanty 101 views 2 comments 0 points Most recent by Ankit Chauhan Reporting and Analytics for HCM -
Report for Missing TimecardsSummary Employees without time card associationContent Hi All, We have a requirement to identify and report those employees that are missing time card association. I am …Sowdha Murugan 237 views 3 comments 0 points Most recent by Pennie Spies Reporting and Analytics for HCM -
OTBI Report - Need Query Transaction Console Approver Name for Job Requisition & Job OfferSummary: Need Query Transaction Console Approver Name for Job Requisition & Job Offer i have tried this query select htce.object_name, htce.task_id task_id_hdr, htce.con…Herman Fersendy 21 views 0 comments 0 points Started by Herman Fersendy Reporting and Analytics for HCM
-
Multiple legal employers records showing in each employeeSummary: Hi Team, we have BI query but it Multiple legal employers records showing in each employee. example one employee have x legal employer but it also showing secon…AjayKumar Maddipati 21 views 4 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
How to get legal employer legislation code with SQLSummary: How to get the legal employer legislation code with SQL Content (please ensure you mask any confidential information): Hi experts, I need to get the legal emplo…Volodymyr Faranosov 61 views 2 comments 0 points Most recent by Volodymyr Faranosov Reporting and Analytics for HCM -
How to identify the employees who didn't receive Outlook invites after a course is assigned?Summary: Hi, Is there a query to identify the recipients of Outlook invites after a course is assigned? we have a situation where some individuals received the invites w… -
SQL query or Table for Actions under Transaction Design studio in oracle fusion HCM my client groupSummary: Hi @everyone We need your help to get below requirement: in case we do personalization through transaction design studio, we can unhide a section in the page wh…
-
Generate run balances seeded processSummary: If we run Generate Run Balances need to know what all are the transactions/records are added/updated in the Pay_run_balances tables Content (please ensure you m…
-
How can some Audit details be reported in Oracle Cloud HCM?Hi, I need some application security details that the client requires. For Example; User Login and logout Roles assigned to the user and their changes Password change in… -
Payroll query that fetches results only if for the Employee Generate Payslip flow is not run.Summary: I need to create a BI report which retrieves Employee Information of the users along with other Common columns also needed to see if whether is employee get pai…Ketan-Oracle 2 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM