Reports
Discussion List
-
How to filter and sum positive or negative value only in FRS reportSummary: To see if FRS report could filter value of positive or negative and do summation against it. Content (required): We would like to know is there a way to filter …Chow Ka Ming Jason-Oracle 81 views 1 comment 0 points Most recent by Janitha Perera Reporting and Analytics for ERP -
BIP report historySummary: I have a requirement to pull the BI reports from Report history for failed runs. Do we have any table to pull the BIP report data based on date range. Content (…
-
RTF template to xls report with blank rows due to conditional regionHi All I created a rtf template which need to output as a xls file. After it generated, it shows some blank rows due to the conditional region in ref template. xls outpu…
-
DTD and Index file for Germany tax reportingWe have a Legal Entities registered in Germany and we have to submit data to German tax authority. For this, I have followed the note id Oracle Fusion Cloud ERP: Germany…
-
SQL-How I get all the children/parent of account in GL ?Summary: SQL-How I get all the children/parent of account in GL ? Content (please ensure you mask any confidential information): Hello I am looking for a custom report t…Cesar Saveedra 22 views 1 comment 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP
-
Fixed Asset ReportingSummary Reporting from Fixed Asset Sub-LedgerContent Hello - I'm looking for the following information in a report from the Fixed Asset sub-ledger. I am looking for a re…User_2025-01-29-20-33-47-986 161 views 6 comments 1 point Most recent by Tim Sweeney-279789 Reporting and Analytics for ERP -
Schedule in Analytics is Greyed-OutSummary: The Schedule button is Greyed-out Content (please ensure you mask any confidential information): Please help! Version (include the version you are using, if app…Dorren Veil Laniog 136 views 2 comments 0 points Most recent by Dorren Veil Laniog Reporting and Analytics for ERP -
Source Code for the Fusion Audit Reports which will be access via Tools > Audit ReportsSummary Source Code for the Fusion Audit Reports which will be access via Tools > Audit ReportsContent Hello Team, I am looking for the source code or Data base tables w…SandeepPaspunuri 95 views 4 comments 0 points Most recent by Murthym123 Reporting and Analytics for ERP -
How to create an OTBI Report to display GL Parent/Child values ?Summary: How to create an OTBI Report to display GL Parent/Child values ? Content (please ensure you mask any confidential information): Hello I would like to have a Cha…Cesar Saveedra 259 views 2 comments 0 points Most recent by Cesar Saveedra Reporting and Analytics for ERP
-
can we pull historical details of CANCELLED ESS jobs from back-end?Problem Description --------------------------------------------------- AUDIT CONCERN: can we pull historical details of CANCELLED ESS jobs from back-end? During an audi…Janardhan ACS-Oracle 34 views 1 comment 1 point Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
How to link between General Ledger, Subledger and Receivables tables in BI PublisherSummary: I'm trying to add information from the Receivables tables to a General Ledger query on income when a transaction has come from the receivables ledger. But I am …
-
query for rejected invoices and rejector commentSummary: We're looking for a query that will show rejected invoices and the reason they were rejected as well as the cost center and creator. Content (please ensure you … -
Can we call OTBI/Analytics dashboard using SOAP/REST webservices in oracle fusion?Hi , We have a requirement to run/submit the analytics/OTBI dashboard using rest/soap webservices. Please share your inputs. Appreciate your help. Thanks in advance.Bhavani Rikkula 302 views 2 comments 0 points Most recent by Bhavani Rikkula Reporting and Analytics for ERP
-
DFF Value (Change/Update) reflection in OTBI Subject AreaSummary I have a DFF with current value as A and OTBI shows that DFF value as A... Now I change the DFF field value to B Does the Value B automatically gets reflected in…UjasB 319 views 11 comments 0 points Most recent by alexey.shtrakhov Reporting and Analytics for ERP
-
Receivables OTBI report: Line level transaction report with payment informationSummary: I have created an OTBI report to show line level detail of AR transactions using the Receivables- Transactions Real Time subject area. I am looking for a second…Emily McAdams 170 views 3 comments 1 point Most recent by Nathan CCC Reporting and Analytics for ERP -
Is there any termination date set for the Audit report ( or can it be set)?Summary: I was wondering if the audit trail captured in the audit report remains infinitely in the system or does it gets purged/terminated. Content (please ensure you m…Shreshtha Kesarwani 21 views 1 comment 1 point Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
Missing Access for a COA segment in a FRS report for a particular userSummary: Business user is missing access to Geography segment values (in parameter) in all the financial reports. Only able to see three values in the parameter. Content…Akash Verma 54 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany -
Do we have report which gives user is present in which approval workflowsSummary: We are searching for report which we can run by user name and the report should gives us details in which workflow approval user is present. Eg: PO , Req, Invoi…Nidhi Chhajed 51 views 5 comments 0 points Most recent by Razvan Paduraru-Oracle Reporting and Analytics for ERP
-
Is it possible to extract a single audit report for all the audit enabled products and objects?Summary: Is it possible to extract a single audit report for all the audit-enabled products and objects using the audit policy capabilities of Oracle Fusion? Content (pl…Shreshtha Kesarwani 61 views 1 comment 1 point Most recent by Mihaela Cozma GL-Oracle Reporting and Analytics for ERP
-
Is there a way to hide a specific hierarchy from being available to users when they run FRS reports?Summary: Is there a way to hide a specific hierarchy from being available to users when they run FRS reports? Content (please ensure you mask any confidential informatio…
-
How to add Reports to Task Menu (Reports and Analytics) in UI?Summary How to add Reports to Task Menu (Reports and Analytics) in UI?Content Hi How to add Reports to Task Menu (Reports and Analytics) in UI? We have requirement like … -
How does SQL Pruning in the data model affects the report performance?Hello, We have a customized version of the AP Aging report. The report performance is slow compared to the standard one. To improve the performance we did some adjustmen…Kristelle 51 views 1 comment 1 point Most recent by Razvan Paduraru-Oracle Reporting and Analytics for ERP
-
What happens if a report is scheduled by a user and, the user is inactivated in futureSummary: What happens if a report is scheduled by a user and later once the schedule is active, the user is inactivated. Also, how can a new user take control of the sch…Abhilash K - Deloitte USI 43 views 3 comments 1 point Most recent by Lee Eslick-Huff Reporting and Analytics for ERP -
Where can we see warnings after FBDI import of customersSummary: Where can we see warnings after FBDI import of customers Content (required): Where can we see warnings after FBDI import of customers. I cannot find them in the…Lucky Sharma 349 views 10 comments 0 points Most recent by GiuliaC-Oracle Reporting and Analytics for ERP -
OTBI - Can we have one line per transaction with tax amount?Summary: We are looking to have only 1 line per transaction and when I add tax amount it splits the report to multiple lines per transaction. Is there a way around this?…Rahul Kumar Gupta.-Oracle 21 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Can Oracle ERP Cloud BIP pulling data from external database to build report?Summary: Can Oracle ERP Cloud BIP pulling data from external database to build report? Content (required): Version (include the version you are using, if applicable): Co…User_2025-02-10-23-40-15-146 22 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Security feature for AR invoice print options available in view image button of transactionsSummary: Is any security feature for AR invoice print options available in the view image button of transactions Content (required): Users are saving(save as pdf method)…Siva Gollapalle 104 views 5 comments 0 points Most recent by Nikki K Reporting and Analytics for ERP
-
Is there any formula to calculate the number of days in a financial year in FRS?Summary: We have a requirement where we need to apply a formula as [(Row 1)+(Row2)]/Number of days in a FY, so for that we need to automatically get no.of days calculate…Srishti Kedia-Oracle 81 views 2 comments 1 point Most recent by CathyK Reporting and Analytics for ERP -
Requisition Approval E-Mail Report Template changes is not getting reflected in output fileI have customized the seeded report named "Requisition Approval E-Mail Report" but the changes is not getting reflected in the notification. It is taking the last update…Deepa Kumari 45 views 3 comments 0 points Most recent by Deepa Kumari Reporting and Analytics for ERP