Popular Tags
- Reporting 1,332
- OTBI 1,329
- Analysis and Data Visualization 875
- FDI 823
- BI Publisher 766
- Analysis 647
- Administration 533
- Oracle Fusion Analytics 514
- OBIEE 406
- BI Publisher Data Models 310
- Analytics 273
- Answers 258
- Analyses 249
- Security 238
- Developers 234
- OAC 227
- HCM 211
- Data Modelling and Datasets 207
- Data Connectivity 204
- BIP 197
- ERP Analytics Content 186
- Report Output 173
- BI Publisher Report Templates 170
- Agents 148
- Customizing Reports 136
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
ODI
Discussion List
-
ODI Error: Create view on source (LKM BIAPPS SQL to Oracle (Multi Transport))Hi, I have moved one mapping from UAT to SIT environment in ODI. I regenerated the scenario and run the scenario. The mapping is failed for below error. I have done the …User_F707D 12 views 1 comment 0 points Most recent by LCDavis-Oracle Oracle Business Intelligence Applications -
ORA-01427: single row subquery return more than one rowWhen I run the mapping in ODI it will getting the issue ORA-01427: single row subquery return more than one row And am add rownum=1 in join condition interface successfu…User_HQ9TE 22 views 1 comment 0 points Most recent by SteveF-Oracle Oracle Analytics Cloud and Server -
Difference ODI on MP vs OCI - DIHi Team, We are deciding which ETL tool to suggest to the client for implementing FDIP/FAW. Can someone explain the difference between recommending ODI on MP and OCI-DI?…Vivek_Gautam 145 views 8 comments 0 points Most recent by Girish Ka-Oracle Oracle Fusion Data Intelligence -
Drop ODI COPY$ tables after data load completionHi, In ODI, during the data load it creates COPY$ tables in Oracle DB. In some cases, we get lot of copy$ tables getting created in DB and those are occupying more DB sp…Mrudula Kothapalli 21 views 2 comments 0 points Most recent by Gianni Ceresa Oracle Business Intelligence Applications
-
1Drop ODI COPY$ tables after data load completionDescription: In ODI, during the data load it creates COPY$ tables in Oracle DB. We're trying to drop the COPY$ tables with any of the ODI built in feature if available. …Mrudula Kothapalli 33 views 0 comments 1 point Started by Mrudula Kothapalli Oracle Analytics Cloud and Server Idea Lab
-
How can two different teams can use a single PVO with different set of columnsHi, We have a scenario where AP team can extract ledger PVO with different column set and similarly AR team also need to extract the same PVO with different column set. …User_RO78H 12 views 1 comment 0 points Most recent by John Hung-Oracle Oracle Transactional Business Intelligence
-
Regarding Data Integration(Data Asset) Service in OCIAfter creating workspace in Oracle Cloud, I am creating data asset for the same. But when I try to create data asset it is showing me to add some policies to enable it. …
-
Any interface not executed in odi11gAny interface not executed in odi11g am checked in service still working fine but loadplans still running status not executed. How to clear the cache in odi 11g And how …User_HQ9TE 11 views 3 comments 0 points Most recent by Gianni Ceresa Oracle Business Intelligence Applications
-
1Allow non-default domain users to be configured for Object Storage connections in ODI MarketplaceWe have to use the default domain for the user configured in ODI to connect to OOS, need to allow other created domains' users to be configured to access OOS. When acces…JamesM4454 12 views 2 comments 1 point Most recent by JamesM4454 Oracle Fusion Data Intelligence Idea Lab
-
Individual mapping is running fine but while running same in load plan getting failedIndividual mapping is running fine but while running same in load plan getting failed That columns just i am mapping source to target but same column names both tables. …User_HQ9TE 52 views 1 comment 0 points Most recent by Gianni Ceresa Oracle Business Intelligence Applications