PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

Application engine sql and ORA-01858

edited Jun 22, 2023 7:08PM in PeopleTools and Lifecycle Management - PSFT (MOSC) 4 commentsAnswered ✓

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 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center