Payroll for NA / Time and Labor - PSFT (MOSC)

MOSC Banner

Invalid character error when testing CTX905DP SQR for Dental Care Act

Hi,

I am testing the new SQR by also testing for the first time and learning Group Build. After troubleshooting the setups , created a group build using a query etc.. when the JOB get to the CTX905PD sqr step, I get this error message.


04-JAN-2024_02:30:49.000000_PM


Loading Canadian Dental Eligibility Data

(SQR 5528) ORACLE OCIStmtExecute error 1858 in cursor 4:
   ORA-01858: Caractère non numérique trouvé à la place d'un caractère numérique

Error on line 240:
   (SQR 3723) Problem executing cursor.

SQR for PeopleSoft: Program Aborting.

Non numerical character found instead of a numerical character.


Any idea where I should look at to resolve issues on our side ?

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