What is value set in Fusion(Oracle Cloud)? How to create a value set?

-
Let's see what is value set and how to create one.

A value set is a group of valid values that you assign to a flexfield segment to control the values that are stored for business object attributes. We have following types value sets.

  • Format only, where end users enter data rather than selecting values from a list
  • Independent, a list of values consisting of valid values you specify
  • Dependent, a list of values where a valid value derives from the independent value of another segment
  • Subset, where the list of values is a subset of the values in an existing independent value set
  • Table, where the values derive from a column in an application table and the list of values is limited by a WHERE clause

Security

Value set security only works in conjunction with usage within flexfield segments.
You can specify that data security be applied to the values in flexfield segments that use a value set. Based on the roles provisioned to users, data security policies determine which values of the flexfield segment end users can view or modify.


Please check how to different value sets in below links. Independent Valueset


Comments

Post a Comment

Popular posts from this blog

How to configure DFF field and publish it to BI(OTBI) in Fusion?

-
Image
Hello All, A lot of times, we have a requirement to enable the DFF in fusion and make it available in OTBI subject area. Let us see how to implement this functionality? -> Login to cloud and navigate to 'Setup And Maintenance' -> Search for 'Manage Descriptive FLexfiled' task -> Click on 'Manage Descriptive Flexfields' task and search for the DFF that you want to configure. -> Click on the edit and navigate to ' Edit Descriptive Flexfield' screen ->  If you want context sensitive , Click on Mange contexts to create new context. -> Click on create(+) icon under Context sensitive segments section to create new segment and enter the required details. Name : Display Name for additional field. Code: Unique code for this segment API Name: name of the field the way you want to appear in the APIs(web services) Data Type: Data Type of the field. Table COlumn: table column where you want to store t...
Read more

How to import/batch load user role assignment in fusion?

-
Image
How to import/batch load user role assignment in fusion? During the go-live and UAT, we have requirement to load the batch of users and user assignment. If you have requirement to load  users, please check my other Post  . If you have requirement to load batch of assignments, Please follow below steps. Oracle allows you to assign one role to multiple users through cloud my service role assignment import functionality Prerequisite:     User should exist in fusion cloud     Role should exist in fusion cloud If you have to assign multiple roles, you have to create one file for each role. For example, if you have to assign ‘Project Manager’ and ‘AR Manager’ roles, you have to create one file each for  ‘Project Manager’ and ‘AR Manager’. Fusion cloud only allows csv format with File format should be as followed. You can download sample file here. Your file should contain the email addresses (Email as header column) of the users...
Read more

How to synchronize Users and Roles in Fusion?

-
Image
User accounts for users of Oracle Fusion Applications are maintained in your Lightweight Directory Access Protocol (LDAP) directory. The LDAP directory also holds information about roles provisioned to users. During implementation, any existing information about users and their roles must be copied from the LDAP directory to the Oracle Fusion Applications tables. To copy this information, you use the task Run User and Roles Synchronization Process. -> Search for 'User and Roles Synchronization Process' task and click on task link -> Click on submit by clicking on 'submit' button -> You can see below confirmation message with process id upon submission -> Click on navigator button and click schedule process button -> You can view the process status on below screen
Read more