Cloud
Discussion List
-
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 35 views 1 comment 0 points Most recent by Bindu Dasharath-Oracle Data Integration
-
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… -
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 91 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 31 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 …
-
Security Exception in SOACSSummary Security Exception in SOACSContent You receive an exception message: "java.security.cert.CertPathValidatorException: Path does not chain with any of the trust an…
-
DBCS - Cloud Data from Saas REST APISummary Can we invoke SAAS REST API from DBCS db objectContent Is there an option that we can invoke REST API call in DBCS? Is it possible to get data from SAAS cloud ap…Sridevi K-Oracle 18 views 3 comments 0 points Most recent by Nitin Srivastava-192281 Data Integration
-
ATP repository connection in ODI CSSummary How to connect ATP repository in ODI CSContent Hi Team, I have provisioned ODI MP Image with ATP to store the repository, but when I launch the odi studio and co… -
API end-points for AccountsSummary Are there REST APIs available to get Account Groups, Account Segment values and Account Combinations?Content I am investigating REST APIs for Oracle Financials C…
-
ODI RCU repository creation in ATPSummary How to create odi repositories in ATPContent Hi Team, I want to create ODI repository schemas in ATP DB , But it is not allowing with Admin user as it needs SYS …