The OAC REST API endpoint PUT /api/{version}/catalog/connections/{connectionId} supports updating credentials for connection types Oracle_ADW, Oracle_ATP, and Oracle_DB, but returns an error for FA, OTBI, and oracleepmcloud connection types: "Failed to update the connection. Invalid connection type. Details: Failed to get translate the type: FA"
Requested Enhancement:
Extend the OAC Connections REST API to support credential updates (username/password) for all connection types, including:
- FA (Fusion Applications / OTBI)
- oracleepmcloud (EPM Cloud - EPBCS, EDMCS, etc.)
The API should allow the same operation that works for ADW/ATP/DB connections to also work for FA and EPM connections.
Business Justification:
We automate credential rotation for OAC connections via CI/CD pipelines. Currently, ADW/ATP/DB connections can be rotated programmatically, but FA/OTBI and EPM connections require manual intervention through the OAC UI. This creates:
- Security risk from delayed password rotations
- Operational overhead requiring manual steps during credential rotation cycles
- Inconsistency in automation coverage across connection types
Environment:
- OAC instance on OCI (Gen2)
- API version: 20210901
- Regions affected: All (tested in us-ashburn-1 and us-phoenix-1)
