Oracle Fusion HCM Analytics

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

FAW -- Invalid credential name

Received Response
31
Views
2
Comments
Vasanthakumar Ravi
Vasanthakumar Ravi Rank 3 - Community Apprentice

Hi All,

We are running the below sql query in OAC BI publisher and getting 'Invalid credential name'. Please share your input if you have faced similer issue.

SQL Query

=======================================

select *
from dbms_cloud.list_objects(
'XX_DATA_STORE.XX_STORAGE_CREDENTIALS',
'https://objectstorage.uk-london-1.oraclecloud.com/n/{my-namespace}/b/ob-bucket/o/');

Error Message

========================================

Invalid credential name - XX_DATA_STORE.XX_STORAGE_CREDENTIALS ORA-06512: at "C##CLOUD$SERVICE.DBMS_CLOUD$PDBCS_240425_1", line 2060 ORA-06512: at "C##CLOUD$SERVICE.DBMS_CLOUD$PDBCS_240425_1", line 12567 ORA-06512: at line 1

Answers