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