A user is unable to create a public enquiry on the system as the created datedoes not populate and is grayed out. On saving enquiry the error messageappears: ORA-01400 cannot insert Null Into DOC_DATE_ISSUED.
If
a) the version of PEM (DOC0150) form (open PEM form and go Help>About Current Form) is 5.4.1.0 as below
and
b) The ENQVALIDATE option doesn’t exist within Product Options.
then Fix 4 for enquiries wasn't correctly applied (form was copied but sql scripts weren’t run).
Connect as Highways owner to your database and run scripts below.
INSERT INTO HIG_OPTION_LIST (HOL_ID ,HOL_PRODUCT ,HOL_NAME ,HOL_REMARKS ,HOL_DOMAIN ,HOL_DATATYPE ,HOL_MIXED_CASE ,HOL_USER_OPTION )SELECT 'ENQRECDATE' ,'ENQ' ,'Date Recorded' ,'Set to Y to set Date Recorded when Enquiry first saved, set to N to set Recorded Date on system population of Enquiry Id(Default)' ,'' ,'VARCHAR2' ,'N' ,'N' FROM DUALWHERE NOT EXISTS (SELECT 1 FROM HIG_OPTION_LIST WHERE HOL_ID = 'ENQRECDATE');
--
INSERT INTO HIG_OPTION_VALUES (HOV_ID ,HOV_VALUE )SELECT 'ENQRECDATE' ,'N' FROM DUALWHERE NOT EXISTS (SELECT 1 FROM HIG_OPTION_VALUES WHERE HOV_ID = 'ENQRECDATE');