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
-
Securing OTBI/BIP ReportsSummary Securing OTBI/BIP ReportsContent Hi All, One of our client has a requirement where they would like to give "Read only access"(no edit/create/delete even from BI … -
Open/Close Ledger ReportContent Is there a report that can show when ledgers were opened and by whom? If not, is there a way to build this? Thanks, Dan -
Out-of-box reports in all modules and customizing themSummary Out-of-box reports in all modules and customizing themContent Hi , In financials cloud,what type of reports are provided as out-of-box for all modules?Where can … -
How does Oracle push pdfs from the cloud?Summary How does Oracle push pdfs from the cloud?Content The Oracle system is exporting PDF files but they come down with a .TMP file extension instead of a PDF extensio…User_2025-01-28-07-47-26-775 44 views 1 comment 0 points Most recent by User_2025-01-28-07-47-26-775 -
Setting Tab Names in Excel When Downloading an FRS ReportSummary Setting Tab Names in Excel When Downloading an FRS ReportContent I have 60+ Company (Balancing Segment) values. When I generate a report in FRS and then download… -
Overall – New Multiple Pillar Oracle Cloud Implementation White Paper - November 2 , 2017, 10:00 a.mContent Submit your questions for the Overall – New Multiple Pillar Oracle Cloud Implementation White Paper session to have them answered during the live event. Post you… -
Important Information About Fusion OTBI R12 Patch Bundle 10Summary This note provides information about Fusion OTBI R12 PB10 (2017 October monthly patch bundle).Content This note provides information about Fusion OTBI R12 PB10 (… -
Account analysisContent Has anyone developed account analysis that shows the project number from April invoice line? i am not able to link GL , subledger and AP subject areas in OTBI to… -
Invoice Approval and Notification InformationSummary Cannot find the table name for Invoice Approval and Notification InformationContent We want to extract details of Invoice Approval and Notification Information b…User_2025-01-22-19-25-44-650 64 views 3 comments 0 points Most recent by User_2025-02-05-11-38-57-253 -
Intercompany out of balance reportContent Hello Gurus we looking at developing the following report we are not using AGIS and we have one ledger only. we would like to get the account balance twice on th… -
Payables - Reports & AnalyticsSummary Cannot view analysis created in draft sectionContent Hi , I've created an analysis,called Payables Trial Balances Real Time on a demo environment but I cannot vi… -
Expression: Project Currency error when using dashboard prompt for project cross subject area real tSummary Error Codes: OAMP2OPY:G689FFB3:SDKE4UTF Expression: Project CurrencyContent wonder if anyone encountered the same issue when developing a new OTBI report using p… -
how can you link project subject area to GL company hierarchySummary trying to link projects - cross subject area Real time to General Ledger Transactional Balance Real timeContent Checking if you know someone who can guide us on … -
Content Pack - Oracle Fusion Cloud (Financials, Supply Chain and Manufacturing)Summary Where can I find Content pack for Data Visualization / OAC for Oracle Fusion CloudContent hi there, Does anyone know where to find the content packs for data vis…User_2025-01-28-08-30-45-744 90 views 0 comments 0 points Most recent by User_2025-01-28-08-30-45-744 -
Filtering Out Zero Values in OTBI Pivot TableSummary Filtering Out Zero Values in OTBI Pivot TableContent I have a pivot table in OTBI that contains some zero balances. Is there a way to filter them out of the pivo…User_2025-01-30-00-16-17-628 49 views 1 comment 0 points Most recent by User_2025-01-28-01-14-15-052 -
Struggling to Find Expense Report Line DetailsSummary Can't Find Receipt Date and Number of Days in "Expenses - Expense Transactions Real Time"Content We are seeking the following fields for Expense Report Items: -R… -
FA Depreciation TimingSummary Post sub-ledger activity to a different periodContent Hello - Is there a way to force sub-ledger activity in one period to post in the GL in a future period? I h… -
BI Publisher Report Linking Account with NodeContent I'm trying to create a report in BI Publisher that displays account (Segment2 in the GL_CODE_COMBINATIONS table) with the account tree node. I can't find a table… -
Support for Legal Entity Time Zone in ERP Cloud FinancialsSummary Request for documentation about how and for which transactions Legal Entity Time Zone in ERP Cloud FinancialsContent Our understanding is that in ERP Cloud the t… -
Unable to find invoice validation status through BIP sqlSummary Unable to find invoice validation status through BIP sqlContent We are not bale find invoice validation status through BIP sql by using AP_INVOICE_ALL. Will be a… -
how to get the GL balances for a UOMSummary we are trying to build FRS or essbase adhoc report , we using the mixed currency journal to enter actual and stat journal all together but UOM is not presented i… -
How to show the grand total with group by option ?Summary How to show the grand total with group by option ?Content Can you please help us how to show the grand totals with group by option. I am trying to bring the repo… -
Expense Report AnalysisSummary We are trying to improve our reporting on expense reports and add additional fields in our reportsContent We are trying to improve our analysis on expense report… -
Revoke Roles in Security Console R12 Still Showing Assigned in BI ReportSummary Since R12 upgrade revoking roles in Security Console, the revoked users' roles still appear to be assigned in our existing custom BI report (SQL below)Content In… -
Automated Test script execution for Cloud SaaS applicationsSummary Automated Test script execution for Cloud SaaS applicationsContent Hi all, I posted this in Integrations track but didn't get a response, hoping someone can prov… -
OTBI Edit and Creation of new report Missing After Patch releaseSummary OTBI Edit and Creation of new report Missing After Patch releaseContent We just took the monthly patch this weekend and certain users, General Accountants and Fi… -
Subject Areas and Roles - R12Content Can anyone point me in the direction of some documentation which shows which Roles can access which Subject Areas across ERP for Fusion R12? Thanks Dean WillifordUser_2025-01-29-00-51-37-288 77 views 4 comments 0 points Most recent by Venkateswarlu Yenuganti-23335 -
How to change the Costs Column for periodsSummary How to change the Costs Column for periodsContent Hi, I have a requirement to show the Budget and Actual costs with figures for month on month basis. So kindly g… -
Standard Financial DashboardsSummary Need to create some basic Financials Dashboards, which gives a clarity over Company Financial HealthContent Hi All, I have implemented Oracle Financials Cloud fo…User_2025-01-29-20-34-14-699 155 views 2 comments 0 points Most recent by Farooq Syed, CPA, PMP, CISA -
Fusion R12 Upgrade -BI | Icons appearing as dots ( . )Summary After upgrading to R12 Fusion, the BI icons like "Add" (+) and "Delete"(x) are appearing as dots (.)Content After upgrading to R12 fuion, the icons like "Add" (+…