You are viewing an old version of this page. View the current version.
Compare with Current
View Page History
Version 1
Current »
If a popsel hasn’t been created in Banner, IT will need to create one for you.
IT information
Run the following PL/SQL:
DECLARE
v_application GENERAL.GLBSLCT.GLBSLCT_APPLICATION%TYPE := 'GENERAL';
v_selection GENERAL.GLBSLCT.GLBSLCT_SELECTION%TYPE := '<username>'; --use oracle username
v_creator GENERAL.GLBSLCT.GLBSLCT_CREATOR_ID%TYPE := v_selection;
v_desc GENERAL.GLBSLCT.GLBSLCT_DESC%TYPE
:= 'Popsel for ' || v_creator;
BEGIN
cos_popsel.p_create_popsel (v_application,
v_selection,
v_creator,
v_desc);
END;
The user will also need permissions for the following forms in BAM:
Create File
The file should be a .csv file, with a header row and only Banner IDs.
Upload the file to jobsub
Go to GJAJFLU
Enter the GJRPSIM for the JOB and navigate to the .csv file that was created
Go to GJRPSIM
Verify records exist on GLAEXTR.
0 Comments