Application engine sql and ORA-01858

Peopletools: 8.57.06

I'm running the sql statement below outside of peoplesoft and I got over 800 rows returned. When I run the sql in application engine I recieve ORA-01858 -  a non-numeric character was found where a numeric was expected. I have tried %dateout and %datein, without any success in application engine sql. How do I get application engine sql to run on an Oracle database with a hard coded date?

Sql:

SELECT X.TO_VALUE_STR50 

 , 'US' 

 , 'USD' 

 , 'REGULAR_BONUS_PAYMENT_ELECTION_RULE' 

 , ROW_NUMBER() OVER (PARTITION BY d.emplid 

 ORDER BY d.emplid) 

 , 'DIRECT_DEPOSIT' 

 , 'US' 

 , 'USD' 

 ,CASE D.ACCOUNT_TYPE WHEN 'C' THEN 'Checking' WHEN 'S' THEN 'Savings' END