Core Concurrent Processing - EBS (MOSC)

MOSC Banner

Custom report ends with error ORA-01840: input value not long enough for date format

R12.1.3

Hello Folks,

 

I have a custom report which a procedure used to insert element for employees based on SIT , and the report parameter is just Date from & Date to

The issue is report was working fine and suddenly ended with error ORA-01840: input value not long enough for date format

The weird thing is we just have a new fresh clone from production and the report ends normally on clone error only in production

Attached the procedure

 

Thanks in advance 


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