SQL
Discussion List
-
Can we send notification to bell icon in Fusion HCM using the BI Publisher reports?Content Is there a way to send the notifications to the bell icon in the Fusion HCM by running the BI reports. Please provide your inputs on this. Thanks and Regards, Am…Amrit 139 views 8 comments 0 points Most recent by Bharadwaj Pisipati Reporting and Analytics for HCM -
How to fetch email ID of an user in oracle fusionSummary: How to fetch email ID of an user in oracle fusion Content (required): How to fetch email ID of an user in oracle fusion. I have the value of username and need t…Neelesh Varma 5.6K views 15 comments 0 points Most recent by SukanyaGhosh2502 Reporting and Analytics for HCM -
We are looking for the SQL to fetch the last updated by/last updated date of wage basis rule.Summary: employee from NJ state (US). When we ran the payroll the amount for element named Deferred comp regular was recorded under pretax deduction balance. This was be…Bhushan Kulkarni 4 views 1 comment 0 points Most recent by Shyam Rajbhar Reporting and Analytics for HCM
-
Payroll DD/Taxes Report SQL HelpWe have a New Hire Direct Deposit/Tax report that captures employees who have not completed DD and/or Taxes. How would I update the query to pull all new hires/rehires (…
-
Query to fetch all the eligibily profiles linked to Benefit PlanSummary: Hello, CC! I am in need to biuld a query that given certain Benefit Plan I need to get all the Eligibility Profiles that is attached to it. Ex: I have a paramet…Matheus Roberto 186 views 1 comment 0 points Most recent by Thiru-Oracle Benefits-Oracle Reporting and Analytics for HCM -
Drill Down in Pivot table with BI PUBLISHERSummary I want to create a drill down from a result on a pivot table which will redirect you in another reportContent Hello, Someone know how can I crate a drill down in… -
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 3 views 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)… -
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 412 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 56 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 24 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 785 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 101 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 42 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 22 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 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 25 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 53 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 106 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 283 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 22 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 64 views 2 comments 0 points Most recent by Volodymyr Faranosov Reporting and Analytics for HCM