It's All About the Platform.

  • January 30, 2018

Using the Public Unique Identifier (PUID)

Richard Bingham
Senior Development Manager

This document sequencing feature allows you to configure a uniquely identifiable field on your Oracle Sales Cloud business objects. You can specify both a fixed prefix and a number/character system (or radix).

PUID is a configuration which applies to existing fields, and without PUID setup these are already populated with a unique 15 digit numerical value. Example fields are ActivityNumber, OpportunityNumber and PartyNumber (for Accounts). This value can now be configured using a PUID to help support specific business requirements. There are two ways to set this up.

Common Setup

Two Profile Options can be set to default values for prefix and radix. These are accessible using the Setup and Maintenance task 'Manage Public Unique Identifier Profile Options' as shown below.

The values set here apply the same for ALL objects with a PUID field. The prefix is simply a text string. The radix lists a set of value patterns you can use.

For more details on the Radix value options take a look at the example tables in this documentation page. Interestingly the radix list comes from lookup ZCA_PUID_ENCODING which could be extended by adding your own Lookup-Type entry and all the associated Lookup-Code values.

Business Object Setup

If you wish to have a PUID configuration for a specific Business Object, then you can use the Setup and Maintenance task "Manage Public Unique Identifier Sequence Generation". As you can see below, once you select a Business Object you can then define the values it will use. These will supersede the Profile Options defaults mentioned above.



First I have created a PUID Sequence definition for the Opportunity object.

As shown below, the Opportunity Number field now has a value based on the settings above.

Coming Soon

In Release 13 the support for PUID is extended to each one of your Custom Objects. This is done through the addition of a Record Number standard field, whose values are set using the exact same configurations discussed above.

Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.