Reports
Discussion List
-
Report Parameters in OTBI ReportsSummary I would like to be able to have the report parameters visible in OTBI reportsContent Hi Folks- Is there a way to have the report parameters included in OTBI repo…User_2025-01-30-21-33-20-426 154 views 7 comments 0 points Most recent by Neal Foley Reporting and Analytics for ERP -
HZ Classification ReferenceContent Hi Team, I'm looking for Classification Orginal System Referenc, If I join OWNER_TABLE_ID from HZ_CODE_ASSIGNMENTS and OWNER_TABLE_ID from HZ_ORIG_SYS_REFERENCES… -
Smartview and OTBISummary Smartview and OTBI not the sameContent When we run Smartview and OTBI reports simultaneously, many times they don’t balance. We are struggling to determine the c…Yasmin Kennedy 140 views 2 comments 1 point Most recent by Nathan CCC Reporting and Analytics for ERP -
Is there a way to pass parameters to an Infolet?Summary Need to convert a report that passes a parameter into an infolet so I can easily share it with many users that are not familiar with running BI Publisher reports…Fede SD 139 views 9 comments 0 points Most recent by User_2025-01-22-19-56-59-022 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 972 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 55 views 0 comments 2 points Most recent by OraFusionworld Reporting and Analytics for ERP
-
Limit IT support users to use OTBI within their folder onlySummary Limit IT support users to use OTBI within their folder onlyContent Hi all, is there any way to limit those IT support users to access his/her folder only? Not ab…User_2025-02-04-05-26-22-197 36 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP
-
Open Prepayment OTBI ReportSummary Open Prepayment OTBI Report with Validation status of Available that can be back dated to the prior month.Content I have an Open Prepayment report in OTBI from s…
-
Supplier address withholding tax tableSummary Supplier address withholding tax tableContent Hi, Which view contain the Withholding Tax Exemptions details and how to connect it with POZ_SUPPLIER_ADDRESS_V vie…Shlomo Elnekave 56 views 8 comments 0 points Most recent by Shlomo Elnekave Reporting and Analytics for ERP -
Table "ALL_TABLES" - does not include all tables?Content Hi, When I run a query in BI Publisher Enterprise, I can for example, get results from this query: SELECT DISTINCT UPPER(table_name), num_rowsFROM all_tablesWHER…
-
Check In / Check Out Functionality in BIP/OTBI?Summary We are looking for a function that allows code to be 'locked' if checked out by another user.Content Does anyone have ideas on how to 'check out' a data model or… -
What is the limitation for BIP output to SFTPSummary What is the limitation for BIP output to SFTPContent Hi Team, What is the file size limitation to send the BIP output file from BIP server to SFTP. Thanks in Adv…ArunKumarDammalli 160 views 1 comment 1 point Most recent by Médéric Chauvin 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
-
Calculation Between two Presentation Analysis ReportSummary Calculation Between two Presentation Analysis ReportContent Hello i have two analysis report in BI Publisher one for Revenue and other for Cost of good sold i ne…Mahgoub S.Mohamed 31 views 7 comments 0 points Most recent by Mahgoub S.Mohamed Reporting and Analytics for ERP -
Finance: Can we get Grand Totals from two separate groups in matrix reportSummary Finance: Can we get Grand Totals from two separate groups in matrix reportContent We have developed a custom report in two separate groups in matrix report. In f…Nalsoft Pvt Ltd 26 views 6 comments 0 points Most recent by Nalsoft Pvt Ltd Reporting and Analytics for ERP
-
Misaligned columns and lines in reportSummary When published in Excel, reports lines and columns are misalignedContent Hello everyone, Sorry if this topic was already created before (I didn't find it), but I…User_2025-03-28-01-07-13-341 43 views 8 comments 2 points Most recent by Rich Merkel Reporting and Analytics for ERP
-
Adding Project Classification (Class Code) to OTBI report duplicate Costs RowsSummary Adding Project Classification (Class Code) to OTBI report duplicate Costs RowsContent Adding Project Classification (Class Code) to OTBI report duplicate Costs R…User_2025-01-30-23-00-53-497 80 views 2 comments 1 point Most recent by User_2025-02-04-13-08-33-519 Reporting and Analytics for ERP
-
Subledger job inquiry for up to date reportingSummary Subledger job inquiry for up to date reportingContent We are just starting to develop reports in BI/OTBI Oracle Fusion as a newer client. We've previously only m…User_2025-02-04-18-03-15-131 39 views 3 comments 1 point Most recent by User_2025-02-04-18-03-15-131 Reporting and Analytics for ERP
-
Apply customer hierarchy to receivables subject areasSummary We are trying to build reports from the Receivables subject areas that can rollup values based on the CDM Customer HierarchyContent We have established hierarchi…User_2025-01-28-18-21-52-276 51 views 1 comment 0 points Most recent by Veronica Dumitriu Reporting and Analytics for ERP
-
Scheduling Cash to GL Recon BI Publisher ReportSummary Has anyone had any success with scheduling the Cash to GL Reconciliation BI Publisher Report?Content We have a request from business users to schedule this repor…
-
NEW Analytics for ERP - 20ASummary NEW Analytics for ERP - 20AContent Hi, We have now 20A, but Oracle new buit in Analytics for ERP is not available, any idea on ERP analytics. Regards,Farooq Syed, CPA, PMP, CISA 87 views 3 comments 0 points Most recent by Farooq Syed, CPA, PMP, CISA 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 140 views 1 comment 0 points Most recent by Hamish Vickers Reporting and Analytics for ERP
-
BIP Expense Report ApproverSummary Looking to find the appropriate SQL that will give me the approver name for Expense Reports using BI PublisherContent The goal of this report is to utilize burst…User_2025-02-04-18-47-46-124 95 views 3 comments 2 points Most recent by Andrew_Schmitz Reporting and Analytics for ERP
-
rtf template - summarize column within groupSummary rtf template - summarize column within groupContent Hi, I created simple table ( see attached files ) and i want the column values to be presented on one row. wh…Shlomo Elnekave 39 views 5 comments 0 points Most recent by Shlomo Elnekave Reporting and Analytics for ERP
-
Smart View handled an unknown exception thrown by Microsoft OfficeSummary Smart View error using ExcelContent Hi, I'm using Smart View version 11.1.2.5.910 with Microsoft Office Standard 2016, I'm constantly receiving this error "Smart…Patricia Gonzalez 146 views 1 comment 1 point Most recent by Gaurav Chaudhary-163150 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
-
Customized Trial Balance ReportSummary Users are unable to run Customized Trial Balance Report from Scheduled ProcessesContent We have customized the layout of the standard Trial Balance Report and ar…
-
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
-
report accounts payable with cut-off dateSummary A report of accounts payable with cut-off date is requiredContent Does anyone know if in OCF version 19D there is a report of accounts payable with cut-off date …