Value Sets

Overview of Value Sets

 Oracle Application Object Library uses values, value sets and validation tables as important components of key flexfields, descriptive flexfields, and Standard Request Submission. This section helps you understand, use and change values, value sets, and validation tables.

When you first define your flexfields, you choose how many segments you want to use and what order you want them to appear. You also choose how you want to validate each of your segments. The decisions you make affect how you define your value sets and your values.

You define your value sets first, either before or while you define your flexfield segment structures. You typically define your individual values only after your flexfield has been completely defined (and frozen and compiled). Depending on what type of value set you use, you may not need to predefine individual values at all before you can use your flexfield.

You can share value sets among segments in different flexfields, segments in different structures of the same flexfield, and even segments within the same flexfield structure. You can share value sets across key and descriptive flexfields. You can also use value sets for report parameters for your reports that use the Standard Request Submission feature.

Because the conditions you specify for your value sets determine what values you can use with them, you should plan both your values and your value sets at the same time. For example, if your values are 01, 02 instead of 1, 2, you would define the value set with Right-Justify Zero-fill set to Yes.

Remember that different flexfields may have different requirements and restrictions on the values you can use, so you should read information for your specific flexfield as part of your value planning process. For example, the Accounting Flexfield requires that you use certain types of value sets.

Value set options include the following:

• Name
• Description
• List Type
• Security Type

Format options include:

• Format Type
• Maximum Length
• Precision
• Numbers Only?
• Uppercase Only?
• Right-Justify and Zero-Fill Numbers?
• Minimum Value
• Maximum Value

Validation types include:

• Independent
• Dependent
• None
• Table
• Special
• Pair
• Translatable Independent
• Translatable Dependent

Choosing Value Formats

Since a value set is primarily a "container" for your values, you define your value set such that it can control the types of values that are allowed into the value set (whether predefined or non-validated). You can specify the format of your values:​

• Character
• Number
• Time
• Standard Date
• Standard DateTime
• Date
• DateTime
•  
• Warning: Date and DateTime will be obsolete in a future release and are provided for backward compatibility only. For new value sets, use the the format types Standard Date and Standard DateTime.

Few important Value Sets:

Value Set Name	Description	Format Type	MAX SIZE
1 Character	1 Character with no validation	Char	1
1 Number with No validation	1 Number with No validation	Number	1
1 char	1 Character Validation (Please do not define Min/Max Values for this value set)	Char	1
1 char test	1 Character	Char	1
10 Characters	10 Characters free text with no validation	Char	10
10/Number	A 10 digit positive number field with no validation	Number	10
100 Characters	100 Characters	Char	240
100_FREE_CHARACTERS	100_FREE_CHARACTERS	Char	100
11 Characters		Char	11
120 Characters	120 Characters, no validation	Char	120
14 Characters		Char	14
14 Digit Numbers	Value set for India 14 digit numbers	Number	14
15 Characters	15 Characters	Char	15
15 Digit Number		Number	15
15 Number	15 Number	Number	15
150 Characters Optional	150 Characters Optional	Char	150
16 Characters	16 Characters	Char	16
17 chars	17 chars, no validation	Char	17
2 Character	2 Character with Zero Fill	Char	2
2 Characters	2 Characters	Char	2
2 Digits	2 Digit positive number	Number	2
2 Digits(1-99)	1-99	Number	2
20 Characters	20 Characters	Char	20
2003 SIC	Legal Activity Codes for United Kingdom	Char	50
24 Number only		Number	36
240 Characters	240 Characters	Char	240
240 Characters Optional	240 Characters Optional	Char	240
240 char	240 Characters	Char	240
255 Char	255 Char	Char	255
255 char		Char	255
27 Characters	27 Characters, no validation	Char	27
2_Number	Valueset for 2 digit Number	Number	2
2char	2 characters upper case	Char	2
3 Characters		Char	3
3 Digit Numbers	Value Set for Demand Plan Rolling Process	Number	3
3 Digits	3 digit positive number	Number	3
30 Character Optional	30 Character Optional	Char	30
30 Characters	30 Characters, no validation	Char	30
30 Characters Optional	30 Characters Optional	Char	30
30 char		Char	30
35 Chars	35 Alphanumeric Characters,no validation	Char	35
4 Characters	4 Alpha/Numeric characters no validation	Char	4
4 Digits	4 Digits for holding the year	Number	4
40 Chars	40 Chars (no Validation)	Char	40
5 Digit Numbers	5 digit positive numbers	Number	5
5 Digits	Value set to hold the range from 0 to 99999.	Number	5
5 characters	5 characters	Char	5
50 Characters	50 Characters free text with no validation	Char	50
50 chars	50 chars, no validation	Char	50
6 Character	6 character alpha numeric no validation	Char	6
6 Characters	6 Alpha/Numeric characters no validation	Char	6
6/Characters	6 Character Alpha/Numeric	Char	6
6/Number	A 6 digit positive number field with no validation	Number	6
60 Char	60 Characters	Char	60
60 Characters	60 Characters	Char	60
60 Chars	60 Characters	Char	60
7 characters	7 characters	Char	7
7/Digits	A 7 Digit number field with no validations, -ve numbers are allowed	Number	10
7/Number	A 7 digit positive number field with no validation	Number	10
7/NumberWithZero	A 7 digit whole number field with no validation	Number	7
70 Characters	70 Characters	Char	70
8 Characters	8 Characters	Char	8
80 Characters	80 Characters	Char	80
80 Characters - No Validation	Any 80 characters - created for ECO/WIP Job Hold Alert	Char	80
80 Characters Optional	80 Characters Optional	Char	80
9 Number		Number	9
90 Characters	90 Characters, No Validation	Char	90
94 Characters	94 Characters	Char	94
FNDCPCRS_MODE	Mode for request statistics summary/purge program	Char	10
FNDFFTST_SSV_appl_short_name		Char	50
FNDFFTST_SSV_desc_flex_name		Char	40
FNDFFTST_SSV_key_flex_code		Char	4
FNDFFTST_SSV_structure_number		Number	10
FNDMDGEN_MODE	FNDMDGEN Mode values	Char	20
FNDSCSRC(Sort By)	Sort By for Signon Audit Concurrent Requests Report	Char	80
FND_APPLICATION	Application Name	Char	240
FND_APPLICATION_ALL_VIEW	Applications and ALL	Char	240
FND_APPLICATION_ID		Char	50
FND_APPLICATION_SHORT_NAME	Application Short Names	Char	240
FND_AUDIT_GROUPS_NAME	List of group_name from fnd_audit_groups	Char	240
FND_BFM_LINE_BREAK	Line Break options for Bulk Upload/Download.	Char	10
FND_BFM_MODE	Bulk File Manager Mode.	Char	20
FND_CHAR100	100 Characters	Char	100
FND_CHAR240	240 characters, unvalidated	Char	240
FND_CHAR_240	240 characters, unvalidated	Char	240
FND_CHAR_RESC	240 character unvalidated	Char	240
FND_DATE	Non-required date value set with format DD-MON-YY	Date	9
FND_DATE4	Non-required date value set with format DD-MON-YYYY	Date	11
FND_DATE4_REQUIRED	Required date value set with format DD-MON-YYYY	Date	11
FND_DATE4_REQUIRED_STANDARD	Required date value set with format DD-MON-YYYY	Standard Date	11
FND_DATE4_STANDARD	Non-required date value set with format DD-MON-YYYY	Standard Date	11
FND_DATE_REQUIRED	Required date value set with format DD-MON-YY	Date	9
FND_DATE_REQUIRED_STANDARD	Required date value set with format DD-MON-YY	Standard Date	11
FND_DATE_STANDARD	Non-required date value set with format DD-MON-YY	Standard Date	11
FND_FLEX_UPG_SRS_DTFORMAT_VSETS	Date and DateTime Value Sets. Used in FNDFFUPG_CLONE_DATE conc. prog.	Char	60
FND_FLEX_UPG_SRS_NFORMAT_VSETS	Number Value Sets. Used in FNDFFUPG_NUMBER_ONE conc. prog.	Char	60
FND_FLEX_UPG_SRS_NLS_NUMERIC_CHARS	Supported NLS_NUMERIC_CHARS in Oracle Applications. Used in FNDFFUPG_NUMBER_% conc. progs.	Char	2
FND_FLEX_UPG_SRS_XYFORMAT_VSETS	Standard Date and Standard DateTime Value Sets. Used in FNDFFUPG_DATE_ONE conc. prog.	Char	60
FND_FNDMDGEN_SOURCE_DEST	FNDMDGEN Source/Dest Values	Char	11
FND_FORM(Form Name)	USER_FORM_NAME from FND_FORM for all applications	Char	80
FND_INDUSTRIES2	Industry List	Char	80
FND_LANGUAGES	Language Codes	Char	4
FND_LDAP_SYNCHRONIZATION_MODES	LDAP synchronization modes	Char	10
FND_LOBS_PROGRAM_NAME	Existing Program Names	Char	32
FND_LOBS_PROGRAM_TAGS	Existing Program Tags for a specific Program Name	Char	32
FND_LOGINS(Login name)	LOGIN_NAME in FND_LOGINS.  Not validate	Char	30
FND_LOGINS(Sort by)	Sort By for Signon Audit Users Report	Char	80
FND_LOGINS(Terminal_ID)	TERMINAL_ID in FND_LOGINS.  Not validated	Char	30
FND_LOGIN_RESPONSIBILITIES(Sort by)	Sort By for Signon Audit Responsibility Report	Char	80
FND_LOGIN_RESP_FORMS(Sort By)	Sort By for Signon Audit Forms Report	Char	80
FND_MO_LEDGERS	Ledgers for Operating Units	Char	20
FND_MO_LEDGER_DLC		Char	240
FND_MO_OU		Char	240
FND_MO_OU_SHORT_CODE		Char	10
FND_MO_REPORTING_ENTITY		Char	60
FND_MO_REPORTING_LEVEL	Multi-Org Reporting Level	Char	60
FND_MO_TRL_AP_CA_CURRENCY	Set of Books Currency - AP Reports	Char	15
FND_MO_TRL_AR_CA_CURRENCY	Set of Books Currency - AR Reports	Char	15
FND_NUMBER	Positive Integer Number	Number	15
FND_NUMBER15	Non-Required numeric value set	Number	15
FND_NUMBER15_REQUIRED	Required numeric value set	Number	15
FND_NUMBER_1	Integers Between 1 and 9	Number	1
FND_NUMBER_2	Integers Between 1 and 99	Number	2
FND_ORACLE_USERID	ORACLE Usernames (Enabled only)	Char	30
FND_PRINTER_DRIVERS(Priority)		Number	4
FND_RESPONSIBILITY	Responsibility Name	Char	100
FND_RESPONSIBILITY(Responsbility Name)	RESPONSIBILITY_NAME from FND_RESPONSIBILITY for all applications	Char	100
FND_RESPONSIBILITY_GUI	Responsibility Names (GUI only) for application	Char	100
FND_SOA_MODULES	Integrated SOA Gateway Modules	Char	80
FND_SORT_FNDFFCVL	Sort by Rule Name or Error Segment for Cross Validation Rule Listing Report	Char	30
FND_STANDARD_DATE	Date value set	Standard Date	11
FND_STANDARD_DATETIME	DateTime value set	Standard DateTime	20
FND_STANDARD_DATE_REQUIRED	Required Standard Date	Standard Date	11
FND_STANDARD_DATE_TIME	DateTime value set	Standard DateTime	20
FND_STATS_ACTION	Powers the Action Parameter of the Backup/Restore CBO Statistics Conc Program	Char	8
FND_STATS_OWNER_ALL	Value set for displaying the list of database schema owners, including ALL	Char	30
FND_STATS_TABLES	Powers the LOV that displays the LOV for the tables in a selected schema	Char	30
FND_TABLES	tables in fnd	Char	30
FND_TABLES_ALL_VIEW	Tables in application and ALL	Char	30
FND_TERRITORIES	Territories	Char	15
FND_TX_CLASSES	Ebiz Taxonomy Classes	Char	30
FND_TX_GROUPS	Ebiz Taxonomy Groups (Structures)	Char	30
FND_UNSUCCESSFUL_LOGINS(Sort By)	Sort By for Signon Audit Unsuccessful Logins Report	Char	80
FND_USER		Char	100
FND_USER(Signon Audit)		Char	100
FND_USER(User Name)	USER_NAME from FND_USER	Char	100
FND_USERS	User Id	Char	50
FND_USER_FIX_EMP_CUST_ACTION	Action to take when fixing employee_id and customer_id	Char	30
FND_USER_FIX_EMP_CUST_ERROR	class of error when fixing employee_id and customer_id	Char	30
FND_WFLOAD_MODE	Workflow Definitions Loader Mode	Char	80
FND_WFRESGEN_MODE	Workflow Resource Generator destination modes	Char	80
FND_WF_AGENT	Workflow Agent	Char	30
FND_WF_AGENTS	Workflow Agents	Char	30
FND_WF_AQ_WAIT	AQ wait period valiadetion set for WF BES	Number	30
FND_WF_CORRELATION_ID	Correlation ID validation set for WF BES.	Char	128
FND_WF_DEQ_CONDITION	Condition for dequeuing ( Currently it will not be displayed )	Char	120
FND_WF_ERR_ACTS	Errored workflow activities for a given Itemtype	Char	30
FND_WF_ERR_KEYS	Workflow error item keys based on a given item type	Char	50
FND_WF_ERR_PROCS	Workflow processes with activities in ERROR	Char	30
FND_WF_ITEM_TYPES	Workflow Item Types	Char	80
FND_WF_ITEM_TYPES_RAC	Item types enabled for RAC leveraging	Char	80
FND_WF_MAIL_STATUS	Workflow Notification Mail Status	Char	30
FND_WF_NTF_STATUS		Char	30
FND_WF_PERSISTENCE_TYPE	Workflow Item Persistence Type	Char	30
FND_WF_PURGE_YN	Yes / No for purge	Char	1
FND_WF_ROLES_LOV	Workflow Roles LOV	Char	80
FND_WF_RUNTIMEDATA_PURGE	Validation set to equate boolean for Core Workflow Only data purge alone or Everything.	Char	1
Fnd Stats Gather Options	LOV for Gather Options for Fnd Stats	Char	12
Fnd Stats History Mode	History Mode LOV For Fnd Stats	Char	8
Fnd Stats Purge Mode	Purge Modes For the Fnd_stats purge_history program	Char	10
Fnd Stats Yes_No		Char	3