OTBI
Discussion List
-
Restrict Participation in Another Plan Fast FormulaSummary: Content (required): Hello everyone, I'm currently trying to create a Fast Formula that will restrict population's eligibility for Compensation Plan B if they ar…Maria Xydopoulou 31 views 0 comments 0 points Started by Maria Xydopoulou Reporting and Analytics for HCM -
Created Eff for Extra internal info in candidate application details section in a requisition,Summary: I have created a eff under person extra info it is BI enabled . Content (required): I have run the ESS Job Import Oracle Fusion data extension for transaction B…Rajib_Samanta 201 views 4 comments 0 points Most recent by Rajib_Samanta Reporting and Analytics for HCM -
Checklist QuestionnaireSummary Provides the details of the questionnaire assigned to the worker, questions and responsesContent You can report on the questionnaire questions and responses from…Raghavendra Raghunath-Oracle 881 views 13 comments 5 points Most recent by Shweta Reporting and Analytics for HCM -
Does anyone know how to prevent BI Folder being accidently moved?Summary: Any strategy to prevent the BI folder structure from being accidently manipulated. When a folder is accidently moved, the reports that use a BI Publisher data m… -
Is the performance goal section possible to pull in OTBI?Summary: I was able to pull the overall summary rating and rating from the competency section which is the behavior office (refer to the screenshot) however, I cannot fi…Christian Suarez 31 views 3 comments 0 points Most recent by Christian Suarez Reporting and Analytics for HCM -
OAC vs OTBI best for reporting ?Summary Soliciting comments and feedback as to when OTBI is best for reporting vs. Oracle Analytics CloudContent Hello Forum: I'm looking for feedback when OTBI might be… -
Unable to Join Multiple Subject AreasSummary: Unable to join "Workforce Management - Absence Real Time" Subject Area with "Workforce Management - Worker Assignment Real Time" Content (required): Our require…Jyothi Gorantla 31 views 4 comments 0 points Most recent by Jyothi Gorantla Reporting and Analytics for HCM
-
Reports for Goals Completed in Plan YearSummary: I'm looking for the best way to report on all goals completed based upon the plan year. I've attempted to use the 'Goal Status Overview Real Time' subject area.…Lauren K. 11 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Recruiter ScorecardSummary: Content (required): Has anyone created a recruiter scorecard before? How do you deal with requisition metrics if there was recruiter turnover and the new recrui…Riti Malhotra 31 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
'Performance Document Rating Distribution' report not runningSummary: Hi Peers, I'm trying to make use of the seeded report 'Performance Document Rating Distribution'. It is not running whereas other seeded reports (e.g. 'Performa…S Shree 51 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Can we define hierarchies in OTBI reportsDear , I have a requirement to do hierarchies in OTBI report, it is possible in otbi report? For example if i am login and open report its shows only my and under my emp…Mirza_Adeel 51 views 28 comments 0 points Most recent by Mirza_Adeel Reporting and Analytics for HCM -
EEO Reporting for Federal, State and LocalHi all, Is there any document which tells us more about "Submit EEO-4 State and Local Government Report for US". Thanks, Sathish -
Trying to create a simple analysis or report to view the performance document questionnaire questionSummary I am trying to create a simple analysis via OTBI to view the performance document questionnaire questions, but it will not pull up 2019 performance documents whe…Andy Rayburn 75 views 11 comments 0 points Most recent by Hazel De Castro Reporting and Analytics for HCM -
Where can I find "Job Definitions" for ESS jobs?Summary: I'm looking for a list of ess job definition names such as: 'JobDefinition://oracle/apps/ess/hcm/users/SyncRolesJob' Content (required): The end goal is to crea… -
OTBI: Questionnaire ScoreSummary: Trying to pull the overall score from a questionnaire tied to performance document Content (required): Hello all, I'm trying to build a report in OTBI where I c…Hazel De Castro 41 views 9 comments 0 points Most recent by Hazel De Castro Reporting and Analytics for HCM
-
OTBI Report: Matrix manager as participantSummary: Hello, Has anyone created an OTBI report regarding matrix manager as participant: overview for HR for which performance documents a matrix manager/stakeholder i…Hazel De Castro 31 views 2 comments 0 points Most recent by Hazel De Castro Reporting and Analytics for HCM
-
Last_updated_by column is showing user name not full name in OTBI reportSummary: Last_updated_by column is showing user name not full name in OTBI report Content (required): Does anyone know how to get full name of the person in last updated…
-
Educational Major meaning in OTBISummary Only code is available in Person ProfileContent Hello Everyone!I need your help again. We are building and Educational report and the Major information a code ("…Alvaro Couto 31 views 5 comments 1 point Most recent by User_2025-03-07-05-33-11-638 Reporting and Analytics for HCM -
HR Action Original creation dateSummary Report on HR Action original creation dateContent Hello, Has anyone written a report of HR Actions history that includes original action entry (creation) date? I…User_2025-02-04-15-06-22-759 81 views 5 comments 0 points Most recent by Scott Conaway Reporting and Analytics for HCM -
Requested feedback reportContent We are trying to build a report to get the requested feedback details using ‘Workforce Performance - Requested Feedback Real Time’ subject area. However, no data…User_2025-02-05-23-59-37-171 115 views 13 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Filter Person Number Using Copy PasteSummary: In an OTBI Analysis, is there a way to filter a column based on a copied list of values? For example a column from an excel file or a comma separated list. For …
-
Payroll Arrears Audit ReportSummary Allows you to audit for any arrears deductions prior to finalizing payrollContent This audit report is run after the first payroll calculation to check for arrea…Becky Stalsby 254 views 4 comments 4 points Most recent by Stephanie Turner Reporting and Analytics for HCM -
Tenure in Job FamilySummary: Content (required): I am looking for time in job family. I have reports already for overall tenure and time in current assignment/job but need something for job…Riti Malhotra 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Report to fetch the timecard approver detailsSummary: Content (required): We have a client requirement to build a report to fetch the timecard approver details. Does anyone know whether it is possible to fetch the …Prajna Hegde 141 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Secure OTBI so user can see only 1 folderSummary: We are implementing EHS and want the safety managers to only see the EHS folder under the custom folder. Content (required): Do we need to apply permissions to … -
OTBI does not show accrual/absence balance dataSummary: I'm trying to create a report which shows an employee's accrual. However it does not show any data in OTBI. Content (required): I want to create a report in OTB…Nicolas Vahman 351 views 8 comments 0 points Most recent by Sandeep001rp Reporting and Analytics for HCM
-
Does a CLOB column supported by Advanced SQL Tab in OTBI when combining two subject areas?Summary: I always get an error when I tried combining two subject areas in OTBI under Advanced tab which consist of a CLOB column such as comments. Does anyone know how …Hazel De Castro 41 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
OTBI Subject Area or Query to retrieve Job Profile informationSummary: Content (required): Hello experts, is there an OTBI subject area to retrieve Job Profile information such as: ProfileItemId, ProfileId, ProfileCode, ContentType… -
Reporting issue - How to show sickness days vs actual worked daysSummary: Reporting issue - How to show sickness days vs actual worked days Content (required): I am trying to write a report to show the number of days a person is contr…User_2025-03-07-06-11-23-192 21 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM