SQL
Discussion List
-
SQL Query based on date input value errorSummary: SQL Query based on date input value error Content (please ensure you mask any confidential information): We are trying to run the below query to be used in a va… -
Transaction console approvals reportThe user is asking for a BI report that shows all the approvals for a transaction in HCM, right now I'm able to find the current and historical approvals but I can't fin…RODOLFO GARCIA SOTELO 24 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Oracle SQL - Position at a point in timeSummary: Hi, I am just writing a query to get any employees that are on secondments, leave, etc at a given point in time. One of the key requirements is to get all the a…Simranjeet Singh 22 views 0 comments 0 points Started by Simranjeet Singh Reporting and Analytics for HCM
-
[OTBI] "Workforce Performance-Performance Check-in Real Time" subject areaSummary: Duplication of "manager question text" and "manager response text" in "Workforce Performance-Performance Check-in Real Time" subject area. Content (required): A…kayoung lee 92 views 2 comments 0 points Most recent by Ilaria Petrosino Reporting and Analytics for HCM
-
Hcm tables/query which stores CA meal and rest break detailsHi Team, We have client requirement to create report for following details. Time Code(s) = Rest Time Violation and Meal Time Violation Time Card Work Date Attestation Qu…
-
Table with the worker number field of the HCM module in Oracle Cloud FusionKind regards, Please help me to identify the table that has the worker_number field, it is not the person_number of the HCM module in Oracle Cloud Fusion. Thank you for …Jhonattan Diaz 36 views 2 comments 0 points Most recent by Jhonattan Diaz Reporting and Analytics for HCM
-
salary formatted in rtf templateSummary: Hi everyone, We are customizing compensation letters for a client. We are having problems formatting the amount field for a certain bonus that should be paid to…Gerardo Peluso 134 views 3 comments 0 points Most recent by Chris O-Oracle Reporting and Analytics for HCM
-
Sql query that retrieves the total number of processed hours claimed by an employee in OTLI need sql query that retrieves the total number of processed hours claimed by an employee in Oracle Fusion Time and Labor.
-
BIP | SFTP issuesSummary: In which table holds the FTP failure error messages. Content (please ensure you mask any confidential information): Assume that BIP report unable to place the f…
-
We looking employees Names in arabic language like LANGUAGE = 'AR'Summary: Hi Team, We looking employees Names in arabic language. for department name we used Transalation table HR_ALL_ORGANIZATION_UNITS_TL ,,and dept_arabic.LANGUAGE =…AjayKumar Maddipati 113 views 2 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM -
SQL needed to find parent department in department tree for any given department nameSummary: SQL needed to find parent department in department tree for any given department name Content (required): Hi All, Please share SQL to find parent department in …C.R.Balaji 3.1K views 8 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
DM for an Emergency Contact ReportHi Sorry if this has been asked before and I see a number of reports in OTBI but I am looking to see if someone has a data model for an Emergency Contact report. I am lo… -
Table names to get reported time and calculated time on time card for reportingHi, We need a timecard report comparing the reported time vs the calculated time. Can anyone please share table names to get reported time and calculated time on time ca…
-
How to fetch CURRENT and PREVIOUS Salary using BIP?I need columns to compare the CURRENT and the PREVIOUS salary of employees in 1 row only. How to construct the BIP report using SQL?Welsey 606 views 9 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to fetch Resignation details, which include Resignation reason,,Summary: This is the resignation page in Me tab. How to fetch all These details using SQL?Aryan Yadav 13 views 1 comment 0 points Most recent by Vishnu Vardhan Raju Reporting and Analytics for HCM -
Position Request Status ReportHello, I am looking for a report that will give me all the positions requested for New Position, Backfill/Replacement, and Promotion by leader. Ideally the report captur…
-
How to fetch comments and attachments from hcm extract and bip report?Summary: I want to know, how to fetch comments and attachments from HCM extract and BIPreport? Content (required): Version (include the version you are using, if applica…
-
Dynamic SQL in query BISummary: I have a custom criteria in Person Security Profile and it contains an SQL query. I am able to retrieve that query on BI and I want to use that query in a WHERE… -
Need Oracle SQL query to get the Office number for Location details from Assignment pageSummary: Need Oracle SQL query to get the Office number for Location details from Assignment page Content (required): Need SQL Version (include the version you are using… -
Query to retrieve manager assignment numberSummary: Content (please ensure you mask any confidential information): Hello experts, we need for each employee to retrieve the line manager assignment number. Do you h…Valerio Curzi 113 views 5 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM -
BIP Query to list 'Data Security Policies' tied to a job roleSummary: Client has a requirement to list ALL the Inherited Roles, Privileges and 'Data Security Policies' tied to a job role. We are able to list the Inherited Roles, P…Shrikant Gupta 645 views 8 comments 0 points Most recent by inoappsms Reporting and Analytics for HCM -
Requirement for Custom QuerySummary: Hi Experts! We had a requirement from the customer to have a role which would grant access only to CONTRACTOR records and should satisfy the following condition…
-
Table for Manage Content TypesSummary: Hi team, Need a table or SQL quere where Manage content type information stored. Content (please ensure you mask any confidential information): Version (include…
-
how to find the employee tenure of the current position in the report.How to find the employee tenure of the current position in the report.Mohamed Eliyas 13 views 3 comments 0 points Most recent by Mohamed Eliyas Reporting and Analytics for HCM
-
Workforce Management Subject Areas (Historical Role & Manager Data)Morning Everyone, I'm investigating a quirk with an OTBI report that we've recently developed for viewing various articles of information for new starts within our organ…John Aitken 23 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Query to get the scheduled work hours of employee from shifts the employee has assignedContent I have a requirement to report the weekly work hours the employee is scheduled for. Employee will be assigned work schedule and work schedule will be liked with …Raghavendra M 4.5K views 7 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM -
Language translation in oracle standard notificationsHi, I want to edit the rtf template according to the language of the standard notifications that I want to edit in Oracle. For example, where can I edit the Turkish RTF …Cansel Karasoy 42 views 9 comments 0 points Most recent by Oriana L. Reporting and Analytics for HCM -
Pension Automatic Enrolment calculation card report in OTBISummary: Content (required): Hi, hoping someone can steer me in the right direction here. I'm looking to report on the data contained in employees' PAE calculation card …
-
Fetching employee using BIP query if employee have Job changes and TerminationSummary: Fetch the details of employee who have job changes and termination details of employee Content (required): Hi, I am working on BIP query to fetch the details of…Kamini Kaushik-Oracle 494 views 4 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
how to loop through a value set from a fast formula to get multiple valuesHi All, I have requirement to get multiple rows from a value set from a loop and then add up all the returned values from the value set in the fast formula. how can this…