Cloud
Discussion List
-
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…
-
Is there a historical data store or PVO for Person Email Address?Summary: PVO for Person Email Address is not retrieving historical and future dated records. Content (required): I am not able to find a historical PVO for Person Email …
-
Is there a historical data store or PVO for Person Address?Summary: PVO for Person Address are not retrieving historical and future dated records. Content (required): I am not able to find a historical PVO for Person Address. Av…
-
Is there a historical data store or PVO for Person Phone?Summary: PVO for Person Phone are not retrieving historical and future dated records. Content (required): I am not able to find a historical PVO for Person Phone. Availa…
-
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…
-
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…
-
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 Data Integration
-
DB link feature works between On-Prem Oracle DB to Oracle ADW?Summary: We need to create a DB link between On-Prem database and Cloud (ADW) database, is there any specific steps we need to taken care before doing this? Or Could you…Bapiraju Swamy Vuda-Oracle 151 views 2 comments 2 points Most recent by Bapiraju Swamy Vuda-Oracle Data Integration -
Is on-prem ODI 12.2.1.3 needs to be upgraded to latest version 12.2.1.4 before migrating to Cloud?Summary: Hi Team, Customer is planning to migrate entire DWH to Oracle cloud. Currently we are using ODI 12.2.1.3 & Oracle 19c DB in an on-prem environment. I need to un…Shaik Gousimiya-Oracle 111 views 6 comments 8 points Most recent by Shaik Gousimiya-Oracle Data Integration -
PLS-00172: string literal too long while loading BICC PVO data using ODI MarketplaceSummary: We are trying to load data from Fusion BIACM JournalEntryLinePVO into ADW using ODI-Marketplace. This Job fails with below error. ERROR ----------- ODI-1590: Th…Sahithi Kolasani-Oracle 92 views 3 comments 0 points Most recent by Sahithi Kolasani-Oracle Data Integration -
Unable to load BICC PVO using ODI-MSummary: Recently we are coming across the following error randomly for some of the PVOs. ODI-1590: The execution of the script failed. Caused By: javax.script.ScriptExc…Sahithi Kolasani-Oracle 32 views 0 comments 0 points Started by Sahithi Kolasani-Oracle Data Integration
-
Triggering FCCS Data Management Job from ODISummary: Trigger Data Management job and extract data files from FCCS to ODI/ADW. Content (required): We are able invoke REST API GET and POST Methods from Soap and trig… -
Function strange behavior when invoked via API gatewaySummary: The function behavior is not consistent when I invoke it via API gateway. i have function that merges pdf and writes the merged file to a ftp location. When i t…
-
Truncate the Data size to avoid "ORA-12899: value too large for column" in ODISummary: We have a source a file that has more than 4000 char in one column and we trying to load data in ADW but the maximum varchar2 character limit is 4000 char only … -
Data Entity doesn't load data through Fusion Data AssetSummary: It was creating a Fusion Data Asset and configured the Oracle Business Intelligence Cloud Connector Console. The connections are work fine, but when create a da…
-
Setting prune time for a PVO extraction using Fusion BICCCSummary: We need to extract Fusion PVO data using BICCC job. We will be creating a job in Fusion BIACM and trigger that job from ODI and load data into ADW. We have a re…Sahithi Kolasani-Oracle 11 views 0 comments 1 point Started by Sahithi Kolasani-Oracle Data Integration
-
Improve productivity with Oracle Cloud Infrastructure Data Integration’s latest release - Nov 5 2021New blog about OCI Data Integration’s newly released: https://blogs.oracle.com/cloud-infrastructure/post/new-oci-data-integration-release-adds-support-for-hierarchical-d…
-
How do you add a supervisor to a worker using HSDL?Summary: Currently unable to assign supervisor to newly created workers with HSDL. Can anyone provide an example template? Content (required): Can anyone provide an HSDL…
-
Oracle Fusion to Google Cloud BigQueryContent Our DW is Google Cloud BigQuery, and we are exploring ways in which we could push Oracle Fusion data to Google Cloud BigQuery in most cost effective and efficien… -
connecting the OCI DB from the Autonomous WarehouseContent Client is implementing a ADW on cloud. Scenario is as follows: 1. Source: DB available on cloud (node#2) 2. Target: ADW is available on cloud (node#3) 3. ODI ins…Rehan Ahmed Khan-Oracle 16 views 2 comments 0 points Most recent by Anubhav Bhardwaj Data Integration
-
Improve productivity with Oracle Cloud Infrastructure Data Integration’s latest releaseContent New blog about OCI Data Integration’s newly released: https://blogs.oracle.com/cloud-infrastructure/post/improve-productivity-with-oci-data-integrations-latest-r…Aditya Duvuri-Oracle 16 views 0 comments 2 points Most recent by Aditya Duvuri-Oracle Data Integration
-
Fast-track data discovery with new release of Oracle Cloud Infrastructure Data CatalogContent We’re excited to announce a new release of Oracle Cloud Infrastructure (OCI) Data Catalog. In this release, we accelerate the cataloging of your data by automati…
-
New Oracle Cloud Infrastructure Data Integration release adds pipelines and orchestrationContent We're excited to announce a new release of Oracle Cloud Infrastructure Data Integration. This release adds new transformations, connectors, and two of the most h…
-
New release of Oracle Cloud Infrastructure Data Integration adds connectivity to Oracle Fusion AppliContent New blog about OCI Data Integration’s newly released connectivity to Oracle Fusion Applications: https://blogs.oracle.com/cloud-infrastructure/load-and-transform…
-
Define a specific procedure in Oracle Cloud Infrastructure Data Integration data flowSummary How to define a specific SQL procedure in Oracle Cloud Infrastructure Data IntegrationContent Hi, we are evaluating latest OCI DI version. While trying to replic… -
New Oracle Cloud Infrastructure Data Integration release focuses on connectivity and transformationsContent We're excited to announce a new release of Oracle Cloud Infrastructure Data Integration. This release expands connectivity options, transformation capabilities, …
-
New OCI Data Catalog release introduces AI and ML-based features for better productivityContent We’re excited to announce a new release of Oracle Cloud Infrastructure (OCI) Data Catalog. In this release, we have added many productivity improvements to help …
-
Using Oracle Cloud Infrastructure Data Integration with MySQL Database Service and HeatwaveContent Virtually all data types from any data source can be integrated into the MySQL Database Service and HeatWave. When you need to collect data from diverse sources …