Oracle Integration job fails

Document ID : KB000096829
Last Modified Date : 17/05/2018
Show Technical Document Details
Issue:
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')'
Cause:
The description for the imported Oracle job is too long for the VARA object, and it throws the mentioned error. 
Resolution:
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. 

OR

-Contact support to receive updated Oracle Integration files that can account for longer descriptions.