The new value set types created in Oracle Fusion with respect to Oracle EBS are:
- Standard Date and Standard DateTime: These value set types provide a more flexible and consistent way to store and display date and time values. They are also more compatible with third-party applications and reporting tools.
- Subset: This value set type allows you to create a subset of values from an existing independent value set. This can be useful for creating value sets for specific purposes, such as a weekend subset of the days of the week value set.
- Format only: This value set type allows users to enter any value, as long as it conforms to the specified formatting rules. This can be useful for validating data formats, such as a phone number value set that requires users to enter a 10-digit number in the format (XXX) XXX-XXXX.
In addition to these new value set types, Oracle Fusion also provides a number of enhancements to existing value set types, such as the ability to define default values and to specify minimum and maximum values.
Here is a table that summarizes the new value set types in Oracle Fusion and their corresponding types in Oracle EBS:
| Oracle Fusion value set type | Oracle EBS value set type |
|---|---|
| Standard Date | Date |
| Standard DateTime | DateTime |
| Subset | Dependent (subset) |
| Format only | None |
Note that the Date and DateTime value set types in Oracle EBS will be obsolete in a future release. For new value sets, it is recommended to use the Standard Date and Standard DateTime value set types in Oracle Fusion.
Watch Video
