Changes Required to Module-Specific Schema References

With the upgrade in January 2022 of Oracle software that controls Mountaineer Administrative Processes (MAP), all SQL scripts referencing a specific module schema (such as HR, GL, AP, WVUHR, WVUFIN) will need to be replaced with ‘APPS’.  ITS-created scripts will be remediated by ITS. If you locate a script created by ITS that has not been remediated, submit a MAP support ticket for the script to be remediated or call the ITS Service Desk at 304-293-4444 or 1 (877) 327-9260.

If you have created a SQL query that contains the module schema within the script, you will need to change those references to APPS. If you do not update your scripts, you may be retrieving incorrect data. Your result may not throw an error, but it may be retrieving results based on old versions of the columns in the tables. Even if the data looks correct today, the scripts may start pulling incorrect data in the future when we apply Oracle patches as they are now using the new EBR technology.

The example below shows the changes that you will need to make.