OTBI
Discussion List
-
How to ensure consistent output of default Date format in OTBISummary Default Date format is different for 2 different users who have same Regional PreferencesVersion Oracle Cloud Application 21B (11.13.21.04.0)User_UM4C6 24 views 1 comment 0 points Most recent by User_2025-02-06-14-37-05-233 Reporting and Analytics for HCM -
Resignation Rejected ReportContent Hi Team, We are looking for some report by which we can fetch the data for all the Resignation status was Rejected. In our current environment, when the employee…Kiran Kancherla 28 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Checklist item and report on there StatusSummary Need a report for onboarding checklist (DoR) which the acknowledgementContent Team, We have onboarding checklist items and using BI publisher for some of them to…Santosh Mudide 55 views 4 comments 0 points Most recent by Santosh Mudide Reporting and Analytics for HCM -
Generate Workpattern code like NYYYYYNSummary Generate Workpattern code like NYYYYYNContent Hello I am trying to generate an understandable work pattern code like NYYYYYN for reporting. Any quick pointers ho…Murthy Kodavati 21 views 2 comments 0 points Most recent by Murthy Kodavati Reporting and Analytics for HCM -
How to create a Custom Job Role (Read Only) for using "PAYROLL - ELEMENT ENTRIES REAL TIME" subjectSummary Need to create a Custom Role which gives read only access to UI and allow access to "PAYROLL - ELEMENT ENTRIES REAL TIME" subject areaContent Hello Experts I hav…Dharmendra Shukla 23 views 2 comments 1 point Most recent by Dharmendra Shukla Reporting and Analytics for HCM -
How to convert Bonus percent into amountSummary Need to convert Bonus Target Percent (field) into Bonus Amount using Annualized Salary (Local) fieldContent I need to convert the percent numbers into % numbers …Abhishek Bagh 37 views 2 comments 0 points Most recent by Senthamizh Arasu Govindan Reporting and Analytics for HCM
-
Positions Report With Active Employees and Blank PositionsSummary The report i created does not show open positions when i apply filter on Assignment status Not Equal To InactiveContent Hi, I created a position report using "Po…User_2025-02-11-02-55-52-410 52 views 3 comments 0 points Most recent by User_2025-03-07-05-10-47-928 Reporting and Analytics for HCM -
Report on Attached Documents to HelpDesk Service RequestsContent Hi all, I was just wondering if anyone knew if it was possible to report on the files attached to Service Requests on HelpDesk. I've had a look at the Subject Ar…
-
Need help on Logical SQLSummary Need help on Logical SQLContent Hi , I have added three columns to existing logical sql OTBI, After adding the three new fields report format has changed, Can an…Reddykrishna Chidella-Oracle 50 views 4 comments 1 point Most recent by Reddykrishna Chidella-Oracle Reporting and Analytics for HCM -
Need inputs to display data in a single record for each employee if an employee is having multiple aContent Hi All, We have a requirement to display Person, Visa and assignment details through OTBI. As of now we are using below two subject areas to achieve this require…
-
Customize OTBI Analysis Header FieldsSummary Need Help with customizing the OTBI analysis header field to a custom nameContent Hello Everyone, I am new to OTBI analysis and I need help with some customizati…GauravGupta39 49 views 2 comments 1 point Most recent by Ellen Manthei Reporting and Analytics for HCM
-
Subject Area which includes Maternity Weekly Average EarningsContent Can any one help me to identify subject area which contains below highlighted field in the attachment? Absence Administration (Maternity Leave) -> Override Avera…ViswanathaReddyKetireddy 29 views 2 comments 0 points Most recent by ViswanathaReddyKetireddy Reporting and Analytics for HCM
-
No access to create BI Publisher reportSummary No access to create BI Publisher reportContent Hi all, is it possible to give users access to create/Modify only OTBI reports but only read-only access to BIP re…Prashant Kumar - 2103 42 views 4 comments 1 point Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM -
OTBI Agents and BI publisher scheduling us there a Report displaying the active scheduling ?Summary OTBI Agents and BI publisher scheduling us there a Report displaying the active scheduling ?Content Hello , We would like to have a list of the existing active a…Revital Mefano 45 views 12 comments 0 points Most recent by Prudence K Reporting and Analytics for HCM -
Export my Favourites analysesContent Hi there, is there an easy way to export the favourite analyses. I do not mean the actual analyses but rather the structure that one has under Favourites. Thank …Bobby Jourdan 9 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Override Average weekly earning field in OTBIContent Does anyone know if the Override Average weekly earning field that can be found in Absence Records under legislative information is available in OTBI?Tasha 25 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI Pivot Table - Value FilterContent Hi, I am looking at how many assignment actions have been processed on the same effective start date per employee. In OTBI I have an assignment history report lo…
-
Deploy OTBI artifactsSummary How to deploy OTBI artifacts (REST or SOAP available?)Content Hi All, I would like to know if there is a way (apart from manual operation) to deploy OTBI artifac…User_U66J8 27 views 4 comments 0 points Most recent by Anil Kola-Oracle Reporting and Analytics for HCM
-
Headcount by Age Band in Workforce Trends Real timeSummary Unable to count headcount by Age Band as compared to other attributesContent Hello Experts! I'm hoping this is an easy one! I'm trying to report Period End Headc…Rob F 88 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Scheduled Report Returning only 25k rowsSummary Scheduled Report Returning only 25k rowsContent I have an OTBI report that i am running that has output greater than 25k rows but less than 65k rows. I thought i…User_EQ8R5 84 views 4 comments 0 points Most recent by Raymund Jerome Reporting and Analytics for HCM
-
Report Job History does not display informationSummary OTBI Report Job HistoryContent OTBI Report Job History displays for a few seconds and then screen mostly vanishes in Production.User_2025-02-10-21-24-50-036 39 views 5 comments 0 points Most recent by Juan Rendon Reporting and Analytics for HCM
-
How to add drill down feature on Formula ColumnSummary How to add drill down feature on Formula ColumnContent Hi Experts I created an analysis using "Workforce Management - Worker Assignment Real Time" to see the Age…Dharmendra Shukla 40 views 6 comments 0 points Most recent by Dharmendra Shukla Reporting and Analytics for HCM
-
OTBI Multi-Language SupportSummary This white paper explains how OTBI supports multi-language translation, the current limitation and the planned enhancementContent OTBI supports multi-language tr…User720640-Oracle 677 views 3 comments 7 points Most recent by Tamer El-Tonsy - Tatonsy Reporting and Analytics for HCM -
Configuration Fusion HCM OTBI SecuritySummary This white paper is a guide in how to configure security for HCM OTBI.Content This white paper addresses how to: * Grant line managers and employees the ability …Rebecca Emerson 544 views 3 comments 12 points Most recent by Tamer El-Tonsy - Tatonsy Reporting and Analytics for HCM
-
Restricting BI Answers Access for Fusion Application UsersSummary This paper outlines steps that customers can take to restrict user access to BI catalog.Content This paper is published by Oracle OTBI product development. By de…User720640-Oracle 261 views 3 comments 9 points Most recent by Tamer El-Tonsy - Tatonsy Reporting and Analytics for HCM
-
How to Implement Specialized Reporting Security in OTBI for Fusion HCMSummary Creating Custom Roles for Specialized Reporting Access in Oracle Transactional Business Intelligence (OTBI)Content By default OTBI would always enforce Fusion HC…user714053-Oracle 695 views 2 comments 6 points Most recent by Tamer El-Tonsy - Tatonsy Reporting and Analytics for HCM
-
Busting OTBI Myths - NOT INContent Myth: OTBI can't give me a list of workers without goals (or absences or ...) There are a few ways to perform a "NOT IN" query. The easiest and most performant i…Julian Challenger-Oracle 105 views 1 comment 2 points Most recent by Tamer El-Tonsy - Tatonsy Reporting and Analytics for HCM -
Use of Variable prompt in OTBIContent Hi Experts, Greetings of the day!! Can someone please let me know the use of variable prompts in OTBI analysis. Regards, Divya Version 21ADivya Kollipara 47 views 2 comments 0 points Most recent by Divya Kollipara Reporting and Analytics for HCM
-
Compare two fields from two different subject areasSummary I am trying to put a filter where I compare the Requisition country to an Employee's nationality but they are from two different subject areas and the output is …User_2025-02-05-06-55-02-399 169 views 14 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Time card entry report in OTBISummary Time card entries not visible in "Workforce Management - Reported Time Cards Real Time" SAContent Time card entries are not visible in "Workforce Management - Re…Mohit Gupta-45440 331 views 26 comments 1 point Most recent by User_2025-02-11-15-16-39-434 Reporting and Analytics for HCM