OTBI
Discussion List
-
Visualization Configurator isn't displaying the correct dataHello, I’m experiencing an issue with the Visualization Configurator not displaying the correct data. I created a visualization using source data from OTBI, but the sele… -
Query to fetch Approvals Groups Across Workflow ModulesSummary: We need to update a workflow approval group. I’d like a query that shows, by module, every workflow rule that will be affected by this change. Exemple: Approval…usr_a.nv 41 views 6 comments 0 points Most recent by Kate D.B-Oracle Payables, Payments & Cash Management
-
Could you please share any OTBI AP Dashboard ?Summary: Could you please share any OTBI AP Dashboard ? Content (please ensure you mask any confidential information): Hello Could you please share with me any seeded OT…martingabriel Kinovisques 15 views 1 comment 0 points Most recent by RVohra Payables, Payments & Cash Management
-
OTBI Report coming up with blank dataSummary: We created an OTBI analysis in Recruiting in Real Time and data is coming up blank. Content (please ensure you mask any confidential information): Summary: We c… -
OTBI report export is not pulling all dataSummary: Whatever the data showing in the report is not showing in the exported data. It's only around 5,000 records. Content (please ensure you mask any confidential in…
-
PO Change Order Details in Oracle FusionSummary: Details regarding PO change history in table level Content (required): Looking for the tables which records the following set of information: Proposed Amount Ch…
-
Cross validation Rule extract by report / SQL querySummary Need report/SQL query for extracting Cross validation rulesContent I am looking for Cross-validation report or SQL Query to extract all cross-validation rules at…VijayPatel 452 views 4 comments 2 points Most recent by Malleswara_Rao_P Reporting and Analytics for ERP
-
How can I retrieve the full details of each exception?Hi everyone, I’m working on a report that returns schedule exceptions using the following query: SELECT 1 KEY, pse.SCHEDULE_EXCEPTION_ID, pse.SCHEDULE_ID, pse.SCHEDULE_A…Andriampeno Odilon 31 views 4 comments 0 points Most recent by Andriampeno Odilon Reporting and Analytics for HCM -
Does Masked/Token Corporate card Numbers for loaded transactions are stored in Oracle Backend?Summary: There is a business use case to create a custom report which will pull the employee's card numbers. I am not able to view any Corporate card Numbers for the exi…
-
How to pass parameter value from one job to another in ESS job setHi All, We have a ESS job set, input for the second ESS job would be the one of the parameter from the first ESS job. Can you please let us know how we can achieve this …Arunkumar Ponnusamy 151 views 3 comments 0 points Most recent by Ranga Swamy Ediga Reporting and Analytics for SCM
-
Syntax for referencing a user privilege in an EL ExpressionSummary: Content (please ensure you mask any confidential information): Hi, I am trying to build a custom menu to access OTBI reports from the Navigator / springboard . …NeenaS25 11 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
Fixed Assets - Entered PeriodSummary Is the "Entered Period" available in any of the Fixed Asset subject areas?Content I have been searching through the various asset-related subject areas for a fie…ndryden 319 views 7 comments 0 points Most recent by Malleswara_Rao_P Reporting and Analytics for ERP
-
Assistance Required for OTBI Reports in SCM (Inventory Module)Hi, We are developing a few OTBI reports for the SCM module, specifically on the inventory side. However, we are facing difficulty in identifying the correct subject are…ShubhamP 41 views 7 comments 0 points Most recent by Malleswara_Rao_P Reporting and Analytics for ERP
-
Import Oracle Fusion Data Extensions for Transactional Business Intelligence having an impact.Summary: There's an issue with HCM Reports having said that some columns were not available and the root cause of it was when Import Oracle Fusion Data Extensions for Tr…Franz Marcelo 951 views 8 comments 1 point Most recent by Rich Merkel Reporting and Analytics for ERP -
How to report on the course number for an offering?Summary: Hello, We have a report at the offering level but we don't find how to retrieve the course number of these offerings? We can see course identifier but then it's…
-
OTBI reports: The currency symbol always defaults to dollar $ symbolSummary: We have always used 'User's Preferred Currency' for the Currency symbol under 'Data Formatting' in OTBI reports. We are rolling out reports to EMEA and APAC use…VivekKandasamy-Oracle 61 views 2 comments 0 points Most recent by Akhila.Allagadda Reporting and Analytics for ERP
-
Report dashboard prompt showing error - ACIOA5LNSummary: Report dashboard prompt showing error - ACIOA5LN Content (required): One of the working BI report which uses dashboard prompt, suddenly stopped working and show…
-
Error when trying to save an analysis - don't have sufficient privilegesContent Recently we started to receive the following error after editing and analysis and trying to save it. "You do not currently have sufficient privileges to save a r… -
Unable to fetch the State, County and City values through "Payroll - Calculation Cards Real Time"Summary: Unable to fetch the State, County and City values through "Payroll - Calculation Cards Real Time" subject area Content (please ensure you mask any confidential …
-
How to turn off case sensitivity when searching for a value using OTBI analysis filters?Summary: I want to be able to filter records using 'contains any' filter, where the value I enter is not case sensitive. For e.g., When I search with value 'Tier' it giv…
-
Import Price List Items and ChargesSummary: ESS job - Import Price List Items and Charges completing in an error Content (please ensure you mask any confidential information): ####[2025-12-03T07:21:19.332…
-
pr approval comment does not appear in tableSummary: Approval message does not appear in table POR_APPROVAL_TASK_COMMENTS Content (please ensure you mask any confidential information): Hello team, I'm trying to fe…Alon Hadar Tamir 21 views 2 comments 0 points Most recent by Alon Hadar Tamir Self Service Procurement
-
[OTBI] "Workforce Performance-Performance Check-in Real Time" SA - unexpected behaviour on filtersSummary: Hello, I have following OTBI analysis : SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1';SELECT 0 s_0, "Workforce Performance - Performance Check-In …
-
SQL runs in query tool but not Data ModelI need to calculate the number of days a person will work during a pay period. To do this I am calculating the the days from the last day of work through the end of the …Jason Snipes 12 views 6 comments 0 points Most recent by Jason Snipes Reporting and Analytics for HCM -
Headcount value 0 for some employeesSummary: I was comparing the headcount (the built-in fact) against the employee detail row wise data and the counts did not match. I noticed that some employees had the …Swapna Govind 61 views 4 comments 0 points Most recent by Nalsoft Pvt Ltd Reporting and Analytics for HCM
-
How to pull Survey results from a Journey in OTBISummary: Cannot seem to pull any results in OTBI using 'Workforce Management - Survey Journey Responses Real Time. Specifically need to easily and cleanly see Questionna…
-
Mass Course DeeplinkSummary: We have a request for Course deeplinks for about 600+ courses. Is there any way to get the deeplinks, other than going into each course and manually c&p them? M… -
Guided Journey: Pass OM Header ID to BIP report on Redwood pageHello, had anyone being able to embed report in OM Redwood page and pass order number or header id as parameter? according to similar links in HCM - it should be possibl… -
Need to know the logic behind the seeded report parameters of Payables Trial Balance ReportSummary: Just wanted to know the logic behind seeded 'Payables Trial Balance Report' parameters which are mentioned below 1.Include Bills Payable 2.Negative Balances Onl…SireeshaJaladi 102 views 5 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
How to report for those absence leave requests which are in denied statusHi, Can you please suggest how to report for those absence leave requests which are in denied status. Thanks in advance.