Sample Reports
Discussion List
-
Nees SQL query to get the transaction status of Intercompany transactionsHi team, I'm creating a BIP report to extract intercompany transactions and related details. I need to join 'AP_INVOICES_ALL' or 'XLA_AE_LINES' table to 'FUN_TRX_HEADERS…Tharushi Sathsarani 504 views 2 comments 0 points Most recent by Lakshmi Alagappan-Oracle Reporting and Analytics for ERP -
Best approach to create a report templateHi everyone, I’m seeking advice on the best approach to create a report template with the following requirements (Bi Pulisher report): Year-to-Date (YTD) totals Subtotal…Omran Zeaiter 21 views 2 comments 1 point Most recent by Lucky Sharma Reporting and Analytics for ERP
-
Is there a Workforce Management - Position Event Real Time Subject Area?Summary: There is currently a Subject Area for Workforce Management - Position Real Time selectable when creating an Analysis in OTBI. This Subject Area shows the max ef…Gloria Brewster 37 views 4 comments 2 points Most recent by Gloria Brewster Reporting and Analytics for ERP -
Create List of Values for Dependent Segments in GL Custom BI Publisher Reports White PaperSummary: Your finance staff may modify standard GL BI Publisher (BIP) reports to address specific business requirements. They may need to run a GL BIP report by various …Helle Hennings-Oracle 553 views 12 comments 14 points Most recent by Jose Carlos Amaral Flinco Financial Management Resource Center -
Account Analysis for Contra Account Standard Report - CustomizationHi , I have copy this standad report to my custom location . Now i want to add two more columns in this report. 1- Transaction Number ( Which is comming from subledger i…Jasir133341 133 views 2 comments 0 points Most recent by Nasir Iqbal Reporting and Analytics for ERP
-
Open Purchase Orders & Goods Received Not Invoiced reportsSummary Various OTBI reports showing Open Purchase Orders & Goods Received Not InvoicedContent Import the attached catalog files into your environment using the "Unarchi…Andy Gough 2.3K views 19 comments 14 points Most recent by Khalid Mahmood Reporting and Analytics for ERP -
Dunning Letter Format in Peppel 3.0 FormatHi, We have new requirement for our client need to send Dunning Letters in Peppel 3.0 Format. Can you please let us know do we have Oracle standard functionality dunning…Koteshwar Tippani 82 views 1 comment 0 points Most recent by Daniel S.-Oracle Receivables & Collections -
How to configure an additional Input parameter in Account Analysis Report XLAAARPTHello, We have a requirement to add additional department type Input parameter as a filter in BI Account Analysis Report XLAAARPT. This report is being run through the E…
-
AR_STATEMENT_HEADERS and AR_STATEMENT_LINE_CLUSTERS are interiam tablesSummary: AR_STATEMENT_HEADERS and AR_STATEMENT_LINE_CLUSTERS are interiam tables. Content (please ensure you mask any confidential information): We are looking actual ba…
-
Need Outstanding Check Report in Oracle fusionSummary: Hello, We are looking for a report that shows payments that were issued but have not cleared the bank account yet. Is there any report already available in Orac…Sushmitha G 233 views 2 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP
-
Query or the table that contains columns of the Account Analysis ReportSummary: Content (required): Hello everyone, I have a requirement to make a custom report for the Account Analysis Report. I need to pick some of the columns in the seed… -
Audit Report for Oracle backup Log in Oracle fusionSummary: Hello, We are looking for report where the Oracle system backs up all data, libraries, applications, and user profiles daily/on a regular basis. Is there any re…
-
How to create a new KPISummary: How to create a new KPI Content (please ensure you mask any confidential information): Hi Team, How to create a new KPI reports for Finance? Could anyone guide …Venkatesan 1 view 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Different Checklist IDSummary: Checklist_ID is always equals to Task_ID for the task associated with the particular checklist. do there is some cases where it can be different, please help. C…Yashpal_Mahto 11 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Allocation percentage for resources in the projectSummary: Hi everyone, We're looking to gather details on project resources, specifically allocation percentages. It's important that these resources are currently assign…
-
Custom Folder is unavailable to all the UsersSummary: Our users are not able to see the Custom Folder under Shared Folders All our reports are in the Custom folder. Possibly -mistakenly the permission of the folder…
-
The search is not working in the drop down menu in Data set BU publisher reportI have this parameter that is related to a list of value that give all the contract number. the query i am using for the list of value is: select DISTINCT TV.CONTRACT_NU…Omran Zeaiter 52 views 1 comment 0 points Most recent by Andreea Versanu-Oracle Reporting and Analytics for ERP
-
can we fetch report for how many times a report runHi Everyone, we have a requirement to fetch the all custom reports in the fusion, along with their information of how many times that report run in 2024 and what is the …
-
How to print a barcode in BIP report?Summary How to print a barcode in BIP report?Content How to print a barcode in BIP report? Version 19D -
Not able to rename or delete existing folder in BI catalogSummary: Content (please ensure you mask any confidential information): Hello All, Hope you are having a great day. We are facing an issue while renaming a folder in BI …Lucky Sharma 33 views 5 comments 0 points Most recent by Lucky Sharma Reporting and Analytics for ERP -
Is there a way to modify the Online report submission console while executing a BIP report online?Is there a way to modify the Online report submission console while executing a BIP report online. Our customer has about 28+ parameters and the requirement is to always…Aparna N-Oracle 11 views 3 comments 0 points Most recent by Aparna N-Oracle Reporting and Analytics for ERP
-
Rounding in RTF Template FormulaDear All, I am attempting to round the total of X/Y numbers in a sum, but it's not working using the RTF template. This is my formula: I need to round this equation (cu…George Mattar 81 views 2 comments 0 points Most recent by George Mattar Reporting and Analytics for ERP
-
How to Find an IP Address of a User who has Logged in Fusion Application ?Summary: How to Find an IP Address of a User who has Logged in Fusion Application ? Content (please ensure you mask any confidential information): Hello, I have a requir…Cesar Saveedra 428 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
Unable to find custom ESS job created in the scheduled job screenI have created ESS job but unable to find the same in scheduled job screen to run, I have ran "Import User and Role Application Security Data" and "Retrieve Latest LDAP …Thanigainathan R 564 views 4 comments 0 points Most recent by Vijaya Sekhar A-Oracle Reporting and Analytics for ERP
-
Is it possible to change the date to be used in aging transactions in the seeded AR Aging report?Summary: Is it possible to change the date to be used in aging transactions in the seeded AR Aging report? Content (please ensure you mask any confidential information):…Francine Gemora 81 views 6 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
Can we use Pivot dynamically in BIPSummary: Hi Experts , We are having a requirement to convert rows to columns dynamically we used pivot to achieve this but by using pivot we need to hardcode values whic…Bhavani Rikkula 113 views 10 comments 1 point Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
TIMEZONE Display on the report field - UTC Timezone to EST TimezoneSummary TIMEZONE Display on the report field - UTC Timezone to EST TimezoneContent Hi Experts, I am using the OTBI Analysis (Payables Transactions Real Time) to create a…
-
How to enable external directory in Oracle FRS schedulerSummary: How to enable external directory in Oracle FRS scheduler Content (required): We want to be able to send the output of FRS using a batch scheduler on an external…
-
How to write a condition in Delimiter etext templateSummary How to write a condition in Delimiter etext templateContent Hello All, We are creating an etext template for the wire payments(Seeded Disbursement Payment Report…Koteswararao Yenikepalli 96 views 3 comments 1 point Most recent by GAVMAX Reporting and Analytics for ERP -
Termination count is not showing correctly in OTBI reportSummary: Termination count is not showing correctly in OTBI report Content (please ensure you mask any confidential information): Hi All, We are developing a HR dashboar…Venkatesan 11 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP