E-AD: App Designer Does Not Generate Build SQL Script After Editing Field Property. (Doc ID 2914171.1)

Last updated on DECEMBER 12, 2022

Applies to:

Symptoms

Cannot get the correct SQL script generated in Application Designer for the Record to drop the Not Null constraint on the Field in the Database.

Steps to Replicate:
1. Login to Application Designer.
2. Create a Record with one of the field's property as 'Required' and Build it. The field constraint gets set to “Not Null” in the Database.
3. Change the Record Field property to accept null values by unchecking the 'Required' checkbox.              
4. Attempt to “Build” the Record again via App Designer.

The new SQL script is blank, has 0 byte size, and the "Not Null" constraint is still there in the Database.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.