SQL
Discussion List
-
Query to get Deleted users and rolesSummary Need query to get deleted users and role data from FusionContent Is there any table that will provide us the list of deleted users and roles from Fusion. We were…User_2025-01-30-17-58-41-867 563 views 4 comments 0 points Most recent by User_S04WZ Reporting and Analytics for HCM -
Workforce Management-Absence Realtime -Assignment Absence Details not picking all records of absenceSummary Workforce Management-Absence Realtime -Assignment Absence Details not picking all records of absence ONLY for 1 employeeContent Hello Dear SME's, Employee applie…C.R.Balaji 85 views 5 comments 3 points Most recent by Akhilesh_Singh-Oracle Reporting and Analytics for HCM -
What is the relationship between hrc_txn_header and gl tablesSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): 23A Code Snippet (add any code snippe… -
Need inputs to fetch balance "Reference" field value against balance dimensionSummary: Need inputs to fetch balance "Reference" field value against balance dimension Content (required): In the Employee Payroll balance results we are able to see Ba…
-
R13.x HCM BI Cloud Adapter BI View Object to Database Lineage Mapping SpreadsheetSummary This posting includes R13 HCM BI Cloud Adapter BI view object to database lineage mapping. Content This spreadsheet is published by Oracle BI Cloud Adapter Devel…Rashmi M-Oracle 19.2K views 21 comments 11 points Most recent by Lauren K. Reporting and Analytics for HCM
-
Query to fetch legal reporting unit mapped to a legal entitySummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Can we create custom views in Oracle fusion?Summary: Can we create custom views in Oracle fusion? We need to create the view to use it in a value set.
-
SQL query to create value set for Manage Organization Tree Node namesSummary: We need to establish a value set to define the node names under Manage Organisation Tree. Do we have any SQL query to get to get the Node Name? If not please te…
-
Which table stores Payroll Association dates?Summary: We are able to report on Payroll Relationship Final Close date and specific Payroll Assignment dates, but cannot find the data for Payroll Association Final Clo…TraciH-NorthBayHealth 965 views 6 comments 0 points Most recent by awheel09 Reporting and Analytics for HCM -
More details in the access Log in Oracle HCMAs administrators, we regularly download access logs to monitor user activity in Oracle. These logs provide a basic summary of successful and failed login attempts While…Annapia Penta 33 views 2 comments 1 point Most recent by Annapia Penta Reporting and Analytics for HCM
-
SQL query or Table for Actions under Transaction Design studio in oracle fusion HCM my client groupSummary: Hi Team, We need a table name or SQL query where the information of Actions under Transaction Design studio in oracle fusion HCM my client group. Content (pleas…
-
How to get users last login dateContent Hi, We have requirement to fetch all users last login date and time. May i know which table can help to get the info. I tried FND_SESSIONS and ASE_USER_LOGIN_INF… -
BI Report to get the previous and present records of job, salary amount, department and grade.Hi Team, I need a working sql query to get the previous and present records of job, salary amount, department and grade in BI Reports. Parameters: - Action Code, from da…Support 24 views 2 comments 0 points Most recent by Carl Bequilla-Oracle Reporting and Analytics for HCM
-
Reading offering, functional area and setup task using querySummary: For an integration, looking for a way to map Offerings/Functional Areas and available Setup tasks. Using OTBI, is it possible to write a report/query to get the…
-
How to retrieve/calculate fiscal year for payroll period otbi reportSummary I would like to add fiscal year and calendar year in payroll by period OTBI reportContent Hi Team, I have created a prompt name toggle with 2 fields(calendar and…Kalyani Koylada 296 views 3 comments 0 points Most recent by Nidhi Chhajed Reporting and Analytics for HCM
-
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 138 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.5K 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 2 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 163 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. 2 views 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 2 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 406 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 21 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 740 views 5 comments 0 points Most recent by GajavalliKoteswararao Reporting and Analytics for HCM