OTBI
Discussion List
-
OTBI Report for element entriesContent Hello Guys, I need to create an OTBI report for element entries, but when i try to creare the analysis the system show me the following error: No Results The spe…Giuseppe Iacono 121 views 3 comments 1 point Most recent by Anil Kola-Oracle Reporting and Analytics for ERP -
Report results pull in journals 1 hour prior to parametersSummary User selects date greater than 3/10/2021 at 12PM, yet the report results is pulling in journals with a timestamp 1 hour prior to set parameterContent User select…User_2025-02-05-22-11-22-331 28 views 1 comment 1 point Most recent by User_2025-02-05-22-11-22-331 Reporting and Analytics for ERP -
Deep Links Results in Blank PageContent Hello, I have created my first Oracle Cloud ERP OTBI report with deep links to invoice. When I run the report, I have a hyperlink as expected, but the result is …Marlowe Matoba 62 views 9 comments 2 points Most recent by SimonTomey Reporting and Analytics for ERP -
Geography Municipalities ExtractionContent Hello Guys, We need to create a report in order to extract Geography Municipalities data, where could we find this information? Best Regards, GiuseppeGiuseppe Iacono 23 views 0 comments 0 points Most recent by Giuseppe Iacono Reporting and Analytics for ERP
-
Inventory Reconciliation with GL - ReportContent All - I have a requirement to show the Inventory Reconciliation with GL and I see two OOB reports (Costing balances and Inventory Valuation) to satisfy the requi…Hari Thyagaraj 50 views 2 comments 0 points Most recent by Ahmed Eldemerdash Reporting and Analytics for ERP
-
OTBI custom folder security in production VS test environmentsSummary How are you managing your OTBI custom folder security from Production to Test when different?Content I our current environment we have several self service users… -
Project Actual Costs - Account CodeSummary Project Actual Costs - Account CodeContent We are creating a report using the Project Costing - Actual Costs Real Time subject area. We are pulling cost distribu…MLubbert 46 views 2 comments 1 point Most recent by User_2025-02-05-11-02-18-093 Reporting and Analytics for ERP
-
Projects Unprocessed Costs Error DetailsSummary Get detail of Projects Unprocessed Costs ErrorsContent I am trying to build a report using the Project Costing - Unprocessed Costs Real Time to build a report wi…Sharon Harper 34 views 2 comments 0 points Most recent by Sharon Harper Reporting and Analytics for ERP
-
TIMESTAMPADD function in OTBI reporting in UTC and not ESTContent We are using the below function to fetch the data for the previous month in OTBI Reporting & noticed it extracting the data based on UTC time zone and not EST. I…Murali Gangidi 105 views 6 comments 2 points Most recent by Anil Kola-Oracle Reporting and Analytics for ERP
-
Inventory Reconciliation ReportSummary Inventory Reconciliation to GL ReportContent Hello All - I have a requirement to create a sub-ledger report that shows inventory subledger detail and its reconci…Hari Thyagaraj 56 views 1 comment 0 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP
-
Safest/default Path to Publishing changes to GL (Essbase) Trees: Publish Chart of Account DimensionSummary We have been experiencing issues in making changes to GL tree structures in OTBI, so I wanted to be clear on what the options are for each step, to eliminate the… -
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 21 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 21 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 100 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 8 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 92 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 708 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 49 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 235 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 69 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 337 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 167 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 38 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 83 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 66 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 137 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 33 views 6 comments 0 points Most recent by User_2025-02-06-05-37-11-922 Reporting and Analytics for ERP