Popular Tags
- OTBI 1,488
- Reporting 1,414
- FDI 1,229
- Fusion AI Data Platform 1,047
- Analysis and Data Visualization 1,015
- BI Publisher 885
- Analysis 696
- Oracle Fusion Analytics 624
- OAC 562
- Administration 559
- OBIEE 443
- Fusion HCM Analytics 435
- Analytics 435
- Fusion ERP Analytics 428
- BI Publisher Data Models 365
- Security 311
- HCM 293
- BIP 272
- Answers 267
- Oracle Analytics Cloud 265
- Analyses 257
- Developers 248
- Data Modelling and Datasets 235
- Fusion Data Intelligence 232
- ERP Analytics Content 220
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
ODI
Discussion List
-
24FDI Data Lineage Subject AreaIntroduce a Fusion Data Intelligence data lineage subject area that not only identifies where customisations come from - such as from an supplementary data augmentation,…Yagnesh_Analytics 302 views 8 comments 24 points Most recent by Brendan T Oracle Fusion AI Data Platform Idea Lab -
ODI 14.1.2 Salesforce connectivity and options to handle Boolean data type columnsHi, We have upgraded our ODI marketplace image on OCI from 12.2.1 to 14.1.2 recently. Post upgrade, we noticed ODI 12.2.1 is handling Salesforce integrations differently… -
How to update attributes of a datastoreI have created a datastore, and use reverse engineer to get the attributes, but I want to update the type for a column, after update, I can't save the changes, it shows … -
ODI can't load the local csv file on windowsI have two server A: it's my oracle database server, installed odi studio, repository, alone agent A B: it's a windows server, installed odi studio, alone agent B I trie…
-
How do I modify an IKM in ODI 12c to prevent duplicates in a target table?Hi everyone, I was practicing ODI 12c and I came across this problem: I have a mapping in ODI 12c that inserts the data from a staging table into a staging history table…
-
Moving data from SAP BW to FDI-ADW (Custom schemas)Hello Team, We have a requirement to move data from SAP BW to FDI-ADW (custom schemas), and we're referring to the following Oracle documentation for guidance: However, …User_25DQ4 34 views 0 comments 1 point Most recent by User_25DQ4 Oracle Fusion AI Data Platform Forum
-
2Allow 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 22 views 3 comments 2 points Most recent by Farivar Javanbakhti-Oracle Oracle Fusion AI Data Platform Idea Lab
-
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 24 views 1 comment 0 points Most recent by LCDavis-Oracle Oracle Business Intelligence Applications Forum
-
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… -
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 192 views 8 comments 0 points Most recent by Girish Ka-Oracle Oracle Fusion AI Data Platform Forum -
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 24 views 2 comments 0 points Most recent by Gianni Ceresa Oracle Business Intelligence Applications Forum
-
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 32 views 0 comments 1 point Most recent by Mrudula Kothapalli Oracle Analytics 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 11 views 1 comment 0 points Most recent by John Hung-Oracle Oracle Transactional Business Intelligence Forum
-
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 12 views 3 comments 0 points Most recent by Gianni Ceresa Oracle Business Intelligence Applications Forum
-
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 53 views 1 comment 0 points Most recent by Gianni Ceresa Oracle Business Intelligence Applications Forum
-
1Need to configure HFM client with Oracle Business Intelligence Applications (OBIA) 11.1.1.10.3 PS2As far as i know OBIA is not certified with HFM Client .Can we have OBIA to support ODI module to be used for importing data from HFM using integrated ODI 12c Module tha…Saket.Saurav 12 views 0 comments 1 point Most recent by Saket.Saurav Oracle Transactional Business Intelligence Idea Lab
-
OBIEE Pre-Builts Loading one year at a timeHi All, We are in a situation where we need to load one year at a time into the DWH (warehouse). We have 7 years of data to upload and we need to upload one year at a ti…Hippy 41 views 3 comments 0 points Most recent by Gianni Ceresa Oracle Business Intelligence Applications Forum
-
How to use both aggregate and analytic function in ODIHi All, I am working on ODI mapping where I am calculating" Min(ID) over parition by(device_num, sys_id) as min_id" in expression component, I used another expression co…User_XG491 1 view 0 comments 0 points Most recent by User_XG491 Oracle Business Intelligence Applications Forum
-
Differnce between ODI VS OBIEECan Any one tell me the difference between Oracle Data Integration(ODI) and Oracle Business Intelligence Enterprise Edition(OBIEE). Thanks in advance.