Define Fields

Use Application Composer to extend your applications by adding new fields to both standard or custom objects. The fields that you add to an object are custom fields.

When creating a custom field, Application Composer provides a set of field types that you can choose from. For example, you can create a check box field, or create a long text field.

View an Object's Fields

Note: An object can have a maximum of 625 fields. For more information on the number of field types per object, see the "Field Types and Field Properties" topic in this guide.

1. Navigate to Application Composer from the Configuration category in the Navigator.

2. Expand the object that you want to add custom fields to.

3. Select the Fields node to navigate to the Fields page.

   Click the Standard Fields or Custom Fields tabs to view the standard or custom fields available for the object.

   • On the Standard Fields tab:

     Review the list of standard fields that are delivered for an object, and optionally modify the display label and help text for a field.

     The list of standard fields includes all the fields that are delivered by Oracle for an object, as well as system fields, which could include:

     • CreatedBy

     • CreationDate

     • Id

     • LastUpdateDate

     • LastUpdatedBy

     • RecordName

     Note: The custom objects that you create also contain these same system fields, among others.

   • On the Custom Fields tab:

     Review the list of custom fields that you created specifically for your implementation, and create new custom fields.

Add Fields to Objects

To create a custom field:

1. Confirm that you're in a sandbox session, before making any application changes.

2. In Application Composer, select the object that you want to make changes to, then select the object's Fields node.

3. On the Custom Fields tab, click New.

   Application Composer provides a set of field types that you can choose from when creating new fields:

   • Check box

   • Currency

   • Date

   • Datetime

   • Dynamic choice list

   • Fixed choice list

   • Formula

   • Long text

   • Number

   • Percentage

   • Record Type

   • Text

4. Select the type of field you want to create, and then specify the required field attributes to create the custom field.

5. After you create custom fields, you must expose those fields on the right user interface pages, before your end users can see them. See Modify Application Pages Using Application Composer.

When you create custom fields for objects and expose the fields on desktop pages, Application Composer automatically creates all the underlying object artifacts for you, and provides full Web service support for those new fields, as well. Application Composer also makes it easy to enable your object model extensions for importing and exporting.

Note: When you create a new field, its value takes effect only for new records. You must update any records that existed prior to the creation of the new field. You can use Import and Export Management to do so. See Import and Export Custom Objects in this chapter.

Delete Fields

You can delete custom fields from both custom and standard objects if you don't need them, as long as your sandbox is still unpublished.

To delete a field:

1. Make sure that you're in an unpublished sandbox.

2. Select the Fields node of the custom or standard object whose field you want to delete.

3. On the Fields page, select the field you want to delete and click the delete icon.

Note: Before deleting a field, make sure to first remove the field manually if it was used in any BI reports, Outlook, Copy Maps, Data Quality Rules, or Oracle CX Cloud Mobile.