Data Integration
Discussion List
-
EPM DM MutliColumn in quick modeEPM DM MutliColumn in quick mode I was able to load multi column data in non-quick mode, or single column data in quick mode. Would like to know if MuliColumn data load … -
EPM Agent EBS Preseeded QuerySummary: From Planning I set up a "EBS GL Balance" app and can execute the Preseeded Query against the agent, I see the query string it in the log. How do I modify the "…
-
Why delete UE was not able to capture records that have been deleted via HDL?Summary: I have deleted supervisor records via HDL but the HCM extract that uses delete UE is not able capture the deleted records.
-
Accessing "EGP_SYSTEM_ITEMS_B_V" table PythonAccessing "EGP_SYSTEM_ITEMS_B_V" table Python Hello Experts, I need access to the EGP_SYSTEM_ITEMS_B_V (Or any back-end table through Python. Is there any method for tha… -
We are currently on 5.2.2.27711 ADFdi and 4.8.1 .NET. Anyone having any issue?Summary: We are currently on 5.2.2.27711 ADFdi and 4.8.1 .NET, and we continually see the ADFdi plug-in disappear while opening the Journal Entries excel template. Anyon…
-
I am getting error in HDL while loading the worker dataSummary: I am trying to load the worker data through HDL I am getting these 2 errors Work terms records are required when you create or update assignments. The correspon… -
Oracle Data Transforms: Load Data from object storage to Autonomous DBSummary: Hi All, I have CSV file stored into object storage and my requirement is to load csv file content into table in autonomous database using Oracle Data Transforms…
-
How to change server time in ODI Market place.Summary: Hi we have ODI Market Place and the time zone is UTC, How to make it to UTC + 3. Content (required): Hi we have ODI Market Place and the time zone is UTC, How t…
-
ODI-10207 Uncategorized exception during transaction system usage.In ODI 12c when I try to run the job or run the simulation. I am getting the above error. Did anyone also face this error previously? ODI-10207 Uncategorized exception d…
-
Example of a BefExport.py that runs a SQL statement on an OnPremise Database before an ExportI am trying to export data from PBCS to an On-Premise Database using EPM Integration Agent. The Data Load Rule process works and it saves the data on the table. However,…
-
EPM Data exchange: unable to save data load ruleWe are facing two issues with regards to data load rules in data exchange (data load rule between to EPM environments/applications): We are not able so adjust and save e…
-
Oracle Data transforms: Use DB Sequence in Data flowSummary: Hi, I want to load a target table using Oracle Data transforms and populate ID column using a sequence. How could I achieve it? Thank you for your help. Content…
-
ODI Market Place accessIs there any way to access ODI-MP apart from VNC viewer/ Tiger VNC & Mobaxterm Due to customer security policies the above three applications are not accepting is there … -
ODI Load Plan as REST API ServiceSummary: We have requirement for calling ODI load plan in VBCS UI so as to refresh data or run the data load. Currently we are using ODIInvoke webservice which is config…
-
Load rules are taking longer than usual after migrating from non-enterprise to enterpriseSummary: We are doing Planning application migration from Legacy to Enterprise, after doing migration DataManagement load rules are taking longer than usual in the "Tran…
-
EPM Pipeline job sequence executing before prior job completesSummary We are seeing in some instances that the within a Pipeline "integration" that jobs which run long will have the next job in the stage execute (and parallel is no…
-
How to replicate Oracle HCM Cloud base tables into AWS Redshift?How to replicate Oracle HCM Cloud base tables into AWS Redshift? We tried Fivetran . But it uses BICC connector and replicates PVOs not base tables. We looked at Golden …
-
Pipeline with Conditional LogicSummary: Wondering if anyone has been able to achieve conditional logic inside of a Pipeline? Our goal is to create an ad-hoc execution of various different data loads t…
-
rrSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Real time replication of data from FusionSummary: Is there any solution/product available that allows replication of data from Fusion ERP using Golden Gate Services? Content (required): Version (include the ver… -
In ODI, How to use same mappings if source technology is changed from MS SQL Server to OracleSummary: Hi Team, We are having one situations where MS SQL Server database objects are replicated to Oracle database for one Schema and we are having mappings which are…
-
ODI Marketplace - External AuthenticationSummary: Does ODI Marketplace support for External Authentication with Azure AD / IDCS / OAuth Content (please ensure you mask any confidential information): Version (in…
-
Is ODI12c On-premise supported with Oracle DB 23 or Oracle DB23aiSummary: Is ODI12c On-premise supported with Oracle DB 23 or Oracle DB23ai Content (please ensure you mask any confidential information): Version (include the version yo…
-
Unable to retrieve data from object storage to OCI data integration data sourceSummary: Unable to retrieve data from object storage to OCI _DI due to the following error : : DIS_DATA_XPLORER_0015 - Failed to generate code Caused by: java.lang.NullP…
-
Positioning Data Integration Tool - ODI on MP vs OCI - DISummary: Which data integration tool to propose for ETL/ELT use case to load data from Fusion and other data sources to ADW - ODI on MP or OCI - DI Content (required): L…
-
Can I manage GoldenGate operations with Terraform?Summary: Attend our CCC webcast on using Terraform to provision and manage OCI GoldenGate deployments. Content (please ensure you mask any confidential information): Reg…
-
Migrate ODI from one OCI tenancy to another OCI tenancy?Summary: We are planning to migrate the existing ODI services from one OCI tenancy to another ODI tenancy. Content (please ensure you mask any confidential information):…
-
What is the best way to sync Oracle Cloud ERP data to Oracle Autonomus DatabaseSummary: We are currently using Oracle Integration Cloud application to integrate other systems with our Oracle Cloud ERP (SaaS) application. In most of the integrations…
-
How to connect to OCI Services (Ex: OCI Queues)Summary: We would like to configure OCI Queues as a data source in OCI DI. Only option to use "Generic REST" as data source. Generic REST is limited to Basic Auth or OAu…
-
duplicate source value from fileI had a value in source file suppose 1234, this I want to map to 2 target values, source is file target is EPM Dimension custom application, I can't use logic group as i…