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
-
Access for General Ledger DashboardsSummary Cannot view data for seeded GL Analytics DashboardsContent Hello, What security role do I need to access the General Ledger Dashboards: Account Analysis, General…User_2025-02-05-07-37-39-271 55 views 4 comments 0 points Most recent by User_2025-02-05-07-37-39-271 -
Report to show all invoices, amounts, VAT and attachmentsSummary A report that will identify all invoices, with invoice amount and VAT amount along with a field that pick up the file attached name (including extension i.e. .pd… -
Purchase Order PDF Report CustomizationContent Hello, I have to customize Purchase Order PDF Report data model and change the layout as per business requirement. I know we have to follow different process to …
-
How to Add the Serial No Column in OTBI ReportsContent How to Add the Serial No Column in OTBI Reports. -
manager data access for usersSummary manage data access for users - users without data accessContent On Manager data access for user page what sql or tables do i use to get USERS WITHOUT Data Access… -
Report Data Size exceeds limitSummary Report errors due to too many rowsContent I am creating an Oracle BI report to extract journal details however when I execute for a particular entity i get the e…
-
Formula to sum up linesSummary Formula to sum up linesContent Hi all, Just wondering if I have PO lines say 3 lines and I want to display the total sum of the PO amount. How to do it in BI pub…
-
BI Catalog name and path extractionContent Hi All, Is there a way to extract the name and location/path of all reports under share/custom folder? We need it for our documentation and we had 100+ reports s…User_2025-02-06-14-16-13-558 41 views 8 comments 1 point Most recent by User_2025-02-06-14-16-13-558
-
XML file for Disbursement Payment FormatsSummary XML file for Disbursement Payment FormatsContent All, I cannot see any Data model attached to disburse payment templates. how to get XML file for them if we need…
-
FR Web StudioSummary FR Web Studio Too Slow To Build ReportsContent Hi, We are trying to build reports in our ERP environment(s). When we open FR Web Studio the lag is too slow; it t…
-
BI Cloud Connector (BICC) White paper or DocumentsSummary Looking for Information on How to create Extract using BICCContent Hi, I need to send incremental feed of Data such as Customer , Supplier, GRN and POs to anothe…Prateek Parasar - GTUK, ACE Pro 239 views 6 comments 1 point Most recent by Prateek Parasar - GTUK, ACE Pro -
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…