1. Configuring Applications Using Application Composer
  2. Custom Object Public Unique IDs

Custom Object Public Unique IDs

When users create records in the database, the applications use document sequencing to generate a unique ID for each business object record. Understandably, these numbers aren't easy to read or use because of their length and complexity.

To overcome the issue of long IDs, you can set up the applications to make these IDs more user-friendly and readable. This user-friendly value is called the public unique ID (PUID). Custom object PUID values are stored in the Record Number (RECORD_NUMBER) field.

You can accept the default format of a PUID wherein the application automatically generates a unique 15-digit numeric ID for each record. Or, you can change the PUID format using the basic or advanced setup. For custom objects, Oracle recommends that you follow the advanced setup. For each custom object that you define, set a prefix so that new PUID values are unique and don't conflict with other data that might have been previously imported or part of any planned future imports. This will prevent PUIDs automatically generated during import from overlapping with PUIDs automatically generated for records created in the UI or via REST.

To configure the prefix for each custom object's PUID format:

  1. Sign in as a setup user.

  2. In Setup and Maintenance, go to the following:

    • Offering: Sales

    • Functional Area: Sales Foundation

    • Task: Manage Public Unique Identifier Sequence Generation

  3. On the Manage Public Unique Identifier Sequence Generation page, if you're configuring these values for the first time, add a row to the table.

  4. In the Object list of values, select the object for which you're configuring the public unique ID.

  5. In the Radix list of values, select the base numbering to use. This list of possible radix values is the same list of values that are provided in the ZCA_PUID_RADIX profile option.

  6. In the Prefix box, enter the prefix you want to use for the object and unique ID.

    • Enter a maximum of five characters. For example, if your custom object is TroubleTicket_c, then enter TICK_.

    • The allowed characters are: 0-9, A-Z, a-z, and these special characters: period, hyphen, comma, and underscore.

  7. Repeat for all other custom objects.

  8. Click Save and Close.

For more information about the setup for PUIDs, see Overview of Public Unique IDs, Implementing Sales guide.

Related Topics