Sample Reports
Discussion List
-
How to remove html tags from report outputContent Hi team, We built some Analysis based on Sourcing related subject area's Where we see some html texts in the resulting columns like below. How remove these sufix…Nishanth B Jain 137 views 5 comments 0 points Most recent by Anandakrishna Thamballa Reporting and Analytics for ERP -
How to register ESS Jobs in R13 20B?Summary How to register ESS Jobs in R13 20B?Content Hi Everyone, Can you please share your thoughts on How to register ESS Jobs in R13 20B? Thanks, -
Distribution Email List for ESS JobsSummary Distribution Email List for ESS JobsContent Hi Everyone, Can you please share your thought on , how to setup distribution Email List for ESS Jobs? Thanks,
-
Drill Down in OTBI for code combination balance to journal linesSummary Drill Down in OTBI for code combination balance to journal linesContent Use case: We need to build a report listing all the account code combination balances and…Sumanth Kunimakki-21932 63 views 3 comments 1 point Most recent by Arun Raj Reporting and Analytics for ERP -
BI Publisher- Watermark with rtf template (should be visible with table) and excel templateContent Hi All, I need your help. I am trying to implement watermark with rtf and excel template. With rtf, I am able to see watermark only on the last page, where data …
-
BI Query to get Difference between Dates in numeric formatSummary We have requirement to get the Average time required to complete particular ESS Job in Minutes or Seconds.Content Here are more details - We need to calculate th…
-
Need Sample KPI and KPI WatchlistsSummary Need Sample KPI and KPI WatchlistsContent Hi All, We need sample KPI and KPI Watchlists created for ERP modules. Thanks in advance. Regards Siva. Version 20ASiva Kumar-Oracle 64 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Modifying Configurable Expense Report TemplateSummary Access in current user detailsContent Hi,We want to access current logged in user details in configurable expense report template,1. Is it similar to how do it i…Mohak Kirtane 41 views 0 comments 0 points Most recent by Mohak Kirtane Reporting and Analytics for ERP
-
jai_tax_lines_all & jai_tax_types tables in oracle fusionSummary jai_tax_lines_all & jai_tax_types 2 tables which are in r12. Please send relevant tables for these.Content jai_tax_lines_all & jai_tax_types 2 tables which are i…Nageshwaran1 968 views 3 comments 0 points Most recent by Nageshwaran1 Reporting and Analytics for ERP -
How to add one day to the PaymentDate in XSL Template?Summary Need to add one day to the PaymentDateContent I am trying to customize XSL Stylesheet (HTML/XML/Text) tempalte, My requirement is add one day to the payment date…OraFusionworld 57 views 0 comments 2 points Most recent by OraFusionworld Reporting and Analytics for ERP
-
How to send BIP output to SFTP in Zip formetSummary How to send BIP output to SFTP in Zip formetContent Hi Team, We have a requirement to Send the BIP report output in ZIP to SFTP. is there any way to achive this?…ArunKumarDammalli 70 views 1 comment 3 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP
-
Export FRS reports as *.DES extension fileSummary Export FRS reports in 19D as *.DES extension fileContent Hi, Does anyone know how to export FRS reports as *.DES extension file ? Thnx Version R13 - 19D updatesAli Morsy-Oracle 142 views 1 comment 0 points Most recent by Hamish Vickers Reporting and Analytics for ERP
-
Budgetary Control Analysis Report Sample - Projects High VolumeSummary This is a sample budgetary control analysis report for projects control budgets.Content This is a sample report that is a based upon the standard budgetary contr…Anne Wong -Oracle 297 views 6 comments 3 points Most recent by Anne Wong -Oracle Reporting and Analytics for ERP -
Drill down GL to subledgerSummary Drill down GL to subledgerContent Hi all, Is there any standard OTBI reports to drill from GL to subledger like AP and AR? or not possible customize is the work …User_2025-02-04-05-26-22-197 144 views 2 comments 0 points Most recent by User_2025-02-04-05-26-22-197 Reporting and Analytics for ERP -
How do i put in multiple columns in the x axis of a rtf chart?Summary X axis contains values coming from a column and rtf does not allow multiple entries into the x axis label.Sumanth Kunimakki-21932 34 views 0 comments 1 point Most recent by Sumanth Kunimakki-21932 Reporting and Analytics for ERP
-
Advanced CollectionsContent Hello All, Do we have any OTBI subject area which gives data related to Collections. Ex: Collector wise collections. Thanks, NishanthNishanth B Jain 121 views 7 comments 0 points Most recent by Veronica Dumitriu Reporting and Analytics for ERP
-
Period Name- In OTBI reportSummary Need perod name should populate like DEC-FY-20 (DDDFFYY)Content Hello Team, We want to have the Period name in our OTBI report in the format 'DEC-FY-20', 'SEP-FY…Saurabh Sharma_HCL 166 views 1 comment 0 points Most recent by ndryden Reporting and Analytics for ERP
-
Report that tracks receipted PO'sSummary Does anybody have a report that tracks receipted PO's?Content Hi all Just wondering with the accruals of receipted items each month, which reports are being run …Tony Roff 53 views 5 comments 0 points Most recent by User_2025-02-01-08-03-13-309 Reporting and Analytics for ERP
-
Instance details for BI Publisher Report Template - Fusion ERP/SCMSummary Water marking Instance details on BI Publisher Report and EmailingContent We have a requirement to display the Instance name as watermark in some of the BI Publi…Senthilrajan V 60 views 2 comments 0 points Most recent by Senthilrajan V Reporting and Analytics for ERP -
Daily Report that highlights supplier submitted invoicesContent Dear, Please can someone advise how to set up a report that can be scheduled daily to provide us with any new invoices that have been submitted by the supplier s…Tony Roff 37 views 4 comments 0 points Most recent by Koteswararao Yenikepalli Reporting and Analytics for ERP
-
Combing OTBI Output in one rowSummary Combing OTBI Output in one rowContent I'm using the subject area "Project Costing - Actual Real Time" to result Debits and Credits of Project Cost Expenditure Li…User_2025-02-05-23-22-49-102 108 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
R13 Avaliable Cloud Reports in ExcelSummary Avaliable Cloud Reports in ExcelContent Hello : I was wondering if you can share with me the avaliable Cloud Reports in Excel. Thanks for your help Best Regardsgabriel kinovisques-163562 63 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Receipting ReportsContent Hi Is there a report that tracks PO's and the receipted amount? thanks Tony Version 19CTony Roff 47 views 1 comment 1 point Most recent by User_2025-02-06-00-59-55-679 Reporting and Analytics for ERP
-
Reports with hardcoded parameters performing better then those with bind variablesContent Hello, We have a peculiar problem, we have a query for gl balances report which when run by hardcoding the Legal entity and period runs fine fetching all our dat…
-
Policy Predicate ErrorSummary When querying some tables and views we are getting Policy Predicate ErrorContent Selecting data from per_person_names_f or hz_parties is giving a policy predicat…User_2025-02-05-18-28-58-388 27 views 12 comments 1 point Most recent by Nathan CCC Reporting and Analytics for ERP
-
OBIEE 12c / Financial Reporting Studio usage with Oracle Fusion Financial CloudSummary Financial Reporting Studio for Customized Reporting needContent Hi, With earlier releases of on premise ERP products from Oracle we used OBIA for any seeded / cu…User_2025-01-29-01-36-29-977 135 views 4 comments 1 point Most recent by Andrew_Schmitz Reporting and Analytics for ERP
-
Expenses Overview Real Time subject areaSummary A summarization program needs to be run to gather information before data is available in this area.Content We are creating some test reports from the Expenses O… -
Error while customizing BI Publisher ReportSummary We are trying to customize the Account Analysis Report (ESS Job Name - Account Analysis Report) but getting error while trying to modify the data modelContent Hi…Sudha KOVURU 91 views 10 comments 0 points Most recent by Sudha KOVURU Reporting and Analytics for ERP -
Can we find all scheduled BI Reports instead of navigating to each reportSummary Can we find all scheduled BI Reports instead of navigating to each reportContent I was trying to find if we can find all scheduled BI Reports instead of navigati…User_2025-02-01-07-43-15-700 61 views 3 comments 1 point Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP
-
XML Structure of BIP reportContent Hi, I need to create a BIP report which is extracted as an XML. Below is the sample xml structure and sample XSD. How do I define an attribute of an element whil…User_2025-02-05-07-46-04-895 110 views 3 comments 2 points Most recent by Rasu P Reporting and Analytics for ERP