Tag Archives: Define Security

Responsibilities Not Appearing After Logon

Problem: After logging on to Oracle Applications E-Business Suite, a custom responsibility is not appearing. This responsibility has disappeared for all users.

Solution: Checked My Oracle Support document “During Login Responsibilities Assigned to Users do not Appear in the Navigator Page [ID 565130.1]”. However, this did not resolve the issue.

Under the System Administrator responsibility, navigated to Security > Responsibility > Define, then queried for the responsibility that was not appearing (F11, Ctrl+F11). Under the Available From section on the form, the “Oracle Mobile Applications” option was selected. Selected “Oracle Applications” option, and then saved. After logging out and logging back in, the user was able to access the responsibility.

(SEC-30) Role User table (ROLEXLATOPR) should be populated

Problem:

After running SYSAUDIT, the following error appears:

(SEC-30) Role User table (ROLEXLATOPR) should be populated when new User Profiles (entries in PSOPRDEFN) 
are created using User Profile component through PIA. The following User Profiles need to be fixed by 
simply opening and saving them through PIA:
 Oper ID Description
 ------- ------------------------------
 ENTMGR_PRO Procurement Catalog Manager
 1 Total Rows

Solution:

1. Launch the PeopleSoft instance (PIA) and log on as a user with access to the PeopleTools responsibility.
2. Navigate to PeopleTools > Security > User Profiles > User Profiles.
3. Click Search, and choose ENTMGR_PRO (Procurement Catalog Manager).
4. Make a change to the record (e.g. change Language Code from English to Finnish), and save the record.
5. Revert the change (e.g. change Language Code from Finnish to English), and save the record again.
6. Then run the SYSAUDIT report.

Customizing Fixed Assets Manager

1. Navigate to System Administrator > Application > Menu.
Query FA_MAIN in the User Menu  Name field.
Note the values in the Menu, User  Menu Name, Menu Type and Description fields.

2. Clear the form and enter a new menu.
In the Menu and User Menu Name  fields, enter CUSTOM_FA_MAIN.
Enter the same Menu Type (Standard)  and enter a new description (Custom Main menu for Oracle Assets).
Enter the original menu name as a  submenu of the custom menu. Then click Save.

3. Navigate to System Administrator > Security > Responsibility > Define
In the Responsibility Name field, query Fixed Assets Manager.
Note the Responsibility Name,  Application, Responsibility Key, Description, Data Group Name, Menu and Request Group Name.

4. Clear the form and enter a new responsibility. Enter a new Responsibility Name, Responsibility Key and Description.
The Menu must be the custom menu  created above. The Application, Data Group Name and Request Group Name fields remain the same.
Under Menu Exclusions, choose Menu and select the FA_SETUP_MAIN menu.
Then click Save.

5. Navigate to System Administrator > Security > User > Define
To add the custom responsibility to a user, query the user.
Under Direct Responsibilities, insert the custom responsibility.
Then click Save.

Note that the menu exclusion for the Fixed Assets Manager was included (FA_PURGE) in the new
responsibility Custom Fixed Assets Manager, so that additional functionality would not appear in this new
responsibility.

Setting Up Custom GL Menus and Functions

Step 1: Navigate to Security > Responsibility > Request. Enter a new record with a new Group, Application, and Code. Then enter a new Request type.

Step 2: Next, navigate to Application > Function. Press F11 and search for CS%FND%. Locate CS_FNDRSRUN. Click the Form tab. Copy and paste the Parameters value to text file.

Step 3: Insert a new record in Form Functions named MFGL_FNDRSRUN. Paste the copied value into the Parameters field and modify the APPL_SHORT_NAME.

Step 4: Get menu name: GL_SUPERUSER

Navigate to Security > Responsibility > Define. Search for the custom responsibility by pressing F11 and entering the searching string, then press Ctrl+F11.

Step 5: Navigate to Application > Menu. We want to modify the Import Journals and review data Menu. Pull up GL_SUPERUSER menu and click View Tree. Navigate to Journals, then Import. Right-click and choose Properties. Alternatively, search for GL%IMPORT%.

Step 6: The GL_SU_J_IMPORT menu appears. Insert a new menu line together with its Prompt and Function Name. Then Save.

Registering New Active Users Report

This documentation illustrates how to copy an existing report to a new report and register it in Oracle Applications. The Active Users report shall be used as an example.

Step 1:        Log on to Oracle Applications and choose the System Administrator responsibility. Navigate to Concurrent > Program > Define.

Step 2:        The Concurrent Programs form appears. Press F11 and type ‘Active%’ in the Program field. Then press Ctrl+F11.

Step 3:        The Active Users program appears in the form. Click the Copy To button.

Step 4:        The Copy To form appears. Enter ‘Active Users (PDF)’ in the Program field, and ‘FNDSCURSPDF’ in the Short Name field. Then click OK.

Step 5:        The Active Users (PDF) program appears in the form. Change the Output Format field to ‘PDF’. Then click Save.

Step 6:        Navigate to Security > Responsibility > Define. The Responsibilities form appears. Press F11. Type ‘System Administrator’ in the Responsibility Name field and ‘System Administration’ in the Application field, and press Ctrl+F11.

Note the Request Group Name and Application.

Step 7:        Navigate to Security > Responsibility > Request. The Request Group form appears. Press F11 and type ‘System Administrator Reports’ in the Group field and ‘Application Object Library’ in the Application field. Then press Ctrl+F11.

Step 8:        Select the record to insert the new record under, then click New. In the Name field, select ‘Active Users (PDF)’ from the list. Then click Save.

Step 9:        The report now appears in the Concurrent Requests list under System Administrator.

Step 10:   If there are any issues viewing the PDF reports, it may be necessary to change the PDF profile options. Search for ‘PDF’ or ‘Viewer’.