OTBI
Discussion List
-
Changes to BIP report are not reflectingSummary Changes to BIP report are not reflecting in the data. We have changed few columns in the Dataset but the report output displays old column data.Content Changes t…Thiru Vedantham 584 views 3 comments 1 point Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP -
Report for Box 1 of the W2 balance valueSummary Provide a list of highly compensated employees using Box 1 of the W2Content I am trying to get a list of highly compensated employees whose Wages, Tips, other co…User_2025-01-28-09-44-42-254 105 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Need tablenames to pull Valueset values in BI reportContent Hi, I have requirement to pull value set values in BI publisher report. I am not able to find the table names for the valueset in HCM. Can you please let me know…PankajRK 38 views 2 comments 1 point Most recent by Sricharan Monigari Reporting and Analytics for HCM -
Is it possible to display the filter values at the Header section in OTBI?Summary Is it possible to display the filter values at the Header section in OTBI?Content Hello Team, We are trying to display the filter values at the Title section in …Harish Kumar Kovi 36 views 3 comments 0 points Most recent by Harish Kumar Kovi Reporting and Analytics for HCM -
Adobe Flash to run reports/dashboards on browsersContent Hi All, Over the past few days while working in OTBI, I kept getting asked to run flash everytime I opened a report or dashboard- eventhough flash is already ena…PriyaPenugonda-SC 72 views 6 comments 4 points Most recent by PriyaPenugonda-SC Reporting and Analytics for HCM -
XPT Ouput(User Interface Layout) is running under ProgressSummary XPT Ouput(User Interface Layout) is running under ProgressContent HI Team, We have report which has XPT Layout output(User Interface Layout).We have given open p…nitin Sharma 21 views 7 comments 0 points Most recent by Shakher Sharma Reporting and Analytics for HCM -
VIZIYA MAINTENANCE SUMMIT & USER GROUP 2019Summary Join us in Music City in November for our MAINTENANCE (only!) Summit - Oracle eAM & Maintenance Cloud together again!Content VIZIYA MAINTENANCE SUMMIT & USER GRO… -
OTBI Analysis - Controlling Alphanumeric Sort - Uppercase and Mixed Case SequenceSummary How to override the impact of Upper Case data that is sorted ahead of mixed case?Content See attached image. Suppliers "Adams..., Adjuster.., Advanced..., and Ad… -
Access for General Ledger DashboardsSummary Cannot view data for seeded GL Analytics DashboardsContent Hello, What security role do I need to access the General Ledger Dashboards: Account Analysis, General…User_2025-02-05-07-37-39-271 55 views 4 comments 0 points Most recent by User_2025-02-05-07-37-39-271 Reporting and Analytics for ERP -
Reporting on Weekly Changes to Workforce TrendsContent We have a business requirement to report of weekly changes to FTE count for our departments. Where there's not a weekly time dimension in the Workforce Trends su… -
Report to show all invoices, amounts, VAT and attachmentsSummary A report that will identify all invoices, with invoice amount and VAT amount along with a field that pick up the file attached name (including extension i.e. .pd… -
Accessing user-defined tables in OTBIContent Hi All, I have few user defined tables in HCM.Department ID and Department Name. Now I want to access this user defined table and user defined columns and put a …User_DYMHE 325 views 1 comment 0 points Most recent by MandeepKGupta Reporting and Analytics for HCM -
Copy Link requires - Adobe Flash PlayerContent This is an annoying error which keeps coming for Line Managers. Is there a way to fix this issue? ThanksMisbahul Khair 57 views 4 comments 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Calling UDT in OTBISummary We need to get UDT values on OTBI AnalysesContent Hi All, I am working on an OTBI analyses where we need to derive values from UDT. I am not able to see these UD…Vibha Pandey - Oracle 692 views 19 comments 0 points Most recent by User_F1ZIP Reporting and Analytics for HCM -
How to calculate the correct number of employeeContent Hi Guys, I need to calculate the correct number of the employee active in the company. I used the Headcount field with the filter Assignment status == Active, Ac…Giuseppe Iacono 46 views 6 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Look Up Value as Of DateContent Hello, Is it possible to create a field in OTBI to look up a value as of date. The requirement I have is to pull an employees current job and salary and their jo…User_2025-01-31-00-25-12-234 51 views 16 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Problem in a Presentation VariableContent Hi Guys, I have a problem in a report that I created to filter the entry elements for effective start date. I don't able to change the effective start date field…Giuseppe Iacono 38 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Report viewing problemContent Hi Guys, I have a big problem with the report viewing. I created a HR Dashboard, every employees can see the Dashboard, but who have the procurement role don't h…Giuseppe Iacono 32 views 5 comments 0 points Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for HCM -
Formula to sum up linesSummary Formula to sum up linesContent Hi all, Just wondering if I have PO lines say 3 lines and I want to display the total sum of the PO amount. How to do it in BI pub…User_2025-02-04-05-26-22-197 50 views 5 comments 0 points Most recent by Ramesh Nayak Reporting and Analytics for ERP -
Can we get 'Time in Position' through OTBI?Summary Can we get 'Time in Position' through OTBI?Content Hi Team, Is it possible to get 'Time in Position' column through OTBI. Means how long the assignment exists in…Harish Kumar Kovi 55 views 5 comments 0 points Most recent by Harish Kumar Kovi Reporting and Analytics for HCM -
Audit for multiple open assignment-related transactions on same associateSummary Audit for multiple open assignment-related transactions on same associateContent Good afternoon. Wondering if anyone has built an audit (in either OTBI or BIP) t… -
Payroll User-Defined Tables Real TimeSummary OTBI joining subject areasContent Hello. I am trying to link the "Payroll User-Defined Tables Real Time" subject area to the "Person Real Time" / "Workforce Mana…User_F1ZIP 80 views 1 comment 0 points Most recent by Harish Kumar Kovi Reporting and Analytics for HCM -
Date prompt is getting passed in invalid format to BI report used in Dashboard.Summary Date prompt is getting passed in invalid format to BI report used in Dashboard.Content Hello, We are facing an issue in while using dashboard as BIP as content. …~ GK ~ 349 views 4 comments 1 point Most recent by Vinod Andhavarapu Reporting and Analytics for HCM
-
How to show Zero or another message in Infolet if Analysis does not return dataSummary How to show a message or 0 if analysis does not return any row, When there is a count it shows the count.Content How to show a simple message or just Zero (0) as…Prateek Parasar - GTUK, ACE Pro 38 views 11 comments 0 points Most recent by Caroline Gladwin-Oracle Reporting and Analytics for HCM -
Limit what data users can see in OTBISummary We want to limit certain data that the users can see in OTBIContent We have a requirement to limit data on the UI and in OTBI that the user can see. For example,…User_2025-02-04-19-36-53-958 51 views 10 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Report for Absences are going into auto denial statusSummary Report for Absences are going into auto denial statusContent Report for Absences are going into auto denial status We have Absence going into Denial status, not …Mansur Khalil 62 views 2 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Plans to move from OBIEE 11.1.1.9 to 12.xSummary When does Oracle plan to move the OTBI/BIP cloud platform from version 11.1.1.9 to 12.xContent Is there a Statement of Direction or a blog post that states if an…User_2025-01-30-04-37-05-780 42 views 10 comments 3 points Most recent by Aaron Leggett Reporting and Analytics for HCM