OTBI
Discussion List
-
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 79 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 42 views 9 comments 0 points Most recent by Hazel De Castro Reporting and Analytics for HCM -
Alert new offering with alert composer .Summary Notify users enrolled in a course when a new offer is added to it.Content Hi, everybody, someone has information about the possibility to create a custom notific… -
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 -
How to combine two rows of text data into a single column in OTBI?**This post was created as part of a How to Service Request (SR) Release: 11.13.22.07.0 Summary of the question: How to combine two rows of text data into a single colum…Priscila Terazawa - Support-Oracle 656 views 2 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
How to find encumbrance in PPM OTBI Subject AreasSummary: HI Team, I want to find encumbrance in OTBI Subject Areas. Can you please help me to find same. Regards Nidhi Content (required): Version (include the version y… -
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 -
OTBI Dashboard Prompt based on "Trading Partner Item Details" is not returning valuesSummary: We have. a dashboard that contains an analysis and a prompt. The prompt is based on the following sql query: SELECT 0 s_0, "Product Management - Trading Partner…Hassan El Bouihi-Oracle 51 views 3 comments 0 points Most recent by Wim Bos [MLE] Product Master Data Management -
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 -
How to properly address P2T ERP missing subject areas when support remains unresolved after a week?Summary: Missing OTBI subject areas after every clone, support unresolved Content (required): Every clone has same issues with OTBI subject areas missing. We follow SR g…Melissa Goodrich 21 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle Reporting and Analytics for ERP -
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 -
Is there an attribute in PPM that shows the Return on Investment (ROI) of a Project or Program?Summary: In Project Performance or Program Analisys or OTBI, is there a collumn that represents the return of investiments? I didn't find this field. ROI = (Gain from In…Wilromar Benevides 31 views 2 comments 0 points Most recent by Wilromar Benevides Project Management -
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 …