We are running SAP RDS JOB to populate MGMT_NUMBER_RANGES table .
Sorry that my previous post was not clear.
It fails because of this issue.
|Data flow DF_DM_ObjectNumbering_SAPToApp|Reader NUMBER_RANGES_NRIV3
SQL submitted to Oracle Server resulted in error <ORA-12704: character set mismatch >. The SQL submitted is <SELECT ( ((CASE WHEN ( “NUMBER_RANGES_NRIV”.“NUMBER_RANGE_NUMBER” <> ‘’) THEN “NUMBER_RANGES_NRIV”.“NUMBER_RANGE_NUMBER” ELSE CAST ( NULL AS NVARCHAR2(256)) END) ) ) , ( ((CASE WHEN ( “NUMBER_RANGES_NRIV”.“FROMNUMBER” <> ‘’)
THEN “NUMBER_RANGES_NRIV”.“FROMNUMBER”
ELSE CAST ( NULL AS NVARCHAR2(256)) END) ) ) , ( ((CASE WHEN ( “NUMBER_RANGES_NRIV”.“TONUMBER” <> ‘’)
THEN “NUMBER_RANGES_NRIV”.“TONUMBER”
ELSE CAST ( NULL AS NVARCHAR2(256)) END) ) ) , “NUMBER_RANGES_NRIV”.“NUMBER_RANGE_NUMBER” ,
“NUMBER_RANGES_NRIV”.“EXTERNIND”
FROM “DM_STG_MGMT_LKP_ERP”.“NUMBER_RANGES_NRIV” “NUMBER_RANGES_NRIV”
WHERE ( “NUMBER_RANGES_NRIV”.“OBJECT” = ‘RP_PREL’)
Thanks in advance for your help
sampaul4129 (BOB member since 2014-07-25)