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 ?