To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for ERP
Discussion List
-
Send remittance advice report querySummary: Send remittance advice report query Content (required): We want to customize send remittance advice process. And we need the seeded report data model query acce… -
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 … -
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… -
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… -
Transaction (requisition and/or expense report) - approvers and actionsSummary Provide end-users with a report (or reports) that identifies approval status (and history) on requisitions and/or expense reports).Content Boise State has a requ…
-
OTBI - Unpaid Invoice By Payment methodSummary OTBI - Unpaid Invoice By Payment methodContent This report helps to identify unpaid invoice details for any enterprise. -
Audit Report for FranceSummary Does Anyone use Audit Report for FranceContent We are trying to use the provided Audit Report for France and we are running into issues. Did anyone use this repo… -
Report Time out IssueSummary: There is an issue on report execution time out. When a long period report run on any finance side. Then after sometime an error occured on time out. Same report…
-
How to remove/supress subtotal lines in SmartviewSummary Is it possible when drilling down in a Smartview report to 'remove subtotal rows' in the same was as you can with a standard pivot table output? -
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… -
Filter ReceiptHi, I am receiving output of the query as below I would like to modify the below query to have separate queries one query to display row number 1,2,3 which are highlight… -
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…
-
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… -
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…
-
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… -
Edit a standard report without regenerating sample data?Summary: Hi, I am editing a standard report (BIP) in Fusion Financials and have added the new field to the data model using the trick of exporting the zip (xdmz) content…
-
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…
-
Anyone with Insightsoftware Reporting tool experience?Summary: Looking for anyone who has experience with using Insightsoftware's tool for Oracle Financial Reporing Content (required): Looking for feedback on Insightsoftwar…
-
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 …
-
Account analysis report comes with functional currency (USD) in scheduled processes.Summary: Is there another report like account analysis report we can use that will have another currency (originating currency of the transaction) aside functional curre…
-
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…
-
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…
-
How to customize Subledger Period Close Exception ReportSummary: How to customize Sub-ledger Period Close Exception Report Content (required): Ledger Set Parameter to be added to the report. when i'm trying to edit datamodel,…
-
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… -
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…
-
Finally Closed Lines are shown as Cancelled in PO Archive LinesSummary: Some of the finally Closed lines on Change Orders are coming as cancelled in the Po archive lines Content (required): Version (include the version you are using…
-
Finally Closed Lines are shown as Cancelled in PO Archive LinesSummary: Some of the finally Closed lines on Change Orders are coming as cancelled in the Po archive lines Content (required): Version (include the version you are using…
-
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…
-
Permission Error When Trying to Migration BIP Reports between DEV and SAT environmentsSummary: We've setup a pipeline in VBS and are using a job to migrate data models and bip reports from one region to another and running into a permissions error on our …
-
Unable to extract large volume of dataSummary: We have prepared one BI publisher report which has different filter criteria in it. While we run the report & extract the data, it shows only 74701 records and …