OTBI
Discussion List
-
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 154 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 320 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 967 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 64 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. -
Employee Assignments Processed in a 'Calculate Payroll' RunHi, does anyone have an SQL/Data Model to list all employees processed through a 'Calculate Payroll' Run or know which tables i would need to use?
-
Reporting Field for Acknowledgement Comments on Performance ReviewSummary We would like to know the field name (if reportable) for the comments entered by an employee when acknowledging their performance review.Content We have a busine…User_2025-01-30-23-46-38-098 76 views 6 comments 1 point Most recent by Aprajita Gokhale Reporting and Analytics for HCM -
What table/field is Customers->Tax profile->Controls and Defaults ->Tax Classification CodeI'm trying to find a table that contains the tax xlassification code field which is in the customer site → tax profile → controls and defaults