Oracle Fusion Technical: Reports, Data, Integrations and Extensions · Module 12 · Extensions: sandboxes, Page Composer and the boundaries
Value sets and validation
Lesson 122 of 177 · 2 min
A value set constrains what can be entered, and it is what turns a flexfield from a text box into data. The types you will use: a fixed list, a list read from a table, a format-only rule (a length, a pattern), and a DEPENDENT value set, where the options available depend on another field's value — choose a country and the region list narrows. Dependent value sets are the most useful and the most brittle. They enforce a real relationship, and they fail confusingly: when the parent value is absent or arrives after the child in a load, the child list is empty and the row is rejected for a reason that names the child field. Worth knowing before you spend an hour on the wrong field. AND THE VALIDATION THAT BELONGS IN THE PROCESS RATHER THAN THE FIELD. A value set can say "must be one of these".…
The full lesson is part of the course
The video, the complete written lesson and the module quiz are included in Oracle Fusion Technical: Reports, Data, Integrations and Extensions, with a certificate on completion and a fourteen-day refund window.
In this module: Module 12 · Extensions: sandboxes, Page Composer and the boundaries
- 1What a sandbox is, and what it is notFree preview
- 2Publishing, and the point of no return
- 3Page Composer: what it can change
- 4Descriptive and extensible flexfields
- 5Value sets and validation
- 6Application Composer versus Page Composer
- 7Visual Builder: where it fits
- 8Recognising an unsupported request
- 9What breaks: extensions and quarterly updates
- 10Lab briefing · Extend a page and survive an update