SQL
Discussion List
-
Query to check filled and vacant positionsHi All, I need a Query to fetch Vacant and filled positions with headcount. if anyone has please share. Thanks, SowmyaSowmyaSk18 603 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Issue with converting UTC time to BRT timeSummary: When I run below SQL to convert time from UTC to BRT (America/Sao_Paulo), output is not correct. There is a difference of 1 hour in the output. I read somewhere… -
Table(s) contain POD Version and Last Refreshed DateContent Hi... I am looking for a SQL query to derive the last refresh date for a POD and latest patch level (ie 12A, 12C, etc). Thanks in advance for any tips. JRJoe Roberts-Oracle 839 views 15 comments 0 points Most recent by DhirajRathi Reporting and Analytics for HCM
-
Suppress a field in BIP reportSummary: We are looking to group a field and suppress it in a BIP report. Content (please ensure you mask any confidential information): As shown in the snippet, we are …Tammy Hemmingson 11 views 1 comment 0 points Most recent by Tammy Hemmingson Reporting and Analytics for HCM -
{ELE_NAME} in FND_MESSAGES_TLWe have a requirement to display Message Name and Message Text in Payroll Message Report. We are getting these values from FND_MESSAGES_TL table. Now our client wants th…
-
Oracle Fusion Payroll Balance QuerySummary:Performance Issue with my BI Publisher report Payroll Balance Query Content (required): My current payroll balance query is using pay_balance_view_pkg.get_balanc…
-
How to limit values prompt values when using choice list values from SQL ResultsSummary How to limit values prompt values when using choice list values from SQL ResultsContent Hi All, In a dashboard Prompt we are using column prompts we want to limi…
-
How to add multiple IF function in the Field Browser using Microsoft Word - BI Publisher?In my RTF template, I'd like to put a message for employees who are not belong to a specific department: However, in our case, some employees under 'ABC Expert' departme… -
BI Publisher Bursting with Multiple Templates , Multiple Data setsSummary BI Publisher Bursting with Multiple Templates , Multiple Data setsContent Hi Friends We have a requirement where we need to burst BIP reports. Now i have 2 diffe…Mansur Khalil 326 views 4 comments 0 points Most recent by Alon Hadar Tamir Reporting and Analytics for HCM -
User-Defined tables name in Oracle HCM BISummary: Content (please ensure you mask any confidential information): Hello experts, do you know the BI table to extract user-defined tables? Thanks in advance for you…Valerio Curzi 12 views 5 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
How to know input values supported by any fast formulaContent Hi All, Like we have query to get context supported by fast formula, do we have any similar query or table that can help to fetch input values supported by any f…Avinash 42 views 4 comments 1 point Most recent by Ann Van Roosbroeck Reporting and Analytics for HCM -
How to link transaction adminstration Real time with worker assigenment Subject area ?Summary: HI Team, We have need to track the all transactions in hcm of : Change Location, Change Manager, DeleteAssignment Promotions ResignationTransfers. with worker d…AjayKumar Maddipati 14 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
SQL or ORA exceptions caused due to invalid sql, database package state or some database exceptionsSummary: Me pueden ayudar con el error que genera solo para periodos del 2024, el informe es un Publisher .Elia Lican 23 views 1 comment 0 points Most recent by Alexandru Burcea-Oracle Reporting and Analytics for HCM
-
How to get the action reason from the Enterprise Hire Date?I'd like to get the Action Reason based on employee's Enterprise Hire Date. However, when I'm about to add the Action Reason column within the analysis, the value didn't…
-
User's Roles table to track historySummary User's Roles table to track historyContent Hi All, Can any one please help me out with table name which tracks the history of users and roles details. I want to …nitin Sharma 1.1K views 8 comments 0 points Most recent by Dirk Blaurock Reporting and Analytics for HCM
-
Link Requisition with Prescreening Questions and Answers (Oracle Recruiting Cloud)Content I am trying to link Requisition ID, Candidate with Prescreening Questions and Answers but I am unable to find the link between the requisition, candidate and que…scheduler DBA 322 views 6 comments 0 points Most recent by Santhosh Gangishetty Reporting and Analytics for HCM
-
COUNT in a CASE statement for a calculated field in OTBISummary: Need to create a calculated field using COUNT and CASE statement Content (please ensure you mask any confidential information): I am using this Subject Area: Wo…Pradnya_Pampatwar 153 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
BI report - rejected by in Job RequisitionWe are building a report to check the rejected job requisitions and we can't find the field for who rejected the requisition. The field IRC_REQUISITIONS_VL.LAST_UPDATED_…Marta Martinho 11 views 3 comments 0 points Most recent by LakshmiCharitha Cherukuri-Support-Oracle Reporting and Analytics for HCM
-
Query to get assessment questionnaire responses for an employee from learn moduleSummary: Query to get assessment questionnaire responses for an employee from learn module Content (please ensure you mask any confidential information): Hello, I'm tryi…Manisha Rajupeta 160 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Courses Link table name for LMS reportFrom which table we can get the course link in bi reports. Can anyone help me with the table name. Thanks, Dara NagasaiDara Nagasai 1 view 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
SQL to pull Number of Days between two dates (one is a Parameter Date)?I'm currently using BIP Report. This sequel works on me if I'd like to use SYSDATE: TO_NUMBER(TRUNC(SYSDATE) - TO_DATE(TO_CHAR(SEN.SENIORITY_DATE, 'YYYY-MM-DD'),'YYYY-MM…
-
Need query to resignation approved employeesHi, I have a requirement to send emails to employees whose resignation is approved. So I want to use bursting to send emails to employees. Can anyone help me out with th…Dara Nagasai 23 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to report on how long a candidate has been in a particular phase and stateSummary: I would like to report on the length of time that candidates remains in each phase and related state. Content (required): A report that shows how long candidate… -
Combine Two or more subject areasSummary: I tried to add a new subject area to my report - all I need from the below subject area is the Employees Name which is not in the first subject area for Payroll…THawkins_LGI 222 views 19 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM -
The Requirement is to get the Approval history for the Job Offer approvalSummary Approval status and the approval date with the respect to the approver for a job Offer in BIP ReportContent Requirement is to fetch the below for Candidates Job …Ashish Shukla-83483 121 views 3 comments 0 points Most recent by Deepika1704 Reporting and Analytics for HCM
-
How do I pull the exact same timecard data that appears on the Oracle Team Time Cards screen?Summary: I need to create a data model that pulls the exact same data that appears on the Team Time Cards screen. We have OTBI reports that use the "Workforce Management…BeachDreamer 88 views 1 comment 0 points Most recent by Mohamed Mahrir Reporting and Analytics for HCM -
How to report on days since assignment status changeSummary: Hello! I am looking to report on days since Leave. We track leaves using the Assignment Status field, so I am looking to report on days since assignment status …
-
In what particular subject area can Date of Fill, Time to fill and Time to Hire be found?I'd like to pull the following columns within the Recruiting Subject Areas: Date of Fill - Returns the date/time when the requisition was most recently filled. Time to F…Welsey 12 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Any report to get the employees with missing calculation card detailsSummary: Any report to get the employees with missing calculation card details Content (please ensure you mask any confidential information): Hi Team, Greetings! There a…Parag Hiremath 28 views 2 comments 1 point Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Fiscal YTD not working correctly in HCMSummary: Need to get Fiscal YTD terminations but I cannot get it to result in Sep 1, in instead get 09/22/23 if run today. Content (please ensure you mask any confidenti…Sherie Ross 11 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM