Reports
Discussion List
-
Custom BIP Report Dynamic Column IssuesSummary: The requirement is to print the output in below format: For each period, there should be a row and corresponding value in dynamically generated column. Ex.- For… -
BI Excel Template missing formula when data generatedSummary: I've created a BI Excel template based on a DM and the requirement is to have certain columns color coded in the end of the report and also have a formula field…KrishnakumarPathipati 31 views 5 comments 1 point Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP
-
retrieve latest entry from table OKC_K_HEADERS_TLSummary: I am trying to get only the entry that has the most recent creation date from this table. Content (please ensure you mask any confidential information): Creatio… -
Identifying Underlying Queries for SmartLOV/ VOs In BI PublisherSummary: Content (please ensure you mask any confidential information): Hi experts, Would any of you know how to identify the underlying query for a view object in BI Pu…
-
Adding a custom report to DOR screenSummary: Adding a custom report to DOR screen and need the report to fetch data related to current employee but the report fetches null. Content (please ensure you mask …Salma Mohamed Salem 11 views 0 comments 0 points Started by Salma Mohamed Salem Reporting and Analytics for ERP
-
Etext template output file(.txt) is unable to print Arabic language in sequenceSummary: We have custom Etext template under disbursement payment file formats. In that Supplier name is required to show in Arabic language in output file. for testing …SireeshaJaladi 41 views 2 comments 1 point Most recent by SireeshaJaladi Reporting and Analytics for ERP
-
Oracle EBS - invalid SessionSummary: Oracle EBS - invalid Session Content (please ensure you mask any confidential information): How can this be resolved fndgfm.jsp error : The current session is i…
-
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 21 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 163 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 134 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 231 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 33 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 286 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 307 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 161 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 52 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 41 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 41 views 3 comments 1 point Most recent by Lee Eslick-Huff Reporting and Analytics for ERP