Editing, Copying and Deleting List Records

The following describes the available options and procedures when you are viewing list records, check one or more records, and click Edit. This opens a page where you can edit records.

Note: Displayed fields include system-defined fields (all ending with an underscore character), as well as your custom-defined fields. Some system field values can’t be accessed or altered, for example: CREATED_DATE_.

Editing List Records

From the List records editing page, use the following procedure to edit one or more selected (checked) customer records/values.

  1. After entering or changing field values, click Save.
  2. If needed, you may edit additional customer records.

    Note: If you check more than one record, click Next to move from one record to the next for editing. To retain your changes, click Save after finalizing each record.

  3. When finished, click Done and review your new entries.
  4. While on this page, you may also copy and delete List records. See below for details.

Copying List Records

To copying and create a new customer record, use the same procedure as you do to edit a List record, but click Copy on the editing page before making changes to the selected record.

Deleting List Records

There are several ways to delete one or more customer records from a List.

Note: You will be prompted to confirm your request before any deletion completes.

Deleting Records Using the View Records Page

Click Delete in the View and Edit Data page to permanently remove all checked records in your List.

Note: Only one page of records can be deleted at a time. To delete checked records spanning over pages, either expand your number of Lines per Page count, or use the find records option to refine your total number of selected and displayed records (described below).

Using Find Records with Delete Option

To simplify and refine the records you want to delete, use this procedure.

  1. Click Find or Find Record where appropriate.
  2. After you enter the field value(s) to search on, the affected List records are displayed in the View and Edit Data page.

    Note: To search for a timestamp value, use format: yyyy-mm-dd hh:mm:ss.000 (Ending values are zeroes.)

  3. Click Delete.
  4. To reset your page display and return to displaying all records on your List, repeat the Find procedure, but leave all field values blank.

Delete Records Using the List Records Editing Page

  1. In the View and Edit Data page, check the records you want to edit, copy, or delete.
  2. As an individual record is displayed, click Delete to permanently remove that record from your List after confirming your request.
  3. Click Save after each deletion, and click Done when finished.

Deleting Lists

To delete an entire list, please log in to My Oracle Support and create a service request.

Learn more