1. Configuring Applications Using Application Composer
  2. Define Fields

Define Fields

Use Application Composer to extend your applications by adding new fields to both standard and 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 checkbox field, or create a long text field.

Note: Fields with a display name length greater than 120 characters may cause export to fail. Keep this in mind when creating fields.

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 Field Types and Field Properties.
  1. Navigate to Application Composer from the Configuration category.
  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:

    • Checkbox

    • Currency

    • Date

    • Datetime

    • Dynamic choice list

    • Fixed choice list

    • Formula

    • Long text

    • Number

    • Percentage

    • Record Type

    • Text

      Important:
      • The runtime field length calculation for text fields counts any HTML markup introduced by Rich Text formatting. Make sure that you allow for markup in setting a text field's maximum length.

      • A 1500-character limit applies if the characters are single byte. If the characters are multibyte, such as Japanese or Chinese, then the maximum character limit is 1500 characters divided by the number of bytes per multibyte character. For example, if characters are 2 bytes, then the name is limited to a maximum of 750 characters. If a mix of characters is used, then the maximum sum of character bytes that's supported is 1500.

  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 UI pages, before your end users can see them. For the Redwood UX, this is accomplished in either Oracle Visual Builder Studio or in the CX Extension Generator feature in Application Composer.

    For adding fields to Classic pages, 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.

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.

Related Topics