Generate a Unique Reference Fast Formula

You need to set up a fast formula to generate unique reference from the database sequence.

Note: My Client Groups > Show More > Fast Formulas

1. Create a new fast formula.
2. Enter the fields as shown below:

   Field	Value
   Legislative Data Group	Select the required LDG
   Formula Name	Get Unique Reference Code from DB Sequence
   Type	Element Input Validation
   Effective As-of Date	Enter the relevant date

3. The formula text should be as described here:

   FORMULA NAME: Get Unique Reference Code from DB Sequence
   FORMULA TYPE: Element Input Validation
   DESCRIPTION : A formula that returns the next value of the reference code. The reference
   code is generated using a database sequence
   ***********************************************************************/
   
   inputs are Unique_Reference(text)
   
   l_rc = GET_REF_CODE_FROM_DB_SEQ()
   Unique_Reference = to_char(l_rc)
   
   return Unique_Reference