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
-
BI Publisher report should send email with Digital signatures in email body.Summary We have a business requirement to digitally sign the email while transmitting transaction prints to customers. Basically, the email body needs to have the digita… -
Access to Fusion Accounting Hub Reporting Cloud Service ( FAHRCS).Content Hi all, Please clarify whether the "General Accountant" role has access to Fusion Accounting Hub Reporting Cloud Service ( FAHRCS). Best Regards, Vipusha
-
No data in Account Analysis ReportContent Steps to reproduce: Run Account Analysis Report Process -> Select parameters and filter with some accounts -> Process ends "Success" -> Open the file -> There is…
-
Account Segment Group ObjectsContent Our team is looking to group together certain accounting segments for use in some of their reporting and imports. They currently have specific payroll object gro… -
BI REST APIsSummary BI REST APIsContent Hi All, Has anyone tried using the REST APIs to invoke a BI Report? I am having a hard time to get it working. If you have sample code and ca… -
How to access Custom ESS Job SetContent Business Users are not able to access the Custom ESS Job Set. We checked the below Oracle notes, but nothing works. How to Grant Execution Privileges to ESS Cust… -
FscmTopModelAM.FinExtractAM.GlBiccExtractAM.BalanceExtractPVO does not contain creation_date, why?Summary Why does FscmTopModelAM.FinExtractAM.GlBiccExtractAM.BalanceExtractPVO not include creation_date column?Content Why is creation_date missing from BICC Balance Ex…User_2025-03-07-18-57-57-349 660 views 0 comments 1 point Most recent by User_2025-03-07-18-57-57-349
-
Configuring Key Flexfield Segments in Oracle Financials Cloud to leverage OTBI for ad-hoc analysesSummary Configuration Steps to enable OTBI reporting of Key Flexfields (KFF's) in GL, Budgetary Control and Fixed Assets (Rel 11)Content To report on Key Flexfield Segme…
-
Pulling reports dataContent Hi, Is there ways to pull data from BI report say Payables Register Report using any API and push to staging tables from the external application. I have require… -
Readiness PDF linkContent Previous to 21A update, Readiness docs had both HTML and PDF links. But, now we have only the HTML link. The PDF was very useful for offline viewing. If feasible…
-
Budget balances not available in General Ledger subject areasSummary Can we query budget balances in General Ledger subject areas?Content Budget balances not available in General Ledger subject areas like 'General Ledger - Balance… -
Can Saved Custom Groups be used in Calculations/Formulas?Summary Using Custom Groups in Calculated ItemsContent In OTBI, I've designed an analysis where I've created custom groups of the Natural Account Segment Code using GL -… -
Fixed Asset Report- OTBISummary Fixed Asset Report- OTBIContent I created a Fixed Asset OTBI report. The report is working well only recently it starts dropping data. its only reflecting 25000 …
-
how i get discount rate in ar ar invoice ?Content in table ra_customer_trx_all i need to get discount rate . i tried but i can't get it , how i get it ?
-
Missing account coding data for Invoices in Workflow tables in PRODContent Hello, We have a custom BI report that tracks the Account coding details for AP Invoices. We are using the workflow tables to get these details. Per my understan… -
Page wise totalContent Hi, I have report which runs for multiple pages assume 20 lines in each page there is requirement to sum page wise total of the amount (which means sum of the am…
-
Finance Cross Validation RulesContent Other than the help guide are there any Best Practices for Cross-Validation Rules? Version 21A -
Internet Speed requirements for Oracle ERP/HCM Cloud for connectivity through cell phone network 4gSummary What is the minimum speed required to connect Oracle ERP/HCM Cloud using cell phone network 4g?Content With more people working remote or work from home because …
-
Ability to export configuration in readable format (like OC Autoconfigurator)Summary Users want to export setup data to check the configuration, but currently only zip package export are supported, and the data is not the same as what we view on …
-
Help with OTBI Filter ErrorSummary Error when filtering for a date rangeContent Hello, I am having 2 issues. 1. I am trying to create a filter using Invoice Date where report would show all invoic…
-
OTBI Drill down to External Cash Transaction - Blank transaction pageContent I cant get the drill down to External Cash Transactions to work in my OTBI Analysis. Everything seems to be fine and I am redirected as expected. The problem is …
-
Bursting A Report With SubTemplatesSummary How to burst a report using a sub template.Content Hi Experts, We have a custom report which uses a sub-template. The report also uses bursting to email. But the… -
OTBI report - Issue with Expense Transactions Real Time subject areaSummary OTBI report using this subject area no longer shows data from prior assignmentsContent We have an SR for this issue but I'm wondering if anyone else has noticed … -
ExternalReportWSSService sample payload to pass template nameSummary ExternalReportWSSService sample payload to pass template nameContent Hi, Can we pass report template name to ExternalReportWSSService SOAP service which triggers…
-
OTBI Analysis: Using TIMESTAMPADD to derive last day of the month based on Period Name in Subject ArContent Hello There, I have an OTBI analysis for Subject Area: "General Ledger - Balances Real Time". The analysis has a column "Time"."Accounting Period Name" OR "Time"…
-
OTBI Report for element entriesContent Hello Guys, I need to create an OTBI report for element entries, but when i try to creare the analysis the system show me the following error: No Results The spe… -
Report results pull in journals 1 hour prior to parametersSummary User selects date greater than 3/10/2021 at 12PM, yet the report results is pulling in journals with a timestamp 1 hour prior to set parameterContent User select…
-
Table to get BI Report Template and Data Model DetailsSummary Table to get BI Report Template and Data Model DetailsContent Hello, In EBS, we had XDO tables which stored BI Report and Data Definition details. Do we have any…
-
How to use Flexfield feature at BIP data model?Content Hi, Are there any document about BIP data model flexfield feature? I hope the feature make me easy to query AFF info when I create custome BIP report. Thanks
-
Change ESS Job Description while submitting it from BIPSummary Change ESS Job Description while submitting it from BIPContent In Cloud, we can submit the ESS Job from BIP using "ESS_RUNTIME.set_submit_args" procedure. Is the…