OTBI
Discussion List
-
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 327 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 686 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 39 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 33 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 ~ 350 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
-
Custom BI Publisher Report SQL ErrorSummary SQL or ORA exceptions error.Content Hello, We are receiving the following error when running a custom built BI Publisher report. This report was functioning with…User_2025-02-05-07-37-39-271 99 views 14 comments 0 points Most recent by Tom Strudley Reporting and Analytics for ERP
-
Negotiation Status Pie with Draft Negotiations (OTBI)Summary A report to show the percentage a negotiations in different statuses including draft for a given procurement BUContent In 19A release we enabled draft status neg… -
Workforce Trend Real Time - Calculate Weekly TurnoverSummary Trying to use Workforce Trend Real Time and Worker Assignment Event Real Time to calculate weekly turnover ratesContent Hi! I'm trying to create a report showing…User_2025-01-28-04-09-16-818 166 views 4 comments 1 point Most recent by Lauren Owen Reporting and Analytics for HCM
-
Can we perform material simulations in S&OP based on Demand ?Content Hello All, I need some clarification regarding oracle cloud S&OP Requirement : Once forecast is generated in Demand Management(DM) user copies the forecast from …SHARATH CHANDER MANOHAR 46 views 2 comments 0 points Most recent by SHARATH CHANDER MANOHAR Supply Chain Planning and Collaboration
-
Analytics for Absence BalanceSummary Is it possible to make an analytics to get absence balance for a given dateContent Is it possible to make analytics to get the absence plan balances for a given …Prasan Edirisinghe 90 views 1 comment 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Subject Area in OTBI to extract default Expense Account information of userSummary Subject Area in OTBI to extract default Expense Account information of userContent Hi, I am trying to build a OTBI report which has cost center and company infor…Nidhi Chhajed 225 views 3 comments 0 points Most recent by Meshack Rakumakoe Reporting and Analytics for ERP