SQL
Discussion List
-
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 37 views 13 comments 0 points Most recent by Nizar Kassam Reporting and Analytics for HCM -
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 12 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 47 views 1 comment 0 points Most recent by Deneen Burrows-Oracle Reporting and Analytics for HCM -
Fusion BI Catalog Folder Management Best PracticesSummary A white paper on Fusion BI Catalog Folder Management Best PracticesContent This white paper provides the best practices for working with BI catalog folders, and …User720640-Oracle 331 views 7 comments 11 points Most recent by Claudio Civati 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 65 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 63 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 42 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 55 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 47 views 28 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Requisition Filled Date and Time to fill on ORC reportContent I am looking for a way to pull in the requisition filled date into a filled requisition report for ORC. I cannot find that field in the subject areas. In additio…Jennifer Eichholz 96 views 4 comments 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
Combining Multiple Question RowsContent I have an ORC report that is pulling our filled reqs and the candidates' information that have been hired into those reqs. We want to see on the report their ans…Jennifer Eichholz 45 views 2 comments 0 points Most recent by Jennifer Eichholz Reporting and Analytics for HCM
-
BI report or OTBI report to list out ALL Pending vacation requests for a managerSummary BI report or OTBI report to list out ALL Pending vacation requests for a managerContent Hi Experts, My manager would like to know if there’s a way to view all th…
-
Previous Termination Date and Assignment NumberSummary Previous Termination Date and Assignment NumberContent Hi Guys, Its my first time in here. Just want to know if there's a way to get the previous assignment numb…User_2025-02-05-11-53-59-507 40 views 8 comments 0 points Most recent by User_2025-02-05-11-53-59-507 Reporting and Analytics for HCM
-
Termination Date Using Column ReferenceSummary Get a greater than term date if business unit = thisContent UPDATE: I have attached a copy of the XML of the original report. My goal is to only bring back termi… -
Org Chart in OTBISummary Ability to create Org Chart in OTBIContent Hi All, I am looking at ways to create an Org Chart in OTBI, which will display the Hierarchy in a Tree View similar t…User_2025-03-07-00-53-57-686 619 views 6 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Etext Template in csvSummary Etext template in csv drops leading 0's from reportContent when we export the file as text, the ID's keep leading 0's, but when it goes to csv leading 0's are dr…Mike Borghoff 28 views 2 comments 0 points Most recent by Mike Borghoff Reporting and Analytics for HCM
-
report to get list of direct reports for a managerContent Hi Experts, I am looking for a query where the manager can get the output as the name of all direct report specific to them, I am able to achieve it in analysis …GauravSushant 971 views 3 comments 1 point Most recent by User_2025-03-07-00-53-57-686 Reporting and Analytics for HCM -
Headcount in Fusion ProfileSummary Do you know what table does Headcount belong to in Fusion>Person Management>Manage Person.Content Do you know what table does Headcount belong to in Fusion>Perso…Mark kristan De los Reyes 29 views 1 comment 0 points Most recent by Aaron Leggett Reporting and Analytics for HCM
-
field that pulls number of direct reportsSummary I am working on a report that requires a field to pull 'Number of Direct Reports'. A non-manager would have 0 or null. Manager will pull active direct reports.Co…User_2025-02-06-07-21-22-662 63 views 4 comments 0 points Most recent by User_2025-01-28-20-36-10-715 Reporting and Analytics for HCM
-
Has anyone seen custom reports timing out after 20A upgradeSummary BIP Reports timing outContent We have a custom BIP report built off a SQL data model. It used to run about 15 minutes. After upgrading to 20A in all our developm…TonyWo 38 views 3 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
Pull Question Library with SQLSummary Questionnaires:- My Workforce > performance > Setup and maintenance > Manage Questionnaires > Select “HR Checklists” in Subscriber > Select “Questionnaire Librar…User_2025-02-06-07-21-22-662 49 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
BIP Report: Converting multiple row & multiple column values into single row and multiple column valSummary BIP Report: Converting multiple row & multiple column values into single row and multiple column valueContent Dear Experts I am working on a BIP report (SQL quer…Karthik K-Oracle 309 views 1 comment 0 points Most recent by Karthik K-Oracle Reporting and Analytics for HCM -
Concatenate a case statement with fieldsSummary I want to concatenate a case statement with a field in OTBI. How would i do so?Content "Worker"."Person Type", CASE WHEN ( "Assignment Manager List Unsecured"."M…User_2025-02-06-07-21-22-662 55 views 3 comments 0 points Most recent by Susan Anderson Reporting and Analytics for HCM
-
Connect OTBI to SQL DeveloperSummary ReportingContent Is there a way to connect OTBI to SQL developer? I want to run queries and create reports through SQL developer.User_2025-02-06-07-21-22-662 199 views 3 comments 1 point Most recent by Tom Strudley Reporting and Analytics for HCM
-
Can I report on System Entry Date?Summary How can I report on the system entry date of an action? Not the creation date or last update date.Content Hi all, Has anyone found a way to report on the actual …User_2025-01-31-22-36-07-589 92 views 5 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM
-
Using Multi-threading in BI Publisher Data ModelSummary Using Multi-threading in BI Publisher Data ModelContent Hi Experts, In order to improve performance , I see that BI publisher has option in Data Model Properties…Aloka Bhattacharya 603 views 1 comment 0 points Most recent by Mihaela M Reporting and Analytics for HCM -
Using WITH in SQL versus sub-query-which is better?Summary Using WITH in SQL versus sub-query-which is better?Content Hi Experts, Can someone help me understand if using WITH in SQL query really improve performance versu…Aloka Bhattacharya 112 views 1 comment 0 points Most recent by Mihaela M Reporting and Analytics for HCM
-
Attributes of Pay ElementsSummary Taxable, Niable and Pensionable flags associated with each pay elementContent Hello, I am trying to develop a report in Oracle Fusion to obtain every payroll ele…User_2025-02-04-17-55-40-189 43 views 3 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
Making Changes to Standard Notification TemplatesSummary Is there a delay between a customized BIPublisher report and the workforce Notifications?Content Hello Experts! We've recently started venturing into changing so…