2839935 - Insufficient privileges error when replicating any tables - SLT

• Failed to create triggers for table <table name> with logging table <logging table name>
  RFC destination: <RFC connection name to source ABAP system>
  Database connection: R/3*
  ORA-01031: insufficient privileges
  SQL statement:  CREATE OR REPLACE TRIGGER "XXXX" AFTER UPDATE ON <schema_name>."<table_name>" REFERENCING NEW AS NEW OLD AS OLD F
  HEN IF ( :NEW."<key_field_name1>" <> :OLD."<key_field_name1>"  OR :NEW."<key_field_name2>" <> :OLD."<key_field_name2>" ) THEN BEGIN select "SEQ_/1CADMC/XXXX".NEXTVAL into
  " , "IUUC_TIMESTAMP" , "IUUC_PROCESSED" , "<key_field_name1>" , "key_field_name2" , "IUUC_OPERAT_FLAG" ) VALUES ( ct_num, to_char(SYS_EXTRACT_UTC(SYST
  elect "SEQ_/1CADMC/XXXX".NEXTVAL into ct_num from dual; INSERT INTO "<schema_name>"."/1CADMC/XXXX"(  "IUUC_SEQUENCE" , "IUUC_T
  LUES ( ct_num, to_char(SYS_EXTRACT_UTC(SYSTIMESTAM P),'YYYYMMDDHH24MISSFF'), 0, :NEW."<key_field_name1>", :NEW."<key_field_name1>",  'I'); END; ELSE BE
  TO "sapsr3"."/1CADMC/xxxx"( "IUUC_SEQUENCE" , "IUUC_TIMESTAMP" , "IUUC_PROCESSED" , "<key_field_name1>" , "<key_field_name2>" , "IUUC_OPERAT_FLAG"
  SFF'), 0, :NEW."<key_field_name1>", :NEW."<key_field_name2>",  'U'); END; END IF; END IF; END;
  PL/SQL: ORA-00942: table or view does not exist

• The source ABAP is installed on Oracle DB.
• Dump in SM21 of source system:

*** ERROR => ORA-01031 occurred at SQL stmt (parse error offset=0) dbsloci.c 13576]
{root-id=0050568A58121ED9B4D87C555BA8A0FF}_{conn-id=CCC5D2E90ED4F15B80FF0050568A5812}_1
Dump statement cache (after SQL error):
sc_p=00000000094D6918,no=199,idc_p=0000000000000000,con=1,act=0,slen=94,smax=256,#vars=0,stmt=000000004E84A410,table=
CREATE SEQUENCE "sapsr3"."SEQ_/1CADMC/00002155" START WITH 1 INCREMENT BY 1 CACHE 1000 ORDER ;
statement (len=94) for table ' ':
CREATE SEQUENCE "sapsr3"."SEQ_/1CADMC/00002155" START WITH 1 INCREMENT BY 1 CACHE 1000 ORDER
exec_immediate() -> orc=1031, 99=DBSL_ERR_DB
head_p=00000000023F7840, cid=0: dbsl err=99=DBSL_ERR_DB-> dbds err=1=DS_SQLERR,dbdsoci.c:1011
*** ERROR => ^^ Ds_exec_imm() -> err=1=DS_SQLERR dbdsoci.c 1024]
{root-id=0050568A58121ED9B4D87C555BA8A0FF}_{conn-id=CCC5D2E90ED4F15B80FF0050568A5812}_1
***LOG BY2=> sql error 1031 performing EXE [dbds 578]
***LOG BY0=> ORA-01031: insufficient privileges [dbds 578]
***LOG BY1=> sql error 1031 [dbacds 1843]
dbcon[db_con_disconnect]: disconnecting from connection 1 ...

SAP Landscape Transformation replication server

permission, authentication, authorization, ORA-01031: insufficient privileges , KBA , CA-LT-SLT , SAP Landscape Transformation Replication Server (SLT) , Problem