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
-
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…
-
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…
-
Integration UsecaseSummary On Prem DB to SaaS IntegrationContent Dear Experts, We are evaluating PaaS offerings to implement the following Integration use case : Integrate transactional da…
-
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…
-
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…
-
Calling OCI Function From ODISummary: HI Team, Can we call a Rest API generated from OCI from ODI 12c? If yes, then please provide us the steps. Content (required): Version (include the version you …
-
manifest fileSummary: Uploading a manifest file in Data Asset Content (required): I'm attempting to construct Data Asset for a demonstration, and I need to use an REST API to fetch d…
-
Getting error while start and stop of the odiAgentSummary: Not able to start ODI Agents scripts used for Agent Start sudo systemctl start agentodi.service Content (required): This is the current status of the agent: age… -
Is Effective Date Disabled checkbox shared to all offerings?Summary: Effective Date Disabled checkbox is selected to other offerings too when I only enabled it on the offering I have created. Content (required): When I tried to s…
-
Performing selecting query in DB2 adaptor using OIC is erroring out.Summary: Performing selecting query in DB2 adaptor using OIC is erroring out. Performing an operation on a table. operation = select query is giving below Error Message …
-
Error while installing ODI in window m/c Error message : The permanent log directory is unknownWhile installing ODI on local machine in Window m/c getting error message : :::::::::::::::::::::::::::: at oracle.as.install.engine.InstallEngine.startOperation(Install…
-
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…
-
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…