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
-
concatenate data elements with line break in BI excel templateSummary: It is concatenating with supp_name,supp_name2,supp_name3 columns separated by ',' . In my case comma "," also displaying for null cases. Hence i am trying to d… -
Request for Custom SQL Query for SaaS Service Usage Metric Report (Oracle Fusion Expenses)Hello Team, We are in a need of a custom sql query which Oracle uses to populate a count for the below service in the SaaS Service Usage Metric Report, as we got to know… -
Is it possible to enable audit and tracking of all user activity?Summary: Business requires all user activity regardless of module and transaction within the Fusion SAAS ERP to be tracked. Is there a way to achieve this functionality?… -
Getting error while bursting BIP report output to sFTP serverSummary: Getting below error while bursting BIP report output to sFTP server- Below is my SFTP bursting query- *with hash_q as query* select distinct HASH "KEY", 'MicroS… -
Is it possible to set separate Permissions for My Folder and Custom folder (under Shared Folders)?Summary: The requirement is to provide access to create Data Model, Report and Analysis under My Folder in Oracle BI Catalog and for the same user provide read-only acce… -
Any one has idea on Pivot table in rtf, need some help on itAny one has idea on Pivot table in rtf, need some help on it. It is allowing only 5 columns, can we extend it more than 5 columns and also grouping data , need it to be … -
Oracle BICC not providing PVO's for IEX tables of AR ModuleHi Team, Currently we are consuming Fusion FSCM data via BICC console for loading data to our warehouse. We are able to load all data related to Customer, AR Invoices ,R… -
How to have a fixed table for stub before check regardless of the number of invoicesSummary: We have a business requirement to create a custom in-house check wherein the remittance table is causing the check to shift and overflow to the 2nd page. We nee… -
How to run Audit Type Reports by EPM Automate or by RestAPI for EDMCSSummary: 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 table contains future budget period amount details?Summary: Hi Experts, We need to retrieve budget amount, actual amount and commitment amount for future budget periods for a report, these are the fields we see in the be… -
Why the printing from the fusion is different from a laptop to another ?!Summary: I've tried to print a report from the fusion (its layout is made by the word in a RTF format) and it's been printed correctly on my laptop but the other laptops… -
How to execute BIP report and get a PDF file by calling SOAP web service ?Summary: How to execute BIP report and get a PDF file by calling SOAP web service ? Content (please ensure you mask any confidential information): BIP reports were run u… -
sSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
Oracle OTBI Report View does not run for wider searchThe only table/view I have been able to identify, that provides OTBI report usage statistics is the BIPUBLISHER_V view as provided by Oracle. This view consistently eith… -
Fetching Flow Through Funds fields under Grants module in Base tablesWe are unable to fetch values in Base tables for Flow-Through Funds fields like Sponsor , Reference Award Name, Amount under Grants module. PFB the required fields viewe… -
How to get count in pivot table in rtf templateHow to get count in pivot table in rtf template -
Is there a PVO (or combination of PVOs) that returns the accounting status of a Payables invoice?I need to return the accounting status (Accounted, Partially Accounted, Selected, Unaccounted) for a specific AP invoice but using PVOs. The column "ApInvoicesPostingSta… -
Connect Two Subject Areas Without Common Attribute or Dimension in OTBI (Answers Report)Hello experts, I need assistance with connecting data from two different subject areas for a report in OTBI: Receivables - Transactions Real Time Subscription Management… -
ESS JOB User defined list of value with multiple displayed fieldsSummary: Creating a parameter for a custom ESS Job with a custom list of value . Content (please ensure you mask any confidential information): In Oracle Fusion I've cre… -
Function in FRS Webstudio report to go back on GL Average Daliy Balance Cube on an exact dateOur client wants to run Daily P&L built on GL Average Balance Cube using FRS and compare current date PATD balance to same day PATD balance for last month. This is also … -
Oracle EPM SmartView pulling backend 16 digit numbers instead of members from Fusion ERPWhen we tried to login into Oracle Fusion ERP through SmartView and perform adhoc analysis, we encountered an issue having 16 digit numbers instead of member names/Alias…
-
Financial Reporting Center reports not showing in searchHello, We are having an issue with reports showing in FRC. When a user searches for a report in FRC they return no results, but if the user navigates to the BI Catalog r… -
Unable to export the report in text format Windows (CRLF) UTF-8Summary: Hi We have a custom report. When we export the report in text format, should be export in Windows (CRLF) UTF-8 format but it is exported in Unix (LF) format. Ex… -
JDE On Prem Connector to Fusion Data IntelligenceSeeking guidance on the On Prem JDE Connector to Fusion Data Intelligence. We have reviewed this article highlighting the capabilities: https://docs.oracle.com/en/cloud/… -
While the ESS job names are visible in the ui, they are only partially displayed in the BIP ReportSummary: While the ESS job names are visible in the user interface, they are only partially displayed in the BIP Report, with approximately 50% of the job name informati… -
Report 2x - 5xing values when using the hierarchical tiersI'm having issues trying to get the right data when using the object 'Level 22 Value' in Natural Account Segment under the General Ledger - Transactional Balances Real T… -
Does BIP allow additional static attachments, Word and Excel, to be added to a bursting email?Summary: We are customising the standard PO print BIP report and they will all be delivered via email, using the bursting functionality. The email will have a PDF attach… -
Inquiry: Attaching XSL-Based XML Output to PDF in Oracle Print Transaction ReportSummary: The Print Receivable Transaction seeded job is currently generating PDF output for customers. A new requirement has been raised to build an XSL-based XML output… -
How to create and submit BIP reports by batch (request set)Summary: How to create and submit BIP reports by batch (request set) Content (please ensure you mask any confidential information): There is a client requirement to run … -
default awards period type to inception to dateSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…