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
-
Attempting to Extract GL Journal Workflow ApproversSummary: Asking how to access the workflow metadata around assigned approvers in Oracle ERP. Content (required): I am attempting to create a report with BIP that extract… -
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… -
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…
-
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 … -
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…
-
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… -
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… -
What does the lightbulb next to a feature in the What's New feature summary mean?Summary: I am guessing maybe it means the feature was introduced as the result of an idea posted, but I am not sure. Content (required): Version (include the version you… -
Financial Cloud: Are Allocation rules impacted by a Refresh?Summary: I am new to Financials Cloud Oracle. I was hired to be the Quarterly Update Coordinator. I am trying to learn and absorb as much information as possible to help…User_2025-02-12-17-31-01-725 27 views 8 comments 1 point Most recent by User_2025-02-12-17-31-01-725 -
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… -
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… -
Bursting Enabled or DisabledHi Team, We wanted to check if we have a table or sql query to check how many reports have bursting enabled so a report or list can be prepared for the same. Please let … -
Ability to assign roles and access on the basis of position.Summary: We should able to assign roles on the basis of Position. Content (required): Ability to assign roles and access on the basis of position. i.e. Suppose employee … -
Supplier Bank/Branch Address UploadSummary: Content (required): Hi, Is there a way to upload Bank and Branch Addresses through FBDI? Even though we can import bank and branch details, there is no template… -
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… -
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… -
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… -
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… -
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…User_2025-02-10-15-12-48-631 24 views 2 comments 0 points Most recent by User_2025-02-10-15-12-48-631 -
PPM: Data Security in Custom I Publisher ReportSummary: We need some sort of Data Security to be handled in Custom BI Publisher Reports related to Projects module. We are looking for options related to the seeded Sec… -
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… -
When running BIP report on Oracle fusion ERP we are getting Time our error.Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable): -
Combine BiP and OTBI audit data in custom reportSummary: Is it possible to combine BiP and OTBI audit data? Content (required): We have enabled the BiP audit feature and have compiled an OTBI audit report. Business is… -
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… -
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… -
Error whilst joining Subledger and GLHi, I am trying to create a report that joins the subject areas Subledger Accounting: Journals Real and General Ledger: Journals Real Time. It works fine up to the point… -
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 … -
Which table will hold the information of period of an Asset BookSummary: Which table will hold the information of period of an Asset Book Content (required): Which table will hold the information of period of an Asset Book Version (i… -
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…