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
-
How to save a report output with date suffix?Summary How to save a BIP report output with date suffix.Content I managed to get a complete XML output using select query with XMLELEMENT () tag using Data Model. Now I… -
Delivered Deep Link to the Audit > Manage Expense Reports pageSummary Delivered Deep Link to the Audit > Manage Expense Reports pageContent Is there a plan or timeline on when the ability to deep link to the Manage Expense Reports … -
How can user hide, add or remove content from Dashboard PagesSummary Dashboard Page seem to allow you to remove content but no way to add the report backContent I am in 19B/R13. Looking at the Payable Dashboard, I can click on x t…Prateek Parasar - GTUK, ACE Pro 28 views 0 comments 2 points Most recent by Prateek Parasar - GTUK, ACE Pro -
RSS Feed for Oracle Readiness DocumentationsSummary Does anyone know an RSS Feed so we can get automatic updates on when the Readiness Documentation is upload to OracleContent Hi All, Currently we have a reminder … -
Write Back to the Oracle Financials Cloud from EPBCS using Data managementContent Hi All, We wanted to write back data to Oracle Financials Cloud general ledgers in Actual Scenario. Can we Write Back to the Oracle Financials Cloud from EPBCS u…
-
Balance Sheet in OTBISummary Balance Sheet in OTBIContent I have a requirement to build out a balance sheet specifically in OTBI. Some folks have recommended using the subject area for Gener…
-
Value Set InformationSummary Value Set InformationContent Hi, I wanted to know, if a new value set is created where we can see that information in OTBI Subject Areas. We created a new Value … -
Business Date calculation in BI PublisherSummary Business Date calculation in BI PublisherContent Hi, We have a requirement to populate settlement date in 'Disbursement Payment file' with following logic in BIP…
-
Custom Role to access Finance related Schedule ProcessesSummary Is there a way where we can provide Finance users to have access to only Finance related Schedule Processes and not other processes.Version Oracle fusion Release…
-
Can we extract AP BPM Rule through BI Report in CloudContent Can we extract AP BPM Rule through BI Report in Cloud , or we have any other option
-
Prompt Variables Not Being PassedSummary Selections from Prompt variables are not passedContent I have a custom Subject Area/data set derived from a logical SQL query joining the existing subject areas,…
-
Fetch Data from Last run dateSummary Only get updates and creates after the previous run of the reportContent This is something I know can be done in hcm extract but I would like to knoe if at all i…Prateek Parasar - GTUK, ACE Pro 506 views 5 comments 0 points Most recent by Prateek Parasar - GTUK, ACE Pro
-
Supplier Profile syntax has been excluded from the most recent version of the "ERP OTBI Report to FuContent Supplier Profile syntax has been excluded from the most recent version of the "ERP OTBI Report to Fusion App Drill-Down Actions" white paper (which had most rece…User_2025-01-28-16-10-52-033 35 views 1 comment 3 points Most recent by User_2025-02-06-21-15-08-830
-
Logical SQL Error - OTBISummary When attempting to create a new Analysis using simple Logical SQLContent I am attempting to create a new analysis using the logical SQL below; however, whenever …
-
Query for Approval DelegationContent Hello, I am looking to build a BIP Report which displays whenever someone has delegated approvals to someone of a lower job level - does anyone know where this i…
-
Accounts Receivable Reconciliation ReportContent Hello, I am looking to build a reconciliation focusing on the Accounts receivable transactions, I want to show the number of Accounts Receivable transactions tha…
-
PO and Invoice Amount - OTBISummary Need to show PO and Invoice Amount in a reportContent Hello - I have a requirement to show the Invoice Amount and PO Approved amount in the same report. I can se…
-
ERP Cloud implementation using Agile methodologySummary ERP Cloud implementation using Agile methodologyContent Good Morning everyone, Has anyone done ERP Cloud implementation using Agile methodology ? Any feedback/le…
-
OTBI-Parameter-DependentSummary OTBI-Parameter-DependentContent All-> Can we show the parameter values based on another parameter from OTBI? Example: Subject Area: General Ledger - Journals Rea…
-
Usefulness of the Cloud Learning SubscriptionSummary Usefulness of the Cloud Learning SubscriptionContent Hi we are new in the cloud and I am trying to figure out whether the Cloud Learning Subscription is worth th…
-
Schedule and distribute a report to specific usersSummary Schedule and distribute a report to specific usersContent Hello Friends, I need to schedule and distribute a report to specific users. I clicked the "More" optio…
-
Manager Email AddressSummary I need to know how to add a field which includes manager's email addressesContent Using the Expense - Expense Transactions Real Time subject area, I need to add …
-
Direct Database Query Capability Disabled in Update 19A for Oracle CloudSummary Direct Database Query Capability Disabled in Update 19A for Oracle CloudContent Hello Friends, In Fusion Applications Update 19A, the Direct Database Query capab…
-
Who can edit the report?Summary Who can edit the report?Content Can any user edit the OTBI reports or is that something that only the owner of the reports (for example : FASETUP) can edit the r…
-
BIP Expense Report ApproverSummary Looking to find the appropriate SQL that will give me the approver name for Expense Reports using BI PublisherContent The goal of this report is to utilize burst…
-
Subledger Distributions to General LedgerSummary Subledger Distributions to General LedgerContent All-> Need to show the amounts of Invoice distributions/Matched/not matched POs related to Payables payments/rec…
-
Convert SYSDATE to Mon-YY format in oracleSummary Convert SYSDATE to Mon-YY format in oracleContent Hi , Can you please suggest how to convert SYSDATE to Mon-YY format. Version 19B
-
OTBI - YTD -For - Period NameSummary YTDContent All->How to calculate Year-To-Date YTD (total amount for a given period) for a amount column from OTBI. when a user selects Period Name from Parameter…
-
Report on selected bank accountSummary I need to report on the selected/default bank account where a colleague may have more than one in the systemContent Hello, I need to report on the selected/defau…
-
OTBI Project Reporting - ForecastsSummary Unable to locate any measures that relate to past versions of forecasts in OTBIContent Hi, I am in then process of building an in-year expenditure/budget/forecas…