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 18.104.22.168.211011 and later
Oracle Data Integrator - Version 22.214.171.124.211011 and later
Information in this document applies to any platform.
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:
- Have several mappings / ETL loading data from BICC
- Schedule the ETL
- Notice that the error occurs randomly, and other times the same session succeeds
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!