Skip to main content

Generate NoetixViews

To generate NoetixViews, sign in to the Angles Hub and perform the following steps:

  1. Select Administrator > Noetix Views Administrator. The Noetix Views Administrator page is displayed.

  2. Select New Generation. The New Generation window is displayed.

  3. In Generation Mode, select the required generation mode:

Full generation

If you have selected Full Generation > Proceed, the Installation Setup tab is displayed.

You can monitor the progress of each stage using the progress indicator. To customize its appearance, select the View button and choose between a Circular or Linear display format.

  1. In Stage 1, provide the following details and select Initialize:

    Note: You can terminate the process by selecting the Terminate button. You can also track the configuration progress and system events by expanding the Logs button.

    1. DBA Details:

      • Username: Enter the username of a database user account that has Database Administrator (DBA) privileges.

      • Password: Enter the password of the database user account that has Database Administrator (DBA) privileges.

    2. Schema Details:

      • Noetix Schema User Name: Enter the desired schema username for a new Noetix System Administration User Account.

      • This schema will serve as the owner of the NoetixViews Administrator installation, and will be used to manage and maintain Noetix system configurations.

      • Password: Enter a secure password for the schema for the new Noetix System Administration User Account.

      • Confirm Password: Re-enter the password to confirm.

      • Host : Enter the IP address or server where the database (with DBA privileges) is stored.

      • Service: Enter the service name that is used to connect to the database (with DBA privileges).

      • Port: Enter the port number.

    3. Grant privileges to the Noetix System Administrator?

      To enable full functionality of the Query User Maintenance feature, permanently grant the SELECT ANY TABLE and SELECT ANY DICTIONARY privileges to the Noetix Administrator Account.

      You can grant these privileges each time you run the Query User Maintenance tool to delete Noetix Query User (U) roles. However, temporary grants require entering DBA credentials every time roles are removed.

      Note: Granting these privileges permanently also improves performance during certain Stage 4 installation processes.

      Select Yes (recommended) or No based on your requirement.

    4. Storage Locations: Select the required default and temporary tablespaces.

      • Default Tablespace: The default tablespace is the primary storage location where all permanent database objects—such as tables and indexes—created by the Noetix system administration user account will reside.

      • Temporary Tablespace: The temporary tablespace is used to store intermediate results and temporary data generated during query execution, sorting, or other database operations.

    After the completion of the stage 1, Oracle E-Business Suite (EBS) connection is created in the Connection Manager page.

    After the stage 1 is completed, go to stage 2.

  2. In Stage 2, provide the following details and select Initialize:

    Note: You can terminate the process by selecting the Terminate button. You can also track the configuration progress and system events by expanding the Logs button.

    Grant Limited Privileges to AOL Data

    APPS User Credentials: Enter the username and password for the Oracle Applications APPS administrative user account.

    This wizard uses the provided credentials to grant SELECT privileges to the Noetix System Administrator User Account.

    After the stage 2 is completed, go to stage 3.

  3. In Stage 3, provide the following details and select Initialize:

    Note: You can terminate the process by selecting the Terminate button. You can also track the configuration progress and system events by expanding the Logs button.

    APPS User Credentials: Enter the username and password for the Oracle Applications APPS administrative user account.

    This account will be used to run synonym creation statements for the tables granted during stage 2 of the installation process.

    After the stage 3 is completed, go to stage 4.

  4. In Stage 4, provide the following details and select Initialize:

    Note: You can terminate the process by selecting the Terminate button. You can also track the configuration progress and system events by expanding the Logs button.

    • APPS User Credentials: Enter the username and password for the Oracle Applications APPS administrative user account.

      This wizard uses the provided credentials to grant SELECT privileges to the Noetix System Administrator User Account.

    • Payroll User Credentials: Enter the username and password for the Oracle Applications Payroll administrative user account.

      These credentials are required to enable access to payroll-related views and functionality within Noetix.

    • Multi Concurrency Columns

      Enabling multi-concurrency columns enhances data processing performance and scalability.

      In Enable Multi Concurrency Columns?, select Yes to activate multi-concurrency columns, or No to keep the feature disabled.

    • Translation Language: Select the required translation language.

      Important: If you select a translation language other than the Oracle Applications' base translation language (typically 'US - American'), ensure that your Oracle Applications installation includes the necessary translated data. Without it, you may encounter issues such as missing columns or incomplete data in the generated views.

    • View Generation Options

      Select the views you want to generate in the Angles Hub.

      Note: All options include views for both Application Object Library and Noetix Administration Objects.

    • In Answer Builder, select the required options.

      Answer Builder creates answers specific to your Oracle configuration.

    Stage 4 lasts for weeks. After the stage 4 is completed, go to stage 5.

    You can terminate the process by selecting the Terminate button. You can also track the configuration progress and system events by expanding the Logs button.

  5. Go to Stage 5, select Initialize to generate Noetix out-of-the-box reports.

    Note: You can terminate the process by selecting the Terminate button. You can also track the configuration progress and system events by expanding the Logs button.

To update the generated NoetixViews, go to the Pre-update Scripts tab and select Initialize.

To initiate a system diagnostic, go to the Health Check tab and select Perform Health Check.

To view the NoetixViews generation status and download the pregeneration zip file, go to the Miscellaneous tab and select the respective icons under the Actions section.

Partial Generation

If you have selected Partial Generation, select Download pregeneration zip file. The Pre-Generation file is downloaded.

  1. Extract the files and open Command Prompt from the extracted pre-generation directory.

  2. Sign in to the Oracle database using SQL*Plus with Database Administrator (DBA) credentials.

  3. Following is the command format:

    sqlplus <DbaUsername>/<DbaPassword>@<Host>:<Port>/<Service>

  4. After connecting to the Oracle database, run the following installation script:

    @install.sql

  5. You will be prompted to provide the following details for creating and configuring the Noetix Views System Administration Oracle User schema:

    1. Database Administrator username and password

    2. NoetixViews schema details in the database string format

    3. Oracle username and password for the NoetixViews SysAdmin

    4. Default Tablespace to store NoetixViews Objects

    5. Temporary Tablespace to store temporary data during the database operations

    6. Oracle Apps username and password

    7. Grant SELECT ANY TABLE and SELECT ANY DICTIONARY privileges to the Noetix Administrator Account

    After providing the required details, the script will automatically execute all three pregeneration stages in sequence.

  6. Sign in to the Angles Hub application and perform the following steps:

    1. Go to Connection Manager and create an Oracle EBS connection.

    2. Select Administrator > Noetix Views Administrator. The Noetix Views Administrator page is displayed.

    3. Select the Ellipsis icon for the connection that you have created and select Details. The Installation Setup page is displayed.

    4. Run Stage 4 and Stage 5.

    Edit Connection

    1. Go to Administrator > Noetix Views Administrator. The Noetix Views Administrator page is displayed.

    2. To edit any connection, select the required connection and select the Actions > Details button.

      You can also download logs by selecting Actions > Download Logs.

Was this article helpful?

We're sorry to hear that.