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

Option 2 Regenerate Using Scripts

Option 2: Regenerate Using Scripts

Regenerating Noetix views using scripts involves running a series of scripts from SQL*Plus. The steps you follow are very similar to the steps used when initially generating Noetix views.

This regeneration method is mainly performed on a UNIX-based computer. If the NoetixViews files and scripts are not already present on this computer from the earlier generation, see Load the Software on UNIX in “Installing Noetix Views.”

Generally, during regeneration of views, only Stages 2 through 4 are run. However, you can run Stage 1 to modify tablespace settings or grant the SELECT ANY TABLE and SELECT ANY DICTIONARY privileges to the Noetix System Administration User account by using the install1.sql script available in the NOETIX SYS schema installation folder.

After upgrading NoetixViews to version 6.5 from version 6.2 or later, if you have upgraded Oracle E-Business Suite to Release 12.2.3 or later, for the first regeneration, you must run the install1.sql script using the values provided during the generation. You do not need to run the install1.sql script again for subsequent upgrades of Oracle E-Business Suite.

To regenerate Noetix views using scripts

Using SQL*Plus, connect to the database as the existing Noetix System Administration User:

sqlplus <username>/<password>@<dbconnectstring>

Complete Stages 2, 3, and 4 of the generation process: Run Stages Pregeneration Considerations, Pregeneration Considerations, and Pregeneration Considerations of the views generation process. When prompted whether to save previous settings, ensure that you type Yes to save the role prefixes and query user settings in the database. Do not type No unless directed by insightsoftwareSupport, or if you want to replace the role prefixes in the database with the ones saved in the tupdprfx.sql file in the NOETIX SYS user directory. For more information, see Pregeneration Considerations in “Generation of Views.”

Please note that if you change a role prefix, any reports written against Noetix views within that role will break. Also, changing the multi-currency option during a regeneration of views impacts reports written against the views for Oracle Projects. For information, see Changing the Multi-Currency Option While Regenerating Noetix Views.

If any errors are detected during Stage 4, the Noetix Help File will not be regenerated. As a workaround, after completing Stage 4, you must first run the ifix4sts.sql script to override Stage 4 errors, and then manually regenerate the Noetix Help File. The ifix4sts.sql script is located in the same directory where the install4.sql script is present.

Check creation of concurrent programs: If there are any issues with the creation of concurrent programs, a warning message will be displayed stating that the concurrent program creation has been completed with errors. You need to resolve the warnings or issues listed in the Listerrors cm.lst file. Then, connect to the database through SQL*Plus as the Noetix System Administration User, and run the wnoetx conc pgm create.sql script. The missing concurrent programs will be created. If you need assistance in resolving the issues or running the script, contact insightsoftwareSupport.

Run the listchng script (optional): This will create a file showing differences between your previous and new generations.

start listchng.sql

These changes will be contained in the listchng.lst file.

Regenerate answers: You will need to rerun the Noetix Answer Builder. After successfully running the Noetix Answer Builder, use the Noetix generators to update your answers, as well as to generate your query user data into the meta-layers of the business intelligence (BI) tools. For more information, see Option 2 Regenerate Using Scripts.

Regenerate the Noetix Help File: You will need to regenerate your Noetix Help File to reflect your updated generation. For information about generating and distributing the Noetix Help File, see Option 2 Regenerate Using Scripts.

Update query tools (if needed): Refer to your query tool documentation to see if your tools or their meta-layers need to be updated. If you are using Angles for Oracle Generator for Oracle Discoverer (Angles for Oracle Generator) in conjunction with Oracle Discoverer, you will need to extract views as described in the Angles for Oracle Generator for Oracle Discoverer Administrator Guide to update your End User Layer (EUL).
Published:

Option 2 Regenerate Using Scripts

Option 2: Regenerate Using Scripts

Regenerating Noetix views using scripts involves running a series of scripts from SQL*Plus. The steps you follow are very similar to the steps used when initially generating Noetix views.

This regeneration method is mainly performed on a UNIX-based computer. If the NoetixViews files and scripts are not already present on this computer from the earlier generation, see Load the Software on UNIX in “Installing Noetix Views.”

Generally, during regeneration of views, only Stages 2 through 4 are run. However, you can run Stage 1 to modify tablespace settings or grant the SELECT ANY TABLE and SELECT ANY DICTIONARY privileges to the Noetix System Administration User account by using the install1.sql script available in the NOETIX SYS schema installation folder.

After upgrading NoetixViews to version 6.5 from version 6.2 or later, if you have upgraded Oracle E-Business Suite to Release 12.2.3 or later, for the first regeneration, you must run the install1.sql script using the values provided during the generation. You do not need to run the install1.sql script again for subsequent upgrades of Oracle E-Business Suite.

To regenerate Noetix views using scripts

Using SQL*Plus, connect to the database as the existing Noetix System Administration User:

sqlplus <username>/<password>@<dbconnectstring>

Complete Stages 2, 3, and 4 of the generation process: Run Stages Pregeneration Considerations, Pregeneration Considerations, and Pregeneration Considerations of the views generation process. When prompted whether to save previous settings, ensure that you type Yes to save the role prefixes and query user settings in the database. Do not type No unless directed by insightsoftwareSupport, or if you want to replace the role prefixes in the database with the ones saved in the tupdprfx.sql file in the NOETIX SYS user directory. For more information, see Pregeneration Considerations in “Generation of Views.”

Please note that if you change a role prefix, any reports written against Noetix views within that role will break. Also, changing the multi-currency option during a regeneration of views impacts reports written against the views for Oracle Projects. For information, see Changing the Multi-Currency Option While Regenerating Noetix Views.

If any errors are detected during Stage 4, the Noetix Help File will not be regenerated. As a workaround, after completing Stage 4, you must first run the ifix4sts.sql script to override Stage 4 errors, and then manually regenerate the Noetix Help File. The ifix4sts.sql script is located in the same directory where the install4.sql script is present.

Check creation of concurrent programs: If there are any issues with the creation of concurrent programs, a warning message will be displayed stating that the concurrent program creation has been completed with errors. You need to resolve the warnings or issues listed in the Listerrors cm.lst file. Then, connect to the database through SQL*Plus as the Noetix System Administration User, and run the wnoetx conc pgm create.sql script. The missing concurrent programs will be created. If you need assistance in resolving the issues or running the script, contact insightsoftwareSupport.

Run the listchng script (optional): This will create a file showing differences between your previous and new generations.

start listchng.sql

These changes will be contained in the listchng.lst file.

Regenerate answers: You will need to rerun the Noetix Answer Builder. After successfully running the Noetix Answer Builder, use the Noetix generators to update your answers, as well as to generate your query user data into the meta-layers of the business intelligence (BI) tools. For more information, see Option 2 Regenerate Using Scripts.

Regenerate the Noetix Help File: You will need to regenerate your Noetix Help File to reflect your updated generation. For information about generating and distributing the Noetix Help File, see Option 2 Regenerate Using Scripts.

Update query tools (if needed): Refer to your query tool documentation to see if your tools or their meta-layers need to be updated. If you are using Angles for Oracle Generator for Oracle Discoverer (Angles for Oracle Generator) in conjunction with Oracle Discoverer, you will need to extract views as described in the Angles for Oracle Generator for Oracle Discoverer Administrator Guide to update your End User Layer (EUL).
For an optimal Community experience, Please view on Desktop