BI Publisher
Discussion List
-
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 73 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 32 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 32 views 2 comments 1 point Most recent by ashtrakhov-Oracle 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 120 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 35 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 33 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 136 views 2 comments 0 points Most recent by Farooq H Syed Reporting and Analytics for ERP
-
After R12 upgrade BIP and OTBI reports are not defaulted to custom Inquiry roleSummary After R12 upgrade BIP and OTBI reports are not defaulted to custom Inquiry roleContent After R12 upgrade BIP and OTBI reports are not defaulted to custom Inquiry…
-
R13 Risk Management OTBI subject area Description documentationSummary R13 Risk Management OTBI subject area Description documentationContent This documentation is published by Oracle OTBI development. This document provides users a…User720640-Oracle 69 views 1 comment 5 points Most recent by Youssouf Reporting and Analytics for ERP
-
Uk compliant VAT report in r12Content All,We are trying to find a uk compliant report or processes/white paper that we can use to run our vat returns from, are you please able to point me in the righ…Doron de Jong-57089 20 views 1 comment 0 points Most recent by Veronica Dumitriu Reporting and Analytics for ERP
-
Financial OTBI Index ColumnsSummary This workbook documents index columns in R13.17D Financials OTBI subject areas.Content This document is published by Oracle OTBI Development. Index columns use d…User720640-Oracle 80 views 2 comments 5 points Most recent by rajArun Reporting and Analytics for ERP
-
Fusion R12 Upgrade -BI | Icons appearing as dots ( . )Summary After upgrading to R12 Fusion, the BI icons like "Add" (+) and "Delete"(x) are appearing as dots (.)Content After upgrading to R12 fuion, the icons like "Add" (+…
-
Customizing a standard reportSummary Customize option is not visibleContent Hi, I'm trying to customize "General Ledger Trial Balance Report ".I want to copy and save it under my custom folder for e…Armagan Sahin-57534 81 views 1 comment 0 points Most recent by Gergana Radoutcheva-Oracle Reporting and Analytics for ERP
-
Running an uploaded .RTF reportSummary Edited report cannot be run in the financial reporting centerContent Hi, I've downloaded a standard trial balance report and edited it.But when I try to run it I…Armagan Sahin-57534 26 views 1 comment 2 points Most recent by Gergana Radoutcheva-Oracle Reporting and Analytics for ERP
-
Compare costs on the same task across projectsSummary We have a standardized work breakdown structure and would like to compare costs for the same task across projects.Content We have a standardized work breakdown s…Jeanne Partner 35 views 1 comment 0 points Most recent by Prasanna Reka-OC Reporting and Analytics for ERP
-
What happened to OTBI Web Query(iqy)Summary What happened to OTBI Web Query(iqy)Content In older releases if we edit analysis and go to advanced tab we used to have option to download Web Query (iqy) for t…Prasanna Reka-OC 34 views 0 comments 0 points Started by Prasanna Reka-OC Reporting and Analytics for ERP
-
Securing OTBI/BIP ReportsSummary Securing OTBI/BIP ReportsContent Hi All, One of our client has a requirement where they would like to give "Read only access"(no edit/create/delete even from BI …Vikram Agarwal-43618 101 views 2 comments 0 points Most recent by Amj Reporting and Analytics for ERP
-
Important Information About Fusion OTBI R12 Patch Bundle 10Summary This note provides information about Fusion OTBI R12 PB10 (2017 October monthly patch bundle).Content This note provides information about Fusion OTBI R12 PB10 (…User720640-Oracle 56 views 0 comments 0 points Started by User720640-Oracle Reporting and Analytics for ERP
-
Intercompany out of balance reportContent Hello Gurus we looking at developing the following report we are not using AGIS and we have one ledger only. we would like to get the account balance twice on th…
-
Tips and Tricks: Fetch Large Volume of Data using BIP in Oracle CloudSummary Tips and Tricks: Fetch Large Volume of Data using BIP in Oracle CloudContent Hi Experts, Recently I encountered a situation where I was trying to fetch entire Wo…AshishERPCloud 92 views 2 comments 4 points Most recent by User_AEMC1 Reporting and Analytics for ERP
-
How to show the grand total with group by option ?Summary How to show the grand total with group by option ?Content Can you please help us how to show the grand totals with group by option. I am trying to bring the repo…User_AEMC1 50 views 10 comments 0 points Most recent by Vikram Agarwal-43618 Reporting and Analytics for ERP
-
Revoke Roles in Security Console R12 Still Showing Assigned in BI ReportSummary Since R12 upgrade revoking roles in Security Console, the revoked users' roles still appear to be assigned in our existing custom BI report (SQL below)Content In…
-
How to add Administration menu in Fusion R12 in BI Home pageSummary Administration Menu is not available after upgrading to Fusion Cloud R12Content How to get Administration menu next to the advanced menu in Fusion R12 in BI Cata…
-
How to make the Graph OTBI ReportSummary How to make the Graph OTBI Report with feature drill down to applicationContent Hi, We have require to prepare the OTBI graph report with the feature drill down …
-
BIP - Asset Details ReportSummary Asset Details ReportContent This report can help in getting extract of Assets from Fusion Assets for reporting , conversion data compare etc.Soumya Prakash Parhi 97 views 5 comments 4 points Most recent by Soumya Prakash Parhi Reporting and Analytics for ERP
-
Expose an BI Publisher Report Paramter's LOV in ESS jobSummary BI Publisher report can be exposed as ESS job. How can the LOV for the report parameter be exposed in ESS?ManiShankar Choudhary 38 views 7 comments 0 points Most recent by Manish Pesswani Reporting and Analytics for ERP
-
Fill group by data in Group by columns and sub totals in a BI Publisher reportSummary Fill group by data in Group by columns and sub totals in a BI Publisher reportContent Current Output 1. Group by column data is merged 2. Group by column data is…Sachin Mistry, CFA, PMP 47 views 2 comments 2 points Most recent by Sachin Mistry, CFA, PMP Reporting and Analytics for ERP