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
-
Drill Down from OTBI Subledger Accounting Reports to Subledger Journal Entry DetailsSummary Drill Down from OTBI Subledger Accounting Reports to Subledger Journal Entry DetailsContent Hi all, This is 19c new function, "Drill Down from OTBI Subledger Acc…User_2025-02-04-05-26-22-197 77 views 2 comments 0 points Most recent by User_2025-02-04-05-26-22-197 -
Custom Style in OTBISummary How to change graphs color, stlying in OTBIContent Hello - Is there a way to change or add custom style/color to a graph or chart within OTBI analysis and dashbo… -
Begin/End Balance for Accumulated depreciation of an AssetSummary Begin/End Balance for Accumulated depreciation of an AssetContent Customer asks: We're building a Fixed Asset Balances report out of Subject area Fixed Asset Bal…
-
rtf template - display constant text on every pageContent Hi All, I have a rtf template which contains nothing but a (row*column) table. I need to display a constant text like "Hello" at the bottom of every page, other …
-
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…
-
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… -
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
-
ERP Cloud R13 quarterly upgrades to advance for one monthSummary Requiring to advance Quarterly release one month aheadContent Hello community, Could I know if an ERP Cloud (Financials/Purchasing) client can move ahead the qua…
-
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…
-
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 -
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 …
-
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…
-
Monitoring approval errors in Financial CloudContent We are trying to create a BIP report that will be scheduled to run to collect all workflow instances that have erred while/during approval. This is required for …User_2025-02-05-11-44-44-738 37 views 2 comments 1 point Most recent by User_2025-02-05-11-44-44-738
-
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…
-
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…
-
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 476 views 5 comments 0 points Most recent by Prateek Parasar - GTUK, ACE Pro
-
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,…
-
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 …
-
OTBI: Receivables - Transactions Real Time Subject AreaSummary OTBI: Receivables - Transactions Real Time Subject Area don't show collectionsContent I am trying to develop a report on this subject area to show the customer a…
-
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…
-
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…
-
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-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…
-
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…
-
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…
-
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 …
-
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…
-
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…
-
19C ThemeContent Hi After upgrade to 19C Patch seems some of the pages have got a black banner at the top with font in grey color . See attached . Any help how to change it back …