Issues with Oracle Regexp_Replace and Regex_Substr

[Rschult1]

I am having issues with my input step not recognizing my case statements or my regexp_replace / regexp_substr functions. How can I get this to work in Alteryx? 

REGEXP_REPLACE(
case when PROJ_COST_LINE.x_expenditure_item_desc like '%POL-%' then

regexp_replace(regexp_substr(PROJ_COST_LINE.x_expenditure_item_desc,
'(E-)([[:digit:]]{6,7})', 1,1,NULL),'[^0-9]','')
else

null

end,'[^[:digit:]]','')as "Engagement Number",

REGEXP_REPLACE(
case when PROJ_COST_LINE.x_expenditure_item_desc like '%POL-%' then

regexp_replace(regexp_substr(PROJ_COST_LINE.x_expenditure_item_desc,
'\POL-([0-9]+)', 1,1,NULL),'[^0-9]','')
else

null

end,'[^[:digit:]]','') as "PO Line Item Number"

[Felipe_Ribeir0]

Does this statement works on the Oracle interface?

[Rschult1]

Yes. This statement works with no issue in Oracle SQL developer.