2900425 - SLT replication from Oracle fails with ORA-01031: insufficient privileges - SAP Landscape Transformation Replication Server

• SLT replication of Oracle table fails.
• LTRC > Application Logs shows the error:
      Failed to create logging table /1CADMC/00000XXX for table NODE
      Database connection: XXXX
      SQL code: 1.031
      SQL message: con=4(IPADDRESS:1521/DATABASE): ORA-01031: insufficient privileges
  
  SM21 search for ORA-01031:
      CREATE OR REPLACE FUNCTION IOV /*VERS1*/ (L IN NUMBER,V IN NUMBER) RETURN NUMBER IS $IF DBMS_DB_VERSION.VERSION>11 $THEN
      ...
      e: OCIStmtExecute() failed with -1=OCI_ERROR, SQL error 1031:
      ORA-01031: insufficient privileges
      Creating function IOV failed with SQL error 1031
      ORA-01031: insufficient privileges
      SQL function RTRIM2 does not exist (orc=1403).
      SQL function CONCAT3 does not exist (orc=1403).
• Failed to create synonym
  ORA-01031: insufficient privileges

• SAP Landscape Transformation Replication Server
• Oracle source

Oracle, source, database, ORA-01031, insufficient privileges , KBA , HAN-DP-LTR , Use CA-LT-SLT instead , Problem