The script from the Oracle Integration, SCRI.MK_CCB_JOBS fails to import jobs. The following error is seen in the details:
U02012033 Query could not be executed: 'ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at line 1 (Client : Client# Object: Ah_idnr='######'/Otyp='SCRI'/Name='SCRI.MK_CCB_JOBS', Line '00050', Variable: 'VARA_SEC_SQL_GET_CCB_JOB_HEADER')'
The description for the imported Oracle job is too long for the VARA object, and it throws the mentioned error.
There are two resolutions:
-If the Oracle job is a custom job and the description can be shortened, then shorten the description and then try to import.
-Contact support to receive updated Oracle Integration files that can account for longer descriptions.