Popular Tags
- OTBI 1,473
- Reporting 1,405
- FDI 1,195
- Fusion AI Data Platform 1,038
- Analysis and Data Visualization 1,004
- BI Publisher 875
- Analysis 687
- Oracle Fusion Analytics 611
- Administration 556
- OAC 527
- OBIEE 436
- Fusion HCM Analytics 427
- Analytics 419
- Fusion ERP Analytics 409
- BI Publisher Data Models 361
- Security 301
- HCM 279
- BIP 267
- Answers 266
- Analyses 255
- Developers 246
- Oracle Analytics Cloud 246
- Data Modelling and Datasets 231
- ERP Analytics Content 217
- Data Connectivity 214
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
BI Publisher Data Models
Discussion List
-
2How to restrict the data access for different users on BIP reportsWe developed some custom BIP reports in our system, and by default, BI consumer role is taking the read access, thus, most of our users who have the BI consumer role wil…Jay0089 116 views 0 comments 2 points Started by Jay0089 Oracle Transactional Business Intelligence Idea Lab -
ESS job Is not generating the PDF file in the output sectionHi Team, I was trying to get the bursting query output through ess job, but my job is getting succussed and output file is not generating. why I am not getting pdf file …Pooja_123 64 views 2 comments 0 points Most recent by Kevin M-Oracle Oracle Transactional Business Intelligence Forum -
Java.sql.SQLException: Invalid column indexSummary Errors out with the mesaage Content Hello There, We are using Oracle Financials Cloud and BI Publisher. I have a simple WITH Clause sql construct. On execution i…Donald 5.4K views 14 comments 0 points Most recent by User_0YPLB Oracle Transactional Business Intelligence Forum
-
Can Someone help with table and column details for the Manager performance check-in feedback columnHi, we have OTBI report developed for check-in details summary information. As this is hitting performance issues very often and taking very long time to run. we are con…User_LEKDP 21 views 1 comment 0 points Most recent by John Hung-Oracle Oracle Transactional Business Intelligence Forum
-
Repeating Footer on Invoices Report Output and print ContinuedThe request here is for the footer to display (repeat) on every page of a multi-page invoice. On all pages apart from the LAST page, the footer should repeat with the wo…Pooja K-Oracle 81 views 4 comments 0 points Most recent by Abhilash K - Deloitte USI Oracle Analytics Publisher Forum
-
15Ability 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 496 views 4 comments 15 points Most recent by Emiliano R Oracle Transactional Business Intelligence Idea Lab
-
Is it possible to run the procedure in Oracle BI Publisher ?Hello everybody Is it possible to perform the procedure before generating a report in Oracle BI Publisher, when creating a Data Model ? I have reports that are executed …Vitalii_Alliance_dgtl 263 views 4 comments 0 points Most recent by Kevin M-Oracle Oracle Analytics Publisher Forum
-
"Not Enough Memory to open this page" -BI ReportHi Folks, We have a report which generates assignment details, we are able to export the report in xml format, but while running in HTML format , first it takes time to …Sushant95-Oracle 71 views 1 comment 0 points Most recent by Gianni Ceresa Oracle Analytics Publisher Forum
-
How to add Rerun option to generate BI report for incremental dataHi, We want rerun option for regenerating previously scheduled report to get incremental data. Currently we are not able do the same, every time we have to run option to…Jeetesh Singh 11 views 1 comment 0 points Most recent by Mallikarjuna Kuppauru-Oracle Oracle Analytics Publisher Forum
-
How to add Rerun option to generate BI report.Hi, We want rerun option for regenerating previously scheduled report to get incremental data. Currently we are not able do the same, every time we have to generate the …Jeetesh Singh 11 views 1 comment 0 points Most recent by Ashish-Oracle Oracle Analytics Publisher Forum
-
BIP After entering all parameter we click on "Apply" button and we change prompt of "Apply" button?BIP After entering all parameter we click on "Apply" button can we change prompt of "Apply" button as "Generate" ? Also how can we change font and size of parameter prom…Nikatfusion 23 views 2 comments 0 points Most recent by Nikatfusion Oracle Analytics Publisher Forum
-
Bursting BIP report to different emails by respective business unitsHello guys, am super new to bursting. I am facing an issue with bursting an excel attachment which has 3 tabs (a detailed report, +2 summarized tables by buyer name). Th…GabrielWong 43 views 3 comments 0 points Most recent by Kevin M-Oracle Oracle Analytics Publisher Forum
-
How does CD_TRX_AMOUNT xml tag is getting generated "Create Customer Statements" report ?I am trying to customize the "Create Customer Statements" report in oracle fusion, for which I needed to add one column in "G_LINE_CLUSTER" group. As soon as I am editin…Binod Kumar 21 views 1 comment 0 points Most recent by Ishtiaque AHmed Oracle Analytics Publisher Forum
-
Print Receivables Transactions : Provide Confirmation of Invoice Email DeliveryHi Team, In AR Invoice Printing process, After sending the invoice copy to customer is there a way to access the .msg files send to customers as proof of delivery. We ne…
-
ORA-00939: too many arguments for function error when used substr in SQL Query in DataModelHi, I have created a DataModel using below query : select HZP.PARTY_NAME, HZP.PARTY_NUMBER from HZ_PARTIES HZP where 1=1 AND HZP.PARTY_NAME IN (substr(:P_STRING1,:P_STAR…Shashidhar Goud 303 views 7 comments 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence Forum
-
Issue with rounding in RTF Template FormulaIn my RTF template, the formula rounds values to 2 decimals by default. For example, if INVL_UNIT_PRICE_VARIANCE is 0.006 in the data model, the output becomes 0.01 aft…Pooja K-Oracle 551 views 6 comments 0 points Most recent by Pooja K-Oracle Oracle Fusion AI Data Platform Forum
-
Dynamic column names and column value 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 92 views 2 comments 0 points Most recent by Mallikarjuna Kuppauru-Oracle Oracle Fusion AI Data Platform Forum
-
ESS Schedule Process ID into OTBISummary: Obtaining ESS Schedule Process ID into OTBI data model Content (required): Hi all, Has anybody every seen or done getting the ESS “Scheduled Process” request ID…dbudd 481 views 3 comments 0 points Most recent by Neha_Naik004 Oracle Transactional Business Intelligence Forum
-
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 33 views 1 comment 0 points Most recent by Sathyaprakash M Oracle Fusion AI Data Platform Forum
-
BI Publisher Report not returning SOME values for a column - data exists in the sample data.https://us.v-cdn.net/6037859/uploads/VM7Z1JMDBZ6T/datawithvalues.xml https://us.v-cdn.net/6037859/uploads/YG9WZPN1S8E9/outputfrominternaltemplate.xlsx We have a BI Pub r…