Popular Tags
- OTBI 1,493
- Reporting 1,414
- FDI 1,255
- Fusion AI Data Platform 1,047
- Analysis and Data Visualization 1,015
- BI Publisher 888
- Analysis 696
- Oracle Fusion Analytics 626
- OAC 570
- Administration 561
- OBIEE 444
- Fusion HCM Analytics 440
- Analytics 437
- Fusion ERP Analytics 433
- BI Publisher Data Models 366
- Security 311
- HCM 294
- Oracle Analytics Cloud 273
- BIP 272
- Answers 267
- Analyses 257
- Developers 249
- Fusion Data Intelligence 243
- Data Modelling and Datasets 237
- ERP Analytics Content 221
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 324 views 9 comments 24 points Most recent by Yagnesh_Analytics Oracle Fusion Data Intelligence 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 Data Intelligence 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 25 views 3 comments 2 points Most recent by Farivar Javanbakhti-Oracle Oracle Fusion Data Intelligence 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 21 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 205 views 8 comments 0 points Most recent by Girish Ka-Oracle Oracle Fusion Data Intelligence 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 22 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 14 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 19 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 52 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 11 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.