To Provide Access to Segment Values in Accounting Flex field to find-update in R12.2 onwards

 

 TO Provide Access to find/update Flexfield Segment in R12.2 onwards:

From R12.2 above Value set Insert/Update depends on Security access

To Insert/Update the Accounting Flex filed segment values we need to provide access for specific user by assigning roles (flexfield value set security) so they can have access to Segment Values form and can modify all value sets.

Oracle recommend that you set up flexfield value set security to restrict privileges for modifying value sets to specific users.

However, if you want complete backwards compatibility, where all users with access to the Segment Values form can modify all value sets, the simplest way to do this is using Functional administrator by creating grant:

 

This setups applies to Form Name : FNDFFMSV ( accessed from System Administrator-> Validation->
Values and System Administrator-> Flexfield-> Key-> Values)

After creating the grants from functional administrator, we will be able to perform the following in FNDFFMSV form:
i) Access the values in Name field LOV, when we Find Values By Value Set.
ii) Access the values in Application,Title,Structure & Segment field LOV’s, when we Find Values By Key
Flexfield
iii) Access the values in Application,Title,Structure & Segment field LOV’s, when we Find Values By
Descriptive Flexfield
iv) Access the values in Application, Name & Parameter LOV’s, when we Find Values By Concurrent Program.

Issue: Unable to access Accounting Flexfield as when try to search get below message.

Error Message: FRM-40212: Invalid Value for field APPLICATION_NAME

Similarly, we cannot find even by searching Flexfield Title or value set:

AF-1

Solution:

1. Navigate to Functional Administrator responsibility.

Functional Administrator ->Home ->Grant->Create the Grant as follows:

In this form enter the Grant name and description

Please see attached document for steps and details to follow:

To Provide Access to Segment Values in Accounting Flex field to find-update R12.2 onwards

Select grantee type as “specific user” and select the user as shown in screen.

 

NOTE: Select grantee type as “All Users” to give access to all user and Select Responsibility through which they will have access.

 

Object: Select Object as ”Flexfield Value Set Security Object(1)” from List of Values

 

Click Next: Select the data context type as “all Rows”

 

Click Next:

Select the Set as ”Flexfield Value Set Security Insert/Update Set” from List of values

 

Click next and Review all the data and click on Finish button.

 

 

Now grant has been successfully created:

 

After providing the grant we can query the value set information:

After creating the grants from functional administrator, we will be able to perform the following in
FNDFFMSV form:
i) Access the values in Name field LOV, when we Find Values By Value Set.
ii) Access the values in Application,Title,Structure & Segment field LOV’s, when we Find Values By Key
Flexfield
iii) Access the values in Application,Title,Structure & Segment field LOV’s, when we Find Values By
Descriptive Flexfield
iv) Access the values in Application, Name & Parameter LOV’s, when we Find Values By Concurrent Program.

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s