EBS Customizations (MOSC)

MOSC Banner

validat

I am having a problem validating PO promised date in Oracle forms personalization . I am using EBS 12.1.3

I am trying ensure the PO promise date is not less than the PO creation date, but I keep getting an error 'not a valid month'.

:PO_LINES.PROMISED_DATE is null    OR
(to_date(:PO_LINES.CREATION_DATE, 'MM-DD-YYYY HH24:MI:SS') > to_Date(:PO_LINES.PROMISED_DATE,'MM-DD-YYYY HH24:MI:SS')
AND :SYSTEM.RECORD_STATUS = 'INSERT')
or (to_date(:PO_LINES.PROMISED_DATE, 'MM-DD-YYYY HH24:MI:SS') < trunc(sysdate)  AND :SYSTEM.RECORD_STATUS = 'CHANGED')

but keep getting not a valid month error ORA-01843

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