Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Oracle E-Business Suite R12.x HRMS : A Functionality Guide

You're reading from   Oracle E-Business Suite R12.x HRMS : A Functionality Guide Design, implement, and build an entire end-to-end HR management infrastructure with Oracle E-Business Suite

Arrow left icon
Product type Paperback
Published in Jun 2015
Publisher
ISBN-13 9781782177388
Length 222 pages
Edition 1st Edition
Arrow right icon
Author (1):
Arrow left icon
Pravin S Ingawale Pravin S Ingawale
Author Profile Icon Pravin S Ingawale
Pravin S Ingawale
Arrow right icon
View More author details
Toc

Value sets

A value set is a set of values or a collection of values. When a user enters a value for a certain field in Oracle, which can be a report parameter or concurrent program parameter, then it validates the entered value.

Navigate to System Administrator | Application | Validation | Set.

The Format Validation section in the following screenshot will tell us the types of values that are held by the value set. We have selected it as Char, which implies that the value in the value set will be of a type character. You have to select the maximum size the value will have. It can be 10, 20, or 100 as per your requirements.

The Precision field is used if your value set is of the type number. You can set the precision of the number you want to.

Value sets

When you create a value set, you need to select the validation type for the value set as indicated in the preceding screenshot.

These are the following types of validation in a value set:

  • None: This type has no validation
  • Independent: This type has a defined...
lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $19.99/month. Cancel anytime