Skip to main content
insightsoftware Documentation insightsoftware Documentation
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

Modify Noetix Query Users

Modifying query users involves adding or deleting features, adding or deleting roles of NoetixViews, and changing access to data in views for various Oracle E-Business Suite modules.

Note: For modifying users, you need to use the Noetix Query User Maintenance tab of the Security Manager dialog box. However, you can partially modify Database User (Type U) type users by running the idelqusr.sql script. This script allows you to delete already assigned roles from the Noetix query user account. For more information, see Modify Noetix Query Users in “Delete Noetix Query Users.”

To modify the general properties of an existing Noetix query user

  1. On the Noetix Query User Maintenance tab of the Security Manager dialog box of the NoetixViews Administrator, select a Noetix query user, and click Edit. The <Noetix query user> Properties dialog box appears.

  2. On the General tab of the <Noetix query user> Properties dialog box, you can change the language code for the query user. If the user is a Database User (Type U) type user, you can select or clear the selection for creating query tool optimizing views or synonyms. However, you cannot change the user type and user name.

  3. For information about various options on the General tab, see step Modify Noetix Query Users in “Add a Noetix Query User Using an Existing User.”

  4. Click OK on the <Noetix query user> Properties dialog box. You return to the Noetix Query User Maintenance tab.

  5. After you have finished changing the general properties of all the required Noetix query users, click OK to commit the changes to the database.

To modify access to data in HRMS for a Noetix query user

  1. Click the Business Group tab on the <Noetix query user> Properties dialog box to modify the Noetix query user’s access to data in the Noetix views for Oracle Advanced Benefits, Oracle Human Resources, Oracle Payroll, and Oracle Time and Labor. The tab will display the business groups currently assigned to the Noetix query user for each Oracle application.

    For information about the Business Group tab, see Modify Noetix Query Users in “Add a Noetix Query User Using an Existing User.”

  2. Click OK on the <Noetix query user> Properties dialog box. You return to the Noetix Query User Maintenance tab.

  3. Click OK to commit the changes to the database.

To modify query user’s access to data based on ledgers/sets of books

  1. Click the Ledger tab (for Oracle E-Business Suite Release 12 and later) or Set of Books tab (for Oracle
    E-Business Suite versions prior to Release 12) on the <Noetix query user> Properties dialog box to modify the Noetix query user’s access to data in the Noetix views for Oracle Assets, Oracle General Ledger, and Oracle U.S. Federal Financials. The tab will display the ledgers/sets of books currently assigned to the Noetix query users for each Oracle application.

    For information about the Ledger tab (for Oracle E-Business Suite Release 12 and later) or Set of Books tab (for Oracle E-Business Suite versions prior to Release 12), see Modify Noetix Query Users in “Add a Noetix Query User Using an Existing User.”

  2. Click OK on the <Noetix query user> Properties dialog box. You return to the Noetix Query User Maintenance tab.

  3. Click OK to commit the changes to the database.

  4. To modify the Noetix query user’s access to data based on operating units

  5. Click the Operating Unit tab on the <Noetix query user> Properties dialog box to modify the Noetix query user’s access to data in the Noetix views for Assets, General Ledger, and U.S. Federal Financials. The tab will display the operating units currently assigned to the Noetix query user for each Oracle application.

  6. For information about the Operating Unit tab, see Modify Noetix Query Users in “Add a Noetix Query User Using an Existing User.”

  7. Click OK on the <Noetix query user> Properties dialog box. You return to the Noetix Query User Maintenance tab.

  8. Click OK to commit the changes to the database.

To modify the Noetix query user’s access to data based on inventory organizations

  1. Click the Inventory Organization tab on the <Noetix query user> Properties dialog box to modify the Noetix query user’s access to data in the Noetix views for Bills of Material, Cost Management, Enterprise Asset Management, Inventory, Master Scheduling/MRP, Quality, and Work in Process. The tab will display the inventory organizations currently assigned to the Noetix query user for each Oracle application.

  2. For information about the Inventory Organization tab, see Modify Noetix Query Users in “Add a Noetix Query User Using an Existing User.”

  3. Click OK on the <Noetix query user> Properties dialog box. You return to the Noetix Query User Maintenance tab.

  4. Click OK to commit the changes to the database.

To modify the Noetix query user’s access to data based on service request types

  1. Click the Service Request tab on the <Noetix query user> Properties dialog box to modify the Noetix query user’s access to data in the Noetix views for Deport Repair, Field Service, and TeleService. The tab will display the service request types currently assigned to the Noetix query user for each Oracle application.

    For information about the Service Request tab, see Modify Noetix Query Users in “Add a Noetix Query User Using an Existing User.”

  2. Click OK on the <Noetix query user> Properties dialog box. You return to the Noetix Query User Maintenance tab.

  3. Click OK to commit the changes to the database.

To modify access to accounting data for a Noetix query user

  1. Click the Security Rules tab on the <Noetix query user> Properties dialog box to modify the Noetix query user's access to accounting data in Noetix views based on the flexfield security rules. The tab will display the flexfield security rules setting currently assigned to the Noetix query user.

  2. For information about the Security Rules tab, see Modify Noetix Query Users in “Add a Noetix Query User Using an Existing User.”

  3. Click OK on the <Noetix query user> Properties dialog box. You return to the Noetix Query User Maintenance tab.

  4. Click OK to commit the changes to the database.

To add or delete roles for an existing Noetix query user

  1. Click the Roles tab on the <Noetix query user> Properties dialog box to modify the roles assigned to the Noetix query user. The tab will display the Noetix roles currently assigned to the Noetix query user.

    For information about adding or deleting roles on the Roles tab, see Modify Noetix Query Users in “Add a Noetix Query User Using an Existing User.”

  2. Click OK on the <Noetix query user> Properties dialog box. You return to the Noetix Query User Maintenance tab.

  3. When you have finished adding or deleting roles for all the required Noetix query users, click OK to commit the changes to the database.

Modify Default Flexfield Security Rules

For the Noetix query users of the Oracle E-Business Suite Authenticated User (Type A) and Oracle E-Business Suite Authenticated Responsibility (Type R) types, the default flexfield security rules setting assigned can be modified. For information on how to modify the default flexfield security rules setting, see Configure Default Flexfield Security Rules Settings in the “NoetixViews for Oracle General Ledger” section in “Module-Specific Information.”

Published:

Modify Noetix Query Users

Modifying query users involves adding or deleting features, adding or deleting roles of NoetixViews, and changing access to data in views for various Oracle E-Business Suite modules.

Note: For modifying users, you need to use the Noetix Query User Maintenance tab of the Security Manager dialog box. However, you can partially modify Database User (Type U) type users by running the idelqusr.sql script. This script allows you to delete already assigned roles from the Noetix query user account. For more information, see Modify Noetix Query Users in “Delete Noetix Query Users.”

To modify the general properties of an existing Noetix query user

  1. On the Noetix Query User Maintenance tab of the Security Manager dialog box of the NoetixViews Administrator, select a Noetix query user, and click Edit. The <Noetix query user> Properties dialog box appears.

  2. On the General tab of the <Noetix query user> Properties dialog box, you can change the language code for the query user. If the user is a Database User (Type U) type user, you can select or clear the selection for creating query tool optimizing views or synonyms. However, you cannot change the user type and user name.

  3. For information about various options on the General tab, see step Modify Noetix Query Users in “Add a Noetix Query User Using an Existing User.”

  4. Click OK on the <Noetix query user> Properties dialog box. You return to the Noetix Query User Maintenance tab.

  5. After you have finished changing the general properties of all the required Noetix query users, click OK to commit the changes to the database.

To modify access to data in HRMS for a Noetix query user

  1. Click the Business Group tab on the <Noetix query user> Properties dialog box to modify the Noetix query user’s access to data in the Noetix views for Oracle Advanced Benefits, Oracle Human Resources, Oracle Payroll, and Oracle Time and Labor. The tab will display the business groups currently assigned to the Noetix query user for each Oracle application.

    For information about the Business Group tab, see Modify Noetix Query Users in “Add a Noetix Query User Using an Existing User.”

  2. Click OK on the <Noetix query user> Properties dialog box. You return to the Noetix Query User Maintenance tab.

  3. Click OK to commit the changes to the database.

To modify query user’s access to data based on ledgers/sets of books

  1. Click the Ledger tab (for Oracle E-Business Suite Release 12 and later) or Set of Books tab (for Oracle
    E-Business Suite versions prior to Release 12) on the <Noetix query user> Properties dialog box to modify the Noetix query user’s access to data in the Noetix views for Oracle Assets, Oracle General Ledger, and Oracle U.S. Federal Financials. The tab will display the ledgers/sets of books currently assigned to the Noetix query users for each Oracle application.

    For information about the Ledger tab (for Oracle E-Business Suite Release 12 and later) or Set of Books tab (for Oracle E-Business Suite versions prior to Release 12), see Modify Noetix Query Users in “Add a Noetix Query User Using an Existing User.”

  2. Click OK on the <Noetix query user> Properties dialog box. You return to the Noetix Query User Maintenance tab.

  3. Click OK to commit the changes to the database.

  4. To modify the Noetix query user’s access to data based on operating units

  5. Click the Operating Unit tab on the <Noetix query user> Properties dialog box to modify the Noetix query user’s access to data in the Noetix views for Assets, General Ledger, and U.S. Federal Financials. The tab will display the operating units currently assigned to the Noetix query user for each Oracle application.

  6. For information about the Operating Unit tab, see Modify Noetix Query Users in “Add a Noetix Query User Using an Existing User.”

  7. Click OK on the <Noetix query user> Properties dialog box. You return to the Noetix Query User Maintenance tab.

  8. Click OK to commit the changes to the database.

To modify the Noetix query user’s access to data based on inventory organizations

  1. Click the Inventory Organization tab on the <Noetix query user> Properties dialog box to modify the Noetix query user’s access to data in the Noetix views for Bills of Material, Cost Management, Enterprise Asset Management, Inventory, Master Scheduling/MRP, Quality, and Work in Process. The tab will display the inventory organizations currently assigned to the Noetix query user for each Oracle application.

  2. For information about the Inventory Organization tab, see Modify Noetix Query Users in “Add a Noetix Query User Using an Existing User.”

  3. Click OK on the <Noetix query user> Properties dialog box. You return to the Noetix Query User Maintenance tab.

  4. Click OK to commit the changes to the database.

To modify the Noetix query user’s access to data based on service request types

  1. Click the Service Request tab on the <Noetix query user> Properties dialog box to modify the Noetix query user’s access to data in the Noetix views for Deport Repair, Field Service, and TeleService. The tab will display the service request types currently assigned to the Noetix query user for each Oracle application.

    For information about the Service Request tab, see Modify Noetix Query Users in “Add a Noetix Query User Using an Existing User.”

  2. Click OK on the <Noetix query user> Properties dialog box. You return to the Noetix Query User Maintenance tab.

  3. Click OK to commit the changes to the database.

To modify access to accounting data for a Noetix query user

  1. Click the Security Rules tab on the <Noetix query user> Properties dialog box to modify the Noetix query user's access to accounting data in Noetix views based on the flexfield security rules. The tab will display the flexfield security rules setting currently assigned to the Noetix query user.

  2. For information about the Security Rules tab, see Modify Noetix Query Users in “Add a Noetix Query User Using an Existing User.”

  3. Click OK on the <Noetix query user> Properties dialog box. You return to the Noetix Query User Maintenance tab.

  4. Click OK to commit the changes to the database.

To add or delete roles for an existing Noetix query user

  1. Click the Roles tab on the <Noetix query user> Properties dialog box to modify the roles assigned to the Noetix query user. The tab will display the Noetix roles currently assigned to the Noetix query user.

    For information about adding or deleting roles on the Roles tab, see Modify Noetix Query Users in “Add a Noetix Query User Using an Existing User.”

  2. Click OK on the <Noetix query user> Properties dialog box. You return to the Noetix Query User Maintenance tab.

  3. When you have finished adding or deleting roles for all the required Noetix query users, click OK to commit the changes to the database.

Modify Default Flexfield Security Rules

For the Noetix query users of the Oracle E-Business Suite Authenticated User (Type A) and Oracle E-Business Suite Authenticated Responsibility (Type R) types, the default flexfield security rules setting assigned can be modified. For information on how to modify the default flexfield security rules setting, see Configure Default Flexfield Security Rules Settings in the “NoetixViews for Oracle General Ledger” section in “Module-Specific Information.”

For an optimal Community experience, Please view on Desktop
Powered by Zendesk