OTBI
Discussion List
-
How to improve the performance of OTBI dashboards and reportContent Hi, We have created a custom dashboard. And few reports are taking long time to respond. Can someone tell me how can I improve the performance of Dashboards and …Nivya Mathire 96 views 12 comments 0 points Most recent by Rizwan Basha Reporting and Analytics for HCM -
Some users cannot see infolet tab pages under AnalyticsSummary: Under Analytics, Although some users can see a few infolets, why are they not able to see infolet tab pages like General Accounting Infolets, Service Infolets, … -
Not showing data in OTBI for other line manager type, how can we fix this?Summary: Right now, individuals with the manager type "Cross-Functional Manager" can't access any data about their direct reports in OTBI. The UI is behaving correctly; …Martijn van den Berg 30 views 2 comments 0 points Most recent by Martijn van den Berg Reporting and Analytics for HCM -
Request for Documentation on Fields Match for XML Document in IBY_TRXN_DOCUMENTS TableSummary: Hello, My team I are working on an H2H implementation for a client using the Oracle ERP Cloud system. As part of this implementation, I need to understand the s…Arturo Contreras 216 views 2 comments 0 points Most recent by Edgar Nieto-Oracle Payables, Payments & Cash Management -
Round to nearest 0.5 decimalSummary: Leave balance in hours, converted to days to 2 decimal points. Content (required): My formula is FLOOR("Front-Loaded Plan"."Accrual Balance"/7.4) however for so…Dawn Cawston - CPS 91 views 4 comments 0 points Most recent by Narendar Rao Naineni Reporting and Analytics for HCM
-
showing data based on the selected candidate in analysis added to offer screenSummary: We have analysis added to offer screen and we want to get data based on selected candidate so we need binding variable to take candidate number from the screen …Salma Mohamed Salem 21 views 1 comment 0 points Most recent by Alexandru C. -Oracle Reporting and Analytics for HCM
-
Control Budget UploadSummary: Control Budget Upload Content (please ensure you mask any confidential information): At the start of the Financial year, the budget from planning was not transf…
-
In which table is the "Resource Management" data stored?Which table stores the data displayed in Manage Resources search results? I want to retrieve these data with SQL. Path::Setup and Maintenance>Financials: Resources>Manag…REI TSUKAHAR-Oracle 315 views 1 comment 0 points Most recent by Shivashish Dwivedi-Oracle Project Management
-
What is the database field/column for PO Charge Account?Summary: Our client would like the PO Charge account/distribution to appear on the PO PDF template. We did not find it in the seeded data model, which means we would nee…Farah Zekria 16 views 1 comment 0 points Most recent by Michael Gibby - Huron Consulting Group Purchasing -
Unable to extract internal requisitions through requisition subject areaSummary: Want to retrieve the internal requsitions raised from the subject area Content (please ensure you mask any confidential information): When extracted, i am getti… -
Report Payables withholding tax and accountsSummary: Hello, We would like to know if there is a report to support the Payables withholding tax invoices and Tax Accounts Content (please ensure you mask any confiden…usr_a.nv 23 views 2 comments 0 points Most recent by Siva Chittapragada-Oracle Payables, Payments & Cash Management
-
Do we have option to have multiple sheet in OTBI extractSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Offer ID not showing up on Recruiting Real Time Subject AreaSummary: Offers created under a requisition, but Offer IDs not showing up on the backend Recruiting Real Time subject area. Content (required): For a particular requisit…User_2025-07-18-13-29-11-469 93 views 8 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Fetching column for employee Feedback(in PD) whether it is completed/bypassed in OTBI reportsSummary: I have a requirement to add one column in OTBI report to fetch the status of employee feedback if is completed or bypassed. Can we use SQL query to fetch the de…Kamini Kaushik-Oracle 13 views 2 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Reporting on Eligible for Pretax Age Catch-Up Contributions FieldSummary: Looking to include the column Eligible for Pretax Age Catch-Up Contributions in a payroll report to pull all data assigned to a person's Reporting Information c…Emily Meyer 34 views 2 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM -
Certification link is not working after implementing Redwood.Summary: We just realized that learners cannot access the course completion certificate when they complete the training. Content (required): When learners complete the t… -
Org levels missing from the OTBI report for the inactive treeWe recently did our restructures and created a new version of the tree. The old version end on 2-Jul and the new version starts from the 3-Jul. Now the Org tree has leve…Girish Bhatia 42 views 7 comments 0 points Most recent by Girish Bhatia Reporting and Analytics for HCM -
Issue with Logical SQLSummary: Hi, I was working with a Report which will provide various employee emails like home email and business email addresses along with few other assignment details.… -
How to receive description of EFFs' LOVSummary: Hello Experts, We have created a report to see the item attributes. For a case we need to see the description of the value. Do you know in which table the value…
-
How to return Geographies using OTBISummary: We want to return Geographies (State, County and City) using OTBI. But the data should not return the geocodes but should return the actual name. Ex: State: LA …RenzelkeithCoquia 2 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
How do I remove unwanted commas in OTBI report outputSummary: Custom address field column contains extra columns when source column is null Content (please ensure you mask any confidential information): I have created an O…DennisOliver 31 views 5 comments 0 points Most recent by DennisOliver Reporting and Analytics for HCM -
Display Source warehouse information during Item entry in the sales orderSummary: Hi Folks We would like to see the source warehouse along with On-hand information during item entry in the sales order Content (please ensure you mask any confi…
-
HCM native datamodels/bipSummary: are there another schema.table wich sample reports delivered in HCM Cloud are stored to extract a list of them ?? Content (please ensure you mask any confidenti…
-
Formula to calculate Learning Assignment Creation Date + 7 Days in OTBISummary: Hi, I am trying to create an assignment analysis that will assign a course based on the Assignment on Date + seven calendar days. Can you please suggest if it i…
-
How to filter the column values by another column?Summary: I'm currently creating an OTBI report under this Subject Area: Workforce Management - Checklist Real Time I want to filter employees which have these Response A… -
Facing issue with top manager type in OTBIWe have created otbi report using top manager type. Multiple managers are visible in OTBI, but in system only 1 manager is tagged. Is there any way we can pick the activ…Pranay_Soma 23 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM