%CurrentDateTimeIn not converting in CAST(SYSTIMESTAMP AS TIMESTAMP) in insert sql of AE

Hi,

I have used %Currentdatetimein to populate DATETIME_STAMP field in my record .I write code in Application Engine SQL step as below(pseudo code)

INSERT INTO PS_REC1  

 SELECT %OperatorId  

 ,%runcontrol  ,FLAG  

 ,TEXT  

 ,%CurrentDateTimeIn  

 FROM PS_REC2

after running Application engine some time it went to error sue to 'SQL Error: ORA-00947: not enough values ' and some time it went to sucess.

it is observed that environment is not converting ,%CurrentDateTimeIn   in SQL as below

INSERT INTO PS_REC1  SELECT '304220' ,'bcnbnb' FLAG ,TEXT,CAST(SYSTIMESTAMP AS TIMESTAMP)   FROM 

PS_REC2

In Nosucess PI sql is genrated as below(here CAST(SYSTIMESTAMP AS TIMESTAMP)  ):