SQL
Discussion List
-
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 44 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 612 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 29 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 965 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 66 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 51 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 312 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 56 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 91 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 597 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… -
How to get readiness level in reportContent Hi Everyone. I am trying to get the data of the succession plan in a report however I got all data except Readiness level. In HRM_PLAN_CANDIDATES table, the Read…Misbahul Khair 45 views 1 comment 0 points Most recent by Nancy Lang-Oracle Reporting and Analytics for HCM -
Potential assessment report on a specific talent reviewSummary Potential assessment report on a specific talent reviewContent Hello, we have a OTBI report for potential assessment, this report is accessible through > select …Helene V 51 views 1 comment 0 points Most recent by Nancy Lang-Oracle Reporting and Analytics for HCM -
BI Publisher data model filter manager typeSummary Recently implemented second manager type which is causing multiple lines on BIP reportContent We have a daily BIP report that sends employee data based on action…Rob Stahly 25 views 4 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Leave adjustment detials for employeesSummary Leave adjustements for employees is available in any subject areas in OTBIContent HI, In the Absences sometime HC team are doing adjustment in the annual leave, …Farooq Syed, CPA, PMP, CISA 29 views 4 comments 1 point Most recent by User_2025-02-06-09-29-18-902 Reporting and Analytics for HCM -
Location informationSummary I need to run a report showing our locations, addresses etcContent Hi, Is there a subject area that holds the following information: Location Name, Office, City,…User_2025-02-05-22-44-35-842 45 views 5 comments 0 points Most recent by Susan Anderson Reporting and Analytics for HCM
-
Converting Simple SQL into Direct Database SQLSummary Converting Simple SQL into Direct Database SQLContent I have a current report written in Simple SQL as I need to do some left joins on Subject Areas in OTBI. How…User_2025-01-31-17-49-32-187 59 views 3 comments 4 points Most recent by Karen Waddell Reporting and Analytics for HCM
-
Previous and current values flip in the OTBI ReportSummary Previous and current values for different action codes for an employeeContent Hi All, I have a requirement to fetch a report consisting of changes to Jobs, EEO1 …User_2025-01-30-21-52-52-008 456 views 21 comments 1 point Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM
-
Work Schedules in OTBIContent Afternoon all, Has anyone managed to report on all of the details that sit within Fusion Work Schedules from OTBI? I've built a fairly simple report, that pulls …User_2025-01-28-05-39-23-766 342 views 6 comments 3 points Most recent by Emily Robinson Reporting and Analytics for HCM
-
Dashboards which Include a Date PromptSummary Dashboards which Include a Date Prompt and No Data ReturnedContent Hi, I have created a Dashboard with a Date Prompt and a BI Publisher Report. The BI Publisher …Karen Waddell 47 views 5 comments 0 points Most recent by Karen Waddell Reporting and Analytics for HCM