Reports
Discussion List
-
How to use MAX Date in OTBIContent Hi I'm getting multiple work relationship records, I would like to return only the latest work relationship record. How can use MAX function to select the latest…User_2025-02-07-19-03-14-525 2.6K views 8 comments 0 points Most recent by User_2025-02-11-05-19-35-410 Reporting and Analytics for HCM -
BIP report: Users with HR and line manager role should only see their direct/indirect reportsSummary: BIP report: How can we make sure that when an HR User, who is also a Line manager, is only seeing their own reports (direct and indirect) when pulling the repor…Franziska Reichel 191 views 6 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Need an Oracle documentation which list changes done to database or TablesOracle agreed to share a documentation which will help customer identify changes done to Tables which might affect BI Publisher reporting. But, Oracle said there is no d…Vamsi Kuchipudi 11 views 2 comments 0 points Most recent by Vamsi Kuchipudi Reporting and Analytics for HCM
-
workforce management - worker assignment real time returning in correct dataSummary: We are maintain an OTBI analysis which fetches Core HR details adding Grade Step column is fetching incorrect details. PFA snippet for more details Please let m…Manoj Kumar S 31 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
SQL Help for Dates crossing into New YearSummary: HI All, I have a requirement to pull a list of dependents that will be turning 21 within 6 weeks (ie. If I run the report today, I should be pulling into those …User_2025-02-04-08-51-08-912 21 views 6 comments 0 points Most recent by User_2025-02-04-08-51-08-912 Reporting and Analytics for HCM
-
Placing a Report Job on HoldSummary: Content (required): I have a report in OTBI that is scheduled to run every Monday morning. I would like to place the job on hold for the next month (December) a…Annette M 21 views 1 comment 0 points Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for HCM -
Workforce Compensation Page Parameters for EL ExpressionsContent Hello experts, is there an Oracle official documentation which can allow me to have all compensation module parameters (i.e. ManagerId; PlanId; etc.) in order to…Valerio Curzi 37 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
HR Recruitment process metricsContent As part of the end to end recruitment process, I would like to report the following basic metrics..... 1. Job Requisition submitted (by hiring mgr/SDA) to Job Re…User_2025-02-11-13-03-12-474 39 views 3 comments 0 points Most recent by Harriet Reporting and Analytics for HCM
-
Changing Ownership of Scheduled AgentsSummary: We recently had an employee leave the company who was the owner of the majority of our reports and scheduled agents. In an effort to safe time, is there a way t…User_2025-02-11-00-58-38-371 21 views 1 comment 0 points Most recent by Paidiparthi Ravindra Reporting and Analytics for HCM
-
Fiscal Year, quarter and Month in OTBI reporting as a parameter and also as a fields.Summary: We have a requirement to report Employee Details based on Fiscal Year, Fiscal Quarter and Fiscal Period. In the subject Area Workforce Management Assignment Eve…Venkateswaran Murali-Oracle 531 views 2 comments 1 point Most recent by Venkateswaran Murali-Oracle Reporting and Analytics for HCM
-
Dynamic Dates for Parameters or SchedulesSummary Is there a list of dynamic dates for use in parameters or in schedules?Content Hi all - I did review this post (https://cloudcustomerconnect.oracle.com/posts/862… -
Not a Question: Dynamic Date Parameters in BI ReportContent This is not a question and I have shared the info, For most of the BI Reports we have the input parameter as "AsOfDate" alias Sysdate or current date. Sometimes …Janardhana Kondaveeti 129 views 5 comments 15 points Most recent by Visu Reporting and Analytics for HCM -
Dashboard with two Prompts: Selecting a value in the first Prompt changes the value in the second PrContent Hello All, In the dashboard “Performance Evaluation Comparison FCU Second Half”, there are two different Prompts, each Prompt uses the same field in OTBI "Perfor…
-
How to exclude logged in user from BIP report?Summary: Logged in user needs to get excluded from their own BIP performance report Content (required): Hi, we have built a custom BIP report for performance data for ma…Franziska Reichel 31 views 4 comments 0 points Most recent by Franziska Reichel Reporting and Analytics for HCM
-
Delegation ReportSummary: Content (required): Is there a report or a subject area in which we can report all current delegations? We want to find which people are delegating to others an…Annette M 21 views 2 comments 1 point Most recent by Wiktor Ornatowski-Oracle Reporting and Analytics for HCM
-
Termination - reporting offboarding commentsSummary: Content (required): We are trying to create a report that selects all terminated employees within a date range, along with the term action reason. Many times ou…Annette M 61 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
SQL or tables for Resignation Workflow Approver historySummary: Resignation Workflow Approver history Content (required): Hi all, I need to pull our the workflow details of Resignation workflow in BI. So please let me know f…Aditya Lanka 421 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
SQL query to retrieve earnings and deductionsSummary SQL query to retrieve earnings and deductionsContent Hi Experts, I'm designing a balance extract that needs to fetch pension deductions 403. To create the data g…Aloka Bhattacharya 2.7K views 6 comments 2 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
OTBI report logic to fetch Employees who were in current position as of 1st June,2019Summary: We have a requirement to create an OTBI report which will fetch all Employees who were in current position as of 6/1/2019. I was looking at the subject area - '…Sovan Mishra-Oracle 131 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to find 'User Defined Column' within Compensation PlanSummary: Can anyone help locate this field within a Compensation Plan. I need to find "Numeric Column 18", preferably within a Subject Area or if it's only within a tabl…Andrew_Schmitz 41 views 5 comments 1 point Most recent by Andrew_Schmitz Reporting and Analytics for HCM -
Performance Task Next Step BIP ReportSummary: Creating a BIP report for Performance Tasks showing Step/Next Step Content (required): We have a BIP report for the Performance Task Steps which include Task St… -
Report to Audit object migrationsSummary: A report that shows who created/updated application objects (i.e. Fast Formulas). Content (required): Version (include the version you are using, if applicable)…Wayne Smith 31 views 2 comments 0 points Most recent by Paidiparthi Ravindra Reporting and Analytics for HCM
-
Unable to find Filing Status, Allowances and Exempt fields in OTBI in 19CContent Hi All, We are unable to find the "Filing Status" , "Exempt" and "Allowances" fields in "Payroll - Calculation Cards Real Time" OTBI subject area. When we click …
-
Subject Area filtering - empty valuesSummary: Subject Area filtering - empty values Content (required): Subject Area filtering of Assignment Type filters out empty values as well. For example, if we have pe…User_2025-02-11-21-40-21-159 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Need SQL to get Element Duration DatesSummary: Need SQL to get Element Duration Date, that is at assignment level. Content (required): Need SQL to get Element Duration Date, These dates are present in 3 leve…Raghavendra M 213 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Report on 'Ad Hoc' feedbackContent The business has decided they want the option to give feedback without the one receiving the feedback being able to see it (don't ask me why). We've advised the … -
Termination Report Unable to Pull In SalariesSummary Trying to pull a historical report of terminations in a certain location with salary amount at time of termContent Hi - I have looked into a number of posts rega…Kyle Norris 72 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Report to fetch Element with assignment number and name for employeesSummary: i am using the below SQL to fetch the details. But the SQL is taking time to fetch the details. Can anyone please let me know if my i am missing any join Conten…minati_behera-Oracle 21 views 1 comment 0 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM
-
Sum of Distinct/Unique values in Header for ETEXT templateSummary: Sum of Distinct/Unique values in Header for ETEXT template Content (required): I have 4 records for same person in my xml. All 4 records have same salary($2000)…Jaeyshree Kumaran 513 views 5 comments 0 points Most recent by Jaeyshree Kumaran Reporting and Analytics for HCM
-
Year to Date Turnover FilterSummary How to return Year to Date (YTD) this year vs. YTD previous years for turnover metrics.Content I'm trying to return year to date turnover and compare it against …Ryan_Sullivan 35 views 3 comments 0 points Most recent by Ryan_Sullivan Reporting and Analytics for HCM