Popular Tags
- OTBI 1,494
- Reporting 1,412
- FDI 1,271
- Fusion AI Data Platform 1,048
- Analysis and Data Visualization 1,011
- BI Publisher 890
- Analysis 696
- Oracle Fusion Analytics 626
- OAC 568
- Administration 559
- OBIEE 444
- Fusion HCM Analytics 440
- Analytics 439
- Fusion ERP Analytics 436
- BI Publisher Data Models 367
- Security 311
- HCM 292
- Oracle Analytics Cloud 280
- BIP 272
- Answers 266
- Analyses 256
- Fusion Data Intelligence 250
- Developers 248
- Data Modelling and Datasets 237
- ERP Analytics Content 220
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
BI Publisher Data Models
Discussion List
-
18Ability to extract all ESS job and job set name via Manage Enterprise Scheduler Job for HCM/Fin/CRMOrganization Name Department of Treasury and Finance Description Hi Team, Per Oracle Fusion product limitation, The Jobset and Job Definitions are not stored in any DB t…Akash Gupta 536 views 5 comments 18 points Most recent by Divesh K. Oracle Transactional Business Intelligence Idea Lab -
In Oracle Fusion BI Publisher, where can we see the package body referenced by standard reports?In BI Publisher, some seeded reports use packages in triggers (like before report). Where can we see or get the PL/SQL package body for it? For example, from the report …
-
How to force URL defined in BIP Layout editor to open in a new windowWe need to open a standard application redwood page using the URL functionality in the layout editor. Example target page is: /fscmUI/redwood/procurement/workconfirmatio…
-
4Improvement request to generate explain plan for XLA tableOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of):Accenture Description (Required):I wan…Yuko Naniwa 133 views 1 comment 4 points Most recent by Porfirio Benjamín Rodríguez Miguens Oracle Transactional Business Intelligence Idea Lab
-
Pending worker reportI am new to reporting, and I have to make a report using BI Publisher data modeler in SQL. When I put effective start date later than today and DATE_START later than tod…Sachin P 56 views 4 comments 0 points Most recent by MandeepGupta Oracle Transactional Business Intelligence Forum
-
'Print Receivables Transactions' Data Model does not return any Sample Data.The underlying data model for 'Print Receivables Transactions', ' Transactions Print Data Model', does not return any sample data. I would need this to get a sample XML …Reena Agrawal 204 views 5 comments 0 points Most recent by Shane Riley Oracle Business Intelligence Applications Forum
-
70Disable Drag and Drop for Report FoldersOrganization Name American Express Description We have had issues with permissions when a report folder is accidently moved by dragging and dropping to another folder. W…Brenda Doak 1.3K views 35 comments 70 points Most recent by JR_MTB Oracle Transactional Business Intelligence Idea Lab
-
1Enable 2HRS of execution time for large datasets in Oracle Analytics Server / Data VisualizationPlease enable 2HRS of execution time for large datasets in Oracle Analytics Server / Data Visualization, datasets are timing out in 10 mins, where existing support is un…Shubhendu Halder 1 view 1 comment 1 point Most recent by Alan Lee - Oracle-Oracle Oracle Analytics Idea Lab
-
We have a custom report and when trying to run the report there are an error displayedWe customized the Purchase Order Notification report by modifying its data model. After running the report, everything worked correctly. However, when we tried to add a …Varun Dhondea 169 views 12 comments 0 points Most recent by MandeepGupta Oracle Analytics Publisher Forum -
3BIP date function for First Day of Previous MonthWe have a report that we run on the first day of each month, and enter the Start Date and End Date parameters for the dates of the previous month. We want to schedule th…Geoff 52 views 1 comment 3 points Most recent by MandeepGupta Oracle Transactional Business Intelligence Idea Lab
-
5Upload BIP .catalog object via Web ServicesOrganization Name The Hackett Group Description We need to enhance the CatalogService to allow the upload of .catalog objects. Currently, the Web Service supports the cr…3lRob 397 views 12 comments 5 points Most recent by FROZADOS Oracle Transactional Business Intelligence Idea Lab
-
35GSI - Data Source Access across Oracle Pillars (HCM and FIN) - BI AdminOrganization Name Southern Description The Oracle Idea Lab is logged to highlight a gap in the BI Publisher security design. As of today, a user with the ability to crea…Matt Van Asten 663 views 22 comments 35 points Most recent by Sheikh M Kashif Oracle Analytics Publisher Idea Lab
-
31Allow report with eText template to output a report to csv with the same structureOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Accenture Description (Required): Cur…User_CJ6QA 1.4K views 13 comments 31 points Most recent by User_PJNK9 Oracle Transactional Business Intelligence Idea Lab
-
How to create ess job that will directly use the parameter of the data model?Hello, We have an analysis that we wanted to be available in the Scheduled Process. Since we cannot link the Analysis itself to the ESS job report job ID, we tried to re…Kristelle 351 views 4 comments 0 points Most recent by Shilpi Anand Oracle Transactional Business Intelligence Forum
-
8OTBI Scheduled Report to FTP FolderDescription Currently we get the reports from OTBI via email. But it will be good to have the agent send the output directly to our FTP/SFTP server. Use Case and Busines…Ilavarasu Radjunilamegame 666 views 12 comments 8 points Most recent by AvinashRN Oracle Transactional Business Intelligence Idea Lab
-
3Improving SQL Developer Productivity in Oracle Fusion HCMProblem Statement: Oracle Fusion HCM SQL Developer Experience Currently, developing and validating SQL queries for Oracle Fusion HCM is a highly fragmented and time‑cons…Chakresh Nayak 65 views 5 comments 3 points Most recent by MandeepGupta Oracle Transactional Business Intelligence Idea Lab
-
Dynamic column names and respective column values for BI reportI am creating custom report, in that we have to get column names and their respective values dynamically. Like this I have data, I have to get output like in this format…Rahul K-Oracle 31 views 2 comments 0 points Most recent by Gokul Kathirvel Oracle Fusion Data Intelligence Forum
-
16Automation of OTBI reports for version source control and deploymentOrganization Name Pengurusan Air Selangor Sdn Bhd Description We are looking for the mechanism to automate the archive and unarchive steps of custom BIP catalogs from Re…User_BKC13 443 views 5 comments 16 points Most recent by MandeepGupta Oracle Transactional Business Intelligence Idea Lab
-
3Enable Scheduling of BI Publisher Jobs on First Business Day of the MonthCurrently, BI Publisher does not allow scheduling a recurring job to run on the first day or first business day of each month. This functionality is not working. As a wo…Khushi 11 views 1 comment 3 points Most recent by Sandeep S. Chauhan-Oracle Oracle Analytics Publisher Idea Lab
-
5Capability to access Key "Application Reference" field in "Receivables – Standard Receipts ApplicatOrganization Name ADO Staffing Inc, Description We need capability to report the Application reference as part of the receipt or Credit Memo application detail. Applicat…Comakshi Ars 123 views 3 comments 5 points Most recent by Sabrina Bernardi Oracle Transactional Business Intelligence Idea Lab