SQL
Discussion List
-
Termination report with subquerySummary Looking for a subquery that would eliminate currently active employees form termination reportContent Hello, I am trying to build a termination report for our or…User_2025-01-29-23-59-58-976 96 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How get approver comments?Content Hi All, I am just trying to find a subject area to get the approval comments at the point of approval of a performance document? Is it possible to get from subje…Achala Munasinghe 57 views 5 comments 0 points Most recent by Dr Surlina Yin-Oracle Reporting and Analytics for HCM -
OTBI Comp Report That Restricts ViewsSummary OTBI Compensation Report using a custom DM needs restriction on dataContent We've created an OTBI comp report using a custom data model. This report is allows mg…User_2025-01-25-00-37-41-739 42 views 7 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to enable graph report export option from UI Dash boardsSummary How to enable graph and report export option from UI Dash boardsContent We are not able to find export option on UI Dash board for graphs and reports. Client req…User_AEMC1 70 views 10 comments 1 point Most recent by Melanie Mahon-Oracle Reporting and Analytics for HCM -
Report to Include Employees Who Have Gone from one Employee Type to anotherContent I need to create a report that shows me all employees who have moved from person type = Employee to person type = Manager (in Assignment Details). How do I compa…User_2025-01-25-03-28-26-914 36 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Tip: SQL Query to check existence of HCM EnterpriseSummary Tip: SQL Query to check existence of HCM EnterpriseContent Tip: SQL Query to check existence of HCM Enterprise ,which can be used in data model. select name,orga…Abhishek Sood HCM 58 views 3 comments 4 points Most recent by Prudence K Reporting and Analytics for HCM -
Number of current contracts in the actual month and in the previous MonthSummary Number of current contracts in the actual month and in the previous MonthContent Hello, I want to create report displaying number of employees by the contract ty…User_I6AXL 48 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Dashboard Prompt: Not show Inactive values in Search selectionSummary Control dashboard prompt to not show the Inactive values for users in search selectionContent Hi All, We have built a dashboard with dashboard prompt for 'Goal P…User_2025-01-23-22-36-48-692 58 views 3 comments 0 points Most recent by Caroline Gladwin-Oracle Reporting and Analytics for HCM
-
List of Table names to create data model ReportSummary Hi, Where can we find List of Table names to create data model in Reports ans AnalyticsUser_2025-01-25-01-41-07-379 87 views 5 comments 1 point Most recent by User_2025-01-25-01-41-07-379 Reporting and Analytics for HCM
-
holiday accrual dates are not working for me! please help!Summary holiday accrual dates are not working for me! please help!Content hello I am using a custom report which shows how much holiday was taken in each year and the ac…User_2025-01-29-02-09-34-137 74 views 4 comments 0 points Most recent by User_2025-01-29-02-09-34-137 Reporting and Analytics for HCM
-
BI Publisher Date PromptContent Hi All I'm struggling to get a Date prompt working in BI Publisher. I can get the prompt to show but it doesn't work (seems more complex than the easy prompts in…Aaron Leggett 86 views 3 comments 0 points Most recent by User_2025-01-28-20-47-34-889 Reporting and Analytics for HCM -
As of Date Presentation VariableContent Hi Is it possible to create a presentation variable for a date to get a report from the past? For instance, I need a report to show what the data was on the 1st …Aaron Leggett 143 views 3 comments 0 points Most recent by Aaron Leggett Reporting and Analytics for HCM
-
Common Alignment for both RTF and PDF not working in LettersSummary Common Alignment for both RTF and PDF not working in LettersContent Hi, I have developed one appointment letter, when i run this report the alignment of RTF Temp…User_2025-01-28-00-11-59-141 52 views 5 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
SQL Function to allow more than 4000 charactersSummary Need SQL Function to allow more than 4000 charactersContent Hi, I have built sql custom report and my requirement is to bring employee overall comments using BI …User_2025-01-28-00-11-59-141 41 views 3 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
Add Trimestre prompt in BI publisher depending on assingment tableSummary I want to add a prompt in bi publisher report which is Trimestre and depends on per_all_assignments_m (effective_start_date)Content Hello, How can i define on sq…
-
Competency Rating in PerformanceSummary I need to pull item ratings and item comments a manager entered in the Competency section in a performance documentContent HELP!!!! I need to pull item ratings a…Gala Meyerovich 179 views 2 comments 0 points Most recent by Gala Meyerovich Reporting and Analytics for HCM -
Slow performance in OTBI AnalysisSummary Slow performance in OTBI AnalysisContent Hello, I have created some Analysis in OTBI. I see that are very slow or they go in time out. The reports have 4 attribu…Giuseppe 1234 216 views 2 comments 0 points Most recent by Giuseppe 1234 Reporting and Analytics for HCM -
Can Security Roles cause Duplicates in OTBI Analysis?Summary Troubleshooting Duplicates in AnalysisContent I have a user who is running a custom Analysis and getting duplicate and triplicate employee records returned. When…User_2025-01-28-17-24-53-863 71 views 2 comments 0 points Most recent by User_2025-01-28-17-24-53-863 Reporting and Analytics for HCM
-
degrees informations of profiles in tables fusion ?Summary I want to create a report using information of degrees of profiles in bi publisherContent Hello, Someone know please where can I found the information of degrees…User_I6AXL 68 views 2 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
BI Security - Secured view - real sqlContent Hello, I want to know if there is a way to get the real sql behind the secured view? For example: CMP_SALARY_SECURED_LIST_V or PER_PERSON_SECURED_LIST_V or PER_A…User_2025-01-25-01-33-46-269 169 views 15 comments 0 points Most recent by User_2025-01-25-01-33-46-269 Reporting and Analytics for HCM
-
How to pull APR document through SQL?Summary How to pull APR document through SQL?Content We have a business requirement to pull Annual Performance Document of all employee. Oracle says there is an ER with …User_2025-01-27-23-54-00-342 37 views 3 comments 0 points Most recent by Rebecca Emerson Reporting and Analytics for HCM
-
Bursting BIP QueryContent Hi All, We build BIP report with Bursting as per our requirement. The query which we build on the Performance Management module. If we run the report with Perfor…
-
Filtering Between Two "TimeStampDiff" DatesContent Good Day, I was wondering if anyone has had a similar query and has also found a solution. The query is i want to search between Two Dates and for then for it to…User_2025-01-28-07-12-45-467 89 views 5 comments 0 points Most recent by User_2025-01-28-18-08-05-947 Reporting and Analytics for HCM
-
Report doubling my values.Summary I have a report which should count every employee as 1, but for some reason counts them as 2.Content Hi, I have a traffic light report which counts employees who…User_2025-01-25-04-51-10-553 30 views 3 comments 0 points Most recent by User_2025-01-25-04-48-26-816 Reporting and Analytics for HCM
-
Remove expired dates from an end date report.Summary End dates of before the current date are appearing on my report.Content Hi, I have produced a report on end dates, such as fixed term and probation end dates. Th…User_2025-01-25-04-51-10-553 43 views 4 comments 0 points Most recent by User_2025-01-25-04-51-10-553 Reporting and Analytics for HCM
-
Changes in Hours / Grade / Salary / Organisation / Business Units etcContent Hello, We are looking for a way to create an analytical report or maybe even a dashboard that can show when "Historically" an employee has changed one of these f…User_2025-01-28-07-12-45-467 133 views 3 comments 2 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Unable to pick latest salary details for a person using subject area "Compensation - Salary HistoryContent Hello All, I am having a trouble in pulling out the latest salary details for a person using "Compensation - Salary History Details Real Time" Subject area. I ca…User_2025-01-25-06-20-12-259 134 views 18 comments 0 points Most recent by User_2025-01-25-06-20-12-259 Reporting and Analytics for HCM
-
Reporting on Working Pattern/ Work Schedules aswell as current assignment information in a single reSummary Possiblity of generating a report Including Working patterns/Work and Assignment information within an Analysis/ReportContent Hello, We are currently struggling …Brad Hughes 104 views 4 comments 0 points Most recent by Brad Hughes Reporting and Analytics for HCM -
Comments of manager for annual performance interview information in BI publisherSummary Where can I find the comments of the manager for the annual performance interview in PI publisher (fusion tables)Content Hello, Someone know where can I find in …User_I6AXL 78 views 3 comments 0 points Most recent by User_2025-01-28-09-43-13-552 Reporting and Analytics for HCM
-
Location of Performance Document Manager for BIP in Release 11Summary I would like to know the location of Performance Document Manager for BIP reportContent I have a BIP report where the user, manager's name, and the last complete…Christina Anglin 91 views 6 comments 0 points Most recent by User_2025-01-28-09-43-13-552 Reporting and Analytics for HCM