With the upgrade in January 2021 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 an issue 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.
...
Current | After revisions |
|---|---|
select papf.full_name, papf.attribute2 WVUID, wp.doc_id,papf.attribute15, papf.email_address from wvuhr.WVUHR_PMTS wp, hr.pay_external_accounts ieba, hr.per_all_people_f papf | select papf.full_name, papf.attribute2 WVUID, wp.doc_id,papf.attribute15, papf.email_address from apps.WVUHR_PMTS wp, apps.pay_external_accounts ieba, apps.per_all_people_f papf |