Error Message

A user is unable to create a public enquiry on the system as the created date
does not populate and is grayed out. On saving enquiry the error message
appears: ORA-01400 cannot insert Null Into DOC_DATE_ISSUED.

Explanation

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).

How to Avoid

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 DUAL
WHERE 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 DUAL
WHERE NOT EXISTS (SELECT 1 FROM HIG_OPTION_VALUES
                   WHERE HOV_ID = 'ENQRECDATE');