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
-
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… -
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, James
-
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… -
How to filter and sum positive or negative value only in FRS reportSummary: To see if FRS report could filter value of positive or negative and do summation against it. Content (required): We would like to know is there a way to filter …
-
Uploading to BI keeps loadingSummary: Specifically in Firefox browser, whenever I upload something (layout, datamodel, report,..) the loading popup keeps loading and doesn't do anything. Content (re… -
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… -
OTBI - General Ledger - Balances Real Time Subject Area not Returning Budget DataSummary: OTBI - General Ledger - Balances Real Time Subject Area not Returning Budget Data Content (required): Having successfully loaded budget data into Financials fro…User_2025-02-10-15-12-48-631 291 views 4 comments 0 points Most recent by Global Oracle Support-Oracle
-
User does not see a delivered reportSummary: User does not see a delivered report Content (required): User clicks on Schedule New Process, and types "Reserve". She only gets results for the Reserve Detail …
-
ESS Job vs BIPSummary: ESS Job vs BIP Content (required): Assuming we don't have any dependent list of values, is there any strong/security reason we should use ESS Job on top of the … -
Display Report Job ID INSIDE the BIP ReportSummary: Display Report Job ID INSIDE the BIP Report Content (required): Is there any way we can display the "Report Job ID" INSIDE the BIP Report? or use it in the burs…
-
Download BIP Output based on Report Job IDSummary: Download BIP Output based on Report Job ID Content (required): Is there any API to download the BI Publisher output in XML format based on the "Report Job ID" w…
-
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…
-
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… -
Reporting changes to user status in Financials?Summary: How can changes to user status (eg new accounts, locking/unlocking, activation/inactivation) be reported? Content (required): As part of our monthly compliance …
-
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 31 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…