BI Publisher
Discussion List
-
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 105 views 5 comments 0 points Most recent by alexey.shtrakhov 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 53 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 99 views 4 comments 0 points Most recent by Uvaraja-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 107 views 0 comments 1 point Most recent 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 68 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 84 views 0 comments 0 points Most recent 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 80 views 5 comments 0 points Most recent by Ayesha Thilakarathna-51043 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 462 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 43 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 60 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 208 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… -
GL/SLA Account Analysis Report - Custom Spreadsheet Output FormatSummary Custom BIP template for the Account Analysis Report that displays GL/SLA journal line output in a spreadsheet format for easier searching and filteringContent * …Linda Wong-Oracle 256 views 6 comments 2 points Most recent by Marisa Escobar-83500 Reporting and Analytics for ERP
-
ESS Job DuplicateSummary Duplicate ESS JobContent Good People, While trying to duplicate the ESS Job created a new job , unfortunately now unable to search and find the newly created job…Soumya Prakash Parhi 77 views 3 comments 1 point Most recent by Shakher Sharma Reporting and Analytics for ERP
-
How to create a custom read online role to allow users to self serve reports that are segregatedContent Hi All I am struggling to get to grips with one area of reporting and that is allowing users to self serve some key reports we have but I need them to be segrega…Doron de Jong-57089 60 views 1 comment 1 point Most recent by Linda Wong-Oracle Reporting and Analytics for ERP
-
What table joins required to link PO Receipts to GL lines in Data Model?Summary Need to Extract GL lines with PO Receipt details, PO Number with Data ModelContent Hello, We are trying to create a custom GL Report that will show subledger det…user6675104 278 views 2 comments 0 points Most recent by Zlatko Alvir-Oracle Reporting and Analytics for ERP
-
Custom Enterprise Scheduler Job not showing to intended usersSummary Custom Enterprise Scheduler Job not showing to intended users while showing to othersContent Hi All, I have created a custom scheduler job using "Manage Custom E…
-
BI Analysis and/or Report for Specific Fiscal Year per Specific Account CodeContent I am needing to prepare either a report and/or analysis to show all purchase orders from a specific account code over a specific time period (ex: FY16). I have z…Brad Stefanoni 41 views 1 comment 0 points Most recent by User578443-Oracle Reporting and Analytics for ERP
-
Year Difference between 2 Date in BI Publisher Data ModelSummary Date FunctionContent Good People, Any one can help in Year Difference between 2 Date in BI Publisher Data Model ? Is there any function for the same ? Thanks, So…Soumya Prakash Parhi 42 views 2 comments 1 point Most recent by alexey.shtrakhov Reporting and Analytics for ERP
-
Preparing a custom fixed asset reportSummary Custom report designContent Hi, I would like to create a custom fixed asset report.What data model should I select or create or how can I do that ?(BI Publisher,…Armagan Sahin-57534 189 views 1 comment 0 points Most recent by Jennifer Sherbrook - CNL Reporting and Analytics for ERP
-
How can we find roles/access needed for a subject areaSummary How can we find roles/access needed for a subject areaContent Hi All, We are on R12. Our OTBI subject areas (for FIN and PRC) are working only for some users and…
-
Addition of New Field withing Subject AreaSummary How to add new filed (proejct classification) within a particular subject areaContent We have created Project Classification such as "Accounting Business Objecti…Debashis Das-80554 54 views 1 comment 0 points Most recent by Dustin Grabowski-Oracle Reporting and Analytics for ERP
-
How to do an average days to approve formula?Content Hi all, I am trying to do an average days formula from a requisition submission date and when it was approved, and then put another column in with the month it w…Doron de Jong-57089 82 views 1 comment 0 points Most recent by Aaron Leggett Reporting and Analytics for ERP
-
Application Policy NameContent Hi, We are on Cloud R12. Oracle provides an audit report by name "User Role Membership Report". This report displays all the roles a user has in cloud. Is there …
-
Standard Financial DashboardsSummary Need to create some basic Financials Dashboards, which gives a clarity over Company Financial HealthContent Hi All, I have implemented Oracle Financials Cloud fo…Muhammad Asif Qureshi 158 views 2 comments 0 points Most recent by Farooq Syed, CPA, PMP, CISA Reporting and Analytics for ERP