Popular Tags
- OTBI 1,494
- Reporting 1,412
- FDI 1,278
- Fusion AI Data Platform 1,050
- Analysis and Data Visualization 1,013
- BI Publisher 890
- Analysis 696
- Oracle Fusion Analytics 628
- OAC 570
- Administration 559
- Fusion HCM Analytics 445
- OBIEE 444
- Fusion ERP Analytics 442
- Analytics 440
- BI Publisher Data Models 367
- Security 311
- HCM 293
- Oracle Analytics Cloud 284
- BIP 273
- Answers 266
- Fusion Data Intelligence 257
- Analyses 257
- Developers 248
- Data Modelling and Datasets 237
- Fusion Data Intelligence FDI 222
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
BI Publisher Data Models
Discussion List
-
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 45 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 363 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 628 views 6 comments 0 points Most recent by Pooja K-Oracle Oracle Fusion Data Intelligence 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 116 views 2 comments 0 points Most recent by Mallikarjuna Kuppauru-Oracle Oracle Fusion Data Intelligence 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
-
BI Publisher Report not returning SOME values for a column - data exists in the sample data.We have a BI Pub report that is showing data not populating on some of the rows. The values exist in the code result, sample data, XML. However when added to the interna…
-
2Dialog box or an indicator while deleting a folder from BI catalog to show the progress of deletionHi Team, While working on BI catalogs, if we want to delete or move any folder, there should be an indicator or a dialog box provided to show the progress. This will off…Lucky Sharma 21 views 0 comments 2 points Most recent by Lucky Sharma Oracle Transactional Business Intelligence Idea Lab
-
Repeating headers within a loopHello All, I am currently facing an issue with repeating headers within a loop using the and tags. Despite implementing these tags, the headers are not repeating as re…Bhavani Rikkula 63 views 4 comments 0 points Most recent by Sumanth V -Oracle Oracle Analytics Publisher Forum
-
1How to show Dynamic decimal formatting of Amount in BIP Report excel(*.xlsx) format using RTFExpectation is to show the value to number decimal based on CCY value in Excel(*.xlsx) report format. E.g. if CCY = CAD then number decimal value should be #,##0.00 else…Anil Pandey-Oracle 135 views 2 comments 1 point Most recent by Anil Pandey-Oracle Oracle Transactional Business Intelligence Idea Lab
-
Query to fetch employee's eligibilty for performance document.Hi, I want to create a report of eligibility of all performance document for all employees available in system but currently I can only fetch data for any one user in OT…Shubham Patil29 33 views 1 comment 0 points Most recent by John Hung-Oracle Oracle Transactional Business Intelligence Forum
-
Default Package name for HCM pl/sqlI want to add an event trigger based on an pl/sql function on the HCM table in BI data model. Where can I find the package names?
-
6Ability to segregate create and migrate functionality via the BI Admin RoleThere should be a separate privilege to provide the create BIP/Data Model vs Migration of data models. This will help to support the segregation of duties as there are u…
-
invalid relational operator errorHi - I am trying to write a query to pull report parameter value in report layout, however due to system limitation whenever my default selection for any parameter is Al…Hemant_Jain 96 views 5 comments 0 points Most recent by Kevin M-Oracle Oracle Analytics Publisher Forum
-
How to implement Bulk invoice download in BIPHi, We have created a BIP report to get IDR links attached to invoices and by clicking on the link given by the report we can download only one invoice at a time. Is it …User_8OVHZ 21 views 1 comment 0 points Most recent by Mallikarjuna Kuppauru-Oracle Oracle Analytics Publisher Forum
-
1Ability to report on User Account last loginOrganization Name Debenhams Description The requirement here is to have the ability to accurately report on a User Account's last login date and timestamp. The FND_SESSI…Mike Royle 51 views 4 comments 1 point Most recent by Sidney Mori Oracle Transactional Business Intelligence Idea Lab
-
How send two file-excel multi. templateGood day everyone! Is it possible to send several files in one letter using bursting? I have a report and there are two templates in it, how should I send them to the ma…Vitalii_Alliance_dgtl 71 views 2 comments 0 points Most recent by DPM Oracle Analytics Publisher Forum
-
1Uninvoiced Receipt accrual report showing amounts in scientific notationUninvoiced Receipt accrual report showing amounts in scientific notation like Report is showing 6.12890000000000000000000000000000000001E02 Amount on UI is 612.89Himanshu M 11 views 0 comments 1 point Most recent by Himanshu M Oracle Transactional Business Intelligence Idea Lab
-
Put instructions on Parameter pageIs there a way to put a text box with instructions/comments/directions on the parameter page?Jill Larson 41 views 5 comments 0 points Most recent by Mallikarjuna Kuppauru-Oracle Oracle Analytics Publisher Forum