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
-
Custom BI Publisher Report SQL ErrorSummary SQL or ORA exceptions error.Content Hello, We are receiving the following error when running a custom built BI Publisher report. This report was functioning with… -
Subject Area in OTBI to extract default Expense Account information of userSummary Subject Area in OTBI to extract default Expense Account information of userContent Hi, I am trying to build a OTBI report which has cost center and company infor… -
Cannot see HZ_GEOGRAPHY_IDENTIFIERS_VL view with Custom Geography Type in Data ModelSummary Cannot see HZ_GEOGRAPHY_IDENTIFIERS_VL view with Custom Geography Type in Data ModelContent Hi I have LACLS Colombia reports into Oracle ERP Cloud. However, they…User_2025-01-30-22-31-23-162 42 views 1 comment 0 points Most recent by User_2025-01-30-22-31-23-162
-
Bank statement balances check reportContent Crossposting here from the Cash Management forum as per Oracle's suggestion. We want to have a report that shows bank statements for which the subsequent bank st… -
What is the Data Model that runs the 'General Ledger and Subledger Account Analysis' Report?Content Hi All, There is a report run via a scheduled process called 'General Ledger and Subledger Account Analysis'. The report is extremely useful and we would like to… -
Get the correct PO Number for an Invoice NumberContent Hi, We had some consultants in they wrote a large piece of SQL, of which the below is a small part. It's looking to get the correct PO number for a specific invo… -
How to set/enable the menu "Reports and Analytics" regardless of responsibilitySummary We’ve created the BI reports to General Ledger but is not possible see the “Reports and Analytics” option on the responsibility menu area, is possible enable thi… -
No response after import sample XML data into excel through BI PublisherSummary No response after import sample XML data into excel through BI PublisherContent Hi all, I have export xml data and want to create xml template in BI publisher in…
-
How to avoid special characters from rtfContent How to avoid new line feed coming as special symbols from rtf template.? Ex.. text entered to item description from application is like line 1. press Enter Line…
-
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 39 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…