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
-
Adding Distribution Information to Payables Invoice InquiryYou can extend pages with custom OTBI reports, for example with budgetary control charge account and projects information is useful when viewing invoices. The Embedded I… -
Can we populate currency based on the ledger currency in FRS Report in Oracle FusionHi, We are currently building a financial report using Financial Reporting Studio (FRS) in Oracle Fusion/ERPCS, and we are exploring options to dynamically populate the … -
Is there a way to change the default export format to xlsx in ERP?Summary: We use Excel 2024. When exporting reports out of ERP, they default to Excel 2007. Is there a way to change the export format to xlsx? Content (please ensure you…
-
How to default logged in user to BI report parameter?Summary: Default logged in user to BI report parameter Content (please ensure you mask any confidential information): Hi, We have a custom BI report, that has a paramete… -
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 …
-
Financial Reporting Studio Issue: 2026 Data Not Appearing (current Year)Dear Oracle Support, We are encountering an issue in Financial Reporting Studio (FRS) that is affecting the display of 2026 data in our reports. Pervious year data showi…
-
Payable Invoice lifecycleSummary: looking for any OTBI Analysis which provides AP Invoice lifecycle view. Content (please ensure you mask any confidential information): Version (include the vers…
-
Query to fetch approver details for all pending requisitionsSummary: Query to fetch approver details for all pending requisitions Content (please ensure you mask any confidential information): We are creating a report which will …
-
What table store approval rules configuration in FusionSummary: We are looking tables name for approval rule configuration. Navigation: Tools>Transaction Console>Approval Rules Content (please ensure you mask any confidentia…
-
SQL to get the list of all tax codes definedSummary: Hi, Can anyone please share the SQL to get the list of all tax codes defined. Or are you aware if there is any standard reports which is available that can prov…
-
Standard Purchase Order Report sub template logicSummary: Hi Team, Theres a subtemplate being called in PO template rest of contents in rtf template has english content with fields no language specfic condition. but w…
-
BICC columns with numeric datatype fetching incorrect decimal values.Summary: We observed that an issue with BICC extract for columns with numeric datatypes. We noticed that columns with numeric datatype, for decimal values, its fetching …
-
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… -
OTBI Dashboard and Reports for ExpensesSummary An OTBI dashboard with a series of drillable reports for ExpensesContent The attached catalog files can be imported into an ERP Cloud instance to create a dashbo…
-
Balance Sheet SQL query requirement in BIPHi everyone, I need to build a custom balance sheet report in Oracle Fusion Cloud Financials using BI Publisher**,** and I’m completely stuck at the starting point. I ha…
-
when scheduling a BIP report by selecting multi select parameters at Trigger job is skippingSummary: when a scheduled a report by selecting multi select parameters in general Tab and at Trigger in schedule Tab job is getting is skipped even when data exists. Ex…
-
Apply Format Currency in RTF within a calculation TagSummary: Hello, Is there a way to apply a format currency () for this tag in an RTF template: Thanks Content (please ensure you mask any confidential information): Vers…
-
issue with custom bip reportSummary: our team has developed a custom report for weekly notification on held invoices. report purpose is if any approval pending or hold to be released it will send i…
-
OTBI - Issue while submitting Custom report - Asset Cost DetailSummary Error while selecting parameters for Custom OTBI report which was copied from Asset Cost Detail reportContent Error while selecting parameters for Custom OTBI re… -
REST API to run FRS reports in FusionSummary: Need to know REST API details if any to run FRS reports in Fusion Content (required): REST API to run FRS reports in Fusion Version (include the version you are… -
Can a ESS job have 2 different BIP report layout which will execute 2 different queriesSummary: We have a requirement wherein client is expecting one ESS job will execute different queries based on parmater and both quries are having different report layou…
-
Displaying Accounting Period parameter LOV in expandable hierarchical manner when running FRS ReportThe business' FRS report currently has their AccountingPeriod parameter set to only query years, which is causing issues when they're trying to query years with periods …
-
AR Transaction Approval QuerySummary: Hi Team, Please help to get table that stores AR transaction approval History.
-
Missing informations in FscmTopModelAM.PrcExtractAM.PozBiccExtractAM.SupplierExtractPVOSummary: Why ZX_PARTY_TAX_PROFILE Informations regarding Suppliers are not in the PVO 'FscmTopModelAM.PrcExtractAM.PozBiccExtractAM.SupplierExtractPVO' but only in the o… -
CX Sales BI Publisher report to show payment terms for accountsSummary: Is it possible to have a BI publisher report to show list of account and their payment terms which would have been setup in accounts receivables ? What tables a…
-
How to retain the existing permission of target server while migrating #BIP reportPlease could you help us in the process how we can retain the existing permission in target system when we get the BIP report migrated after modification. For example, i…
-
Need fusion table details for Tax Classification Code for supplier in Fusion.Summary: Need fusion table details for Tax Classification Code for supplier in Fusion. Content (please ensure you mask any confidential information): Version (include th…
-
How can we change the default template for the ESS Job Print Receivable TransactionSummary: I want to use another RTF for the standard ESS Job Print Receivable Transaction job Content (please ensure you mask any confidential information): Version (incl…
-
why the BIP Report does not consider the template while generating the output in CSV Format ?Req : Generate CSV output format with specific column names. Hi Team, I have designed an Etext template for the purpose of generating output in CSV format. Etext Templat…
-
REST Data Source Fetching Only 25 Records in Oracle APEX – How to Retrieve All Records?Summary: I am currently working on building a dashboard in Oracle APEX using a REST Data Source to fetch data from an Oracle Database. However, I am facing an issue wher…