OTBI
Discussion List
-
Subject Area for Supplier CountrySummary I want to be able to bring the suppliers country into a report but can't find the right subject areaContent Hello, I have created an analysis in OTBI and I want …User_2025-02-04-19-45-49-438 25 views 2 comments 1 point Most recent by User_2025-02-04-19-45-49-438 Reporting and Analytics for ERP -
Number of Accounting Periods in Accounts Receivable for OTBI ReportingContent We have a thirteen period calendar setup in Oracle, each period is four weeks. When we attempt to write OTBI reports we are only seeing 12 periods. My question i…Robert G Wilkinson 25 views 1 comment 2 points Most recent by User775911-Oracle Reporting and Analytics for ERP -
OTBI data modelSummary Is there a place where we can understand the data model (tables) for OTBI reports?Content Is there a place where we can understand the data model (Tables) for OT…Jeff Hare CPA CISA CIA 106 views 5 comments 3 points Most recent by Jeff Hare CPA CISA CIA Reporting and Analytics for ERP -
What table does Configuration Owner field come from?Summary Receivable module - What table does Configuration Owner field come from?Angela.Ahrens 16 views 3 comments 3 points Most recent by Angela.Ahrens Reporting and Analytics for ERP
-
OTBI report to fetch Absence types and related absence plans with approval status, used balance, carSummary OTBI report to fetch Absence types and related absence plans with approval status, used balance, carryover, accruals.Content Hi All, We have an OTBI requirement …User_2025-02-10-16-28-01-402 105 views 0 comments 2 points Most recent by User_2025-02-10-16-28-01-402 Reporting and Analytics for ERP
-
Unable to preview BI Publisher output in RTF:Summary Unable to preview BI Publisher output in RTF:Content Hi Guru, I am facing one strange issue in BIP Desktop , i am able to load and design the RTF but when i am t…Rohit Soni-259808 750 views 6 comments 3 points Most recent by Lucky Sharma Reporting and Analytics for ERP
-
Reporting with Hierarchies in OTBISummary Fusion OTBI - Hierarchies are not showing in all General Ledger subject areasContent Background/Requirement: My client wants an OTBI analysis which includes vari… -
OTBI Formula HelpSummary Formula help for custom columnsContent Hello, I want to add a couple of custom columns to my OTBI analysis which have formulas in them and I was wondering if som…User_2025-02-04-19-45-49-438 54 views 1 comment 1 point Most recent by Amarnath Reporting and Analytics for ERP
-
Extract Cost Center from "Code Combination Description" field - (Procurement - Spend Real Time) subjSummary Extract Cost Center from "Code Combination Descpription" fieldContent I am using "Code Combination Description" field as one of my select columns from (Procureme…UjasB 249 views 5 comments 0 points Most recent by Anders W. Langholm Reporting and Analytics for ERP
-
Tables to query files imported to ERPSummary We want to create a report that list the files imported to the ERP from external systems for reconciliation purposes.Content Hello evryone, Anyone can hep me to …User_B9AX9 71 views 1 comment 0 points Most recent by Christian Guidibi Reporting and Analytics for ERP
-
Transaction Query exampleSummary example of a GL Transaction query flexible to a range of parametersContent Seeking an Oracle Cloud example of a GL transaction query that returns line item detai…User_2025-02-11-03-09-13-126 344 views 6 comments 2 points Most recent by Sahil_Makhiza Reporting and Analytics for ERP
-
OTBI Report that shows the element details field "Description"Summary OTBI Report that shows the element details field "Description"Content I am trying to build a report where I can pull in the field 'Description' on an element. Fo…
-
General Ledger - Balances Real Time Subject Area: not returning Beginning and Ending BalanceSummary General Ledger - Balances Real Time Subject Area: not returning Beginning and Ending BalanceContent I am trying to create an analysis based on General Ledger - B…Dharmendra Shukla 179 views 4 comments 1 point Most recent by Dharmendra Shukla Reporting and Analytics for ERP -
Logiacl sql for cross subject area analysisSummary Logiacl sql for cross subject area analysisContent Hello All, I am trying to create a cross subject area logical sql for receivables as below. However I still ge…
-
Updating non-logical OTBI to Logical SQL OTBI without rebuilding?Summary Updating non-logical OTBI to Logical SQL OTBI without rebuilding the original OTBI?Content I need to update an existing OTBI (non-Logical SQL) to use Logical SQL…User_BUU5W 41 views 3 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for ERP
-
OTBI usage tracking in 21ASummary OTBI usage tracking in 21AContent In this new subject area below, will that only track usage within the CRM subject areas or will that track report usage in the …Andrew_Schmitz 88 views 0 comments 3 points Most recent by Andrew_Schmitz Reporting and Analytics for ERP -
Depreciation reserve of assetContent We're building a Fixed Asset Balances report out of Subject area Fixed Asset Balances - Real Time'. But we are not able to get the balances for Accumulated Depre…JL-JL 72 views 1 comment 0 points Most recent by Greg Jonovich-Oracle Reporting and Analytics for ERP
-
Power BI and OBIEESummary How to create a connection between Oracle Cloud (FIN and/or SCM)?Content Hello, we would like to start using Microsoft Power BI for BI Reporting, instead of OTBI…User_2025-01-30-21-34-16-665 142 views 8 comments 6 points Most recent by Tessy Reporting and Analytics for ERP
-
Direct vs In-direct suppliersContent All - How to identify in Oracle Procurement cloud the direct vs in-direct suppliers? Also is there a field in OTBI that can tell direct vs Direct suppliers? I se…Hari Thyagaraj 37 views 6 comments 0 points Most recent by User_2025-02-06-05-37-11-922 Reporting and Analytics for ERP
-
Schedule Job Manager in OTBI to export the report output to Object Storage (OCI)Content Is there a way to export an OTBI BI publisher report to object storage (OCI) as part of a Job Manager scheduled job? -
Rx-Only: Other Receipt Applications ReportSummary Rx-Only: Other Receipt Applications ReportContent Hi All, Do we have the same/similar "Rx-Only: Other Receipt Applications Report" from fusion cloud.?Amarnath 28 views 1 comment 0 points Most recent by Nadia Khan-73252 Reporting and Analytics for ERP
-
Receipts Awaiting Bank Clearance Report in EBS R12Summary Receipts Awaiting Bank Clearance ReportContent HI All, Do we have the same/similar functionality report as "Receipts Awaiting Bank Clearance Report" from EBS in …Amarnath 12 views 1 comment 0 points Most recent by Nadia Khan-73252 Reporting and Analytics for ERP
-
Miscellaneous Receipts Register EBS R12Summary Do we have any standard report for the same from oracle fusion cloud.Content Hi All, Do we have any standard report for the same from oracle fusion cloud. for Mi…Amarnath 22 views 2 comments 0 points Most recent by Nadia Khan-73252 Reporting and Analytics for ERP
-
Physical or Soft Deletes handled in PVO DataSummary How are Physical or Soft Deletes handled in PVO Data ? Does it comes as a flag/identified along with incremental extract so that it can be deleted in the target …Upendra Nayak 36 views 0 comments 0 points Most recent by Upendra Nayak Reporting and Analytics for ERP -
Report on LicencesSummary Self licence audit processContent Hi All, I have a report that shows me the Users by Service we are subscribed to, but I am wondering if anyone has put together …Lewis Hopkins 58 views 2 comments 0 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP
-
OTBI analysis timeoutContent Hi, we have a customized OTBI analysis report in sharefolder. Some users could run the report successfully serveral months ago, but recently they can't get the r…Min-Hui Yan 196 views 1 comment 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for ERP
-
Ability to Act as another user in OTBISummary In OBIEE on premise we have the capability to 'Act As' another user is this available in OTBIContent Wanted to find out if anyone knows if the ‘Act As’ functiona…amy hardtke 46 views 6 comments 0 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP -
Add a custom calculation columnSummary I want to add a couple of columns into my analysis which contain custom formulasContent Hello, I am sure this is a very simple answer but I was hoping someone wo…User_2025-02-04-19-45-49-438 52 views 1 comment 1 point Most recent by Dhruvjoshi23 Reporting and Analytics for ERP
-
OTBI Report on Cross subject areasSummary PPM-AP Cross subject area reportContent We are implementing fusion Financials and PPM. The current practice is, project managers in PPM get to know the details o…Hemant Kasibhotla-Oracle 157 views 6 comments 4 points Most recent by Andres Vinueza Reporting and Analytics for ERP
-
R13.18A OTBI BI Catalog LockdownSummary With 13.18A release customers will no longer be able to modify the shipped BI catalog content.Content R13.18A OTBI Product Alert This product alert is published …User720640-Oracle 385 views 8 comments 14 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP