How to create independent value set in fusion(Oracle Cloud)?

-

Please check my other Post  to know what is value set

Independent value set is recommended if you have a requirement to restrict DFF field user entry value with valid values that you maintain/specify.

Let's see steps to create a independent value set.

-> Login to cloud, navigate to 'setup and maintenance' and search for  'Manage Value Set' task




-> Click on 'Manage Value Sets' task and navigate to manage value set screen



-> Click on create(+) icon and enter the value set details.

Valueset code: Unique code for value set
Valueset description: Description field
Module: Functional Area
Validation Type: Type of Valueset(Independent)
Value Data Type: Data Type of value set
Value Sub Type: Further classification of  Data Type of value set
Maximum Length: maximum length allowed for the value
Minimum and Maximum value applicable for the number and if you have the requirement to set the number limits.

-> Click on Save. 'Manage Values' button only will be enabled after saving the definition. Click on 'Manage values' button to navigate to the manage screen values.






-> Click Create(+) icon to create values. You can enter value, value description, value effective dates(start and end date) and sort order.







-> Click Save to see the list of available values for this value set





Please check my other Post to see how to associate valueset a DFF segment1





Comments

Post a Comment

Popular posts from this blog

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

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