Get Started with Redwood: Oracle Cloud SCM and Purchasing
OTBI
Discussion List
-
Currency Conversion in OTBI report from Procurement - Procure to Pay Real time subject areaSummary: We have a custom OTBI report created from Procurement - Procure to Pay Real time subject area. The report currently shows all open POs in different currencies. … -
OTBI scheduled reports are not getting sent to recipientsReports are not getting delivered. Sometimes its just sending email notification but email doesn't stay in mailbox, it gets disappeared.Adeeba Akbar 9 views 2 comments 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
Unable to see the Goal Plan Approval status in the Employee Goal Plan OTBI ReportUnable to see the Goal Plan Approval status in the Employee Goal Plan OTBI Report. Only the 'Approved' status is displayed under the 'Approval' Status Column. The Subjec…Chaitanya Sai 46 views 1 comment 1 point Most recent by Jacqueline GRANDIN Reporting and Analytics for ERP
-
Scheduled process listWe would like to know the list of ESS jobs are scheduled with start date, end date and email address of users. Oracle suggested to get the time using Oracle customer con…
-
CASE WHEN Formula Not Displaying CorrectlySummary: CASE WHEN STATEMENT shows two different results pending the format export Content (required): I'm using the following CASE WHEN statement to label a value eithe…
-
Bhavani Rikkula 31 views 2 comments 2 points Most recent by Nagaraju Upputuri Reporting and Analytics for ERP
-
Query for Business Units and Legal Entities mapping for Payables.Summary Need query to fetch Business Units and associated Legal Entities mapping for Payables.Content Hi All, I am having requirement to fetch all the Legal Entities ava…
-
List for all OTBI subject areas/dimensions (as of 23C)Summary: Does anyone have a complete list of all OTBI subject areas/dimensions for creating ad hoc queries? Content (required): Version (include the version you are usin… -
unable to get data for the following fields(Quote Price,RFQ Number,Line Awarded,Lines responded) ?Hi ALL, We have a requirement for the fields(Quote Price,RFQ Number,Line Awarded,Lines responded) in OTBI report. we tried with the following subject area but no date is…Prathyusha pari 12 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Pass BI Results to OTBI Analysis(please ensure you mask any confidential information): Is it possible to pass BI report results to an OTBI dashboard prompt and bind that to an OTBI Analysis column if t…
-
How to exclude weekends and holidays from calculation in OTBI Report?Hi We have a requirement to not include weekends and holidays in calculation for one of the metrics in OTBI report. Kindly suggest some steps to archive Thank you Prathy…Prathyusha pari 13 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
OTBI Asset Depreciation Report with Pivoted Accounting DateI'm trying to create an asset depreciation report in OTBI using a pivot table. My goal is to have the accounting date itself be a pivoted column (displaying depreciation…
-
how to fetch current schedule process start time of any Oracle Fusion scheduled reportSummary: I have a requirement to fetch incremental data. I am using below query. but due to frequent transaction. Few transactions are getting picked by 2 consecutive sc…Grab.saurabh 65 views 2 comments 0 points Most recent by Grab.saurabh Reporting and Analytics for ERP
-
How to join 2 different tables using query builderHi Oracle Community, I m new SQL and took help of query builder to select few columns from payroll tables and would like to join with HR tables. The next few columns I, …
-
drill down financial reporting and otbiSummary: drill down financial reporting and otbi Content (please ensure you mask any confidential information): is it possibile drill down in accounting hub for financia…
-
Incomplete information in the dashboard Customer Listing ReportSummary: Site Purpose Source Reference field does not always display record information Content (please ensure you mask any confidential information): In the dashboard C…SERGIO BARRETO 11 views 0 comments 1 point Started by SERGIO BARRETO Reporting and Analytics for ERP
-
How we get difference of two sum from the same table?Summary: Content (please ensure you mask any confidential information): Hi, We would create a column in a report who get a difference of two sum from the same table. Wha…Ylenia Gentile 21 views 1 comment 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
How can I join General ledger and ExpensesHow can I join General ledger and Expenses I am precisely looking to join below tables gl_je_lines gl_ledgers exm_expense_types Much appreciate your help on this
-
Unable to find subject area to fetch FAI Required field for OTBI reportSummary: Hi, we have a requirement to fetch FAI Required field but unable to find the subject area for OTBI report. Content (please ensure you mask any confidential info…Prathyusha pari 22 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
Requisition Life-cycle report (OTBI)Summary Simple report showing creation date, approval date, PO creation date etc for purchase requisitionsContent See attached screenshot for details. Unarchive the atta…Andy Gough 854 views 10 comments 8 points Most recent by JLogan-EncoreGlobal Reporting and Analytics for ERP -
AR Transaction details with receipt details custom OTBI reportSummary Need to link Receipt Application subject area to transaction details subject areaContent Hi, I have created a custom OTBI report with all standard AR receipt det…User_6OFC2 274 views 4 comments 0 points Most recent by User451524-OC Reporting and Analytics for ERP
-
Oracle BIP or OTBI reports output in Non-English languages in Oracle Fusion Financials (SaaS)Summary: Oracle BIP or OTBI reports output in Non-English languages Content (required): Hi Team , We are looking for the Oracle BIP or OTBI reports output should be in H…
-
Query to find out GL code combinations used in a bank account (LE and Org access Level)Summary: I need to build a report to query to find out GL code combinations used in a bank account (LE and Org access Level). I used one of the sql provided in oracle do…Mansi1302 845 views 1 comment 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
Prepayment BalancesSummary Query for Prepayment BalancesContent Hello, We are looking to build a report that lists all current prepayments and balances, there was a Prepayments Status Repo…Elliot Hall-Walker 58 views 3 comments 0 points Most recent by Risandu olitha Reporting and Analytics for ERP
-
How can I create this formula for a custom column in OTBI?Summary: I'm attempting to create an asset replacement report with the ability to drill back to the replaced asset (DFF). I need to create a formula to compare two colum…Tasha Kretlow-Oracle 68 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
OTBI users are able to edit the report when they have only Read permissionSummary: OTBI users are able to edit the report when they have only Read permission Content (please ensure you mask any confidential information): Version (include the v…Pablo Schenquerman 31 views 4 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
Any way to automatically backup OTBI Custom directory?Summary I am trying to think up a way to do backups on the custom reports directory in OTBIContent As the title states, has anyone come up with a way to automatically ba…User_2025-02-06-06-17-13-684 109 views 4 comments 3 points Most recent by Andres Hernandez Suarez Reporting and Analytics for ERP -
Merge Two OTBI Subject Area For PO receipt dateHi , We have a requirement to develop OTBI report for the following fields ( promised date, Requested Date and Receipt date) for po using two OTBI subject areas we are u…Prathyusha pari 92 views 4 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Custom Calculated Measure to Sum Two Calculated Measure Fields Not Calculating CorrectlySummary: I want to have a column called, "Total Costs" which sums the amounts from two calculated measure fields but for values where one of the calculated measure field… -
OTBI Performance - Project Cross Subject Area - Date Filters Affecting Performance very badSummary: Using Projects - Cross Subject Area Analysis - Real Time there are severe performance issues filtering by accounting date less than or equal to. There is same …