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
-
NEW REPORT: Journal and Transaction Details ReportSummary: The Journal and Transaction Details report lists general ledger journals and subledger transactions activity along with header, line, and distribution-level det…Abhijit Dhakephalkar Gr Manager Financials Product Management-Oracle 3K views 78 comments 9 points Most recent by Pratiksha Sawandkar -
Open-source fonts to replace licensed Monotype fonts in BIP and OTBI in 24AIn 24A, open-source fonts will replace the Monotype fonts currently available in Oracle Transactional Business Intelligence. You can use the open-source fonts available … -
Sample OTBI dashboard and reports for Joint Venture Management TransactionsSummary An OTBI dashboard with a detailed and summary report for Joint Venture Management Transactions. Content You can import the attached catalog file into a Cloud ERP… -
Budgetary Control Balances OTBI with Deep Link Sample ReportSummary: Content (required): The Budget Balances OTBI with Deep Link Sample Report Kit contains a sample report embedded with a deep link to Review Budgetary Control Tra… -
oracle cloud erp frs reportSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Unable to link multiple subject areas in OTBI reportHi, I created an OTBI report with PO and Invoice details such as PO number, PO lines, PO amount, Invoice number, Invoice amount, Transaction currency and Ledger/Accounti…
-
Equivalent Standard AR Report not available in Fusion although Business uses standard reports in EBSEquivalent Standard AR Report not available in Fusion although Business uses standard reports in EBS - Need Oracle confirmation on the availability of standard Fusion AR…
-
Report Logo broken in Gmail but working in OutlookSummary: We are inserting the client logo for the Disbursement Separate Remittance Advice Report and it is working with Outlook but it is broken when being opened in Gma…
-
Why I am not able to see prompts when I navigate through Reports & AnalysisI created an OTBI report in Accounts Receivable with prompts. When I access the report through Browse Catalog, the prompts appear as expected. However, when I navigate v…
-
Multiperiod Accounting invoices amortization detailsneed help in getting details of MPA invoices, query to get details of MPA Invoices with1) Monthly amortization amount 2) Current Month amortization amount 2) Accumulated…
-
Do we have any subject area for custom role creation start and end dateSummary: Do we have any subject area for custom role creation and end date Content (please ensure you mask any confidential information): Do we have any subject area for… -
Missing Mapping for Attribute_Number1 from FUSION.GL_JE_LINES Table to BICC GL_JE_LINES PVOWe are unable to map the ATTRIBUTE_NUMBER1 column from the Fusion GL_JE_LINES table to any column in the BICC Journal Lines PVO (FscmTopModelAM.FinExtractAM.GlBiccExtrac…
-
Connection Timeout (Error 404/504) when connecting BI Publisher to OIC File Server via Port 10134.Summary: Connection Timeout (Error 404/504) when connecting BI Publisher to OIC File Server via Port 10134. Content (please ensure you mask any confidential information)…
-
What are the solution options for Audit Trail for Spend Classification?Summary: We need to have an Audit Trail for Oracle Fusion Cloud Procurement > Spend Classification. Oracle doesn't include the Spend Classification product as part of Ma…
-
Security for OTBI Subject Area "Projects - Labor Distribution Costs Analysis Real Time"Summary: We need to expose OTBI queries written against the subject area "Projects - Labor Distribution Costs Analysis Real Time" to a larger population. Right now, it i…
-
Hi, does anyone have a query on how to pull invoiced and non-invoiced receipts?Hi, does anyone have a query on how to pull invoiced and non-invoiced receipts?
-
Trial Balance ReportTrial Balance Report output is blank, although balances can be seen in Account Inquiry Details UI -
Which table contains the email addresses for users who log in to the Supplier Portal?Summary: Dear Experts, I would like to obtain the email addresses of users who log in to the Supplier Portal using SQL. However, I could not identify the correct table t…
-
How to Obtain History of Last Updated Date and Owner for ReportsSummary: How to Obtain History of Last Updated Date and Owner for Reports Content (please ensure you mask any confidential information): Is there a way to obtain a list …
-
ESS Job (Copy of Accrual Reconciliation Report) throwing warning Too many matching records found."Hi, We have created a new ESS job by simply copying seeded Accrual Reconciliation Report. We did not touch any parameters and kept them as it is. We have just enabled bu…
-
Roles that can create and update, or only view Financial Reporting reports connected to GL EssbaseThis concerns roles that can create and update, or only view Financial Reporting reports connected to GL Essbase. We need to understand two types of roles: one that only…
-
How to Check PPR Approval History from AP Payment ScreenSummary: How to Check Payment Process Request Approval History from AP Payment Screen Content (please ensure you mask any confidential information): Version (include the…
-
Is there a way to dynamically rename split rtf files using PDFZ output?Summary: We have a requirement to rename the individual pdfs that get generated from an .rtf report in BIP. I think I am "close", but I can't seem to get the XML tags co… -
Embed OIC Monitoring Dashboard into OTBI DashboardSummary: Content (please ensure you mask any confidential information): Is it possible to embed the OIC monitoring dashboard on an OTBI dashboard? Version (include the v…
-
How to ensure date columns in BI Publisher Excel output use date filters instead of text filters?Our customer wants to download online versions of reports in Excel format, next they will be applying filters on the table for deeper review and analysis. There are mult… -
Redwood roadmap for Oracle FinancialsSummary: We would like to know Redwood implementation roadmap for Oracle Financials. It involves lots of planning and effort sooner we know the roadmap it will help cust…
-
Access to Fusion transactional tables (GL_JE_LINES, XLA, PJC, CMR) using Fusion Data IntelligenceHi, I need to analyze data that in Fusion transactional schema is stored in tables such as: GL_JE_LINES XLA_DISTRIBUTION_LINKS PJC_EXP_ITEMS_ALL CMR_RCV_DISTRIBUTIONS We…
-
Create 'Buyer Assignment Rules' ReportGood Day Experts, Is there a way to create a report to show details and information for Buyer Assignment Rules? Screenshot below is the view from Fusion Application. Col…
-
How to Pull Fiscal Classification Name on ReportSummary: We are seeking to include the field "Fiscal Classification Name" on a report because the related field "Fiscal Classification Code" is not meaningful to end use… -
Report to obtain the user's transactionsSummary: Report to obtain the user's transactions Content (please ensure you mask any confidential information): Is there a query, process or report to obtain the transa… -
Fetching Tax Lines Based on AP Distribution Lines and Ship To LocationSummary: I'm trying to determine the correct, delivered method for linking AP_INVOICE_DISTRIBUTIONS_ALL with ZX_LINES in order to retrieve tax amounts at the individual …
-
How To Change The Date Format For Date Columns In BICC ExtractSummary: Hi Team, My requirement is to insert the values from the date columns of BICC extract into ATP using DBMS_CLOUD.COPY_DATA functionality. COPY_DATA is not workin…
-
Dynamic Link in the BIP reportSummary: I have to add a dynamic link to the BIP report that would redirect to the absence transaction. Is there a possibility to do this? Content (please ensure you mas…
-
Zero values in Finance GL-profitability subject area in FDIWe are getting zero values in net income column, can you please suggest if there is any data load issue in FDI? or suggested any workaround is helpful.