Brian's Blog

« Feed SUBUGLF documentation | Main | Finaid duplicate runs »

December 19, 2007

Additional WOU Consolidation Issues

Note: Reposted from ECS

1. Cron Job user permissions (the Feed to Finance, maybe other processes).

Now some HR/FIS processes are run from CRON by the SIS Cron Oracle User
(BAN_WOUPRD). BAN_WOUPRD needs additional Banner Security privileges
to be able to run these processes. Testing was done with a regular
Banner user rather than the CRON BAN_WOUPRD user, so this problem
didn't show up in testing.

2. Unique indexes in SPRADDR and SPRTELE have seqno as part of the index, and in SPREMRG
have priority. Sometimes these values had to be edited in HR/FIS in order for the
record to load into SIS.

3. GOBTPAC uniqueness constraint kept some PINs from coming over, had to do workaround.

The gobtpac_external_user value in HR/FIS is not synced with the value in SIS, so
duplicates values may occur between the two systems, even though they can't occur
within any one system ( the system appends a number to the value to make it
unique if a duplicate is encountered during PIN creation).

used sql below to fix, testing found no problem with having a null gobtpac_external_user.

update gobtpac@&&HRFIS_LINK hrfis
set GOBTPAC_EXTERNAL_USER = null
where exists (
select 1
from gobtpac sis
where sis.GOBTPAC_EXTERNAL_USER = hrfis.GOBTPAC_EXTERNAL_USER);

The null value allows these records to be loaded.

4. Banner User Security: pre-consolidation, WOU made sure that each Banner user with an
account in both SIS and HR/FIS had the same userid. Then security roles were merged
during consolidation. Roles are applied in alphabetical order, so it's possible that
a low-alphabet letter role will override settings in a higher alphabet letter role.
This has not been a problem so far.

Posted by wendlerb at December 19, 2007 2:30 PM

Comments

Post a comment