Oracle Application Object Library utilizes values; esteem sets and approval tables as imperative segments of key flexfields, distinct flexfields, and Standard Request Submission. This segment encourages you to get, use and change esteems, esteem sets, and approval tables. When you initially characterize your flexfields, you pick what number of sections you need to utilize and what request you need them to show up. You likewise pick how you need to approve every one of your sections. The choices you make an influence on how you characterize your esteem sets and your qualities. You characterize your esteem sets first, either previously or while you characterize your flexfield fragment structures. You commonly characterize your individual qualities simply after your flexfield has been totally characterized (and solidified and ordered). Contingent upon what kind of significant worth set you use, you should not have to predefine singular qualities at all before you can utilize your flexfield. Read More Info On Oracle Course
You can share esteem sets among portions in various flexfields, fragments in various structures of the equivalent flexfield, and even sections inside the equivalent flexfield structure. You can share esteem sets crosswise over key and enlightening flexfields. You can likewise utilize esteem sets for report parameters for your reports that utilization the Standard Request Submission highlight.
Since the conditions you indicate for your esteem sets figure out what esteems you can use with them, you should design both your qualities and your esteem sets in the meantime. For instance, if your qualities are 01, 02 rather than 1, 2, you would characterize the esteem set with Right– Justify Zero– fill set to Yes.
The esteem set is the only List of Values with approvals. We can utilize the Value Sets at whatever point the Concurrent Program has parameters and keeping in mind that characterizing the Flex Fields. We need to append the esteem sets to the Concurrent Program. Approvals are relying upon Client Requirement. Get More Points On Oracle Certification
Esteem sets are of 8 types. There are a few approval types that influence the manner in which clients enter and use fragment or parameter esteems:
1. None (not approved by any stretch of the imagination)
2. Autonomous
3. Subordinate
4. Table
5. Exceptional (progressed)
6. Pair (progressed)
7. Translatable Independent
8. Translatable Dependent
You can't change the approval sort of current esteem set since your progressions influence all flexfields and report parameters that utilization a similar esteem set.
None: You utilize a None kind esteem set when you need to enable clients to enter any esteem inasmuch as that esteem meets the esteem set arranging rules. That is, the esteem must not surpass the greatest length you characterize for your esteem set, and it must meet any organization necessities for that esteem set. For instance, if the esteem set does not permit alphabetic characters, your client couldn't enter the esteem ABC yet could enter the esteem 456 (for esteem set with a most extreme length of three). The estimations of the fragment utilizing this esteemed set are not generally approved, and they don't have depictions. Since a NONE esteem set isn't approved, a portion that utilizes this esteemed set does not give a rundown of qualities to your clients. A portion that utilizes this esteemed set (that is, a non– approved section) can't utilize flexfield esteem security guidelines to limit the qualities a client can enter.
Autonomous: An Independent esteem set gives a predefined rundown of qualities for a section. These qualities can have a related portrayal. For instance, esteem 01 could have a portrayal of 'Organization 01'. The significance of significant worth in this esteemed set does not rely upon the estimation of some other section. Autonomous qualities are put away in an Oracle Application Object Library table. You characterize autonomous qualities utilizing an Oracle Applications window, Segment Values.
Table: A table-approved esteem set gives a predefined rundown of qualities like an autonomous set, yet its qualities are put away in an application table. You characterize which table you need to use, alongside a WHERE provision to constrain the qualities you need to use for your set. Regularly, you utilize a table-approved set when you have a table whose qualities are kept up in an application table (for instance, a table of merchant names kept up by a Define Vendors structure). Table approval additionally gives some propelled highlights, for example, enabling a fragment to rely on numerous earlier portions in a similar structure. Get More Points on Oracle SOA Online Training
Subordinate: A needy esteem set is like a free esteem set, then again, actually the accessible qualities in the rundown and the significance of given esteem rely upon which autonomous esteem was chosen in an earlier portion of the flexfield structure. You can think about reliant esteem set as a gathering of little esteem sets, with one minimal set for every autonomous incentive in the relating free esteem set. You should characterize your free esteem set before you characterize the needy esteem set that relies upon it. You characterize subordinate qualities in the Segment Values windows, and your qualities are put away in an Oracle Application Object Library table.
Unique and Pair Value Sets:
Unique and pair esteem sets give an instrument to permit a" FLEXFIELD– within– a– flexfield". These esteem sets are basically utilized for Standard Request Submission parameters. You don't, for the most part, utilize these esteem sets for typical FLEXFIELD sections. Unique and Pair esteem sets utilize exceptional approval schedules you characterize. For instance, you can characterize approval schedules to give another flexfield as esteem set for a solitary fragment or to give a scope of flexfield as esteem set for a couple of sections.
Translatable Independent and Translatable Dependent: A Translatable Independent esteem set is like Independent esteem set in that it gives a predefined rundown of qualities for a portion. Be that as it may, an interpreted esteem can be utilized. A Translatable Dependent esteem set is like Dependent esteem set in that the accessible qualities in the rundown and the significance of given esteem rely upon which autonomous esteem was chosen in an earlier section of the flexfield structure. Be that as it may, an interpreted esteem can be utilized. FLEXFIELD Value Security can't be utilized with Translatable Independent or Translatable Dependent esteem sets. For organization approval, translatable esteem sets must utilize the configuration type Char. The most extreme size must be no more noteworthy than 150. The Number Only alternative and the Right– legitimize and Zero– Fill Numbers choice can't be utilized with translatable esteem sets. Range flexfields can't utilize Translatable Independent or Translatable Dependent esteem sets. Get More Points on Oracle SOA Certification
