To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Data Integration
Discussion List
-
Unable to connect to ODI AgentSummary: I have installed ODI12c in my system and trying to connect agent. Even if the NodeManager is up, weblogic server is in "FAILED_NOT_RESTARTABLE" state. And when … -
Unable to find historical UE or BICC to extract TIMECARD_REQ field from PAY_ASSIGNED_PAYROLLS_F.Summary: What historical UE or BICC can I use to extract the Time Card Req field from PAY_ASSIGNED_PAYROLLS_F table? Content (required): We are trying to extract the TIM…
-
Error while trying to delete ODI foldersSummary: An error was thrown while trying to delete some folders from ODI MP repository. It was thrown on both manual deletion and deletion via SDK. The folders have map… -
HIstorical UE/PVO for pay_cost_alloc_accountsSummary: We have a client requirement to pull historical data from pay_cost_alloc_accounts into a PaaS environment for reporting/integration usage. I am unable to identi…
-
Extract a System generated report for ODI, OCISummary: Hello team, can you please help me with the following info : is there a way to extract a System generated report, for all the changes/configurations for a speci…
-
Supports incremental not working when Disabled Effective Date field is checked in BICC.Summary: For some data store, Supports incremental is not working when Disabled Effective Date field is checked in BICC. Content (required): Why for some data store Supp…
-
Triggering Full Load in BICC from ODI MarketplaceSummary: Have anyone worked on Triggering of FUll Load in Fusion BICC directly from ODI marketplace? Any advise appreciated. Content (required): We are able to trigger B… -
How to read an Excel file via ODI 12c?Summary: Hi Team, Could anyone please guide me on the below requirements related to excel file parsing using ODI - Read the excel file placed in a local folder via ODI 1…
-
ODI Web Edition is giving Driver class name must not be empty while setting up data loadSummary: ODI Web Edition is giving Driver class name must not be empty while setting up data load Content (required): I have setup connect to ERP Cloud as type Oracle BI…
-
Retirment of EBIZ HR gradually after upgrading to HCM CloudSummary: We have upgraded to HCM Cloud from EBIZ HR. Earlier to this use when EBIZ HR was our man HR system, many on premise modules like Purchasing, Project Accounting …
-
Assignment details not integrating in their Payroll softwareThe assignment details of one employee does not seem to be extracted from PROD to the XML, which is shared with their Payroll software. There's also one employee where a…
-
Add Employee Work Relationship is not reflecting in Integrationour client created a new work relationship , but it is not sending any assignment detail information in the Integration. What can be the possible reasons for this?
-
Options to extract data from BIP Report and load it to ADW via ODIContent (required): I wanted to know what is the best way or options to extract data from the BIP Report (in Fusion) and load this data to ADW with the use of ODI. We ar… -
Use OCI Base Database as a Target in Data FlowSummary: I'm using Oracle Data Integration and creating a simple data flow for converting a JSON file (stored in storage bucket) to a specific DB table. When using the D…
-
How to configure CLI to control objects in OCI Object StorageSummary: I have a requirement to upload the EPM backup files from file server to object storage via ODI. I am able to upload the file to object storage via uploadobjects…
-
OCI Data Integrator - Unable to output to Object StorageSummary: My Data Flow has a target with Data Asset being Object Storage. I'm unable to validate this as it keeps throwing the following error. "The name of Data Entity t…
-
Is there a way to use Object Storage logical folders while using the "LKM BICC to ADW Copy" ?Summary: Currently we are building data warehouse using Fusion saas data. We are using BICC for data extraction and ODI to consume the BICC extracts. We are using "LKM B… -
How to Configure microsoft 365 Email for sending emails via ODI - Missing OptionsSummary: We have ODI 12.2.1.4.0 on prem ODI And how are we supposed to use Microsoft 365 EMail exchange for sending emails. Content (required): Microsoft 365 email authe…
-
JNPE error with Reusable Mapping ComponentSummary: Mappings having reusable mapping components throw a fatal validation error: JNPE at ReusableMappingComponent.findrmcattributeforsignatureattribute. Please check…
-
BICC - Does BICC have the abiity to identify purged data?Summary: We'd like to incorporate BICC for data extraction where possible but I have not seen that BICC can handle purged data. For example, if there is a cancelled work…
-
Invalid credentials for supervisor password after ODI Web configurationSummary: Configured ODI Web Stack with ATP database and getting invalid credentials even after using the password configured during data repository configuration Content…
-
Getting provisioning message for ODI Web EditionSummary: I am getting Provisioning and below message every time I open data transformations screen to launch Web ODI screen The requested resource is currently unavailab…
-
Oracle Integration Cloud and ADPSummary: Hello everyone, Is it possible to build an OIC integration to ADP? Are there connectors in OIC for ADP? Thank you in advance for your help. Content (required): …
-
How to send Email using "Azure Communication Services"Summary: Customer is asking to utilize Azure Communication services to send Emails from OAS (via agents). Azure communication services uses only a connection string and …
-
Creating Part of file while sFTP file transfer is in progress.Summary Part files while file transfer is in process in paaS(MFT and DBCS)Content Hi All, Unlike we have a sFTP feature in HCM SaaS, where you can select an option to cr…Mohd Shahnawaz Mohd Merajuddin-Oracle 34 views 1 comment 0 points Most recent by Bindu Dasharath-Oracle
-
Can OCI Data Integration connect with "Azure Data Lake GEN2"Summary: Hi All, Can anyone help to let me know if OCI Data Integration can connect with "Azure Data Lake Gen2" or in general terms "Azure Cloud DB GEN2"? Content (requi…
-
recommendation for the VM of the ODI on Market PlaceSummary: Dear All Do you have any recommendation for the VM of the ODI on Market Place, please ? OCPUs, RAM, Disk etc. Content (required): Recommendation for the VM of t… -
Unable to start ODI instanceSummary: I'm not able start my ODI instance from terminal suddenly. earlier i used to start from here and access ODI studio. Content (required): Version (include the ver…
-
Is there any way to call multiple Load Plans from different servers and agents one after another?Summary: Is there any way to call multiple Load Plans from different servers and agents one after another? Content (required): We are having a requirement like to call m… -
Connecting Oracle Golden Gate Cloud Instance to Oracle Fusion Cloud(ERP/HCM) DATABASESummary: Data Replication from Oracle Fusion Cloud(ERP/HCM) DATABASE to Oracle Autonomous Data Warehouse Content (required): How can we leverage Oracle Cloud Golden Gate…