OTBI
Discussion List
-
User is unable to see distribution details for more than 30 lines in this sandbox through UIA sandbox is created to fetch and display Invoice distribution Lines. This distribution tab is created on the invoice inquiry screen on UI by calling a OTBI. OTBI is abl…Sifat Shaikh 12 views 0 comments 0 points Most recent by Sifat Shaikh Payables, Payments & Cash Management -
OTBI Analysis filter by max date valuesSummary I want to filter a subject area, where I get only the max date, as the record is duplicated for different datesContent How to do below in OTBI Analysis, Data Set…Fahad Cader 733 views 10 comments 0 points Most recent by Yandini Mootoosamy Reporting and Analytics for ERP
-
Poor Query Performance of CMP_ASG_SALARY_VSummary: A simple query on this view runs 40+ minutes. We are experiencing poor performance with the CMP_ASG_SALARY_V HCM view. When doing a simple SELECT statement with…
-
OTBI agent More Details - success?Some OTBI Agents More Details read: "Last Run 09/12/2025 8:00 AM GMT+00:00 | Agent Successful | Next Run 10/12/2025 8:00 AM GMT+00:00". Other agent More Details read "La…Stephen Jones 13 views 0 comments 0 points Most recent by Stephen Jones Reporting and Analytics for HCM
-
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 152 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 83 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 12 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 32 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