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
-
How to schedule BIP report in application composer ?Summary: I would like to use the application composer to schedule a BIP report I have defined the (https://****/xmlpserver/services/ScheduleReportWSSService?WSDL ) webse… -
Report to monitor payables invoice rejections due to invalid approval rulesSummary: Any seeded report to monitor payables invoice rejections rejected due to invalid approval rules. These kind of rejections can be viewed only in Transaction cons…
-
Financial Reporting Studio Report displaying Error when no data is foundSummary: Financial Reporting Studio Reports fetching #Error when no data is found. We don't want want to suppress the column or row, rather want to display the value as …
-
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…
-
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…
-
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… -
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… -
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…
-
How do I create an aged report for open transfer orders in OTBISummary: I am trying to create an OTBI Analysis for Open Transfer Orders. We would like to see a count by destination, date, cost of inventory item and possibly the GL A…
-
In Job Details need Travel Required fieldSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Which exact privilege or duty role allows user to access Security dashboard?Summary: We want to give user access to below seeded reports. Currently "Application Implementation Consultant" gives that access but we cannot assign the role due to ot…