Popular Tags
- OTBI 1,482
- Reporting 1,408
- FDI 1,216
- Fusion AI Data Platform 1,043
- Analysis and Data Visualization 1,011
- BI Publisher 879
- Analysis 691
- Oracle Fusion Analytics 618
- Administration 556
- OAC 548
- OBIEE 437
- Fusion HCM Analytics 428
- Analytics 427
- Fusion ERP Analytics 413
- BI Publisher Data Models 362
- Security 303
- HCM 287
- BIP 268
- Answers 266
- Analyses 256
- Oracle Analytics Cloud 255
- Developers 248
- Data Modelling and Datasets 235
- Fusion Data Intelligence 219
- ERP Analytics Content 217
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
BI Publisher Data Models
Discussion List
-
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 336 views 4 comments 0 points Most recent by Shilpi Anand Oracle Transactional Business Intelligence Forum -
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.3K views 11 comments 31 points Most recent by user626742 Oracle Transactional Business Intelligence Idea Lab
-
6OTBI 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 610 views 12 comments 6 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 37 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 AI Data Platform 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 445 views 5 comments 16 points Most recent by MandeepGupta Oracle Transactional Business Intelligence Idea Lab
-
'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 101 views 4 comments 0 points Most recent by Chris_Peer_Gibraltar1 Oracle Business Intelligence Applications Forum
-
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 12 views 1 comment 3 points Most recent by Sandeep S. Chauhan-Oracle Oracle Analytics Publisher Idea Lab
-
34GSI - 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 562 views 21 comments 34 points Most recent by Samarjeet Pati 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 116 views 3 comments 5 points Most recent by Sabrina Bernardi Oracle Transactional Business Intelligence Idea Lab
-
1Analytics Publisher Connects CUPS Private Printer through PACIssue: PAC (Private Access Channel) guarantees only DB data connection to Private data sources. You can't use a private access channel to access any other types of priva…BalaGuddeti-Oracle 22 views 0 comments 1 point Most recent by BalaGuddeti-Oracle Oracle Analytics Publisher Idea Lab -
2 reports in this Ship Confirm Documents BIP Job set are facing issues to fetch dataBelow are the reports in Job set: 1.Print Packing Slip Report Error: oracle.xdo.servlet.data.DataException: oracle.xdo.XDOException: oracle.xdo11g.xpath.XPathException: …Yagna 31 views 4 comments 0 points Most recent by RVohra Oracle Business Intelligence Applications Forum
-
Oracle BI EEDear Expert, Could you please confirm how to get the access for Oracle BI EE access. for it's not coming in Drop down. Thank you!jsmithA 15 views 4 comments 0 points Most recent by Bhaskar Konar Oracle Transactional Business Intelligence Forum
-
How to connect BI Publisher using REST servicesHello everyone, I'm developing a project where I need to consume a couple of reports from BI Publisher using OIC. The idea was to consume them via URL. I see there are c…wilberth Canales Romero 76 views 5 comments 0 points Most recent by Kevin M-Oracle Oracle Analytics Publisher Forum
-
I have a requirement for creation of a new Custom ESS job running SEEDED GL Standard reportHi, I am trying to analyze the possibilities to perform a POC to acheive below requirement" We have a Seeded ESS Job called as "Average Balances Trial Balance Report" in…Sravan Kumar K 21 views 2 comments 0 points Most recent by Sravan Kumar K Oracle Fusion AI Data Platform Forum
-
Delete record from Custom TableHi All, we are using a custom table "MKT_REF_ENTITIES" to store data as a part of journal import and we have came across a occurrence where we need to delete few records…Chetan007 23 views 2 comments 0 points Most recent by Mohamed M. Faramawy-Oracle Oracle Fusion AI Data Platform Forum
-
'No output available' with Report Status 'Success'I have a notification (BIP report) that I am testing in Prod, which is a copy of one we are using in Prod. It is scheduled to run every 30 minutes. When it completes wit…MarkPescatrice 1.4K views 12 comments 0 points Most recent by Mohamed M. Faramawy-Oracle Oracle Analytics Publisher Forum
-
What is the use of FlexFields in Oracle BIPHello Expert, I'm learning BIP, and I want to learn how to use Flexfield in an Oracle BIP parameter. Can anyone explain end to end with an example.Flying 63 views 6 comments 0 points Most recent by RVohra Oracle Transactional Business Intelligence Forum
-
BIP Report DynamicallyHi We have a BIP report with daily frequency, and we need to pass the schedule start time to the data model SQL input parameter#p_from_date to fetch the incremental valu… -
How to create CS pivot (Suppliers as Columns) in OTBI?I am working on a Comparative Statement report in Oracle Fusion Cloud. I am using OTBI subject areas: Procurement – Requisitions Real Time Sourcing – Supplier Negotiatio…Talha Jamal 11 views 1 comment 0 points Most recent by JohnW-Oracle Oracle Fusion AI Data Platform Forum