OTBI
Discussion List
-
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 693 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 81 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 ~ 358 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 98 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 226 views 3 comments 0 points Most recent by Meshack Rakumakoe Reporting and Analytics for ERP
-
Cannot see HZ_GEOGRAPHY_IDENTIFIERS_VL view with Custom Geography Type in Data ModelSummary Cannot see HZ_GEOGRAPHY_IDENTIFIERS_VL view with Custom Geography Type in Data ModelContent Hi I have LACLS Colombia reports into Oracle ERP Cloud. However, they…User_2025-01-30-22-31-23-162 52 views 1 comment 0 points Most recent by User_2025-01-30-22-31-23-162 Reporting and Analytics for ERP
-
Distinct row in a employees reportContent Hi Guys, I need to realize a report with the following field: National Identifier National ID National Identifier Person type Name Last Name Name First Name Legi…Giuseppe Iacono 59 views 2 comments 0 points Most recent by Srini Devara Reporting and Analytics for HCM
-
Performance Rating Level Name for Section and ItemsSummary Show Rating Level Name for both section and item when they use the same rating modelContent Hi, I kindly need to know if there is a way to display section rating… -
Reports needed as per the customer languageSummary Manual reports need to be generated in customer languageContent Hi All, We are facing requirement from customer side that they want reports need to be generated …User_2025-02-06-09-39-00-756 42 views 3 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for SCM
-
Audit Log on reportsContent Hi Experts, We are having multiple BI publisher and OBIEE reports set up in UAT and production environments. What is the most efficient way to run audit on the r…User_2025-01-30-00-14-06-021 144 views 7 comments 0 points Most recent by User_2025-01-28-16-10-52-033 Reporting and Analytics for HCM
-
Procurement - Purchasing Agreements Real Time created reports does not show any dataSummary when a user having only the Purchase Analysis role run a report created using the Purchasing Agreement Real Time subject Area the report does not show any result…Hayds Mercado 129 views 6 comments 1 point Most recent by Senthilrajan V Reporting and Analytics for SCM -
Unable to calculate overhead rule cost in cost managementSummary Unable to calculate overhead rule cost in cost managementContent Our business needs to add a freight to a PO in OSP manufacturing, as there is no direct way we h…