Popular Tags
- OTBI 1,501
- Reporting 1,420
- FDI 1,293
- Fusion AI Data Platform 1,054
- Analysis and Data Visualization 1,015
- BI Publisher 898
- Analysis 699
- Oracle Fusion Analytics 634
- OAC 582
- Administration 564
- Fusion HCM Analytics 447
- Analytics 446
- OBIEE 444
- Fusion ERP Analytics 444
- BI Publisher Data Models 370
- Security 303
- HCM 295
- Oracle Analytics Cloud 294
- Fusion Data Intelligence 276
- BIP 272
- Answers 266
- Analyses 258
- Developers 250
- Data Modelling and Datasets 238
- Fusion Data Intelligence FDI 232
BI Publisher Data Models
Discussion List
-
1SR 3-38319042191 : Oracle Time and Labor table HWM_TM_REC - DELETE_FLAG fieldIn Oracle ERP Cloud I want to use the table HWM_TM_REC to expose a report in my BI to Oracle Analytics Cloud. However, I have seen that for some employees the table HWM_…Marina Chiovato 41 views 0 comments 1 point Most recent by Marina Chiovato Oracle Fusion Data Intelligence Idea Lab -
Is it possible to create a data set using REST API as a data source in oracle fusion cloud?Please suggest solutions to set up an REST API as a data source for a data model in Oracle Fusion. instead of sql query as a data set we need to pull data from rest api …Prakash B Roy 414 views 10 comments 1 point Most recent by MandeepGupta Oracle Analytics Publisher Forum -
How to add a parameter when calling a function from the trigger sectionI have a parameter that I pass directly to the data model - RDATE, and this parameter is automatically added to the triggers section. I get an error when calling the fun…Vitalii_Alliance_dgtl 181 views 8 comments 0 points Most recent by Kevin M-Oracle Oracle Analytics Publisher Forum
-
Field is in DM but not showing on BI Publisher to add to templateI'm trying to add a field to a BIP report and the field is included in the DM. When I open the template and access BIP and select field to add it to the template the fie…Sean-B-01 670 views 9 comments 0 points Most recent by Kevin M-Oracle Oracle Analytics Publisher Forum
-
Not able to Print Enterprise Contract Terms in Custom Report as ARTICLE_TEXT is HTML embeddedselect ch.contract_number, cab.label||''||caa.article_title article,fl.meaning,cab.document_id,cv.ARTICLE_TEXT from okc_k_headers_vl ch,okc_k_articles_b cab, okc_article…Snehashis_Santra 32 views 3 comments 0 points Most recent by Kevin M-Oracle Oracle Analytics Publisher 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 87 views 3 comments 0 points Most recent by Mallikarjuna Kuppauru-Oracle Oracle Analytics Publisher Forum
-
Want to customise Standard Oracle SalesOrder Report by adding new columnsI want to add few new columns in salesorder standard Oracle Report ,but unfortunately standard XML attached in the datamodel does not have the tags that I require , Is t…
-
How to access PaaS table or external database through BI PublisherWe have a PaaS solution where we have created a custom screen and stored the data in the custom table(DBCS), and we have another DW system as well; we want to build a re…DKR 971 views 3 comments 0 points Most recent by Ali Mostafa_connect Oracle Analytics Publisher Forum
-
Pivot row header nameI am trying to do a Pivot but the name is not appearing for the header. I am also trying the same in Pivot for bi publisher but not sure how to do it XML is attached. Co…Dhevina 11 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Oracle Transactional Business Intelligence Forum
-
How to disable pdf attachment while bursting in Oracle Fusion HCMGiven 'FALSE' as parameter6 in my bursting query. Still attachments are triggering. Suggestion PLEASESai Krishna Chelikani 527 views 5 comments 0 points Most recent by Sumanth V -Oracle Oracle Analytics Publisher Forum
-
1Allow Ability to Restrict Data Model Creation in OACCurrently there is no role in OAC which restricts users from creating Data Models in the Published Reporting section of OAC. This is an issue because it allows all Conte…Lee Eslick-Huff 12 views 0 comments 1 point Most recent by Lee Eslick-Huff Oracle Analytics Idea Lab -
Query to get fetch Archived Transaction Summary dataHi Expert, Does anyone have a query to fetch the Archived Transaction Summary data? I would really appreciate it if you could share a BI query here. Thank you in advance…Saher 111 views 3 comments 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence Forum
-
SQL code runs fine in SplashBI SQL Connect tool but times out in Oracle BIP Data ModelHi all - I have a SQL query that runs within a few seconds in my Splash BI (SQL Connect) query tool, however when I use this same code in the Oracle Data Model in BIP it…KDR 135 views 3 comments 0 points Most recent by Mallikarjuna Kuppauru-Oracle Oracle Analytics Publisher Forum
-
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 121 views 0 comments 2 points Most recent 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 62 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.8K 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 104 views 4 comments 0 points Most recent by Abhilash K - Deloitte USI Oracle Analytics Publisher Forum
-
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 291 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