Category 225
Discussion List
-
What SNP table contains the columns indicating whether a mapping attribute is set to update?Good morning everyone, Am developing a script that queries the SNP tables to find all columns that shouldn't update but do. I managed to work my may down from snp_folder… -
Getting Error while connecting to PostgreSQL from ODISummary: Error while connecting to PostgreSQL from ODI12c. Error Message :oracle.odi.runtime.agent.invocation.InvocationException: oracle.odi.core.exception.OdiRuntimeEx…
-
How to load .mdb (Access File) into Oracle Table using ODISummary: .mdb File will be placed on the ODI server and need to be loaded into Oracle Table using ODI 12c. Content (please ensure you mask any confidential information):…Ritesh Kashyap-Oracle 21 views 2 comments 0 points Most recent by Ritesh Kashyap-Oracle Data Integration
-
Get Patches for ODI Marketplace 12.2.1.4Hello world, I've Just deployed ODI classic on Marketplace. However, I'm not able to access to Fusion Middleware EM: I got the following error blank page: Then, I remind…
-
while configuring HCM in PBCS we got an error as followsStarting FusionHcmAdapter main program... prod mode: importDataFromFusionHcm, pid: 201 Initializing adapter in prod mode... fusionHcmWebServiceWsdl: https://fa-emqz-dev7…
-
Archiveing SAP legacy data to OCISummary: We are implementing Oracle Cloud for a client with a SAP legacy system. Our plan is to migrate the latest/top of the stack data to the cloud. However, the clien…Chandramouli Yangareddy 12 views 0 comments 0 points Started by Chandramouli Yangareddy Data Integration
-
FDMEE v 11.1.2.4 - Unable to invoke ODI process errorSummary: Files started loading on 7/29/23. First few files loaded. Then, received error 'EPMFDM-140160:Unable to Invoke ODI process.' Files haven't loaded since. Not sur…
-
How to load the .dmp file into Oracle DatabaseSummary: I have files sftp'd to the ODI Server. Ask is to load the data of the .dmp file into Oracle Database Table via ODI. Can anyone help here how to achieve this. Co…Ritesh Kashyap-Oracle 11 views 2 comments 0 points Most recent by Ritesh Kashyap-Oracle Data Integration
-
Could we provision ODI console in marketplace with MySQL repo?Hello All, We have ODI Marketplace instance on OCI Compute The Repository is in underlying MySQL Database Questions - Is it possible to configure and provision ODI Conso…
-
oracle data transform in OCIIn Oracle Data transform in OCI, can we able to define the user privileges for different user. Supervisor has all access whereas can we able to provide only read access …Amirthavalli Chidambaram 11 views 0 comments 0 points Started by Amirthavalli Chidambaram Data Integration
-
Can you use query parameters with invoke SOAP adapter in OIC?Summary: Hello, We have an OIC integration that invokes the on-premise app (PeopleSoft) with SOAP adapter. With this we were able to create new data (location data) in P…
-
ODI Invoke RESTful service hangs when loading large (2GB) fileSummary: Trying to load a 2GB file generated by ODI to EPM using REST API. The REST API call step shows running for more than two hours with no error and the file is not…
-
Is there a historical PVO for person that contains all the DFF fields?Summary: No available historical PVO that pulls all person details that includes dff. Content (please ensure you mask any confidential information): I'm trying to find a…
-
Is there a historical PVO that pulls Person Details?Summary: No available historical PVO that pulls all person details. Content (please ensure you mask any confidential information): I'm trying to find a data store/PVO th…
-
How to SFTP file load to UCM content server via ODISummary: Hi Team, Content (please ensure you mask any confidential information): How to FTP file load to UCM content server (SOAP service) via ODI Version (include the v…
-
How to convert zip file to base64 in Oracle Data Integrator toolHi Team, I tried to convert the file to base64 data in the ODI tool. Can anyone help with this concept? Thanks Prakash Jayavel
-
Fusion UCM data files load into Snowflake using OCI Data IntegrationSummary: Hi Team, We are able to extract Oracle HCM cloud data using BICCC extracts and now files are available in UCM. Now we want to leverage OCI Data Integration serv… -
RCU creation in ODI-MPWe are getting below error while trying to create RCU in ODI-MP. Both Ingress and Egress rules were set between ODI-MP and ADW and vice versa. Please suggest if any one …Bapiraju Swamy Vuda-Oracle 22 views 1 comment 0 points Most recent by Debadrita Ghosh-Oracle Data Integration -
Connect OCI DI to Azure Blob (as target) to move Oracle UCM data files (from oracle fusion cloud)Summary: We are looking for approach to connect OCI DI to Azure blob as target storage for data files. These data files are available in Oracle UCM, as part of BICCC - P…
-
Setting policies for OCI-DIHi, Even with right policies we cannot define object storage as a data asset (Timeout: Its taking longer than expected. Ref Id - 2aa97cd6-c4af-4d31-b23d-8071da4c48c7) Ha… -
Is there a PVO that pulls Pay Calendar information?Summary: No available historical PVO that pulls pay calendar information. Content (required): I'm trying to find a data store/PVO that pulls pay calendar information but…
-
Is there a historical PVO that pulls the Asssignment EIT?Summary: Historical PVO for Assignment EIT doesn't exist. Content (required): I am not able to find a historical PVO for Assignment EIT. Available PVO is filtered using …
-
Is there available BICC PVO for Seniority Date?Summary: No available PVO for employee's seniority dates. Content (required): I'm trying to find a data store or PVO that is pulling the employee's seniority date but un…
-
Invoke ODI load plan from APEXSummary: Invoke ODI load plan start and stop from APEX Content (required): Kindly suggest the options to invoke ODI load plan start and stop from APEX. Also please provi…Selvam Muthiah-Oracle 32 views 1 comment 0 points Most recent by Ch M Prasad-Oracle Data Integration
-
How to configure ODI to use RESTful Services with OAUTH2Summary: How to configure ODI to use RESTful Services with OAUTH2 We can use Oracle Web Services Manager for ODI to use RESTful Services with OAUTH2 but what all configu… -
Is there a historical data store or PVO for Legislative Information?Summary: PVO for Person Legislative Information are not retrieving historical and future dated records. Content (required): I am not able to find a historical PVO for Pe…
-
Is there a historical data store or PVO for Person EIT?Summary: PVO for Person EIT is not retrieving historical and future dated records. Content (required): I am not able to find a historical PVO for Person EIT. Available P…
-
Is there a historical data store or PVO for Person National Identifier?Summary: PVO for Person National Identifier is not retrieving historical and future dated records. Content (required): I am not able to find a historical PVO for Person …
-
Is there a historical data store or PVO for Person Type?Summary: PVO for Person Type is not retrieving historical and future dated records. Content (required): I am not able to find a historical PVO for Person Type. Available…
-
Is there a historical data store or PVO for Person Name?Summary: PVO for Person Name is not retrieving historical and future dated records. Content (required): I am not able to find a historical PVO for Person Name. Available…