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
-
Need to generate and include a sequence number in custom BI publisher eText template for non paymentSummary: Need to generate and include a sequence number in custom BI publisher eText template for non payment Content (please ensure you mask any confidential informatio… -
Need to generate and include a sequence number in custom BI publisher eText template for position baSummary Need to generate and include a sequence number in custom BI publisher eText template for position based payment file to BankContent Hi Experts, We have a require…
-
can I make a warning massage in report parametersHello community, Can I make the same warning message in the screenshot in the report for parameters? No specific field is required but must enter at least one thanks
-
Oracle BI Publisher Errors with "Replacing Invalid junk char with inverted question mark"So, I am developing a BI Publisher report in Fusion Financials with an etext template to generate output in a flat file csv format. I have done this 30+ times at least a…
-
Extracts General Ledger Cube Balances - Error out as QUERYRESULTLIMITHi, From EPM application, ESS job "Extracts General Ledger Cube Balances" is called, which error out as below. Kindly let me know how to fix this issue. Error: Execution…
-
PO PDF error printing attachments "Could not get data source connection for: FA_UCM_PROVISIONED"Summary: Getting error in PO PDF customization " "No such data source found in the data source config. Or you do not have access permission. Could not get data source co… -
Extract Invoice attachment with Rest API Fusion ERP CloudSummary usingContent The following help page documents how to use the Get an attachment for an invoice Rest API. Running the codes gives me a similar response as per the…
-
unsupported report object's type - [catalog]Currently we are using the following webservice to upload a report into BI Publisher https://fa-exsj-test-saasfaprod1.fa.ocs.oraclecloud.com/xmlpserver/services/External…
-
Required Tables that stores min-max values for Replenishment planningSummary: As part of report development, we required min-max values for Replenishment planning. Please provide the details of tables that has to be used to derive the val…
-
Billing number value not showing in receivables transactions real time oracleSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
receivables transactions real time oracleSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
OTBI Report for AP Invoice HoldsSummary Sample OTBI report for ERP Cloud providing a list of AP Invoices on HoldContent Sample OTBI Report for ERP Cloud: AP Invoices on Hold This report provides a list… -
can we restrict/hide viewing few columns based on rolesIn custom reports, i want to hide few columns based on the roles. I want to restrict the access of columns to few employees only. Is it possible to achieve?
-
Privileges to view reports in BI Catalog without access to transactionsSummary: Requirement for custom role only to access reports in Business Intelligence Catalog for all Procurement Functional Area folders Content (please ensure you mask …
-
How to disable the Open option on Reports & Analytics Catalog?Summary: How to disable the Open option on Reports & Analytics Catalog? Among the various reports offered out-of-the-box by the Oracle Fusion modules, some of them can b…
-
How to Split Rows in Excel BI Publisher Output (Nested Rows Inside One Row)Sure, here's a more polished version of your message: Hello Community, I am working on a scenario where I need to display data in multiple rows within a single row in an…
-
Access Values in mapping set for reportingI'm working on a BI publisher report that is a crosswalk from a legacy system to their new values in Oracle Fusion. The report is around deliver-to locations and in Fusi…
-
OIC Gen3 Services calling in Fusion by using BIP/ Groovy AuthenticationSummary: We are tying to consume the OIC Gen3 REST/SOAP services by using BIP/Groovy we are unable to call them." Error while processing authentication at Trigger. Faile…
-
My ledger currency and reporting currency is different.Summary: Need a report from Oracle cloud financial module that provides month end FX rates. Content (please ensure you mask any confidential information): My ledger curr…
-
How to call an Integration in OIC from ESS Job in Oracle Fusion SaaSSummary: How to call an Integration in OIC from ESS Job in Oracle Fusion SaaS Content (required): I have an Integration in OIC and I want it to be triggered by submittin… -
Schedule of Expenditures of Federal Awards (SEFA)Summary Attempting to built the SEFA report using the Projects - Cross Subject Area Analysis - Real Time subject area.Content Report requirements include: Accounting Yea… -
Error 500--Internal Server ErrorSummary: Error 500--Internal Server Error From RFC 2068 Hypertext Transfer Protocol -- HTTP/1.1: 10.5.1 500 Internal Server Error The server encountered an unexpected co…
-
Report that details current cross-validation rulesSummary Report that details current cross-validation rulesContent All, I'm trying to find a way to view all cross-validation rules in a report in Oracle Fusion Financial…
-
FND_FLEX_VALUE_NORM_HIERARCHY is not available in fusion. Please suggest the replica table in FusionSummary: We have DWH implemented and as part of cloud transformation we are migrating from EBS to Fusion Cloud ERP. Hence, from DWH perspective, we are in process of ana…
-
Unable to access the Standard Invoice screen from the OTBI Action Link ReportSummary I am trying to navigate to the Standard Invoice Screen from the custom OTBI Report via Action LinksContent Hi , I had created a custom report with the Payable In… -
ScheduleSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
How to attach the report output into the notification of document of records approval.How to attach the report output into the notification of document of records approval.
-
Synchronize Hierarchies from EPM to ERPIn EPM, we have established a project hierarchy under an "All Projects" node, with dimensions assigned by department. Our goal is to ensure these hierarchies are accurat…
-
Query for Approval DelegationContent Hello, I am looking to build a BIP Report which displays whenever someone has delegated approvals to someone of a lower job level - does anyone know where this i…
-
SQL script for job roles inherited by data rolesSummary: Trying to build a query to fetch users with their data roles and inherited job roles. I am able to fetch the data roles and job role assigned assigned directly …