OTBI
Discussion List
-
Oracle Learning Planning Prices -> Any alternates to get previous history from 'wlf_plan_records_f'Summary wlf_plan_records_f - does not keep date-tracked rowsContent Hello, Can anyone please help? At the moment, the OLC table 'wlf_plan_records_f' does not keep date-t…SantoshKumarBhairi 9 views 2 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
In need of an AAP Promotion report (FROM and TO details on job)Summary In need of an AAP Promotion report (FROM and TO details on job)Content We have AAP promotion report due in which they are asking FROM and TO of a job in a promot…Adil_R 72 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OBTI Formula for January 1st of Current YearContent I need to get the age of the worker for the start of the year in an OBTI analysis. I have Oracle's formula to calculate age: TimeStampDiff(SQL_TSI_YEAR, "Worker"…Greg Bennett 100 views 8 comments 0 points Most recent by Greg Bennett Reporting and Analytics for HCM -
Expenses Employee Number to Worker - Person NumberSummary Cannot connect 2 subject areas to merge data in OTBIContent Using OTBI I am attempting to merge subject areas Workforce Management -accruals real time with Expen…User_2025-02-10-15-06-52-222 30 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Transaction Approvals and Person NumberContent Hi, I have created logical SQL to return 'Rejected' Document Records from the following subject areas: * Human Capital Management - Approval Notification Archive…Karen Waddell 59 views 14 comments 2 points Most recent by Karen Waddell Reporting and Analytics for HCM -
Duplicate rows returned for some Employees in Production OnlySummary Duplicate rows returned for some Employees in Production OnlyContent Hi, When I run the attached analysis which is developed using logical SQL it returns duplica…Karen Waddell 39 views 10 comments 0 points Most recent by Karen Waddell Reporting and Analytics for HCM
-
modify list of recipients on scheduled reportSummary modify list of recipients on scheduled reportContent We have a scheduled report to which I need to add two recipients. I have not had any luck in the schedule or… -
How to export approval rules configured for HCM transactions such as Absence, Employment etc.Summary How to export approval rules configured for HCM transactions such as Absence, Employment etc.Content Looking for a report to fetch the custom approval rules conf… -
Termination Report with Last SalaryContent I am trying to create a report that has both the reason the employee has left the company (i.e. Voluntary, Involuntary) as well as the salary the employee was re…User_2025-02-06-13-59-03-061 93 views 8 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
ORC - Candidate diversity dataSummary Pull the diversity data for any candidate who has gone through interview process, irrespective of current statusContent Is it possible to pull the candidate dive…User_2025-02-10-17-54-52-878 59 views 1 comment 0 points Most recent by Ellen Manthei Reporting and Analytics for HCM
-
Issues on Termination report with datesSummary Termination report not showing correct amountsContent Hi, I have created Termination report using "Workforce Management - Worker Assignment Event Real Time" subj…Niko Hölttä 28 views 4 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Need inputs to link between calculation cards and Payroll resultsContent Hi All, Can we have a link between Payroll results and Calculation cards tables/subject areas? If anybody is having any links share to us. Thanks, VisuVisu 31 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Pivot tableContent I have created a pivot table for recognition against the business unit. I am trying to get a percentage of the number of employees who received a recognition aga…User_2025-02-06-11-18-47-896 36 views 4 comments 0 points Most recent by User_2025-02-06-11-18-47-896 Reporting and Analytics for HCM
-
Need help with using EXISTS in logical sqlSummary Exclude INACTIVE records created due to legal entity transfer in OTBI analysisContent Hi Experts, I am trying to create an analysis to report both active and ter…Nikhil Bhandari 59 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Not able to fetch the absenec plan balance adjustment date ( i.e ProcdDate in PersonAccrualDetail.daSummary Need to Fetch Balance Adjustment details for different plans . Not able to fetch Balance adjustment date ( i.e ProcdDate in PersonAccrualDetail.dat file)Content …User_2025-01-30-17-37-30-647 34 views 4 comments 0 points Most recent by User_2025-01-30-17-37-30-647 Reporting and Analytics for HCM
-
Resize a performance tileSummary I would like to arrange about 10 of them next to each other and I need to reduce size of each container.User_2025-02-08-08-49-19-186 34 views 2 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Column to be added with option 'Created by' which should give information of Employee Name - While cSummary Column to be added with option 'Created by' which should give information of Employee Name - While creation on new Analysis in reportsContent Hi, While creating …User_2025-01-24-00-17-22-300 35 views 3 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Report on Scheduled Process (ESS Jobs)Summary Looking for report on Scheduled Process (ESS Jobs)Content Hello, I'm looking for a report on scheduled processes. Does anyone have such report and would like to … -
Logical SQL Reports and Report HeadingsSummary Logical SQL Reports and Report HeadingsContent Hi, I have created a report using Logical SQL and was wondering if it is possible to include a user friendly Colum…Karen Waddell 34 views 7 comments 2 points Most recent by Karen Waddell Reporting and Analytics for HCM
-
Set PARAM_EFFECTIVE_DATE within a UNIONSummary Combine results of 2 analysis when one has an effective dateContent I have two reports with the same columns and I am combining them with a UNION. However one an…s_b 41 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Line Manager Dashboard VisualSummary Show / Hide certain visual based on a prompt field valueContent We have a requirement to show or hide a graph based on the field value of the prompt. E.g. Legal …User_2025-02-10-17-54-52-878 37 views 4 comments 0 points Most recent by User_2025-02-10-17-54-52-878 Reporting and Analytics for HCM
-
Organization Tree - Filter on active versionsSummary Provides you the process to filter out the inactive organization tree versions by defaultContent Issue: Organization Trees display all the versions in HCM OTBI s…Raghavendra Raghunath-Oracle 101 views 0 comments 1 point Started by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Point in Time Org Chart with open vacanciesContent Hello, Has anyone built a Point in Time Org Chart with open vacancies? Thanks in advance!Dishti Malhotra-Oracle 30 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
To hide "Home", "Catalog" option while opening an OTBI Dashboard via Widget on Home Page.Content We have a requirement where we need to call an OTBI dashboard via Widget on the Home Page. The road block is to hide the Home, Catalog, Advance, etc. tab that ar…
-
OTBI report to show records ONLY if there was a change in a particular fieldSummary OTBI report to show records ONLY if there was a change in a particular fieldContent Hello, I need to pull a report on a weekly basis if any employee got their Ma…User_2025-02-04-15-06-22-759 314 views 8 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
OTBI Agent Email Analysis Run As Of Date Derived by SQLSummary Trying to setup existing 'Point in Time' analysis with AsOfDate Parameter as automated agent that uses SQL to derive the last day of the prior month at runtimeCo…James Hoffmann 88 views 13 comments 0 points Most recent by James Hoffmann Reporting and Analytics for HCM
-
Find courses not completed in a specializationContent Hello, I have created an OTBI report for our specializations in learn, but I cannot get the report to show which courses are still outstanding. In the screen sho…User_2025-02-06-11-18-47-896 49 views 2 comments 2 points Most recent by User_2025-02-06-11-18-47-896 Reporting and Analytics for HCM
-
How can I filter on column and not a measures in OTBISummary Filter in a sample column and not a measures how can i do it??????Content Hello, I want to transform a simple column in otbi into a measures to create a filter :…User_I6AXL 43 views 2 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Error with Month as a Presentation Variable PromptSummary ORA-01722: invalid number at OCI call error when calling the report through prompt but works fine when hard-codedContent OTBI Report runs fine in Edit mode and s…
-
Selection Steps/Filters per table in one reportContent Hi all, I'm wondering if it's possible to put different filters or selection steps per table, but within one report. I'm making some headcount reports and want t…User_2025-01-31-00-25-12-234 23 views 2 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM