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

Modify View Properties

In the NoetixViews Workbench, you can modify the properties of a view. You can also add, modify, and remove joins for a view.

About Security Codes

You can use security codes to define the application-specific security for views corresponding to an Oracle E-Business Suite module that supports application-specific security. In Noetix Views (NoetixViews), the application-specific security is enforced over the existing organizational unit-based security. When the application-specific security is enforced, access to the data in Noetix views is determined based on security rules, security profiles, budget access levels, and service request types. The following security codes can be used to enforce applications-specific security for views in the NoetixViews Workbench:

  • Account: Enforces application-specific security based on the flexfield security rules. This type of application-specific security can be enforced on views pertaining to Oracle General Ledger that contain the GL CODE COMBINATIONS tables.

  • HR: Enforces application-specific security based on the HR security profiles. This type of application-specific security can be enforced on views pertaining to Oracle Human Resources, Oracle Advanced Benefits, Oracle Payroll, and Oracle Time and Labor.

  • Budget Level: Enforces application-specific security based on budget access levels. This type of application-specific security can be enforced on views pertaining to Oracle U.S. Federal Financials if the views include a call to the N SEC MANAGER MDSEC PKG.CHECK BUDGET LEVEL ACCESS package function.

  • SR Type: Enforces application-specific security based on service request types. This type of application-specific security can be enforced on views pertaining to Oracle Depot Repair, Oracle Field Service, and Oracle TeleService that contain the CS INCIDENTS ALL B table or the

For more information about application-specific security, see the MagnitudeNoetixViews Administrator Guide.

Modifying View Settings

The settings that you can modify for a view include view description, view essay, role label settings, keyword settings, and security code.

To modify the settings of a view

  1. On the NoetixViews Workbench home page, clickModify a View. TheModify Viewpage appears.

  2. Select a view that you want to modify, and then click Modify. The Modify View » <view label> page appears. For information, see Select a View.

  3. Under View, click Modify view properties, and then click Next. The Modify View » <view label> » Modify view properties page appears.

  4. In the Description (up to 80 characters) box, perform the required modification. The description can contain a maximum of 80 characters.

  1. In the View essay (up to 3000 characters) box, perform the required modification. The view essay can contain a maximum of 3,000 characters.

  1. If required, modify the list of keywords displayed for the view. To modify the list, do one of the following:

    1. If you want to add a keyword, in the Keywords box, type a keyword, and click Add to add the keyword to the list of keywords. Keywords are used as index entries in the Microsoft WinHelp format of the Noetix Help File.IMPORTANT: The keywords added to a view must be unique.If you try to add a duplicate keyword, an error message will be displayed.

    2. If you want to remove a keyword, select the keyword from the list, and then click Remove. If you want to select multiple keywords from the list, press CTRL and click the keywords.

  2. In the Role Labels list, perform the required modification. By default, an appropriate role label corresponding to the detected application of the view is selected. To modify the role label settings, follow these steps:

    1. Click Add. The Add Role Labels dialog box is displayed.

    2. In the Labels list, select the role label that you want to add. To select multiple role labels, press CTRL, and then click the role labels. The role labels displayed in theLabelslist are populated based on the NoetixViews modules available in your NoetixViews schema.NOTE: A role label contains a collection of roles that can be assigned to Noetix query users to provide them access to the required form of the view.

    3. Click Add. The selected role labels are added to the Role Labels list.

    4. If you want to remove a role label from the Role Labels list, select a role label, and click Remove. To select multiple role labels, press CTRL, and then click the role labels.

  3. If the view that you are modifying is not a list of values (LoV) view, and if you want to modify the existing application-specific security settings configured for the view, in the Security code list, click an appropriate security code. The values available for selection depends on the application-specific security available for the application associated with the view. For example, if the view that you are creating belongs to Oracle Financials, only the Account value will be available for selection.

  4. If you are modifying a base view, in the Sort layer (0 to 999) box that appears, change the order for the base view in which the view needs to be processed. The sort layer specifies the order in which the view is processed during the Stage 4 of the generation process.

    IMPORTANT: Make sure that the sort layer value of the base view is lower than the sort layer value of the dependent views.

  5. In the Customization comments box, provide a summary of the customizations that you have performed. The customization comments can contain a maximum of 200 characters.

  6. Click Save. The customizations are saved, and the Modify View» <view label> page appears.

Now, you can choose to perform any other customizations on the same view or go to the home page.

Published:

Modify View Properties

In the NoetixViews Workbench, you can modify the properties of a view. You can also add, modify, and remove joins for a view.

About Security Codes

You can use security codes to define the application-specific security for views corresponding to an Oracle E-Business Suite module that supports application-specific security. In Noetix Views (NoetixViews), the application-specific security is enforced over the existing organizational unit-based security. When the application-specific security is enforced, access to the data in Noetix views is determined based on security rules, security profiles, budget access levels, and service request types. The following security codes can be used to enforce applications-specific security for views in the NoetixViews Workbench:

  • Account: Enforces application-specific security based on the flexfield security rules. This type of application-specific security can be enforced on views pertaining to Oracle General Ledger that contain the GL CODE COMBINATIONS tables.

  • HR: Enforces application-specific security based on the HR security profiles. This type of application-specific security can be enforced on views pertaining to Oracle Human Resources, Oracle Advanced Benefits, Oracle Payroll, and Oracle Time and Labor.

  • Budget Level: Enforces application-specific security based on budget access levels. This type of application-specific security can be enforced on views pertaining to Oracle U.S. Federal Financials if the views include a call to the N SEC MANAGER MDSEC PKG.CHECK BUDGET LEVEL ACCESS package function.

  • SR Type: Enforces application-specific security based on service request types. This type of application-specific security can be enforced on views pertaining to Oracle Depot Repair, Oracle Field Service, and Oracle TeleService that contain the CS INCIDENTS ALL B table or the

For more information about application-specific security, see the MagnitudeNoetixViews Administrator Guide.

Modifying View Settings

The settings that you can modify for a view include view description, view essay, role label settings, keyword settings, and security code.

To modify the settings of a view

  1. On the NoetixViews Workbench home page, clickModify a View. TheModify Viewpage appears.

  2. Select a view that you want to modify, and then click Modify. The Modify View » <view label> page appears. For information, see Select a View.

  3. Under View, click Modify view properties, and then click Next. The Modify View » <view label> » Modify view properties page appears.

  4. In the Description (up to 80 characters) box, perform the required modification. The description can contain a maximum of 80 characters.

  1. In the View essay (up to 3000 characters) box, perform the required modification. The view essay can contain a maximum of 3,000 characters.

  1. If required, modify the list of keywords displayed for the view. To modify the list, do one of the following:

    1. If you want to add a keyword, in the Keywords box, type a keyword, and click Add to add the keyword to the list of keywords. Keywords are used as index entries in the Microsoft WinHelp format of the Noetix Help File.IMPORTANT: The keywords added to a view must be unique.If you try to add a duplicate keyword, an error message will be displayed.

    2. If you want to remove a keyword, select the keyword from the list, and then click Remove. If you want to select multiple keywords from the list, press CTRL and click the keywords.

  2. In the Role Labels list, perform the required modification. By default, an appropriate role label corresponding to the detected application of the view is selected. To modify the role label settings, follow these steps:

    1. Click Add. The Add Role Labels dialog box is displayed.

    2. In the Labels list, select the role label that you want to add. To select multiple role labels, press CTRL, and then click the role labels. The role labels displayed in theLabelslist are populated based on the NoetixViews modules available in your NoetixViews schema.NOTE: A role label contains a collection of roles that can be assigned to Noetix query users to provide them access to the required form of the view.

    3. Click Add. The selected role labels are added to the Role Labels list.

    4. If you want to remove a role label from the Role Labels list, select a role label, and click Remove. To select multiple role labels, press CTRL, and then click the role labels.

  3. If the view that you are modifying is not a list of values (LoV) view, and if you want to modify the existing application-specific security settings configured for the view, in the Security code list, click an appropriate security code. The values available for selection depends on the application-specific security available for the application associated with the view. For example, if the view that you are creating belongs to Oracle Financials, only the Account value will be available for selection.

  4. If you are modifying a base view, in the Sort layer (0 to 999) box that appears, change the order for the base view in which the view needs to be processed. The sort layer specifies the order in which the view is processed during the Stage 4 of the generation process.

    IMPORTANT: Make sure that the sort layer value of the base view is lower than the sort layer value of the dependent views.

  5. In the Customization comments box, provide a summary of the customizations that you have performed. The customization comments can contain a maximum of 200 characters.

  6. Click Save. The customizations are saved, and the Modify View» <view label> page appears.

Now, you can choose to perform any other customizations on the same view or go to the home page.

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