OTBI
Discussion List
-
OTBI - Unpaid Invoice By Payment methodSummary OTBI - Unpaid Invoice By Payment methodContent This report helps to identify unpaid invoice details for any enterprise.Soumya Prakash Parhi 135 views 2 comments 7 points Most recent by Swapnil Kashid Reporting and Analytics for ERP -
Error while joining"Journal Batch" from GL Subject area with Receivable subject areas Fields in OTBISummary: The expected OTBI report requires multiple fields from the following multiple Subject areas : - General Ledger - Journals Real Time - Receivables - Transactions…Ekta Nayak-Oracle 13 views 1 comment 0 points Most recent by Ekta Nayak-Oracle Reporting and Analytics for ERP -
Does the AR Transaction Register Report is an OTBI or BI ReportSummary: I need to customize the AR Transaction Register Report , I need to add some additional fields Content (required): I need to customize the AR Transaction Registe…Gabriel Kinovisques 18 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
OTBI Costing - Receipt Accounting Real Time subject area missing a transaction type on filterSummary I am trying to create a report in OTBI to record items I can see withing Supply Chain Execution > Receipt Accounting > Review Receipt Accounting DistributionsCon…Sarah Munro 12024679 41 views 4 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Sample OTBI Reports: Budgetary ControlSummary OTBI Reports for Budgetary Control and Carry ForwardContent These are sample reports for customers using Budgetary Control to assist them in managing their contr…Linda Wong-Oracle 643 views 7 comments 7 points Most recent by CA Nirmal Choudhary Reporting and Analytics for ERP
-
Procurement Agent ListSummary: Content (required): Is there a report that will show a list of our procurement agents and the permissions they have been assigned? We feel like many of them are…Annette M 83 views 2 comments 1 point Most recent by Jeff Hare CPA CISA CIA Reporting and Analytics for ERP -
Receivables - transactions real time failing with ODBC-error about Flex fieldsSummary: When I try to create a very simple report with the Subject area "Receivables - transactions real time" I get an error, every time I try to use a fact from the f…Anders W. Langholm 23 views 0 comments 0 points Started by Anders W. Langholm Reporting and Analytics for ERP -
How to add Dashboard or OTBI analysis on Navigator or Springboard (Home page)This discussion provides step by step guidance on how to add OTBI analysis or Dashboard or any external webpage to application UI home page or on Navigator as new page e…CA Nirmal Choudhary 343 views 0 comments 1 point Started by CA Nirmal Choudhary Reporting and Analytics for ERP -
Custom ESS jobs error outSummary: We have 7 custom reports where created a related ESS job definitions and created custom role (with appropriate Privileges) to run those custom ESS jobs. Job is …AnilJaMI 23 views 4 comments 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP
-
How can I see who an invoice is currently located at in OTBI?Summary: I need to be able to see who's the "Active user" on an invoice in this moment, preferably using a subject area... Content (required): I have searched high and l…Anders W. Langholm 23 views 2 comments 0 points Most recent by Anders W. Langholm Reporting and Analytics for ERP
-
Is supplier audit report available in fusion?Summary: We are looking for standard report to track old value and new value when supplier name, supplier bank number, etc is changed. Please let us know is there any st…User_L2IG5 13 views 1 comment 0 points Most recent by Divya Sidhaiyan Reporting and Analytics for ERP
-
Project Budget Data (EPBCS) with Project Actual (ERP/Project Costing)Summary: Project Budget Data (EPBCS) with Project Actual (ERP/Project Costing) Content (required): How are oracle customers that use EPM/EPBCS for project planning, appr…Andrew_Schmitz 28 views 0 comments 0 points Started by Andrew_Schmitz Reporting and Analytics for ERP -
How to get the ribbon to appear that's above the row with the file location using Firefox?Summary: Ribbon that contains catalog home/favorites/dashboards/new/etc is missing after choosing Browse Catalog in Reports & Analytics. It's like it's hidden, but can't…
-
OTBI Report for Payables Distribution SetsSummary: Trying to create OTBI Report of the Distribution Sets along with the details on the account numbers assigned Content (required): Create OTBI Report of Distribut…
-
R12 ERP OTBI subject areas to database tables mapping spreadsheetsSummary R12 Financial and Supply Chain Management OTBI subject areas to database tables mapping spreadsheetsContent These spreadsheets are published by Oracle OTBI Devel…User720640-Oracle 1.2K views 13 comments 15 points Most recent by AnimeshAgrawal-Oracle Reporting and Analytics for ERP -
OTBI including an header sectionSummary: We have defined an OTBI that exports lines with the images uploaded in the Fusion Product Hub module (SCM). Can be possible to include before the table section …adelsorbo-Oracle 25 views 5 comments 0 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP
-
21D known issues - Just a thread to note down any issues ppl with this release have facedSummary: Opening this thread to note down issues with 21D. Currently we have this release in our lower environment and are testing - so I thought to have a thread that c…Dhruvjoshi23 17 views 3 comments 0 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP -
Procurement > Dashboards > Procure-to-Pay no 'Period' list of valuesSummary There is no value in the list of values for 'Period'Content Hi, I'm trying to open the seeded dashboard Procurement > Dashboards > Procure-to-Pay But with any us…
-
Using BICC PVO in data model for BI publisher reportingSummary: is there way to configure data model to use BICC PVO? we need some custom reporting built and would like to leverage BICC PVO in data model Content (required): …Roman Havrylyak 39 views 5 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Do BICC and OTBI have access to the same data?Summary Wondering if there any differences in what data can be accessed via BICC vs OTBIContent Am wondering if there any differences in what data can be accessed via BI…Jeff Hare CPA CISA CIA 76 views 3 comments 3 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Need a query to get total of Current Cost, Accumulated Depreciation, Impairment for asset categoriesContent Hi all, Can someone give me a query that gives a total of : * Current Cost * Accumulated Depreciation * Impairment per asset categories in Fixed Assets Module. R…Sushan Peiris 489 views 1 comment 1 point Most recent by Sushan Peiris Reporting and Analytics for ERP -
Analysis Report Prompt is not appearing when running from the InvoicesSummary: Prompt added to the analysis report is not appearing when running it using invoice window. Content (required): Hi, I have created a OTBI analysis report (Not fo…Miyuru Guruge 17 views 2 comments 0 points Most recent by Miyuru Guruge Reporting and Analytics for ERP
-
Subject Area Security - Unable to view data from relative subject area despite having role assignedSummary: Subject Area Security - Unable to view data from relative subject area despite having role assigned Content (required): I am currently attempting to troubleshoo…User_IO0OQ 26 views 3 comments 0 points Most recent by Ghanshyam M-Oracle Reporting and Analytics for ERP
-
No data in balances when using Natural Account SegmentSummary: When working with Subject Area General Ledger - Balances Real Time I cannot see any data in balances: Beginning Balance, Period Net Activity and Ending Balance …JJ_DTU 13 views 2 comments 0 points Most recent by Ghanshyam M-Oracle Reporting and Analytics for ERP
-
Is there any OTBI subject area where "associated collaboration documents fields" can be found?Summary: Fields details: Navigation: Supplier > Sites > General > Associated Collaboration Documents Service Provider Trading Partner ID Partner ID Type Document Associa…Atul Aloke 37 views 1 comment 0 points Most recent by Ghanshyam M-Oracle Reporting and Analytics for ERP -
SQL query to display Purchase Category hierarchySummary: SQL query to display Purchase Category hierarchy Content (required): For anyone who might find this useful, I've written a SQL to pull the Purchase Category hie…Mike Burnett 532 views 4 comments 5 points Most recent by Ghanshyam M-Oracle Reporting and Analytics for ERP -
Manager Proficiency result for Competency Assessment ReportSummary i cant find the competency assessment column that shows assessment resultContent I wanted to compare target competency assessment and manager competency assessme…Michael Nega Gebrehawariyat 26 views 1 comment 0 points Most recent by Anna Sherwin Reporting and Analytics for ERP -
Newly created Financial Categories do not show in BI report list of valuesContent I'm looking to pull in 3 new Financial Categories into a BI report I created. I've created the lookup codes under GL and attached the categories to the account s…Matthew Pitkin 97 views 16 comments 1 point Most recent by Sourabh.Choudhury Reporting and Analytics for ERP -
OTBI Cost Centre lists all parent valuesSummary Cost Centre in OTBI returns all parent values as well as the lowest levelContent Hi all, Hoping someone could point me in the right direction. I am attempting to…StuartHibbert 126 views 2 comments 0 points Most recent by Anders W. Langholm Reporting and Analytics for ERP
-
Analytic needs to work with Prompt in DashboardSummary Analytic needs to work with Prompt in DashboardContent Hi, I have a Dashboard include one analytic and one prompt. When i open the dashboard, analytic is searchi…Eren Göktepe-155015 47 views 4 comments 2 points Most recent by A.JOSH Reporting and Analytics for ERP