My Oracle Support Banner

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:

PeopleSoft Enterprise PT PeopleTools - Version 8.50 and later
Information in this document applies to any platform.


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.



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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