BI Publisher
Discussion List
-
Need Outstanding Purchase Order Details Report in oracle fusion R13Summary Need Outstanding Purchase Order Details Report in oracle fusion R13Content Hello All Is there any report in oracle fusion r13 to display outstanding purchase ord… -
PO Encumbrance Journal DetailsSummary PO Encumbrance Journal DetailsContent Hello All I need script to extract PO encumbrance and related journal line details in oracle fusion. Required Columns in qu…
-
Group AssetSummary Report Is nullSummary Group Assets Summary Report is not workContent Dear's i run Group Assets Summary Reports ,no result and i check data model i found attached error messageMahgoub S.Mohamed 10 views 1 comment 0 points Most recent by Chandra Yerra Reporting and Analytics for ERP -
Seeking Assistance Querying for Basic Transactional MetricsSummary How to get counts of journal lines, invoices, and payments per month?Content I'm hoping someone can give me a head start on how to query for the following transa… -
New OTBI Help Landing PageSummary Introducing a brand-new OTBI Help Landing PageContent This e-mail is sent by Oracle OTBI product management. Starting with Release 13.18.10, a brand-new OTBI Hel…User720640-Oracle 65 views 0 comments 6 points Started by User720640-Oracle Reporting and Analytics for ERP -
Transaction time in the report and in Payables Application are differentSummary Transaction time in the report and in Payables Application are differentContent Hi all, Developed a report using Payables -transactions real time subject area.In…Dev Thota 36 views 4 comments 0 points Most recent by Manish Pesswani Reporting and Analytics for ERP -
System Accounts from per_usersSummary How to identify system accounts like FUSION_APPS_SEARCH_APPID from per_usersContent Hi Is there a way to query and get a list of system accounts like FUSION_APPS…Manish Mohan-96908 24 views 0 comments 0 points Started by Manish Mohan-96908 Reporting and Analytics for ERP
-
Number of Values to Display in List on ParamtersSummary How to increase number of values range greater then its highest limit 999Content We have a custom report where we we want to find input values greater then 1000 …Bilal Ahmed 23 views 2 comments 0 points Most recent by Nishanth B Jain Reporting and Analytics for ERP
-
Applying data restrictions for custom reportsContent Hello, We need to create some custom reports applying data restrictions. We got know that secured list views are not available for the ERP reports. Is there a wa…Ayesha Thilakarathna-51043 37 views 2 comments 0 points Most recent by Chandra Yerra Reporting and Analytics for ERP -
BI Publisher Best PracticesSummary Looking for a document that contains Best Practices in deploying BI Publisher ReportsContent Hi All, we have created a scheduled BI Publisher Report in our Test …Juan Miguel Isip-94819 70 views 3 comments 0 points Most recent by Juan Miguel Isip-94819 Reporting and Analytics for ERP -
user role security context security context value reportSummary user role security context security context value reportContent Is there a report where we can retrieve all values as shown in screen shot below?Sachin Mistry, CFA, PMP 92 views 1 comment 1 point Most recent by Manjunath Rallabandi Reporting and Analytics for ERP
-
Need customer master BI reprot query in oracle fusionContent I have a requirement to build custom BI report to display Customer Accounts, Account Site Addresses, and Contacts. Can you please share the query if you have. Th…Lak-126865 55 views 5 comments 0 points Most recent by ashtrakhov-Oracle Reporting and Analytics for ERP
-
Reporting on payment preference dataSummary Reporting on 'Receipt of Payment Notification Preferences' in ReceivablesContent I need to create a new report which pulls data from Manage Customers > Site > Pa… -
Image is blown up when Report is shown via EmailSummary We modified a Layout to add our Organization Logo, however, when its delivered via Email, the image blows up and is too bigContent Hi, we're trying to modify our…Juan Miguel Isip-94819 23 views 1 comment 0 points Most recent by Juan Miguel Isip-94819 Reporting and Analytics for ERP
-
Report Job Hoistory Table nameContent Hi Team, Could you please let me know, whether BI Report job history stores in any table, if so,could you please let me know the table name. Thanks. Uva Version …Uvaraja-Oracle 48 views 4 comments 0 points Most recent by Uvaraja-Oracle Reporting and Analytics for ERP
-
How to Link Purchase Order Invoices back to Project Costs?Content Hi All We're working on a Project Statement report that brings back a comprehensive breakdown of the project costs and revenue. For the costs, we were able to br…Aaron Leggett 47 views 1 comment 0 points Most recent by User10772173-Oracle Reporting and Analytics for ERP -
ESS Job Parameter Conditionally RequiredSummary Conditional ParameterContent Good People, Can we make the ESS Job parameter conditionally required ? e.g. I have 2 parameters say parameter P1 & P2 , can I make …Soumya Prakash Parhi 35 views 0 comments 1 point Started by Soumya Prakash Parhi Reporting and Analytics for ERP -
BI Publisher connecting bank account to receiptSummary Need advice on creating a data model for a BI Publisher report on AR receiptsContent I need to create a new BI Publisher data model which returns the bank accoun…
-
Trial Balance report ends in error and no report is generatedSummary Trial Balance report ends in error and no report is generatedContent Hi All We regularly run the Trial Balance report for the entire financial year from schedule… -
Report Job History is blank for BI ReportSummary Report Job History is blank for BI ReportContent Hi All, We have created a simple BI Report with one data model. When users are running this report, the activity…
-
BPA ApprovalSummary BPA Approval Email notification report issueContent Hi, I was trying to customize the BPA approval email notification seeded template(from Purchase Document E-Ma…Nishanth B Jain 37 views 4 comments 0 points Most recent by Nishanth B Jain Reporting and Analytics for ERP -
Date Incorrect in Report OutputSummary I can't get the date to be correct in the Excel outputContent I have a report that is pulling from the AP tables. The date fields are set to True for Ignore User…Jason Christiansen 34 views 0 comments 0 points Started by Jason Christiansen Reporting and Analytics for ERP
-
Issue with month format to create Trend Analysis Report for Data ProgressionSummary Issue with month format to create Trend Analysis Report for Data ProgressionContent Hi All, We would like to create a dashboard to show data volume progression b…
-
How to set Default Rows Displayed In Download in OTBI reportContent I need to set DefaultRowsDisplayedInDownload as " 65000" for my OTBI report. Is there a way to do it ? Already referred some oracle docs but I could not able to …Ayesha Thilakarathna-51043 39 views 5 comments 0 points Most recent by Ayesha Thilakarathna-51043 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…Jacqueline Fournier 132 views 5 comments 1 point Most recent by Xavier Cuinier Reporting and Analytics for ERP
-
R11 ERP OTBI Subject Area Mapping to Fusion Database TablesSummary Release 11 ERP OTBI subject area database table mapping spreadsheetContent This spreadsheet is published by Oracle OTBI Development. This spreadsheet documents F…User720640-Oracle 402 views 14 comments 9 points Most recent by Koteswararao Yenikepalli Reporting and Analytics for ERP
-
Issues with display in BIP reportSummary Issues with display in BIP reportContent Hi, I created a simple BIP report to retrieve two columns Requisition # and Requisition description. The description is …Bala Ch 24 views 1 comment 0 points Most recent by Nikhil Nelluri-71478 Reporting and Analytics for ERP
-
Reports Generated from Schedule Processes to be mapped to spring boardSummary Reports Generated from Schedule Processes to be mapped to spring board e.g. GL Accounts AnalysisContent Hi All, Is there a possibility to map reports generated v…Achala Munasinghe 50 views 3 comments 0 points Most recent by User_AEMC1 Reporting and Analytics for ERP -
Add OTBI reports to Scheduled ProcessesSummary How to add OTBI reports to Scheduled ProcessesContent Hi, Can we add OTBI reports to Scheduled Processes rather than access them in Reports and Analytics?Lakmal 104 views 7 comments 1 point Most recent by Achala Munasinghe Reporting and Analytics for ERP -
Custom Data Model - Remittance Advice - Change From Check to Wire Payments?Summary Custom report using SQL data model - How to change from check payments to wire payments?Content We have a custom report for AMEX remittance advice which gives us…