My Oracle Support Banner

ODI to BICC Fails with "ORA-20004: Credential "<SCHEMA_NAME>"."ATCS_OCI_CREDENTIAL" does not exist ORA-06512" (Doc ID 2855995.1)

Last updated on MARCH 03, 2023

Applies to:

Oracle Data Integrator on Marketplace - Version 12.2.1.4.211011 and later
Oracle Data Integrator - Version 12.2.1.4.211011 and later
Information in this document applies to any platform.

Symptoms

A data load using Oracle Data Integrator (ODI) from Oracle Business Intelligence Cloud Connector (BICC) fails randomly with the following error:

There are several packages and load plans with mappings that are loading data from BICC located on ADW. .


The issue can be reproduced at will with the following steps:

  1. Have several mappings / ETL loading data from BICC
  2. Schedule the ETL
  3. Notice that the error occurs randomly, and other times the same session succeeds

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.