This job aid shows production campus users how to connect their masked campus solutions database to a non-production CHRS database with DB links only.
Overview
DB Links are the only connection needed for development or testing unless you are modifying the campus' provisioning code. Campuses can connect their own masked CS database to any of the CHRS production support databases.
Connect CS to CHRS
Step 1: Login to Campus CS Environment using SYSADM
Step 2: Drop the any DB links that are already established by using SQL:
DROP DATABASE LINK XXXXX;
Where XXXXX is the database link name
Before you execute, update the XXXXX with the database link name
Step 3: Create DB link using SQL:
exec system.csu_dblinks.build_hrxcs('hachr***');
Before you execute, confirm the target database name.
Step 4: Recreate the Crosswalk table using SQL:
DELETE FROM PS_CSU_CHRS_XREF;
INSERT INTO PS_CSU_CHRS_XREF(CSU_CHRS_ID, CSU_CS_ID)
SELECT CSU_CHRS_ID, CSU_CS_ID
FROM PS_CSU_EMPL_MAP_VW@CSU_CS_HR_LINK A
, PS_INSTALLATION B
WHERE B. COMPANY = 'XX' AND A.BUSINESS_UNIT = 'XXCMP';
COMMIT;
The Crosswalk table must always be rebuilt in CS. When recreating the Crosswalk table, B. Company is from the Campus Solutions PS_Installation Table and A. Business_Unit from CHRS. The campus codes can be located in the CHRS Library.
0 Comments
Add your comment