OTBI
Discussion List
-
Last Run in OTBIHi, I would like to history and last run date and time stamp of the OTBI report. (as when it was lastly excuted) Is there any way to find. ThanksMohammed Rafi 31 views 2 comments 3 points Most recent by Swapnil Kashid Reporting and Analytics for ERP -
Table(s) for Enabled / Not Enabled Functional Audit PoliciesSummary: Is there a table that contains the full list of functional Audit Policies that can be enabled / have been enabled already? Content (required): See PDF for scree…Jeff Hare CPA CISA CIA 11 views 1 comment 0 points Most recent by Jeff Hare CPA CISA CIA Reporting and Analytics for ERP -
OTBI_EXM: No data for Transaction/Billed/Posted Amount Columns on corporate card expenseSummary: When querying corporate card expenses that have not been added to an expense report, no data is populated for fact columns Transaction Amount, Billed Amount, an… -
In OTBI Report, can we have details in single row per transaction with tax amount?Summary: We are looking to have only 1 line per transaction and when I add tax amount it splits the report to multiple lines per transaction. Is there a way around this?…Rahul Kumar Gupta.-Oracle 31 views 0 comments 1 point Started by Rahul Kumar Gupta.-Oracle Reporting and Analytics for ERP -
Details about PrivilegesHi Team, Am looking for a report/ query to find details about privileges. We are looking for finding a what is the exact purpose of a privilege. Example: AP_MANAGE_PAYAB…Swapnil Kashid 11 views 2 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP -
How to audit the consumption of reportsHello, Is there a way we can view who is consuming OTBI and BIP reports? is there some sort of usage stat or which user is running the reports? Many thanks, JamesJames Coles 31 views 2 comments 1 point Most recent by Skolli-Oracle Reporting and Analytics for ERP
-
R13 Higher Ed and Public Sector Cloud OTBI subject area to database lineage mapping spreadsheetSummary: This spreadsheet documents R13 Higher Education and Public Sector Cloud OTBI subject areas to database lineage mapping and subject area security Content: This s…Noelle Bartlam-Oracle 402 views 0 comments 1 point Started by Noelle Bartlam-Oracle Reporting and Analytics for ERP
-
BI publisher report show blank pageSummary: Hello i have customize report in BI and this report is work perfect with all user using windows and Firefox browser , but have one user is have MAC and Safari b…Mahgoub S.Mohamed 91 views 6 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP -
OTBI - General Ledger - Data extraction of Journal description details not populating for some linesSummary: OTBI - General Ledger - Data extraction of Journal description details not populating for some lines Content (required): A query is used to extract data from OT…User_2025-02-04-15-40-21-120 51 views 0 comments 0 points Started by User_2025-02-04-15-40-21-120 Reporting and Analytics for ERP -
Dynamic Logo in RTF Template in FusionContent Hello Team, Could you please let us know how can we use the Dynamic Logo in RTF Template in Oracle Cloud/Fusion. Same logo is called in many other reports and ou… -
Payables Invoices - Withholding Real Time - OTBI Not getting resultsSummary: Payables Invoices - Withholding Real Time - OTBI Not getting results Content (required): We are tying a build a quick OTBI analysis on the seeded subject area P…Balachander G-Oracle 72 views 0 comments 0 points Started by Balachander G-Oracle Reporting and Analytics for ERP
-
Report to find details of history of all reportsHi Team, Could you please let me know if there is a way/ there is a report to retrieve details of all custom reports (OTBI/BIP) in terms of last updated by and last upda…Swapnil Kashid 41 views 2 comments 1 point Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
How to get L3 Hierarchy account in GL transaction analysis OTBI reportSummary How to get L3 Hierarchy account in GL transaction analysis OTBI reportContent Hi , There is a requirement to add L3 hierarchy of the 'Natural Account' segment al…Sellapalaniappan V-Oracle 38 views 1 comment 0 points Most recent by Ahmed Mousa Reporting and Analytics for ERP
-
Need a query to get the Fixed Assets category combination along with all its account combinationsSummary: Need to get the following accounting combinations of the category combinations in accounting rules; Cost, clearing, depreciation reserve, depreciation expense,c…Dian Minshan 1.4K views 1 comment 0 points Most recent by Ahmed Mousa Reporting and Analytics for ERP -
I need a query to obtain Review Budgetary Control Balances screen informationSummary: I am kind of new with Oracle fusion budget control module and We require to create a report where We need the information that appears in the Review Budgetary C…Robinson Antunez 1.4K views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
To create custom subject areaHi All, Could you please let us know if there is a way to register a sql query as a custom subject area that can be used for creating an OTBI report. Our requirement is …Swapnil Kashid 71 views 4 comments 1 point Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
LOV for Analytics show nullSummary: Hello, i have analytics report read from general ledger transaction real time subject area this report is request from HCM user he need information about overti…Mahgoub S.Mohamed 21 views 4 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Last closed period in Fixed Assets - Transactions Real timeSummary: There is no data in the fact column "Last closed period" in the subject area Fixed Assets - Transactions Real time. Content (required): We do have some closed p…Anders W. Langholm 11 views 2 comments 0 points Most recent by Anders W. Langholm Reporting and Analytics for ERP -
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 144 views 2 comments 8 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 11 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…martingabriel Kinovisques 11 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…User_2025-02-04-14-03-09-386 59 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 698 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 272 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 21 views 0 comments 0 points Started by Anders W. Langholm 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 41 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 21 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…
-
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 22 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…