OTBI
Discussion List
-
How to display the latest value (Contract Agreed Amount)?Summary: I am creating an OTBI report for contracts including the contract agreed amount field. Because the contract has revisions, the contract agreed amount is display… -
Drill down on balances in SA General Ledger - Transactional Balances Real TimeSummary: We have created a an OTBI analysis using SA General Ledger - Transactional Balances Real Time. The purpose of the report is to show balances per natural account…ERP & EPM Cloud 23 views 0 comments 0 points Started by ERP & EPM Cloud Reporting and Analytics for ERP -
Recurring Learning Assignment subject area in analysis reportSummary: Hi, Post 26A upgrae Learning Assignment got upgraded to redwood. Now as per the Oracle doc Learning initiative got replaced with Assignment profile.In assignmen… -
Unable to retreive metadata from data model- OTBI ErrorSummary: HI Team, We created an OTBI for an Inventory On hand stock report. Am getting the following error when I try to edit the report. Any idea what could be the issu…Mano_Oracle-Oracle 26 views 2 comments 0 points Most recent by Mano_Oracle-Oracle Inventory Management -
How to give access to Report Job History (scope all Histories) without BI Admin roleSummary: How to give access to Report Job History (scope all Histories) without BI Admin role Content (please ensure you mask any confidential information): Version (inc…Sonali Sethi 11 views 1 comment 0 points Most recent by Skolli-Oracle Reporting and Analytics for HCM -
Facing an Error when changing the ware house in the Order Fulfillment Lines. How to resolve this?Selected shipping method is not available. Already added the required Inventory org to the Shipment method. Still error is populating. How to solve this? -
Sold To party vs Bill To and Ship To party on sales orderSummary: There are three fields for party on Sales Order header Customer (aka buying party aka sold to) Bill-to Customer Ship-to Customer What is the significance of Cus… -
Veteran StatusSummary PER_PEOPLE_LEGISLATIVE_F ;PER_PERSON_LEGISLATIVE_DATA_LEG_DDF'Content Can someone please help on attribute mapping from the application screen(i.e Armed Forces S…User_2025-01-29-01-31-31-940 531 views 10 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
In the SAFT_Supplier and SAFT_Customer files, the values in Column B (SubSectionCode)Summary: In the SAFT_Supplier and SAFT_Customer files, the values in Column B (SubSectionCode) must be correctly aligned with the corresponding rows that contain the rel… -
Table : Table : ZX_LINES (EBSR12 TABLE) -line_number (column) how it is mapped in fusion cloudSummary: Table : ZX_LINES (EBSR12 TABLE) -line_number (column) how it is mapped in fusion cloud Content (please ensure you mask any confidential information): Version (i… -
SQL query to get the result of Recalculate Payroll for Retroactive ChangesSummary: SQL query to get the result of Recalculate Payroll for Retroactive Changes Content (please ensure you mask any confidential information): Hi Team, Greetings! Ca…Parag Hiremath 20 views 0 comments 0 points Started by Parag Hiremath Reporting and Analytics for HCM -
How to schedule report in working hours from Monday to FridaySummary: Schedule oracle standard report in working hours morning 10AM to 7 PM from Monday to Friday Content (please ensure you mask any confidential information): Sched…Tapas_Sathua 34 views 1 comment 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for SCM -
What is the subject area of Project Definition DFF on OTBI on Projects module?Summary: We cannot find Project Definition DFF on OTBI. What is the subject area of this attribute on Projects module. DFF is BI enabled, we run "Import Oracle Fusion Da… -
Trying to report on future dated Job code keying and Grade Rate keyingSummary: We're trying to report on future dated Job code keying and Grade Rate keying but can only obtain current effective data. Is there any way to report on future da…Georgia Puddifoot 17 views 0 comments 0 points Most recent by Georgia Puddifoot Reporting and Analytics for HCM
-
Traversing Department Tree in Reports with a ParameterSummary The ability to use one parameter in an otbi report for the department hierarchy as opposed to the multiple levels of departments being handled individuallyConten…User_2025-01-25-00-51-33-059 149 views 8 comments 1 point Most recent by fareed basha Reporting and Analytics for HCM -
OTBI Custom Prompt for Company Fiscal Period, Quarter, and YearSummary: We have a need to report out on our fiscal calendar dates vs. the standard out of box calendar month dates. I was hoping there was a way to set-up our own fisca…CGardner01 23 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
OTBI Drill Down for AR_Transaction does not work with VIEW actionSummary: OTBI Drill Down for AR_Transaction does not work with VIEW action. It works with the EDIT action. It shows in Deep Links (under Tools) that it's a valid action.…Chris Diltz-Oracle 21 views 2 comments 1 point Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
Accounts Payable OTBI AnalysisSummary: Adding a field to an "Analysis" Content (please ensure you mask any confidential information): I would like to add the Oracle assigned file number to the list o…b nightingale 15 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
OTBI subject area - Attribute to get the no. of Hours spent on each learning itemSummary: Hi Team, We need OTBI subject area and attribute details to fetch the no. of hours spent on each learning item. Content (required): Version (include the version… -
How to include fields in the bell/email notifications?Summary: In external learning requests, there is a field to include the course URL. I would like to include this field in the notifications that come to the bell/email: … -
Feasibility check: OTBI report for supplier registration resubmissionsSummary: Hi Team, We received a customer requirement to understand which suppliers have the most difficulty during the supplier registration process, along with their vo… -
Need Guidance on Mapping Employee Numbers in OTBI Expense-to-Payables ReportingSummary: We have developed an OTBI report using the Payables subject area to retrieve invoices imported from Expenses and to track the payment status of those expense-re…Sai Ambareesh D 4 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM