SQL
Discussion List
-
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 21 views 1 comment 0 points Most recent by Gail Langendorf-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 171 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…
-
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…Alpesh Sanghvi 1 view 0 comments 0 points Most recent by Alpesh Sanghvi 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… -
How to generate the BIP report with the user time zone rather than the server time zone?Summary: Our reports are generated in UTC time zone, especially when it comes to Exit reports the LWD & the submitted dates are not matching because of time zone differe…Elavarasan S 193 views 2 comments 0 points Most recent by Elavarasan S Reporting and Analytics for HCM -
SQL query to retrieve the approval history dataSummary: I wanted to create an SQL query to retrieve the approval history data which is in Transaction Console for process name 'Journal Approval' Content (please ensure…Sonia V 316 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
please help me to fetch report for Specialization with individual activity status in Learn ModuleI want to pull the details of specialization, including status, along with individual activities and their status | SQL query to get specialization details , module name…Nagarani M 11 views 0 comments 0 points Most recent by Nagarani M Reporting and Analytics for Taleo Learn
-
Position Hierarchy queryHi, I need a small query that returns parent position name and code of positions. Is it possible for you to share the query about it? Regards -
Trace the processing details of scheduled BIP ReportSummary: Trace the processing details of scheduled BIP Report Content (please ensure you mask any confidential information): Hi Team, Greetings! What are the best option…Parag Hiremath 32 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
HCM Quick Link Usage StatisticsSummary: Looking for statistics for individual pages access by role, user, etc… for a specific timeframe Content (please ensure you mask any confidential information): A…
-
How to Extract More Details from Oracle Access Logs (Failed Logins)Hello, We are currently trying to understand if there is a way to extract more detailed information from the Oracle access logs. At the moment, we are only able to extra…Rebecca Bortone 22 views 5 comments 0 points Most recent by Jun Ye-Support-Oracle Applications Security
-
FTE and salary doubling on union querySummary: Complex union query. Reports work find individually but union is doubling up FTE and salaries for some records (not all). Content (please ensure you mask any co…LynneLBL 21 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
HCM Help desk query FAQ accesses countHello Experts I need to acquire information from Help desks FAQs in HCM More precisely: * Name, info, last update, etc And the best after this would be to discover how m… -
Trying to get BIP report to burst and consolidate on emailSummary: I am having trouble getting my BIP report to burst and consolidate delivery by email, even though the Enable Consolidate Output box is checked. I have been doin…
-
How to build query like audit report?Summary: Content (please ensure you mask any confidential information): I can run this Audit Report: Is it possible to query the database to obtain the same info? Versio…Stefano_Mazzocca 21 views 1 comment 0 points Most recent by Martina Iovino-Oracle Reporting and Analytics for HCM -
BI Tables storing legal employer addressSummary: Content (please ensure you mask any confidential information): Hello experts, do you know in which Oracle HCM table the legal employer address is stored? Thanks…Valerio Curzi 21 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Duplicate and Missing Payroll Payment Records for EmployeesContent (please ensure you mask any confidential information): I'm encountering an issue where the query returns two rows for a person one with the correct payment statu…User_VQ154 21 views 1 comment 0 points Most recent by Soumya Suravita Reporting and Analytics for HCM
-
Past Incumbents in position tableSummary: HI, I have checked there is no column for past incumbents in HR_ALL_POSITIONS_F and also in subject area "Workforce Management - Position Real Time", But we can…Reddykrishna Chidella-Oracle 101 views 4 comments 1 point Most recent by Soumya Suravita Reporting and Analytics for HCM -
Enabling Increased Length Limits for Data Group Filter CriteriaSummary: Guidance around enabling the increased character limit on the data group filter criteria's for extracts. Content (please ensure you mask any confidential inform…
-
User Entity to get deleted Absence Records - HCM ExtractHi, I have a requirement to extract deleted Absence Records using HCM Extract and send it third party payroll. Could someone suggest the appropriate User Entity?
-
User Account Details (Email Address) in Security ConsoleSummary Need table names to be able to pull email address kept in Security ConsoleContent Hi All, I am struggling to find and link tables to pull User Account Email Addr…User_2025-01-28-05-11-13-165 945 views 11 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Where to find Currency Conversion Rates used in a Compensation Plan?Summary: Hi all, I have a compensation plan (CMP_PLANS_B) with a specific PLAN_ID. I want to retrieve the currency conversion rates used for this plan, which were upload…Martina Iovino-Oracle 42 views 3 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Department Set Name/CodeSummary: We have a requirement to include the Department name, Department Set name/code to a project details BIP report we are able to find what table holds the departme…Marie Joyce Wynona Marzan 21 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
SQL query to retrieve employee location country nameSummary: Content (please ensure you mask any confidential information): Hello experts, we need a query to retrieve the employee location country name but below it extrac…Valerio Curzi 833 views 1 comment 0 points Most recent by Vishnu Vardhan Raju Reporting and Analytics for HCM
-
XML-22002: (Fatal Error) Error while processing include XSL fileSummary: We are getting the error XML-22002: (Fatal Error) Error while processing include XSL file (xdoxsl:///Custom/Human Capital Management/HR/SUBTEMP.xsb?loc= en-GB) …
-
In which table has the name format components storedSummary: Hi Team, We need a table where the name format components stored, Tasks: Manage Person Name Formats - HR_NAME_FORMATS I need the table for name format component…
-
Overdue Task Report in Journey ChecklistsSummary: Overdue Task Report in Journey Checklists Content (required): Hi All, Greetings! we are trying to check the exact data for the terminated employees with checkli…Parag Hiremath 133 views 13 comments 0 points Most recent by Ashraya_SN-Oracle Reporting and Analytics for HCM