=== ODM Answer === please do the following in your TEST: The formula security option enables organizations

to restrict access to formula information. The option also enables organizations to restrict modification of formula information. Based on the level of security set up, users can be given complete or limited access to viewing or updating formulas. An owning organization controls access to formulas by the security profiles associated to it.

To assign Product Development Security Access: [Link] to Product Development Security Manager responsibility=> the Product Development Security Access window. 2. The Formula Security Enabled check box is: Cleared when formula security is disabled. Selected when formula security is enabled. 3. Enter the Organization that you want to assign access to formula security. Required. 4. Select one of these User access options

Yes if you want the organization to have user level formula security. By selecting this security level, you are able to specify user access to formulas on the Product Development Security Profile window. No if you do not want the organization to have user level formula security. Required. 5. Select one of these Responsibility access options: Yes if you want the organization to have responsibility level formula security. By selecting this security level, you are able to specify one or more responsibilities to have access to formulas on the Product Development Security Profile window. No if you do not want the organization to have responsibility level formula security. Required. 6. Save the window.

Assigning the Product Development Security Profile The Product Development Security Profile window enables the Product Development Security Profile Manager responsibility to assign security details to an owning organization that is assigned security access on the Product Development Security Access window. Security details are assigned for users, responsibilities, and other organizations. The assignment method and formula access level are specified on this window

To assign the Product Development Security Profile: 1. Navigate to Navigate to Product Development Security profile manager=> Product Development Security Profile window. 2. Query the owning Organization you want to assign security details. Security Details 3. The combination of entries for each of the following fields determines the desired security level as described in the Results column of the table that follows this step. Other Organization field entries are: Null to indicate the field is blank. No specific other organization is entered. Specific to indicate that a specific organization name is entered. If a value is specified for Other Organization, the value specified for User or Responsibility applies to the Other Organization and not the owning Organization. Only the User or Responsibility field is entered for each row: User field entries are: Null to indicate the field is blank. No specific user is entered. Specific to indicate that a specific user name is entered. ALL to indicate that all users are entered. Responsibility field entries are: Null to indicate the field is blank. No specific responsibility is entered. Specific to indicate that a specific responsibility is entered. Assign Method field entries are: View to indicate the specified organization, user, and responsibility combination has view access. Formulas cannot be updated with this level of formula security. They can only be viewed. Automatic to indicate that the specified view or update access level is given automatically to the specified organization, user, and responsibility combination. Required. Access Level field entries are: View to indicate the specified organization, user, and responsibility combination has view access. Formulas cannot be updated with this level of formula security. They can only be viewed. Update to indicate the specified organization, user, and responsibility combination has update access. Formulas can be viewed and updated with this level of formula security. Required. Refer to the Result column in the table at the end of this task to determine the level of security desired. Set each of the fields appropriately to achieve this security level. 4. Save the window.

How To Report Data Protected Because Of Product Development (Formula) Security [ID 339959.1] Modified 22-MAY-2009
In this Document Goal Solution

Type HOWTO

Status MODERATED

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.

Applies to:
Oracle Process Manufacturing Product Development - Version: 11.5.9 Information in this document applies to any platform. FORM:[Link] - Formula Security Profiles FORM:[Link] - Formula Security Manual Access FORM:[Link] - Formula Security Control

Goal
How to report data protected over Product Development (Formula) Security functionality? Where Product Development (Formula) Security functionality is in use, data is not found and not displayed after selecting over SQL*Plus, TOAD or any reporting tool.

Solution
Where Product Development (Formula) Security in use, one can not just like that get access to Product Development (Formula) data. Protection is base reason for having Product Development (Formula) Security !!

Use API FND_GLOBAL.APPS_INITIALIZE to set the applications context in standalone sessions that were not initialized through normal means. Typically, you would use this API in external custom programs that are establishing their own connections (see also Note 209185.1). Or before SQL statements for which values are to be initialized.

To implement the solution, please execute the following steps: 1. Find applicable User and Responsibility for which Product Development data maintenance is allowed in OPM eg Responsibility 'Formulator' 2. run next SQL to find IDs needed in FND_GLOBAL.APPS_INITIALIZE In SQL*Plus select fu.user_name, fr.responsibility_name , fu.user_id, fr.responsibility_id resp_id , furg.responsibility_application_id resp_appl_id, furg.security_group_id sec_group_id from fnd_user_resp_groups furg , fnd_user fu , fnd_responsibility_vl fr where furg.user_id = fu.user_id and upper(fu.user_name) = upper('&User_Name') and furg.responsibility_id = fr.responsibility_id order by 1, 3

3. in results of above SQL find applicable Responsibilty and other IDs 4. execute FND_GLOBAL.APPS_INITIALIZE exec fnd_global.apps_initialize (&user_id, &resp_id, &resp_appl_id, &sec_group_id); 5. only now select from GMD objects/tables like fm_form_mst_b or gmd_recipes_b One remark to add, it was experienced by a customer above steps to work out from within SQL*Plus, not from within TOAD or PL/SQL Developer.

Related

Products

Oracle E-Business Suite > Manufacturing > Process Manufacturing > Oracle Process Manufacturing Product Development

Keywords FM_FORM_MST_B; [Link]; PRODUCT DEVELOPMENT