SQL
Discussion List
-
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 361 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 160 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 13 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 289 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 3 views 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 30 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 241 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 117 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 85 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 11 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 26 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 15 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
OTBI - Need filter on from date to To date as sysdateSummary: Hi Team, we have requiremnt in OTBI to apply the filter(Completion Date) as From date is 1-04-2023 to TO Date is sysdate. thi is the the is colums of fomula : "…AjayKumar Maddipati 287 views 9 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Invalid Number Error in BI PublisherSummary: Invalid Number Error in BI Publisher Content (please ensure you mask any confidential information): Hi, we are experiencing an issue with a BI Publisher Report.…Barile Alberto 122 views 2 comments 0 points Most recent by Barile Alberto Reporting and Analytics for HCM
-
What is the standard Path in reports and analytics to get Performance management notificationI want to know the standard Path in reports and analytics to get Performance management notification for customization in template. I am attaching the screenshot of noti…
-
IN BI Report two parameters From Date to TO Date but need to change TO Date as sysdateSummary: Hi Team, I have changed parameter Todate as SysDate but it correct or not I'm not sure, any one could you please check this is correct data or not on below quer…AjayKumar Maddipati 14 views 3 comments 0 points Most recent by LakshmiCharitha Cherukuri-Support-Oracle Reporting and Analytics for HCM
-
Oracle BIP Report -> RTF Template page bordersSummary page bordersContent Hello, I am having an issue with achieving page borders in RTF templates. Attached a word document explaining my problem. Can anyone please a…SantoshKumarBhairi 261 views 4 comments 1 point Most recent by SireeshaJaladi Reporting and Analytics for HCM -
Analytics > Administration > Manage Sessions > Ability to Trace Sessions for BI Publisher ReportsSummary: Analytics > Administration > Manage Sessions > Ability to Trace Sessions for BI Publisher Reports Content (please ensure you mask any confidential information):…Bernard T 51 views 1 comment 0 points Most recent by LakshmiCharitha Cherukuri-Support-Oracle Reporting and Analytics for HCM
-
Which table holds the value for 'Province of Employment' for Canada Employees ?Summary: Need the Table and column info for the 'Province of Employment' value to troubleshoot and fix card association issue. Content (please ensure you mask any confid…Priyabrata Prusty 84 views 3 comments 0 points Most recent by Priyabrata Prusty Reporting and Analytics for HCM
-
I need help with creating New Hires report with some Requsition & Assignment & Offer detailsHello, Could you please let me know what Subject Area/Tables I should use to build a report that shows basically the info on the offer screen under: My Client Groups > H…Ramy Atia 33 views 1 comment 0 points Most recent by LakshmiCharitha Cherukuri-Support-Oracle Reporting and Analytics for HCM
-
Query to extract the list of available Locations based on the Legal EntitySummary: Content (required): Hello experts, is it possible to build a SQL query to retrieve the list of applicable locations based on the legal entity? Thanks in advance…Valerio Curzi 752 views 7 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
need a payroll element costing reportSummary: Need to write a payroll element costing report that includes highlighted information from picture below Content (required): need a report that shows all the inf…Bernadette Dorris 154 views 6 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Etext Report output is not coming correctly.Summary: Hi Everyone. I am trying to create a etext report in the HDL format, EDI(delimited type). When i view the report, instead of getting the output value, i am gett…ShawShankk 121 views 11 comments 1 point Most recent by Ankam Vasantha Reporting and Analytics for HCM
-
Oracle BI tables to retrieve Talent RatingsSummary: Content (please ensure you mask any confidential information): Hello experts, which tables allows to extract Talent Ratings as that one attached? Thanks in adva…Valerio Curzi 11 views 1 comment 0 points Most recent by Joe Dorrian Reporting and Analytics for HCM
-
Report to find employees without any presentative (AoR HRBP)Summary: Hi, I'd like to create a report to find if any employees haven't been assigned to any HR Business Partner with an AoR. Do you know if this is feasible and how t…Alberto Americi 51 views 5 comments 0 points Most recent by Alberto Americi Reporting and Analytics for HCM