OTBI
Discussion List
-
Asset end date OTBISummary: Which subject area can tell me which maintenance asset is end-dated or not? I'm troubleshooting for PMs that don't generate forecast and realize some were becau… -
How to get the USER_NAME or USERID into default value of a data model parameterSummary: How to get the USER_NAME or USERID (or exquivalent) into default value of a data model free form string parameter Content (required): In a data model I would li…Jbgood 2.1K views 5 comments 3 points Most recent by Humberto Martín-Oracle Reporting and Analytics for HCM
-
How to create report that show item's list price update historyI can check list price update history of each item by doing the following step: Navigator: Product management > manage items 1. Search item number 2. Click on item numbe…
-
OTBI - Customer Credit - Last Review Date / Next Review Date Missing?Hello, We are looking to pull the Last Review Date and Next Review Date areas of the customer account profile history to an OTBI report. I cannot locate these fields to …
-
How to create a report/Analysis to show Receipts pending for Put AwaySummary: How to create a report/Analysis to show Receipts pending for Put Away Content (required): Version (include the version you are using, if applicable): 23A Code S…
-
Infolets Receipt line: need to extract the querySummary: I need to extract the query under the infolets "Receipt Lines". Is it possible? Otherwise, how can I extract the lines in awaiting receipt, awaiting inspection …Giuseppe Galluzzo 151 views 8 comments 0 points Most recent by Kunal Verma Reporting and Analytics for SCM
-
Project Class Category Causes Duplicate Rows for Project Financial Information in OTBI and BI PUBSummary: When we want to report on the Project Classifications class categories for a project number there is no clean way to do it. The current solution we are doing re…
-
Lease Accounting SetupSummary Lease Accounting SetupContent I was following the steps to enable "Create Property and Equipment Lease" below, however when I go to Setup>Financials . I am not s…
-
HCM alerts real time Subject Area - data not returningSummary: HCM alerts real time Subject Area - data not returning Content (please ensure you mask any confidential information): Hello I am trying to write an Analysis usi…
-
what is the equivalent table in Oracle fusion for wf_notification table in EBSSummary: We are looking to build a report to get approval details of delegated approvals . E.g: Workflow type, original approver , approved by , Approval Date Etc. Conte…
-
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 82 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 11 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…
-
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 192 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
-
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 1.4K 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
-
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…