SQL
Discussion List
-
Fusion Table to get % compatibility on Career PlanningSummary Fusion Table to get % compatibility on Career PlanningContent Hi Gurus, Is anyone knows if there is a SQL table we can use to get the Percent compatibility under…Hayds Mercado 13 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Cost Center Manager SQLSummary I require the table/link for the cost center manager fieldContent Hi I am currently creating a report that requires the cost center manager field for a departmen…User_2025-02-06-00-21-58-611 60 views 5 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
User Sign In InformationContent We are looking to create some reports to extract user sign in information, ie. when and how often employee sign in. I've seen some old post that have some tables…User_2025-01-31-00-25-12-234 106 views 3 comments 1 point Most recent by Sricharan Monigari Reporting and Analytics for HCM
-
Email Trigger through OTBISummary Need Email to be triggered to IT department if any name changes happens in the 'Last Name' or 'First Name' through OTBI agentsContent Hi Team, we have a requirem…User_2025-01-23-22-36-48-692 242 views 6 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM
-
Logical SQL - adding column selectorSummary Is it possible to add a "column Selector" to a Logical SQL report?Content Hi, I am trying to add a "column selector" to a logical SQL report. I would like to giv…Mitch_123456 53 views 8 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Get a list of languages for people in the systemContent Hi, We have 10,000 people in our HCM instance. How do I bring back each individuals language skills So given a suffix or a person_id, I want to bring out the fol… -
Age BinsSummary Invalid Alias FormatContent Hi, I've copied a formula that calculates the age of an employee from the following Oracle video: https://www.youtube.com/watch?v=QpG…User_2025-02-05-22-44-35-842 30 views 5 comments 0 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM
-
Understand SQL Query for Talent profile data modelContent Hi Everyone, I have created the data model for talent profile print action with the help of delivered data by oracle. In delivered data model oracle has used a s…Misbahul Khair 137 views 3 comments 1 point Most recent by AshishERPCloud Reporting and Analytics for HCM -
How to get UI value on SQL outputContent Hello Experts, How we can pull or put some conditions to get the result. Eg. There are few fields with drop value like Yes, No but when I am pulling the data thr…Misbahul Khair 25 views 3 comments 1 point Most recent by Karthik K-Oracle Reporting and Analytics for HCM
-
Creating Top Down HierarchySummary Creating a report for a top down hierarchyContent Has anyone had any success in creating a top down hierarchy. I have attached an excel file which would hopefull…User_2025-01-29-01-34-39-547 72 views 12 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Absence Approval/Rejection Comments- BI ReportSummary Absence Approval/Rejection Comments- BI ReportContent how can we fetch Absence Approval/Rejection Comments in BI Reports.Priyanka_Kumari 51 views 6 comments 1 point Most recent by AshishERPCloud Reporting and Analytics for HCM -
Oracle Error 25137 - Data Value Out of RangeContent Afternoon all, Oracle built us a dashboard a few years ago that compares data fields between two dates, to highlight changes (SQL attached). However, we are now …User_2025-01-28-05-39-23-766 142 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Requirement for the existing BI report to add direct reporteesSummary Can someone help me out with this.User_2025-02-07-09-10-02-492 17 views 2 comments 0 points Most recent by User_2025-02-07-09-10-02-492 Reporting and Analytics for HCM
-
Possibility to retrieve URL of an attachment stored in SaaS through BI PublisherSummary URL of attachments stored in UCMContent Hi, I am trying to find a way to extract via BI Publisher the URL of an attachment stored in the UCM. I have checked in t…Alberto Romani-Oracle 67 views 7 comments 1 point Most recent by Alberto Romani-Oracle Reporting and Analytics for SCM
-
success criteria with html balise in bi publisherSummary How can I delete the html code in success criteria column in bi publihserContent Hello, I want to delete the html balise for the column success_criteria from the…User_I6AXL 40 views 13 comments 0 points Most recent by Nizar Kassam Reporting and Analytics for HCM -
How Charge type (Freight, Duty...) is calculated on a POSummary How Charge type (Freight, Duty...) is calculated on a PO in Landed Cost ManagementContent I need to show per unit cost of Charge (Freight, Duty, Material, Miscel…
-
Table in getting the Manager's Business Location/Location Name in OBIESummary Table in getting the Manager's Business Location/Location Name OBIEMark kristan De los Reyes 13 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Conversion of Timezone in RTF templateContent I am facing a situation where the client is entering the data in the UI as 9:00 AM but since the database stores the time in the UTC format it is storing as 13:0… -
Need a table name/Coumn name to identify whether it is a 2020 tax card or 2019 tax cardSummary Need a table name/Coumn name to identify whether it is a 2020 tax card or 2019 tax cardContent Need a table name/Coumn name to identify whether it is a 2020 tax …User_2025-02-04-07-00-18-658 49 views 1 comment 0 points Most recent by Deneen Burrows-Oracle Reporting and Analytics for HCM
-
R13 20A - What are the common fields to join with Issue Details and Transaction details Subject areaSummary Need help with OTBI subject areaContent We are trying to create a transaction failure report for the transactions that are failed on a daily basis due to MSS tra…Suganthi Srinivasan 76 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Get Data From Previous Row in AnaltycsSummary Get Data From Previous Row in AnaltycsContent Hi, I have null values in Analytics. I dont want to show like null values. So I want to get data from previous row …User_2025-02-05-02-38-04-251 78 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
SQL for Hire Date + 30 daysSummary does anyone have a quick SQL for finding employees hitting their 30 day mark after hire?Content Hi folks - hoping this is an easy one! Does anyone have a quick a…Matthew Grillo-95429 45 views 2 comments 0 points Most recent by Matthew Grillo-95429 Reporting and Analytics for HCM
-
R13 20A - How to include OTBI subject area in BI SQLsSummary Wanted to include in the BI SQL select statement OTBI subject areaContent How can i include OTBI subject areas in my BI SQL reports being created Version 20ASuganthi Srinivasan 57 views 4 comments 0 points Most recent by Suganthi Srinivasan Reporting and Analytics for HCM
-
Here is the below query need to put some manual calculation formula. Can any one please help me in dSummary =IF((Base SalaryContent SELECT DISTINCT(b.person_number) "EMPLOYEE No.", b.person_id as "Unique_id", (select salary_amount from cmp_salary where assignment_id=a.…User_2025-02-07-09-10-02-492 54 views 28 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM