Reports
Discussion List
-
ERP FDI - Report to identify potential duplicate payments in APThe customer is currently using ERP FDI Live and wants to implement a report to identify potential duplicate payments in AP. They have already searched in the list of Pr…Mauro Roberto Rodrigues-Oracle 42 views 3 comments 0 points Most recent by Mauro Roberto Rodrigues-Oracle Payables, Payments & Cash Management -
Query to find instance refresh /clone date in FusionContent Hi All, Like we used to have below query in EBS to get instance clone date , what table is used in fusion. SELECT resetlogs_time FROM v$database; Any help is rea…Nidhi Chhajed 3K views 8 comments 0 points Most recent by Bhanuchander Manthri Reporting and Analytics for ERP -
How to group by formatted date column AnalysisSummary: Hi, we create analysis to count PO created yearly, so create Analysis include bill-to-location, creation date columns ,we want to group by bill-to-location, cre…
-
Include Dynamic dates in File Name for Scheduled Custom ReportSummary: We are scheduling a weekly custom report to run each Tues night for the previous weeks' data (ie. Jun-17 thru Jun-25) Is it possible to include the date paramet…
-
ESS Jobs DashboardSummary: ESS Jobs Dashboard Content (please ensure you mask any confidential information): Hi Team, Greetings! As you know -we submit/schedule multiple ESS jobs. Is ther…Parag Hiremath 301 views 5 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Who printed this report?Summary How do I find out who printed a report?Content A "General Ledger Account Details Report" printed on our check-printing printer, but no-one in the office admits t…User_2025-01-31-00-03-48-847 60 views 9 comments 0 points Most recent by RanaMK-Oracle Reporting and Analytics for ERP -
How to show 0 value instead of null value in a calculated formula column in OTBI report?Summary: How to show zero value instead of null value in a calculated formula column in OTBI report Content (required): I have a column 'Variance' which has value that i…Abhishek Shukla 1.1K views 6 comments 0 points Most recent by Pooja_hb-Oracle Reporting and Analytics for ERP -
How to translate Amount in Words from English to Arabic language in rtf templateSummary: we have a requirement to print Payment amount in Words (English) to Arabic language in check template. The expectation is that, translate below given English te…SireeshaJaladi 497 views 9 comments 0 points Most recent by ArjunReddy88 Reporting and Analytics for ERP
-
previous parameter coming in the View attribute column of the next parameterSummary: Previous parameter names come in the View attribute column of the next parameter , Attached screen shot shows the issue Content (pl ease ensure you mask any con…Jude Franco 42 views 1 comment 1 point Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
RTFtemplate sorting data is there any limitWe want to sort the data in alphabetical order for “Payment Process request status report”. This is the seeded report provided by oracle when PPR is ran. Seeded report i…SivaRamaKrishna-Oracle 11 views 1 comment 1 point Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Accounting Period is coming null in General Journal ReportSummary: Accounting Period is coming null in General Journal Report Content (please ensure you mask any confidential information): No Version (include the version you ar…User_OFP2B 2 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
How to get deep link in Excel Template on a particular field in BI ReportWe are trying to get a deep link as a hyper link on a particular column in Excel Template in oracle fusionLakshmiVanarasi 118 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
Error when generating report, unsupported output format XLSXWe've received an error on one of our reports. Error message is the following: "Output failed. [INSTANCE_ID=bip.bi_serverHA] [OUTPUT_ID=158261] oracle.xdo.servlet.data.D…Francisco Carrillo-Robles 206 views 3 comments 0 points Most recent by Ajay Sharma Reporting and Analytics for ERP
-
how to exclude our custom application data from being picked by Account Analysis Report?Summary: Recently We has implemented a custom application. Data for this custom application flows through accounting hub. The data volume is huge (millions of data each …
-
Report data size exceeds the maximum limit (524288000 bytes). Stopped processing.Summary: We were given a SQL query to pull journal entries for our auditors and it worked successfully for FY22. We tried to run the report again for 2023 and received t…hannah_barry 6.4K views 7 comments 0 points Most recent by Shankar-Oracle Reporting and Analytics for ERP
-
Is it possible to develop BI report to fetch data from VBCS pageSummary: Is it possible to develop BI report to fetch data from VBCS page Content (please ensure you mask any confidential information): Hi All, Is it possible to develo…
-
How to call an OIC integration from BIP reportSummary: I have created an app driven integration with two request parameter. How can I submit the integration from BIP report? Content (required): I got a blog https://…Ananya Sadhukhan 4.7K views 19 comments 0 points Most recent by Adi Salomons Oracle-Oracle Reporting and Analytics for ERP
-
Fusion to SFTP - File got corruptedSummary: By bursting query we are transferring a fusion report to SOA SFTP. But in SOA SFTP the files seems to have missing lines. i.ie., Fusion report has 18k lines in … -
Query to fetch project and Time card entries(OTL)Summary: Hi Team, We need a table where the project number and time card entires details or SQL query Content (please ensure you mask any confidential information): We n…
-
Emailing an OTBI Analyses does not send data for prompt selectedSummary: OTBI Prompt data selected does not match data when emailed. Detailed overview: I have a prompt built into an Analyses report, that enables a manager to select t… -
How to get green check mark and Time along with Digital Signature in Oracle BIPI have a requirement to print the Digital Signature with Green Check mark and Time using RTF Template in BI Publisher(Sample Attached). Let me know how can we achieve th…
-
Need PVO details for PER_USER and PER_USER_HISTORY?Summary: I am looking BICC Tag for PER_USER, PER_USER_HISTORY I've found "HcmTopModelAnalyticsGlobalAM.UserAM.UserPVO" this PVO has history id so I assume this is for PE…RameshBabuJambula 37 views 3 comments 1 point Most recent by RameshBabuJambula Reporting and Analytics for ERP
-
Prompts not in reportSummary: When editing a migrated report I am unable to see the Prompt function for specific dimensions. Content (please ensure you mask any confidential information): Ve…Brooke Deacon 21 views 1 comment 0 points Most recent by Dave Roberts_-Oracle EPM Platform and Freeform
-
How to change the output format of the JAVA type ESS Job from .csv to .xmlI have a ESS Job of JAVA Type in Oracle Fusion having output in .csv format, User want the .xml format anyone have any idea how could I change the format?Damoder Chitti 13 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
How to print previous period in smart view reportsHello All, I need to print the account value for current period and previous period. In FRS we have the relative period function that helps us print the pervious period.…ShitalRamteke 2 views 1 comment 1 point Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Is it possible to audit invoice notes entered by accounts payable users?Summary: I am going through the Payables audit policies to determine if I can enable tracking of any invoice note edits or deletions. I'm not sure if the best approach i…Luis Orihuela 12 views 3 comments 0 points Most recent by Luis Orihuela Reporting and Analytics for ERP
-
Is there a way to limit what tables a user can query in OTBI?We have a support team that's requesting access to write Data Model queries in OTBI. Our concern is restricting them to only the financial tables. Does anyone know if th… -
Is it true that oracle is planning to deprecate webservice datasets from BI Data Model?Is it true that oracle is planning to deprecate webservice datasets from BI Data Model? and if its true, what are all the dataset types that will be retained in the futu…Abhilash K - Deloitte USI 21 views 2 comments 1 point Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
BI Reporting restricting by segment value depending on UserSummary: I am looking for a way of resticting a BI report by a segment value depending on the user accessing the reports. Ideally by assigning a segment to a user withn …JHould 15 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
I need to get OTBI Report Link with parameter like BIP ReportSummary: Hi Team I am looking for deep link or OTBI report link so that I can hit the URL directly by passing parameters. We have this feature in BIP to get the link , b…sailesh_cloudare 1 view 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP