SQL
Discussion List
-
SQL query to retrieve employee business titleSummary: Content (please ensure you mask any confidential information): Hello experts, I need to retrieve the employee Business Title. Do you have a query to share to re…Valerio Curzi 356 views 5 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Fast Formula retrieving Date formatSummary: Hello experts, we built the following formula to retrieve a date to be used in compensation plan in date custom field. However, when testing it the attached err…
-
How to pass person id from redwood page to Value setSummary: How to pass person id from redwood page to Value set Content (please ensure you mask any confidential information): Hi all, We created a value set to fetch late… -
Fetch Request a Position Change Details - Table/XML/TableHi Would someone be able to point to me which table and fields circled in my attachment exist? I am looking to build a report that captures all the details submitted whe…Jose Guerra 11 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
We want to create a BIP report for the Approval Delegations.Oracle has a delivered report, Employee Vacation and Delegation Rules Report. We need to know the tables behind this report so we can add more fields to the report. Does… -
Using Dynamic Hyperlink in Layout Editor (.xpt template)Summary: I have a report using .xpt template / Web layout editor, there is a text Goal Center that I need to convert to a hyperlink so users can go directly to My Team >…Carlo Reyes-59977 53 views 0 comments 0 points Started by Carlo Reyes-59977 Reporting and Analytics for HCM
-
Is there a way to know who changed Password and when?Summary: We would like to know if there are any tables that store information about users' passwords Content (please ensure you mask any confidential information): Hello…Giuseppe Casalino 51 views 7 comments 0 points Most recent by Giuseppe Casalino Reporting and Analytics for HCM -
How to fetch Audit reports under tools or how to schedule the audit report and get data on a dailySummary: Hi Team, I need to fetch audit data, I am able to export the data from the audit report under the tools, how to schedule this report on a daily basis or help me…nanda.patil 205 views 3 comments 1 point Most recent by Ashwin Sinha Reporting and Analytics for HCM
-
Is it possible to add a field to an OTBI analysis that uses sql to query the underlying oracle tableSummary: We have an existing OBTI Analysis that reports on candidate from ORC. We need to add that a field from the Extra Info section of the candidates profile, the Des… -
Could not find the lookup HRC_TRANSACTION_STATUSSummary Could not find the lookup HRC_TRANSACTION_STATUSContent Hi Experts, As a part of pulling the Approval Transaction Details, I have used the table HRC_TXN_DATA. Th…Charan Kollipara 110 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
BIP HCM Payroll - Is there any alternative to pull the Payroll process statusBIP HCM Payroll - Is there any alternative to pull the Payroll process status apart from below Query /* ( SELECT meaning FROM hcm_lookups WHERE lookup_type = 'ORA_HWM_PA…BhaskarDondapati 292 views 10 comments 0 points Most recent by Sunil Makam Reporting and Analytics for HCM
-
BIP Parameters Not Working Correctly with SQL in Data Model and ReportHi all, I'm hoping someone can possibly take a look and help me out with an issue we're having with our BIP Data Model and SQL. We're needing to build an OTBI based repo…
-
OTBI Logical SQL complex query assembler - NOW 10 subject AreasSummary Now updated - Combine analyses from up to 10 different subject areas (V4) Content It was already posted on OBIEE forum, but I figured HCM would be a demanding th…Maxime Pignot-Oracle 1.5K views 14 comments 14 points Most recent by Maxime Pignot-Oracle Reporting and Analytics for HCM -
UI End-Date and Database Records for Bank AccountsSummary: Hi everyone, I recently inactivated a bank account using the checkbox, and now I see a mismatch with the end date. The UI shows it as 01/07/2025, but the tables…
-
Table names/SQL query for Individual Compensation details in HCMSummary: Hi All, Can you please share me the Table names/SQL query for Individual Compensation details in HCM. Thanks, Janardhana Content (required): Version (include th…Janardhana Kondaveeti 5.5K views 11 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Query to retrieve employees with Termination Date nullSummary: Content (please ensure you mask any confidential information): Hello experts, please, could you share a query to retrieve employees without past and future actu…Valerio Curzi 71 views 6 comments 0 points Most recent by Ashraya S.N Reporting and Analytics for HCM
-
Transaction Console Job Requisition approval chain reportSummary: The user can't access the transaction console and through administrative tasks in BPM, they can see only their job requisition. We need a report to see the appr…
-
Query to find hr_assignment_id/assignment_id for which payroll has been RunSummary Find link between payroll run and assignmentContent Hello Team I need a query to find the assignment for which a payroll(quick pay/Regular payroll) has been run …AvishekNandi 933 views 13 comments 1 point Most recent by Lohit Kad-Oracle Reporting and Analytics for HCM
-
Need to update the absence Entry before holiday and after holidaySummary: Hi Everyone , We have requirement where we have to update absence entry for employees who is in long term absence. Below is requirement:- First Step: Check for …Krishna Manmohan 14 views 1 comment 0 points Most recent by Tamilarasan Sekar Reporting and Analytics for HCM -
Query to retrieve Union fieldSummary: Content (please ensure you mask any confidential information): Hello experts, do you have a sample query to retrieve the employee Union name as in the attached …Valerio Curzi 13 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Table to get Absence plan details in Payroll element taskSummary: Hi Team, Could you please provide us the Table or SQL query for the input values of Absence plan details, Absence Payments, Accruel Liability and Balance Paymen…Opkey PA 14 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Query required to fetch the fields - Resident PSD Code, Resident School District, Work PSD Code.Hi, Does anybody have a query that will fetch the fields - Resident PSD Code, Resident School District, Work PSD Code, Work School District. These fields are present in …SowmyaSk 483 views 9 comments 0 points Most recent by Rini_Varghese-Oracle Reporting and Analytics for HCM
-
query to get variable rate program for all employeesSummary: Content (please ensure you mask any confidential information): Hi all, I currently have a query where I am trying to get the variable profile name (under manage…Steph96 131 views 3 comments 0 points Most recent by Matheus Roberto Reporting and Analytics for HCM -
How to Filter a Date Column by Another Date ColumnSummary: I have an OTBI analysis that is 3 subject areas. The goal is to show specific actions in Workforce Management - Worker Assignment Event Real Time, and then show…
-
Oracle HCM Fusion Table to find Business capability in Oracle content ItemsDear Team, We are trying to fetch the business capability field from below navigation: Navigator > My Client Group > Profile > Item Catalog > Search for Skills Library >…
-
Need to fetch the Content ID of HCM ExtractSummary: We have requirement to fetch the Content ID of HCM Extract through BI report. Any one have idea how we can fetch Content Id. Content (please ensure you mask any…
-
In Oracle Fusion TEST, Profile Codes shown in front end but not in HRT_PROFILES_B table.Summary: In oracle fusion TEST instance, am able to see the Profile Codes for Talent Profiles in front end, but am not able to see it in HRT_PROFILES_B Table. Whereas I …Gopika Prem Kumar 13 views 0 comments 0 points Started by Gopika Prem Kumar Reporting and Analytics for HCM
-
Table for Time Type in TimecardWe have a requirement to fetch the time type from timecard. pay_payroll_time_type from hwm_tm_rep_m_ptt_atrbs_v is not returning any value. Could someone guide me on thi…
-
Identification of missing associations on Calculation CardsSummary: Identification of missing associations on Calculation Cards Content (required): Hello Experts, Can you please suggest if Identification of missing associations … -
Retrieve Department Hierarchy per User Assignment (with Effective Date)Summary: Hi everyone, I'm wondering if anyone has a query that returns the organizational department structure for users based on their assignment, while properly consid…Matheus Roberto 21 views 0 comments 1 point Started by Matheus Roberto Reporting and Analytics for HCM