You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Having issue while running a report from OIC using ATPDB table having date parameter

Hello,

I am attempting to run a scheduled integration that executes an SQL query with a date input parameter. I am currently providing the date in the "YYYY-MM-DD" format; however, I am encountering the following error:

"Pure SQL Exception; Caused by java.sql.SQLDataException: ORA-01861: literal does not match format string."

Could you please advise on the correct way to format or pass the date parameter to resolve this issue?

Thank you in advance for your assistance.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!