peoplesoft enterprise - cs 9.0 bundle 20 release notes - ndus sits

75
Peoplesoft Enterprise - Campus Solutions - 9.0 Bundle #20 PeopleSoft Enterprise - CS 9.0 Bundle 20 Release Notes Campus Solutions Student Administration These release notes reflect application updates for PeopleSoft Enterprise Campus Solutions Student Administration products in CS 9.0 Bundle 20. Product Category Incident ID Reported Problem Description Problem Description Resolution Description Other 1947767001 Request ability to link course attributes of the course catalog to course list Customer would like the ability for course lists to reference course attribute values defined in the course catalog, as in a DLST of Course Attribute = 'X' Added new fields to RQ_LN_DETL_TBL and RQ_LN_DETL_VW for the course attribute and value. Then added the fields to pages ADVIS_RQ_LN_DETAIL and CRSE_RQ_LN_DETAIL to be used in derived list setup. Added a new translate value ATT - Course Attributes to field LIST_RECALL_MODE. Modified peoplecode in application package SAA_ACADEMIC_ADVISEMENT:AA_Requirement and AA_RequirementLineDetail to manipulate of the setup pages to properly hide/unhide and initialize the new fields when different setup values are selected. Modified COBOL programs associated with retrieving the setup of the requirement line details, saving results, and processing derived lists to enable the processing to work properly. The SQRs SRGRPADV.sqr and SRRQRADV.sqr to display the new setup values in the reports. Academic Advisement Copyright Oracle Corporation 2010. All rights reserved. 2

Upload: others

Post on 10-Feb-2022

9 views

Category:

Documents


0 download

TRANSCRIPT

Peoplesoft Enterprise - Campus Solutions - 9.0 Bundle #20

PeopleSoft Enterprise - CS 9.0 Bundle 20 Release Notes Campus Solutions Student Administration These release notes reflect application updates for PeopleSoft Enterprise Campus Solutions Student Administration products in CS 9.0 Bundle 20.

Product Category Incident ID Reported Problem

Description

Problem Description Resolution Description

Other 1947767001 Request ability to link

course attributes of

the course catalog to

course list

Customer would like the ability for course lists to

reference course attribute values defined in the

course catalog, as in a DLST of Course Attribute =

'X'

Added new fields to RQ_LN_DETL_TBL and

RQ_LN_DETL_VW for the course attribute and value. Then

added the fields to pages ADVIS_RQ_LN_DETAIL and

CRSE_RQ_LN_DETAIL to be used in derived list setup.

Added a new translate value ATT - Course Attributes to

field LIST_RECALL_MODE. Modified peoplecode in

application package

SAA_ACADEMIC_ADVISEMENT:AA_Requirement and

AA_RequirementLineDetail to manipulate of the setup

pages to properly hide/unhide and initialize the new fields

when different setup values are selected. Modified COBOL

programs associated with retrieving the setup of the

requirement line details, saving results, and processing

derived lists to enable the processing to work properly. The

SQRs SRGRPADV.sqr and SRRQRADV.sqr to display the

new setup values in the reports.

Academic

Advisement

Copyright Oracle Corporation 2010. All rights reserved. 2

Peoplesoft Enterprise - Campus Solutions - 9.0 Bundle #20

Product Category Incident ID Reported Problem

Description

Problem Description Resolution Description

Reports 1672047001 Informational text on

advisement reports

Many schools have a need to publish text at the top

of the Academic Advisement Report, be it a

disclaimer, various instructions, or an introduction.

Currently this is done by coding a requirement and

displaying the description. In 9.0 new problems

arise. First, the requirement has to be coded in

such a way that it is always satisfied, or the AAR will

never close. But since it is satisfied, the

requirement comes up closed on the audit, and so it

isn't there in front of student for them to read. We

need the option to have the text always display.

Also word 'satisfied' always appears (or 'not

satisfied') which is inappropriate for text messages

like this. Can we have an effective way to publish

an attractive header text (or better yet text

messages throughout the AAR) without getting

caught up in these issues about the way

requirements function and display?

Added new field SAA_HIDE_STATUS to the setup tables

RQ_GRP_TBL, RQ_MAIN_TBL, AND RQ_LINE_TBL as

well as report tables/view SAA_ADV_RESULTS,

SAA_ARSLT_RGVW, SAA_ARSLT_RLVW,

SAA_ARSLT_RQ_VW, and SAA_RPT_RSLT_VW. Modified

the application package peoplecode for

SAA_ACADEMIC_ADVISEMENT:AA_RequirementGroup,

AA_Requirement, and AA_RequirementLine to properly

process the new flag on the setup pages, and

AA_Report:AA_ReportOutput to define the field in the XML

file used for producing AA reports. The File Layout

SAA_Report was modified to add the new field and the

XMLP reports SAA_STD_DS and SAA_STD_BATCH and

all associated pieces were modified to include the new

templates for the reports. Modified the AA COBOL

programs/copybooks/dms used in selecting the AA setup

tables, passing the data to the reporting programs, and the

reporting programs for the new advisement reports to track

SAA_HIDE_STATUS.

Reports 1770054001 Search by My

Requirements

sometimes shows

requirement as

satisfied when it is not

If the requirement requires more units than the

individual lines it will display as "Satisfied" on

Search by My Requirements when detail is not

displayed.

The RowInit code for SAA_ARSLT_RLVW.RQ_LINE_NBR

was modified so that Satisfied / Not Satisfied gets assigned

to DERIVED_SAA_DPR.DESCR3 depending on the value

of

SAA_ARSLT_RLVW.REQUIREMENT.GetRelated(SAA_AR

SLT_RQVW.ITEM_R_STATUS).Value, not

SAA_ARSLT_RLVW.ITEM_R_STATUS.

Academic

Advisement

Copyright Oracle Corporation 2010. All rights reserved. 3

Peoplesoft Enterprise - Campus Solutions - 9.0 Bundle #20

Product Category Incident ID Reported Problem

Description

Problem Description Resolution Description

Reports 1942551001 Transfer course

satisfies requirement

line but does not

appear on

Advisement Report

A student completed a transfer course, and it is

equated to an internal equivalent on the transfer

credit model. The course was equivalent at the time

the student took it. Subsequently, the course is

inactivated in the course catalog. The transfer credit

is posted to an articulation term that is after the

effective date of the inactivation on the course

catalog. The AA setup is such that the student's

catalog requirements list the course as satisfying a

requirement line. A new effdt row is entered on the

course list and requirement when the course

becomes inactive. When the advisement report is

generated, the course satisfies the requirement line,

but it does not display on the report. If the course is

made active again, it does display.

In function Load_ReqLine_Crselist

(FUNCLIB_SSTS_PL.RQ_LINE_NBR.FieldFormula), the

code that filters the data displayed in the report was

corrected to exclude inactive courses only if they are

coming from the list of courses available

(SAA_ACRSE_AVLVW). This ensures that inactive courses

from the courses used list would appear on the report.

Peoplecode

DERIVED_SAA_DPR.SAA_DESCRLONG_07.FieldChange

and SSS_CRSE_OFFER_DTL(GBL).PostBuild were also

modified to make the Course Detail drilldown work properly.

Reports 1969304001 The online

advisement report is

excluding an inactive

course from being

used in the audit

when it should be

used.

The online advisement report is excluding an

inactive (transfer) course from being used in the

audit when it should be used based on the student's

requirement term and the effective date of the

requirement. The pdf report is using the course

correctly.

Refer to 1942551001.

Reports 1991135001 Blank field causing

view

SAA_RPT_RSLT_VW

to hang.

Unable to view individual advisement reports as

PDF and batch print step for advisement reports

fails due to the view SAA_RPT_RSLT_VW hanging.

Changed the SQL Text in the view SAA_RPT_RSLT_VW to

properly set a long field to the proper empty value for all

platforms.

Academic

Advisement

Copyright Oracle Corporation 2010. All rights reserved. 4

Peoplesoft Enterprise - Campus Solutions - 9.0 Bundle #20

Product Category Incident ID Reported Problem

Description

Problem Description Resolution Description

Reports 1991866001 Advising report using

incorrect course

equivalency group.

When the course catalog has an effective dated

change and the course equivalency group is

changed, the advisement report uses the course

equivalency group on the latest course catalog

effective dated row instead of the one from the

course catalog row in effect when the student took

the class.

Modified the logic in program SRPCACOL.CBL paragraph

80000-LOAD-SEARCH-ARRAYS to use the start date of

the class to pick up the course equivalencies instead of the

asof-date from the report request.

Reports 2017793001 Advisors' self-service

access to students

advisement reports is

not as expected

AA Report in Self Service does not obey advisor

security and always defaults to one report type for

one institution. Say a student is active in two

institutions and has two different advisors for both.

When the advisors attempt to access the student's

respective advisement report in self service, even if

they do not have access to the other institutions

report, they are able to access it.

A new configuration setting was added to the Advisement

Self-service options (Setup SACR > Common Definitions >

Self Service > Academic Advising) to provide flexibility in

implementing security as defined in Setup SACR > Security

> Secure Student Administration > Userid > Advisement

Report Security. Code has been added in

SAA_ARPRT_SRCA.EMPLID.SearchInit and

SAA_SS_DPR_ADB(GBL).PreBuild to obey the security

settings.

Usage 2015056001 Transfer courses

equated to inactive

courses no longer

pulled into

Advisement after

Bundle #18

After applying Bundle 18, transfer courses that

previously (prior to applying Bundle #18) met

requirement lines but did not appear on the

Advisement Report now do not meet requirement

lines. They appear to not be brought into the

advisement report at all. We need them to continue

to meet requirements.

Removed the second occurrence of the field GRADING-

SCHEME in the copybooks SRCSCEX2.CBL and

SRCSCEX4.CBL.

Contributor

Relations

General 1980386001 AV_ACTN_STF_VW

lacks effective date

logic on

PS_INSTITUTION_TB

L.

Within this delivered view - AV_ACTN_STF_VW, the

EFFDT logic is not coded and needs to be since it is

a primary key to PS_INSTITUTION_TBL

Added the EFFDT and EFF_STATUS condition for the 3

views (AV_ACTN_STF_VW, AV_ACTN_VOL_VW &

AV_ACTN_UNT_VW) on PS_INSTITUTION_TBL and

1. EFFDT and EFF_STATUS condition on PS_AV_STAFF

table for views AV_ACTN_STF_VW and

AV_ACTN_VOL_VW.

2. EFFDT and EFF_STATUS condition on AV_UNIT_TBL

table for view AV_ACTN_UNT_VW.

Academic

Advisement

Copyright Oracle Corporation 2010. All rights reserved. 5

Peoplesoft Enterprise - Campus Solutions - 9.0 Bundle #20

Product Category Incident ID Reported Problem

Description

Problem Description Resolution Description

COD DL 1314642002 Loan Origination

creates Loan

Application for

Stafford Loans where

the student has no

ISIR

In Pell Processing, if a student doesn't have an ISIR

on file, the student is not selected for processing.

However, Loan Origination will select and create a

Loan Ap for the student. For Direct Lending, when

the record is sent the SSN, Last Name and Date of

Birth are sent as 'NONE' on the outbound file.

When returned from COD, the response file cannot

be loaded due these values (COD Inbound abends).

Because an ISIR is required for Stafford Loans,

Loan Origination should not process the student like

the Pell Origination Process. A Loan Edit can be

created to check for this but customers would like to

see the Loan from being created up front.

Added validation check to FAPLDAD2.cbl to stop

processing if student has no ISIR and is awarded with DL

loan.

COD DL 1501178002 Direct PLUS Loans on

'hold' in DL pages

when credit denial

exists

A DL PLUS loan is originated and sent to COD.

When the COD accepts the PLUS loan document

and sends a response back as accepted but with a

credit denial - they don't actually build the award at

COD. So if any origination changes are sent to COD

for a loan in that situation, COD will send back a

rejected file with missing values, because it doesn't

have an origination for the loan at all. When the user

loads this rejected file, the PLUS loan will be placed

in a 'hold' status.

Seems the solution is either to include all of the

fields that were originally sent in the PLUS

origination file in the change file or to place the loan

on 'hold' (or some other status that would prevent

changes from going out) when the credit denial file

is loaded.

Added translate value “L” to LN_ACTION_STATUS - Lower

Endorser Amount accepted/ Endr Accpt.

Added translate value “L” to LOAN_CRDT_OVRID - Lower

Endorser Amount / Lower Amt.

Modified FAPDLINB.cbl and fapdlinb.dms.

Modified FAPDLOCH.cbl and fapdloch.dms.

Financial Aid

Copyright Oracle Corporation 2010. All rights reserved. 6

Peoplesoft Enterprise - Campus Solutions - 9.0 Bundle #20

Product Category Incident ID Reported Problem

Description

Problem Description Resolution Description

COD DL 1632167002 Array length in

FACLLNK0.CBL

needs to be increased

The Direct Loan Out cobol - FAPLDODO failed

because we exceeded the max array size of 500 in

FACLLNKO.CBL. We need this array size

increased so that the job completes successfully.

We have increased the array to 999 but need this

incorporated into the delivered program.

Increased the max array size from 500 to 750 in

FACLLNK0.CBL

COD DL 1671745003 New Direct Loan loan

edits

An April 2007 bulletin (DLB -07-06) from the Dept of

Ed speaks of new edit messages that COD will now

be sending for origination fee percent changes after

7/1/2007. Please add the new DL edits to the Loan

Action Codes setup.

Added the new edit codes to appropriate records. Also few

edit codes deleted to match the Technical reference

document Records modified PS_SFA_COD_EDIT,

PS_LN_ACTNMSG_TBL, PS_PELL_COMNT_TBL

COD DL 1757420001 DL validation issue -

NSLDS Match

Override

Users have noticed that when the DL loan validation

process is performed that students whose ISIR was

initially in default but then overridden they have to

override again in the DL App because loan

validation edits do not look to see if there is an

override. It really should check to see if there is an

override, and it does not.

Made changes to the FAPLOFC0.cbl and FAPLOFC0.dms.

Included NSLDS-OVRD field in the cobol and dms. I added

a condition so that the NSLDS Default Process section

does NOT get called if NSLDS-OVRD checkbox is

CHECKED in Student Aid Attribute page.

COD DL 1843003001 Running promissory

note communication

FAPLDPN2.cbl

resulted in a subscript

error

The Create DL Pnote Communication process ends

with an error when users have more than 250 rows

in the table PS_LN_TYPE_TBL for an aid year. The

cobol program has an internal table/array that only

holds 250.

Increased the max array size from 500 to 750 in

FAPLDPN2.CBL

Financial Aid

Copyright Oracle Corporation 2010. All rights reserved. 7

Peoplesoft Enterprise - Campus Solutions - 9.0 Bundle #20

Product Category Incident ID Reported Problem

Description

Problem Description Resolution Description

COD DL 1854923001 Change record sent to

COD when PLUS or

Grad PLUS loan

accepted but credit

denied

COD doesn't actually record a Plus or Grad Plus

loan in their system when the origination is

approved but the credit check is denied. For many

of these loans, users end up cancelling the loan

which is producing a change record that is sent to

COD. The change comes back rejected and they

have to remove the hold off, originate online and

then accept the origination manually so a change

record isn't actually produced. If an email or

address change is later picked up for this student,

another change record is produced and rejected

and they have to update the loan manually again.

Added translate value “L” to LN_ACTION_STATUS - Lower

Endorser Amount accepted/ Endr Accpt.

Added translate value “L” to LOAN_CRDT_OVRID - Lower

Endorser Amount / Lower Amt.

Modified FAPDLINB.cbl and fapdlinb.dms.

Modified FAPDLOCH.cbl and fapdloch.dms.

COD DL 1873309001 Loan origination

(FAPLBOG1) fails due

to the number of loan

types

The loan origination process is failing because we

have over 500 loan types setup. We modified

FACLLNK0.cbl and increased the occurs of LN-

TYPE-DATA from 500 to 750 but when we did that

the loan origination process wouldn't originate any

new loans at all and the log file showed a "message

table is full - skipped' error.

Increased the max array size from 500 to 750 in

FACLLNK0.CBL and FACLOFC0.cbl

COD DL 1898931001 Allow citizenship

status for DL loans to

be selected from the

ISIR record instead of

Campus Community

Users would like the DL process to pull citizenship

status from the ISIR rather than Campus

Community pages.

Modified FAPLORG0.cbl: for DL SUB and not DL UNSUB

do not to populate CITIZENSHIP_STATUS when new

record is inserted.

Modified FAPLDAD2.cbl : Create a change only if

transmitted status does not match the one on Origination

record.

Modified FAPDLOVL.cbl: Removed validation of citizenship

status for Subsidized and not Unsubsidized .

Financial Aid

Copyright Oracle Corporation 2010. All rights reserved. 8

Peoplesoft Enterprise - Campus Solutions - 9.0 Bundle #20

Product Category Incident ID Reported Problem

Description

Problem Description Resolution Description

COD DL 1950708001 Direct Loan Outbound

File creation Middle

Initial Edit Check

Note that the following error only occurs when

running on a Unicode DB. When running PSJob

DLOUT, user is receiving errors for Invalid Middle

Initial. The check being done in COBOL

FAPDLOVL appears to be the problem. It is using

WS-ALPHA-NUM, which contains only Capital

letters. So when there are Upper/Lower values in

the PS_NAMES table, it errors on Middle Initial. The

check for First and Last name is being done using

WS-ALPHA-NUM-1, which is what we believe the

Middle Initial should be checked against.

Modified FAPDLOVL.cbl and copy book FACCODRW.cbl.

COD DL 1988240001 Loan Origination

(FAPLBOG1) errors

with subscript out of

range

Process: FAPLBOG1

When running Loan Origination for multiple careers,

the process abends with the following error...

Object Code error : file cblbin/FAPLBOG1.gnt'

error code: 153, pc=0, call=1, seg=0

153 Subscript out of range (in FAPLBOG1.cbl,

line 3250)

Initialized DL-INST-CHG-PARMS in the Table Setup Data

of FAPLBOG1.cbl

COD DL 1997769001 COD International

Addresses:

<StateProvince> is

only reported if valid

according to

Technical Reference

guide.

Issue regarding the reporting of International

addresses for all COD program. When determining

if the <StateProvince> is to be included with a value,

program must validate that <StateProvince> is a

valid value that is listed in the Technical Reference

guide. If not, <StateProvince> tag is not reported at

all. For example, <StateProvince>New South

Wales is being reported in Australian addresses.

Code modifications were made to

FAPDLOOR.cbl,FAPDLOCH.cbl, FAPPLOOR.cbl,

FAPASOOR.cbl to ensure that tag <StateProvince> is

included in the XML file only when it is one among the valid

values listed in the Technical Reference Guide.

Financial Aid

Copyright Oracle Corporation 2010. All rights reserved. 9

Peoplesoft Enterprise - Campus Solutions - 9.0 Bundle #20

Product Category Incident ID Reported Problem

Description

Problem Description Resolution Description

COD DL 2000768001 For a single db inst

with multiple attending

school codes - Direct

Loan ID assigned in

Loan App ID and

Routing ID in xml

incorrect.

For a single db inst with multiple attending school

codes - Direct Loan ID assigned in Loan App ID and

Routing ID is xml incorrect. Issue occurs when an

institution has valid attending school codes, yet only

some codes are eligible to participate in the Direct

Loan program.

Modified FAPPKCTL (cbl & dms) to select (via S_STUISIR)

OWNING_SCHOOL_CD from ISIR_CONTROL. When

available, OWNING_SCHOOL_CD will now be used as

CPS-SCHOOL-CODE.

COD DL 2003269001 DL Loan Validation

Edit for Citizenship

Status

Please remove from the DL Loan Validation process

the edit which requires a valid Citizenship Status.

As of 28 Jun 2010, COD has removed that edit from

their code, and is now treating Citizenship Status

the same for DL and Pell processing. Details of the

announcement are at

http://www.nasfaa.org/publications/2010/eacodimp0

62510.html.

Modified FAPLORG0.cbl: for DL SUB and not DL UNSUB

do not to populate CITIZENSHIP_STATUS when new

record is inserted.

Modified FAPLDAD2.cbl : Create a change only if

transmitted status does not match the one on Origination

record.

Modified FAPDLOVL.cbl: Removed validation of citizenship

status for Subsidized and not Unsubsidized .

Financial Aid

Copyright Oracle Corporation 2010. All rights reserved. 10

Peoplesoft Enterprise - Campus Solutions - 9.0 Bundle #20

Product Category Incident ID Reported Problem

Description

Problem Description Resolution Description

COD DL 2005010001 COD sends pnote

status of 'I' (inactive)

and loan will not

authorize or transmit.

In the COD Tech Ref, 'Section 2: Message Classes'

section dated 6/30/2010, COD has included some

additional valid values for which PeopleSoft does

not load.

For the tag <MPNStatusCode>, the following are

valid values:

A = Accepted

R = Rejected MPN or valid MPN not on file at COD

P = Pending

C = Closed

I = Inactive

When a CRPN file is loaded where the

<MPNStatusCode> = 'I', the MPN Status on the

Direct Loan management page goes to a blank, as it

appears the DL Inbound process doesn't handle an

Inactive status. This is causing us to have to

manually override the MPN status so as to be able

to disburse the funds to the borrower.

Added new translate values of "I" and "C" to

LN_ORIG_PNOTE_STAT and LN_PHONE_STATUS. All

programs were update to process the Inactive and Closed

status as an Accepted status. Also, the new Pending status

code of "P" will be translated into the existing Pending

status code of "X" within the system.

COD DL 2005755001 2011 - 2012 Aid Year

Changes for COD

Direct Lending.

Annual regulatory changes for 2011 - 2012 Aid Year

for the COD Direct Lending Process.

Made annual regulatory changes for Aid Year 2011-2012

for the COD DL. Changes include modifying the batch

objects and online objects

Financial Aid

Copyright Oracle Corporation 2010. All rights reserved. 11

Peoplesoft Enterprise - Campus Solutions - 9.0 Bundle #20

Product Category Incident ID Reported Problem

Description

Problem Description Resolution Description

COD DL 2007468001 DL MPN Status Being

Overwritten

Direct Loan is awarded and the Promissory Note

acknowledgement is received before the Loan

Origination acknowledgement. When the Loan

Origination Acknowledgment is received it is wiping

out the MPN Status and MPN Expiration Date.

Modified procedure XXXXX-UPDATE-ORIGAK-PNOTE-

STAT and XXXXX-UPDATE-ORIG-TRANS-FIELDS in

FAPDLINB.cbl to ensure the code retains the current MPN

Expiration date and the MPN Status and doesn't override

with spaces when the incoming response file doesn't have

the MPN Expiration date and MPN Status values.

COD DL 2010872001 Rebate Fee Amount

does not display

correctly on the

Application Financial

page

Direct Loan fee and rebates are always truncated,

there are never any cents. The origination fee is

rounded down to the nearest dollar, and the rebate

is rounded up to the nearest dollar. For AY 2011,

the orig fee is 1%, rebate fee is .5%. When a DL

loan is awarded for $100 or less, after originating

the loan, the Application Financial page does not

display the Rebate Amt field correctly. It should

show $0.00 but it is blank.

Modified the Page field Properties for Rebate Amount Field.

COD DL 2012478001 Academic Year End

Date not being picked

up by loan

adjustments

The Direct Loan Change Rules setup has a row

entered for Academic Year Start Date to not send a

change. No row is entered for Academic Year End

Date. We have overwritten only the Academic Year

End Date on the Direct Loan Demo Ovrd page.

When the loan origination/adjustments process,

FAPLBOG1, is run the change to the end date is not

picked up. The record is not evaluated for

processing at all. Now if the Academic Year Start

Date is removed from the Direct Loan Change

Rules setup page, the change to the Academic Year

End Date does get picked up during loan

adjustments.

Modified the FAPLDAD2.cbl.Missing End-if Statements for

the Academic Year End Date Block.

Financial Aid

Copyright Oracle Corporation 2010. All rights reserved. 12

Peoplesoft Enterprise - Campus Solutions - 9.0 Bundle #20

Product Category Incident ID Reported Problem

Description

Problem Description Resolution Description

COD DL 2014706001 DL PLUS Loans

rejected due to credit

denial

PeopleSoft has an issue with cancellations of PLUS

loans when a borrower is denied based on credit. In

prior years, when a plus loan was denied during the

origination process, there was never a loan record

created at COD. Regardless of this, when users

canceled those denied PLUS loans, PS would

create correction transactions and they would be

rejected by COD because there was no loan record.

This year COD indicated that they would be creating

loan records. Although COD is now creating quasi

records which can be adjusted, PeopleSoft is not

sending all of the data required in order to adjust the

records. As a result records are getting rejected

because of missing fields.

Added translate value “L” to LN_ACTION_STATUS - Lower

Endorser Amount accepted/ Endr Accpt.

Added translate value “L” to LOAN_CRDT_OVRID - Lower

Endorser Amount / Lower Amt.

Modified FAPDLINB.cbl and fapdlinb.dms.

Modified FAPDLOCH.cbl and fapdloch.dms.

COD DL 2032988001 Population Update:

Loan Origination:

student/borrower

citizenship

Additional record.fields to update using Population

Update tool.

Added LOAN_ORIGNATN/ CITIZENSHIP_STATUS to Pop

Update context. When updating Subsidized/ Unsubsidized/

GRAD PLUS loans also update BORR_CTZNSHP_STAT.

COD DL 2036859001 LN_ENDORS_AMT

Defined to Small

The field LN_ENDORS_AMT on the record

LOAN_ORIGNATN is defined with a length of 5, but

we are starting to receive loan endorsed amounts

from COD that are 6 digits in length. These 6 digit

values are stored correctly on the database but do

not display correctly on the page and cause issues

downstream with our data warehouse build that

expects only 5 digits in this field based on the App

Designer record definition.

ICE resolved by defining it as a 12 decimal field:  0 -

999999999.99

Financial Aid

Copyright Oracle Corporation 2010. All rights reserved. 13

Peoplesoft Enterprise - Campus Solutions - 9.0 Bundle #20

Product Category Incident ID Reported Problem

Description

Problem Description Resolution Description

COD Pell 2005756001 2011 - 2012 Aid Year

Changes for Pell

COD.

Annual regulatory changes for 2011 - 2012 Aid Year

for COD Pell Grant processing.

Made annual regulatory changes for Aid Year 2011-2012

for the PELL COD. Changes include modifying the online

objects

COD Pell 2040959001 Enhance Pop Update

for Pell Origination

The Pop Update process for Pell Origination should

update the Pell_Process_Field to P when it updates

the Update_Pell_Org field to Y.

If Update Pell Orig = Y, then set Pell Process Field to P in

Student Aid Attribute.

Canadian Need Analysis (CNAS)2038095001 Hard-coded title of

secondary page

CNAS_RULE_SET_C

OPY

The title of this secondary page ("Copy CNAS Rule

Sets") is hardcoded in the Record PeopleCode.

Created message to display the title.

Canadian Need Analysis (CNAS)2040755001 Hard-coded title of

secondary page

COST_CODE_COPY

_SEC

The title of secondary page

COST_CODE_COPY_SEC ("Copy Cost Code ") is

hardcoded in PeopleCode.

Created message to display the title.

Canadian Need Analysis (CNAS)2040761001 Hard-coded title of

secondary page

CNAS_MSG_COPY

The title of secondary page CNAS_MSG_COPY

("Copy CNAS Messages") is hardcoded in

PeopleCode.

Created message to display the title.

Canadian Need Analysis (CNAS)2042227001 Hard-coded title of

secondary page

STDNT_CNAS_EXT_

SBP

The title of this secondary page ("Student

Extensions") is hardcoded

Created message to display the title.

Financial Aid

Copyright Oracle Corporation 2010. All rights reserved. 14

Peoplesoft Enterprise - Campus Solutions - 9.0 Bundle #20

Product Category Incident ID Reported Problem

Description

Problem Description Resolution Description

FA Term 2035745001 CS90 Recut2 -

Hardcoded title "FA

Term Field Audits" for

page

STDNT_FA_AUDIT_S

EC

Page title ("FA Term Field Audits") is hardcoded in

peoplecode when you access

STDNT_FA_AUDIT_SEC page.

Found in PeopleCode:

DERIVED_FATERM(RECORD) .

VIEW_FIELD_AUDITS(FIELD) .

FieldChange(METHOD) as PANEL .

STDNT_FA_AUDIT_SEC

&TITLE = "FA Term Field Audits";

[...]

DoModal(Panel.STDNT_FA_AUDIT_SEC, &TITLE, -

1, - 1, 2, Record.FA_FATERM_PARNT,

&CURRENTROW1, Record.STDNT_FA_TERM,

&CURRENTROW2);

As a result, "FA Term Field Audits" displays in

English in non-ENG PIA.

Path to page is as follows: Financial Aid, Financial

Aid Term, Maintain Student FA Term.

Search for: 0043, PSUNV, 2009.

On the STDNT_FA_LOAN page that opens (tab

Financial Aid Info), click the Field Audits link. This

will open the STDNT_FA_AUDIT_SEC page. This is

the STDNT_FA_AUDIT_SEC page that has it's title

hardcoded in PCode.

This issue was encountered in CS90 Recut2 build.

Created message to display the title.

Financial Aid

Copyright Oracle Corporation 2010. All rights reserved. 15

Peoplesoft Enterprise - Campus Solutions - 9.0 Bundle #20

Product Category Incident ID Reported Problem

Description

Problem Description Resolution Description

FA Term 2036469001 CS90 Recut2 -

Hardcoded title

"HERA Academic

Level on FA Term" for

page

SFA_ASG_ELIGAL_S

EC

Page title ("HERA Academic Level on FA Term") is

hardcoded in peoplecode when you access

SFA_ASG_ELIGAL_SEC page:

Found in PeopleCode:

DERIVED_GRANTS(RECORD) .

SFA_ASG_FAT_AL_PB(FIELD) .

FieldChange(METHOD) as PAGE .

SFA_ASG_ELIGAL_SEC

"If %Page = Page.SFA_ASG_ELIG Then

DoModal(Page.SFA_ASG_ELIGAL_SEC, "HERA

Academic Level on FA Term", - 1, - 1);

End-If;"

As a result, "HERA Academic Level on FA Term"

displays in English in non-ENG PIA.

Path to page is as follows: Financial Aid,

ACG/SMART Grants, ACG/SMART Grant Eligibility.

Main Page SFA_ASG_ELIG opens. Click on 'HERA

Level' link on the main page. This will open

SFA_ASG_ELIGAL_SEC. This issue was

encountered in CS90 Recut2 build.

Created message to display the title.

Financial Aid

Copyright Oracle Corporation 2010. All rights reserved. 16

Peoplesoft Enterprise - Campus Solutions - 9.0 Bundle #20

Product Category Incident ID Reported Problem

Description

Problem Description Resolution Description

FA Term 2036483001 CS90 Recut2 -

Hardcoded title "FA

Term Academic

Advisor Information"

for page

STDNT_FA_ADVIS

Page Title "FA Term Academic Advisor Information"

is hardcoded in peoplecode for page

STDNT_FA_ADVIS.

Found in PeopleCode:

DERIVED_FATERM(RECORD) .

VIEW_ADVISOR(FIELD) . FieldChange(METHOD)

as PANEL . STDNT_FA_ADVIS:

&TITLE = "FA Term Academic Advisor Information";

&CURRENTROW1 = CurrentRowNumber(1);

&CURRENTROW2 = CurrentRowNumber(2);

DoModal(Panel.STDNT_FA_ADVIS, &TITLE, - 1, -

1, 2, Record.FA_FATERM_PARNT,

&CURRENTROW1, Record.STDNT_FA_TERM,

&CURRENTROW2);

The hardcoded string displays in English in non-

ENG PIA.

Path to page is as follows:

Financial Aid, Financial Aid Term, Maintain Student

FA Term, FA Term. Click the 'Advisor' link on the FA

Term page. This will open page STDNT_FA_ADVIS.

This issue was encountered in CS90 Recut2 build.

Created message to display the title.

Financial Aid

Copyright Oracle Corporation 2010. All rights reserved. 17

Peoplesoft Enterprise - Campus Solutions - 9.0 Bundle #20

Product Category Incident ID Reported Problem

Description

Problem Description Resolution Description

FA Term 2041433001 Hard-coded title of

secondary page

STDNT_FA_TRM_CE

NDT

Title of secondary page STDNT_FA_TRM_CENDT

is hard-coded in PeopleCode

Created message to display the title.

FA Term 2041439001 Hard-coded title of

secondary page

STDNT_FA_STAT_IN

EL

Title of secondary page STDNT_FA_STAT_INEL

("FA Term Other Units") is hard-coded in

PeopleCode

Created message to display the title.

FA Term 2042618001 Hard-coded title of

secondary page

STDNT_FA_STAT_T

C

The title of this secondary page ("FA Term Transfer

Credits") is hardcoded in PeopleCode

Main page: STDNT_FA_STATS

Field: VIEW_TRNSFR_CREDIT

Found in PeopleCode:

DERIVED_FATERM(RECORD) .

VIEW_TRNSFR_CREDIT(FIELD) .

FieldChange(METHOD) as PANEL .

STDNT_FA_STAT_TC:

Created message to display the title.

Financial Aid

Copyright Oracle Corporation 2010. All rights reserved. 18

Peoplesoft Enterprise - Campus Solutions - 9.0 Bundle #20

Product Category Incident ID Reported Problem

Description

Problem Description Resolution Description

FA Term 2043330001 Page title "FA Term

Campus Information"

is hardcoded on page

STDNT_FA_CAMP_S

EC

Page title "FA Term Campus Information" is

hardcoded in peoplecode when you access page

STDNT_FA_CAMP_SEC:

Found in PeopleCode:

DERIVED_FATERM(RECORD).VIEW_CAMPUS(FI

ELD).FieldChange(METHOD) as

PANEL.STDNT_FA_CAMP_SEC:

&TITLE = "FA Term Campus Information";

&CURRENTROW1 = CurrentRowNumber(1);

&CURRENTROW2 = CurrentRowNumber(2);

DoModal(Panel.STDNT_FA_CAMP_SEC, &TITLE, -

1, - 1, 2, Record.FA_FATERM_PARNT,

&CURRENTROW1, Record.STDNT_FA_TERM,

&CURRENTROW2);

As a result, "FA Term Campus Information" displays

in English in non-ENG PIA.

Navigation path: Financial Aid, Financial Aid Term,

Maintain Student FA Term, click on Campus Info

This issue was encountered in CS90 Recut2 build.

Created message to display the title.

Financial Aid

Copyright Oracle Corporation 2010. All rights reserved. 19

Peoplesoft Enterprise - Campus Solutions - 9.0 Bundle #20

Product Category Incident ID Reported Problem

Description

Problem Description Resolution Description

INAS-FM 1991443001 Dependency Override

made on Simulate

2010-2011 FM INAS

does not update the

ISIR correctly

When the Dependency Override is set on Simulate

2010-2011 FM INAS, INAS run and 'Use Simulated

Data' is clicked, the Dependency Override is

populated on the ISIR and the Formula type

updated to reflect the new Dependency status but

the actual Dependency Status is not updated.

INAS interface programs FAPINAS0.CBL, FAPINAS1.CBL,

and FAPINAS2.CBL - and their corresponding DMS scripts -

were modified, reactivating the update logic for table

INAS_SIM_STU when in 'Simulation' mode. Dependency

Status field (DEPNDNCY-STAT) added to the

INAS_SIM_STU update logic.

INAS-FM 2006491001 Untaxed Income total

field set to blank

instead of Zero

Page: INAS_SIM_STU1_11. The Untaxed Income

field for student's with Auto Zero EFC's, when the

Untaxed income individual figures is changed and

then set back to Zero, the over all Untaxed Income

is blank and not Zero

On pages INAS_SIM_STU1_11 and INAS_SIM_PAR1_11,

the page field settings were modified for the following fields

in order for the Student and Parent 'Untax Income' and

'Additional Financial Total' fields to be visible (display Zero)

at all times:

INAS_SIM_STU.TOTAL_FROM_WS3

DERIVED_SA_STU.CHAR_TOT_FROM_WS3

INAS_SIM_STU.TOTAL_FROM_WKC

INAS_SIM_PAR.TOTAL_FROM_WS3

DERIVED_SA_PAR.CHAR_TOT_FROM_WS3

INAS_SIM_PAR.TOTAL_FROM_WKC

Financial Aid

Copyright Oracle Corporation 2010. All rights reserved. 20

Peoplesoft Enterprise - Campus Solutions - 9.0 Bundle #20

Product Category Incident ID Reported Problem

Description

Problem Description Resolution Description

INAS-FM 2036854001 Hard-coded title of

secondary page

ISIR_TA_SEC

Page title is hard-coded in PeopleCode. Message

text should be used instead of hard-coding.

Corrective action was as follows:

Modified the page description for secondary page

ISIR_TA_SEC. Page description updated from blank to

'Total Allowances Detail'.

Modified the FieldChange PeopleCode for

DERIVED_SA_COMP.XFER_TA_DETAIL, commenting out

the existing DoModal page logic.

Modified Page Field properties for the 'Total Allowances'

hyperlinks on pages ISIR_FM_SUMRY and

ISIR_FM_SUMRY_09, changing the 'Destination' parameter

value from 'PeopleCode Command' to 'Secondary Page',

and entering 'ISIR_TA_SEC' as the 'Secondary Page'

parameter value.

INAS-FM 2036855001 Hard-coded title of

secondary page

ISIR_AI_SEC

Page title is hard-coded in PeopleCode. Message

text should be used instead of hard-coding.

Corrective action was as follows:

Modified the page description for secondary page

ISIR_AI_SEC. Page description updated from blank to

'Total Allowances Detail'.

Modified the FieldChange PeopleCode for

DERIVED_SA_COMP.XFER_AI_DETAIL, commenting out

the existing DoModal page logic.

Modified Page Field properties for the 'Available Income'

hyperlinks on pages ISIR_FM_SUMRY and

ISIR_FM_SUMRY_09, changing the 'Destination' parameter

value from 'PeopleCode Command' to 'Secondary Page',

and entering 'ISIR_AI_SEC' as the 'Secondary Page'

parameter value.

Financial Aid

Copyright Oracle Corporation 2010. All rights reserved. 21

Peoplesoft Enterprise - Campus Solutions - 9.0 Bundle #20

Product Category Incident ID Reported Problem

Description

Problem Description Resolution Description

INAS-FM 2036866001 Hard-coded title of

secondary page

STDNT_FM_ASMP_S

EC

Page title is hard-coded in PeopleCode. Message

text should be used instead of hard-coding.

Corrective action was as follows:

Modified the page description for secondary page

STDNT_FM_ASMP_SEC. Page description updated from

blank to 'Federal Assumption Detail'.

Modified the FieldChange PeopleCode for

DERIVED_SA_COMP.STDNT_FM_ASMPTN_PB,

commenting out the existing DoModal page logic.

Modified Page Field properties for the 'Assumption Detail'

hyperlinks on pages ISIR_FM_SUMRY and

ISIR_FM_SUMRY_09, changing the 'Destination' parameter

value from 'PeopleCode Command' to 'Secondary Page',

and entering 'STDNT_FM_ASMP_SEC' as the 'Secondary

Page' parameter value.

INAS-FM 2040831001 Unable to open

Simulate 2009-2010

FM INAS component

Component: INAS_SIMULATION_10. When

attempting to open the Simulate 2009-2010 FM

INAS component, the following error is returned:

Field does not exist -- DERIVED_SA.

SFA_CHAR_EDUCREDIT

The RowInit PeopleCode for

INAS_SIM_PAR.SFA_EDU_CREDITS was modified as

follows...

OLD:

If %Component = Component.INAS_SIMULATION_10 Or

%Component = Component.INAS_SIMULATION_12

Then

NEW:

If %Component = Component.INAS_SIMULATION_11 Or

%Component = Component.INAS_SIMULATION_12

Then

INAS-IM 2031133001 INAS 2011-2012 IM

Assumption codes

require updating

INAS 2011-2012 IM Assumption codes require

updating. New adds and deletes required for 2011-

2012 Aid Year.

Corrected 2011-2012 IM Assumption code data per INAS

2011-2012 User's Guide.

Financial Aid

Copyright Oracle Corporation 2010. All rights reserved. 22

Peoplesoft Enterprise - Campus Solutions - 9.0 Bundle #20

Product Category Incident ID Reported Problem

Description

Problem Description Resolution Description

INAS-IM 2036199002 Incorrect AESA and

CESA displays on

Institutional

Application Data 2011-

2012

Page: INST_COMP_SUMM_12

On the "Computation Data" page, on the Institutional

Application Data - Maintain Application 2011-2012

component, under the "Education Savings

Calculation" group box, Student column, the data in

the AESA column is showing as y when it should be

numeric, and the data in the CESA column is

showing as 9y when it should be numeric.

Modified code in FAPINAS2.CBL, adding NUMERIC value

checks for fields INAR-I-?-AESA-NO-CHLD-X and INAR-I-?-

CESA-SUM-AGE-X. If either of these Parent/Student INAR

sending fields is numeric, the sending field values will be

loaded to their corresponding target fields. If the sending

fields are NOT numeric, zeros will be loaded to the

corresponding target fields.

INAS-IM 2036211001 Incorrect "Percent

Income" display on

Institutional

Application Data

On the "Computation Data" page, on the Institutional

Application Data - Maintain Application component

(both 2011-2012 and 2010-2011 Aid Years), under

the "Custodial Parent Information" group box, "IM

w/options" column, the "Percent Income" is

truncated. If the value computed is 100% it shows

as 10%.

Modifications made to FAPINAS1.CBL and FAPINAS2.CBL

to reflect actual size of column SFA_CP_PERCENT_INC

which is 3 bytes as opposed to 2 bytes.

INAS-IM 2037851001 Hard-coded title of

secondary page

STDNT_IM_ASMP_S

EC

The title of this secondary page ("STUDENT

CONTRIBUTION - IM w/Options") is hardcoded in

PeopleCode.

Corrective action was as follows:

Modified the page description for secondary page

STDNT_IM_ASMP_SEC. Page description updated from

blank to 'Institutionl Assumption Detail'.

Modified the FieldChange PeopleCode for

DERIVED_SA_COMP.STDNT_IM_ASMPTN_PB,

commenting out the existing DoModal page logic.

Modified Page Field properties for the 'Assumption Detail'

and/or 'IM Assumptions' hyperlinks on pages

INST_INAS_SMRY_00 thru INST_INAS_SMRY_12,

changing the 'Destination' parameter value from

'PeopleCode Command' to 'Secondary Page', and entering

'STDNT_IM_ASMP_SEC' as the 'Secondary Page'

parameter value.

Financial Aid

Copyright Oracle Corporation 2010. All rights reserved. 23

Peoplesoft Enterprise - Campus Solutions - 9.0 Bundle #20

Product Category Incident ID Reported Problem

Description

Problem Description Resolution Description

ISIR 1881847002 FASARE05.SQR

contains unused code

The ISIR Correction Error process (FASARE05.sqr)

contains code that is never called. The Convert-Aid-

Year-2000 procedure is never used and should be

removed.

Commented the unused code in FASARE05.sqr

ISIR 1946456001 Rejected ISIR

Correction Loads

although Suspend on

EFC Mismatch is

selected

When loading a Rejected ISIR, EFC is blank,

although the Suspend on EFC Mismatch is

selected, the ISIR still loads. The difference

between blank and zero is not being recognized

during the compare process.

Updated the FAP00SLD.CBL with a EFC_MATCH_UNK in

an IF condition check to make the Suspend on EFC

Mismatch to True

ISIR 2005760001 2011 - 2012 Aid Year

updates for ISIR

Corrections

Updates for ISIR Corrections for the 2011 - 2012

Financial Aid Year.

Made annual regulatory changes for Aid Year 2011-2012

for the ISIR Corrections. Changes include modifying the

online objects

NSLDS 1928097001 NSLDS Request

does not allow the

entry of OPEID code

Customers in a multi campus setup need the ability

to select the 8 digit OPEID code on the NSLDS

Request component. Currently they can only select

the 6 digit Title IV School code. NSLDS will not

accept records without the OPEID.

Added a new Field Branch Code on the NSLDS Request

Page.Made changes to respective Peoplecode so that the

outbound picks up the new Branch Code Value.

NSLDS 1995150001 Display Aid Year on

the NSLDS Pell

Information page

The NSLDS Pell Data sent on the ISIR is for the

Current Aid Year. On the NSLDS Pell Data all

loaded Pell data is loaded but there is no way to

determine one Aid Year from the other as the Aid

Year field that is on the PS_NSLDS_PELL record is

not displayed on the page. Please add the Aid Year

field to the page.

The Aid Year field has been added into the NSLDS_PELL

page

NSLDS 2005757001 2011 - 2012 Aid Year

Updates for NSLDS

processing.

Annual regulatory changes for 2011 - 2012 Aid Year

for NSLDS processing.

Made annual regulatory changes for Aid Year 2011-2012

for the NSLDS. Changes include modifying the online

objects

Financial Aid

Copyright Oracle Corporation 2010. All rights reserved. 24

Peoplesoft Enterprise - Campus Solutions - 9.0 Bundle #20

Product Category Incident ID Reported Problem

Description

Problem Description Resolution Description

NSLDS 2030769001 Process NSLDS Files

(FAPTALRT) fails

after Bundle #19

When running Process NSLDS Files (FAPTALRT)

after the application of Bundle #19 the following

error is returned:

PTPSQLRT - ERROR IN BIND SETUP/DATA

STATEMENT=FAPTALRT_I_INSGEN

VARIABLE#=00031

DATA TYPE=001

DATA LEN =00001

SCALE =000

Application Program Failed

Action Type : SQL UPDATE

In Pgm Section : SQLRT: PROCESS-

SETUP(BIND)

With Return Code: 08001

Error Message : Invalid bind variable number

Stored Stmt : FAPTALRT_I_INSGEN

SQL Statement : INSERT INTO PS_NSLDS_GEN

(EMPLID , SSN

, NSLDS_PELL_OVRPYMN,

NSLDS_PELL_CNTCT , NSLDS_SEOG_OVRP

YMN, NSLDS_SEOG_CNTCT ,

NSLDS_PERK_OVRPYMN, NSLDS_PERK_CNTC

T , PERKINS_SCHOOL1 ,

PERKINS_SCHOOL2 , PERKINS_SCHOOL3

, CPS_SCHOOL_CODE ,

INSTIT_OE_BR , NSLDS_DOB

, CURRENT_SCHOOL ,

NSLDS_ENR_STAT , NSLDS_LOAN_DEFA

ULT, NSLDS_UPDT_TXN ,

NSLDS_UPDT_SOURCE , LAST_UPDATED

, LAST_SEQ ,

NSLDS_POST_SCREEN , NSLDS_POST_SCRE

Commented the declaration of the two fields

SFA-IASG-OVRPYMN and SFA-IASG-CNTCT in

FAPTALRT.CBL

Financial Aid

Copyright Oracle Corporation 2010. All rights reserved. 25

Peoplesoft Enterprise - Campus Solutions - 9.0 Bundle #20

Product Category Incident ID Reported Problem

Description

Problem Description Resolution Description

Pkg - Aggregates 1784520002 Subsidized and

unsubsidized

incoming aggregates

for current aid year

are not impacting

awarding.

When incoming aggregate detail includes both

subsidized and unsubsidized current aid year

amounts the amounts should be combined to impact

the awarding of subsidized and unsubsidized loans

by the system.

Program FAPPKENG (cbl), paragraph 6400-GET-

STUTAB, was modified to appropriately update each

incoming aggregate entry passed from program FAPPKCTL

(cbl) via the FACPKPKG.cbl copylib into program

FAPPKENG (cbl), table STU-CURRENT-HISTORY.

Pkg - Aggregates 1816791002 Validation error for

Stafford Subsidized

loan when an

undergraduate

becomes a graduate

student

User has a student who is a dependent undergrad

for fall and independent grad for spring. The

student is awarded 2087 in sub DL for fall only.

Now the user wants to award remaining eligibility for

spring. Student is eligible for 6413 (8500-2087), but

validation incorrectly reduces the spring DL add-on

to 5500.

The placement for the execution of the paragraph 4500-

FIND-FIRST-TERM-SPLIT (which determines the first non-

zero disbursement percentage for the term NSLDS grade

level in program FAPPKENG.cbl) has been modified

(moved) to now be executed immediately at the beginning

of paragraph A1000-MAIN-MENU. This change now allows

for the correct assessment of the a multiple grade level

Stafford loan. (Also see resolution 1849345001 which was

resolved using the same revision)

Pkg - Aggregates 1838191001 Unable to Award

Subsidized Stafford

Loan in proper

sequence in midyear

Grade Level Increase

Scenario

Scenario: student is year 2 in fall, increasing to year

3 in spring. Was awarded sub and unsub combo up

to aggregate max for the ac year. Now eligible for

additional sub and/or unsub for spring only at the

new grade level. When attempting to add the new

SUB Stafford in the proper sequence - after the

original sub, but before the original unsub -

validation incorrectly reduces the amount of the

original unsub by the amount of the new sub.

Program FAPPKENG (cbl), paragraph 5800-PRIOR-AWDS-

UPDATE, was modified to allow for different Item Type

sequencing of Stafford Subsidized and Unsudsidized loans

such that the resulting award evaluation would be the same

regardless of the relative sequencing.

Financial Aid

Copyright Oracle Corporation 2010. All rights reserved. 26

Peoplesoft Enterprise - Campus Solutions - 9.0 Bundle #20

Product Category Incident ID Reported Problem

Description

Problem Description Resolution Description

Pkg - Aggregates 1849345001 Unable to award

additional Unsub

Stafford in certain

specific mid-year

grade level change

scenarios

In the situation where a student is changing grade

levels mid-year (e.g. between fall and spring), and

the student is eligible for both sub and unsub at the

new grade level, validation does not allow the

awarding of the correct unsub amount.

The placement for the execution of the paragraph 4500-

FIND-FIRST-TERM-SPLIT (which determines the first non-

zero disbursement percentage for the term NSLDS grade

level in program FAPPKENG.cbl) has been modified

(moved) to now be executed immediately at the beginning

of paragraph A1000-MAIN-MENU. This change now allows

for the correct assessment of the a multiple grade level

Stafford loan. (Also see resolution 1816791002 which was

resolved using the same revision)

Pkg - Miscellaneous 1914938001 Pell Fiscal item type

balances are not

calculating correctly

The fiscal item type data for Pell is not matching up

with STDNT_AWARDS. The fiscal count and

amounts are too high. Having accurate fiscal item

type data for Pell is important for reporting

purposes.

Multiple changes to FAPPKPST (cbl & dms)

Pkg - Miscellaneous 1974596002 ITEM_TYPE_FISCL

Offered and Accepted

Amounts do Not

Match Totals from

STDNT_AWARDS

The Fiscal Item Type totals are not always being

updated correctly when awards are changed. One

confirmed scenario is with an award repackaged

under a different disbursement plan. The original

discarded award is not taken into account as a

cancelled award and subtracted from the totals.

Multiple changes to FAPPKPST (cbl & dms)

Pkg - Miscellaneous 2032999001 ISIR assessed for

STDNT_AWRD_DISB

.CPS_SCHOOL_COD

E

Packaging routine updated to assess

cps_school_code value when STDNT_AWRD_DISB

record updated. In addition, new batch tool to

update

STDNT_AWRD_DISB.CPS_SCHOOL_CODE

provided.

Modified FAPPKCTL (cbl & dms) to select (via S_STUISIR)

OWNING_SCHOOL_CD from ISIR_CONTROL. When

available, OWNING_SCHOOL_CD will now be used as

CPS-SCHOOL-CODE.

Financial Aid

Copyright Oracle Corporation 2010. All rights reserved. 27

Peoplesoft Enterprise - Campus Solutions - 9.0 Bundle #20

Product Category Incident ID Reported Problem

Description

Problem Description Resolution Description

Pkg - Miscellaneous 2038098001 Hard-coded title of

"Award Disbursement

Detail" on secondary

page

STDNT_PKG_DISB_S

EC

The title of this secondary page ("Award

Disbursement Detail") is hardcoded in PeopleCode.

The same title is used for 4 secondary pages:

STDNT_AWRD_CTG_DET, AWARD_DETAIL_SEC,

STDNT_PKG_DISB_SEC, STDNT_PKG_DISB_SC2

Created message to display the title.

Pkg - Pell 2026733001 Locked Pell Awards

not Being Reduced,

Resulting in Pell1

Overaward

Award Pell1 for Fall/Spring terms and lock the

award. Then add separate Pell1 for the leading

summer term, sequenced before the Fall/Spring

Pell1. Validation does not reduce the Fall/Spring

Pell1 as required. The behavior is seen after CS 9

Bundle 18 and CS 8.9 Bundle 25.

Program FAPPKENG (cbl), paragraph P8152-FINALIZE-

PELL-AWARD, was modified to reduce any previously

locked Pell award amount that exceeded the current re-

evaluation amount of the award. In this case, the "locked"

award is reduced to the re-valuation amount and scheduled

disbursements are recreated. This change applies to both

auto packaging and manual packaging for Pell award Item

Types.

Pkg - Pell 2029571002 Pell Allowed to be

Manually Validated for

Amounts Exceeding

Max Scheduled

Award

One school is reporting they are able to manually

award (lock) Pell for any large amount Exceeding

5550, and the award passes validation.

Program FAPPKENG (cbl), paragraph P8152-FINALIZE-

PELL-AWARD, was modified to reduce any previously

locked Pell award amount that exceeded the current re-

evaluation amount of the award. In this case, the "locked"

award is reduced to the re-valuation amount and scheduled

disbursements are recreated. This change applies to both

auto packaging and manual packaging for Pell award Item

Types.

Financial Aid

Copyright Oracle Corporation 2010. All rights reserved. 28

Peoplesoft Enterprise - Campus Solutions - 9.0 Bundle #20

Product Category Incident ID Reported Problem

Description

Problem Description Resolution Description

Pkg - Veterans Benefits1855302001 Award Validation:

Need Summary not

updating correctly

with Ed Resources

after Bundle #11

After Bundle #11, Award Validation is not correctly

updating Unmet Need and Unmet COA after the

student has Educational Resources added to an

existing package. The correct modifications are

made to reduce the existing awards as necessary,

but the need summary values are not updated to

reflect the award changes. Unmet Need and Unmet

COA are calculated as if the award changes had not

been made (as if the student still had the same

award amounts as of the time the Ed Resources

were added).

Program FAPPKENG (cbl), paragraph A2000-VET-BEN-

FINAL-CHECK, was modified to ensure that when Award

Validation was invoked multiple times with identical award

information, the Need Summary results would consistently

display the same updated results. In addition, the other

subsequent issues addressed in the discussion section of

this incident, were also addressed, and resolved with

further modifications to the same paragraph, A2000-VET-

BEN-FINAL-CHECK.

Satisfactory Academic Progress2039708001 Hard-coded labels

used as variables by

message 14400, 372

Bind variable values "Aid Year" and "Term" in

message 14400, 372 are hard-coded in

PeopleCode. The message is used on page

SFA_SAP_STDNT and SFA_SAP_STDNT_SIM.

PeopleCode

SFA_SAP_STDNT.SFA_SAP_WK.SFA_SAP_CALC

_BT and

SFA_SAP_STDNT_SIM.SFA_SAP_WK.SFA_SAP_

CALC_BT.

Created message to display the title.

Financial Aid

Copyright Oracle Corporation 2010. All rights reserved. 29

Peoplesoft Enterprise - Campus Solutions - 9.0 Bundle #20

Product Category Incident ID Reported Problem

Description

Problem Description Resolution Description

Verification 1945612001 Tax Verification Data

entry issues

There are multiple issues with data entry in the

Manage 2009-2010 Verification component:

Issue #1: Fed Untaxed Income (PAGE:

SFA_FED_UNTAX_INC) > If you Add a Dollar

Amount to the: Tax-deferred Pension/Saving, Child

Support Received, Military/Clergy Allowance,

Veterans

Non-Ed Benefits, Other Untaxed Income, Other

Unreported Income fields, The Total Other Untaxed

Income field does not sum the amounts. If you

navigate to another tab and come back to the Fed

Untax Income Tab, the Total Other Untaxed Income

field will be populated. Ged Fed Data is NOT used.

Issue #2: Fed Untaxed Income (PAGE:

SFA_FED_UNTAX_INC) > If you Add a Dollar

Amount to the: Child Support Received field, the

dollar amount will not populate to the Tax Form

Data Tab (PAGE: VERIF04_FORM2) > Field

Untaxed Income.

Issue #3: Tax Form Data Tab (PAGE:

VERIF04_FORM2) > Father / Mother Tax Form

Data ? Mother/Father Married Filing Status: (Single,

Head HH, Joint, Separate, Single, Widower). If

Mother/Father Filing Status equal to one of the

following: Single, Head HH, Joint, Separate, Single,

Widower and both parents have Other Untaxed

Income on the Fed Untax Income page > field Other

Untaxed Income of $200 each, when you

Consolidate, and select Consolidate Tax data

(PAGE: VERIF04_CONSOL_SEC), the Other

Untaxed Income field does not equal $400 it only

Changes have been made to the whole Verification

component and its functionality to accommodate the

changes, when the user enters data without Fetching.

Financial Aid

Copyright Oracle Corporation 2010. All rights reserved. 30

Peoplesoft Enterprise - Campus Solutions - 9.0 Bundle #20

Product Category Incident ID Reported Problem

Description

Problem Description Resolution Description

Verification 1996952001 Changes to Income

Adjustments are

incorrectly calculating

Page: SFA_INCOME_ADJ_09. In Manage 2010-

2011 Verification > Tax Form Data > Income

Adjustments link, when entering changes to the field

One-half Self-employment, when there is data in

Certain business expenses. If the data is deleted in

One-Half Self Employment, the total Income

Adjustments is not correct. If One-Half Self

Employment is adjusted again, after being deleted,

the total continues to be incorrect

The peoplecode has been updated to trigger the code for

calculation of the One-Half Self Employment changes to

total Income Adjustments.

Verification 2005759001 2011 - 2012 Aid Year

updates for

Application Data

Verification.

Annual updates for Application Data Verification as

a result of PROFILE and ISIR updates for 2011 -

2012 processing year and updates to Tax Forms

and Schedules for the 2010 tax filing year. This

posting includes: Complete 2011 - 2012

Institutional Verification including update target.

2011 - 2012 Federal Verification with the ability to

enter application data, consolidate and compare.

The ability to update target (ISIR Corrections) will be

delivered as a critical posting with the delivery of FM

final.

Changes have been made to the online and batch objects

to accommodate the changes for the new aid year.

NSLDS 1750845002 Problem with query

SFA_NSLDSREQ_AL

L

The delivered PSQuery SFA_NSLDSREQ_ALL has

an issue with one of the lines in it's criteria for

A.NATIONAL_ID.

Modified the query for the space in the NATIONAL_ID field

Financial Aid

Copyright Oracle Corporation 2010. All rights reserved. 31

Peoplesoft Enterprise - Campus Solutions - 9.0 Bundle #20

Product Category Incident ID Reported Problem

Description

Problem Description Resolution Description

Verification 2011775001 Unable to correct

Bus\Farm Net Worth

to zero after

Verification

If a student, through verification, is no longer is

eligible for the Simplified Needs test it is required

that all asset information be reported. When

running Auto Verification, the Bus\Farm Value is set

to 0 although it was blank on the ISIR. Users then

cannot change this value to 0 (zero) on the ISIR.

The other asset fields such as Cash and Investment

Net Worth remain Blank so users can set those to 0

(zero)

When verification changes were pushed to ISIR, the blank

to zero indicators were not getting updated in FAPUPTGT

cobol, which is now fixed to update accordingly.

AUS - TAC Loads 1997549002 TAC Parent Higher

Education - QTAC

provides this data as

FACT codes

From December 2009, QTAC provided two new

FACT codes PRNT1 and PRNT2 which contain the

values of E573 and E574 respectively. Logic needs

to be added to the QTAC FACT File load to map

these to the TAC Suspense Record

SAD_TAC_SUS.SSR_HIGHST_EDU1 and

SAD_TAC_SUS.SSR_HIGHST_EDU2.

UAC dataset appro,clsappro - EDUC-PAR-GUAR-1

and EDUC-PAR-GUAR-1. Applicant File Layout for

UAC needs to incorporate these fields for insert to

SAD_TAC_SUS.SSR_HIGHST_EDU1 and

SAD_TAC_SUS.SSR_HIGHST_EDU2. The post

logic for these fields is also specific to VTAC and

needs to be all TACs.

NOTE: UAC change has been removed from this

incident.

Added peoplecode in the Function QTAC_Load_File2 in

SAD_TAC_WRK.SAD_TEST_COMP_TAC.FieldFormula

during the load process. Also commented the VTAC centric

code in Application Engine Peoplecode,

TAC_POST_LIB.PRFCTDATG.Step4 for post process.

Financial Aid

Recruiting and

Admissions

Copyright Oracle Corporation 2010. All rights reserved. 32

Peoplesoft Enterprise - Campus Solutions - 9.0 Bundle #20

Product Category Incident ID Reported Problem

Description

Problem Description Resolution Description

AUS - TAC Loads 2009392001 VTAC - Update to

Data Dictionary

VTAC has very recently been advised that the ISAT

(International Student Admissions Test) ID has

changed from 8 numeric to 10 alphanumeric

This change has a structural impact on the following

data file specifications:

D1 Offer file

D3 Legacy Offer file

D8 Victorian Year 12 release file

D9 Interstate Year 12 release file

Changed the length of field SAD_TAC_UMAT_ID from 8 to

10. Altered records SAD_TAC_CD_VIC,

SDAT_TAC_SUS_PRF and SAD_TAC_SUS_VIC

accordingly. Changed the filelayouts

SAD_TAC_VTAC_LAYOUT and

SAD_TAC_VTAC_SUB1_LAYOUT to

SAD_TAC_VTAC_SUB35_LAYOUT. Also changed the

peoplecode

SDA_TAC_WRK.SAD_TEST_COMP_TAC.FieldFormula.

Admissions Web Services2015097001 AAWS staging

records contain

production security

views in Query

Manager

The following records contain ADM_MAINT_SCTY

or ADM_APPL_SCTY in the SQL on Query Manager

resulting in records not being returned in the query

results:

SAD_APL_DAT_STG

SAD_APL_PRG_STG

SAD_APPRGAU_STG

SAD_STDAPNL_STG

SAD_PRGNZL_STG

The security views are based on production data

therefore staged that has not yet been posted to

production records will not be returned in the query

results.

In addition, the record SAD_APL_PLN_STG is not

appearing in QUERY_TREE_ADM. It should be a

child to SAD_APL_PRG_STG and a parent to

SAD_APL_SBP_STG,

The record properties for the following records were

corrected by

(a) removing the query security view (b) setting the correct

parent record.

(1) SAD_APL_DAT_STG

(2) SAD_APL_PRG_STG

(3) SAD_APL_PRG_AUS

(4) SAD_APL_PRG_NZL

(5) SAD_APPRGAU_STG

(6) SAD_PRGNZL_STG

(7) SAD_STDAPNL_STG

The query tree QUERY_TREE_ADM was also modified.

Recruiting and

Admissions

Copyright Oracle Corporation 2010. All rights reserved. 33

Peoplesoft Enterprise - Campus Solutions - 9.0 Bundle #20

Product Category Incident ID Reported Problem

Description

Problem Description Resolution Description

Admissions Web Services2022820001 AAWS - Effective

Sequence on

Application Program

Data is populated with

'0' instead of '1'

When an application is created using AAWS (real

time or batch), the Effective Sequence on

ADM_APPL_PROG should be populated with '1'.

This will mirror the behavior when manually adding

an application through Add an Application or when

running other processes that create applications.

ModifIED the common code to calculate effseq in such a

way that effseq is calculated as 1 and not 0.

Admissions Web Services2023277001 Residency Data

component

encounters buffer

error (15,26) in

Campus Community

When attempting to retrieve residency data using

the navigational path of Campus Community >

Personal Information > Identification > Residency

Data, the following error occurs: No matching buffer

found for level. (15,26). The STDNT_CAREER

record is not getting created for applications created

by AWS called from UCAS.

Modified Admissions API to automatically create a row in

STUDENT_CAREER for a new applicant if one does not

exist already.

Admissions Web Services2032704001 Update #782227

contains two new

Cobol dms files but no

new STORE*.dms

files have been

provided

Update #782227 contains two new Cobol dms files

but no new STORE*.dms files have been provided. Modified storead.dms and storecc.dms to make a call to

adpcmeip.dms and ccpbteip.dms respectively.

Recruiting and

Admissions

Copyright Oracle Corporation 2010. All rights reserved. 34

Peoplesoft Enterprise - Campus Solutions - 9.0 Bundle #20

Product Category Incident ID Reported Problem

Description

Problem Description Resolution Description

Admissions Web Services2035351001 AAWS SCC_LOV web

service is unable to

run to completion

(158,974)

In testing the SCC_LOV web service, when creating

the WSDL and all functional setup the following

errors occurring:

<IBResponse type="error">

<DefaultTitle>Integration Broker

Response</DefaultTitle>

<StatusCode>20</StatusCode>

<MessageID>974</MessageID>

<DefaultMessage>Integration Broker Sync

Handler: OnRequest for message SCC_GET_LOV

could not run to completion on node H900GXYE.

(158,974)</DefaultMessage>

<MessageParameters>

<Parameter>SCC_GET_LOV</Parameter>

<Parameter>H900GXYE</Parameter>

The SCC_GET_LOV service operation handler code was

modified to work correctly with namespaces.

Application Fees and Deposits2016826001 Add application fee

payment and waiver

request to AAWS on

line application

functionality.

Enhance AAWS on line application functionality to

include making an application fee payment or

requesting the fee to be waived. (See Student

Financial incident 2016822000 for further

information.)

See AAWS FP5 Release notes for details.

NLD - Studielink 2008349001 Toggeling the

Financial Message

Handling field on

Studielink Financial

Parameters page

triggers warning

When changing the Financial Message Handling

field on Studielink Financial Parameters page from

Process from Studielink Tables to Process from

Student Financials and back again to Process from

Studielink Tables a warning message is triggered

which prompts the user to enter the required tuition

group field. However when the field content is

Process from Studielink Tables the field should

never be required.

Modified SAD_SL_LOAD_PR2.SAD_SL_FILTER.SaveEdit

peoplecode to add a conditional check to see if the

Financial Message Handling is "Process from Student

Financials".

Recruiting and

Admissions

Copyright Oracle Corporation 2010. All rights reserved. 35

Peoplesoft Enterprise - Campus Solutions - 9.0 Bundle #20

Product Category Incident ID Reported Problem

Description

Problem Description Resolution Description

NLD - Studielink 2008961001 Studielink suspense

check is not correct in

message 03

When a new application is sent via Studielink to CS

while there is already an enrollment for the same

education and year (which is a conversion row), it

does not end up in suspense, but it is processed.

Suspense control is supposed to stop duplicate

admissions/enrollments.

Modified peoplecode in

SAD_STUDIELINK.Inbound.Suspensemethods to add a

new method SuspendFoundStudentRecords,

SAD_STUDIELINK.Inbound.SAD_SL_03 to stop duplicate

admissions/enrolments,

SSR_STD_PRG_NLD.SSR_SL_STARTMO_NLD.Saveprec

hange to assign value to start occasion field as per setup

values. Also modified page SAD_SL_SUSP_K_MGMT to

add new hyperlink for student program/plan and modified

peoplecode in

DERIVED_ADM.SSR_SL_ACAD_PRG.FieldChange

peoplecode for transfer to student program/plan component

and SAD_SL_SUSP_K_MGMT.Activate for hiding/unhiding

the program/plan hyperlink.

NLD - Studielink 2022139001 Studielink Issues from

initial testing

Several issues concerning the XML formatting in the

application package SAD_SL_STUDIELINK are

preventing processing between Institutions and

SURF foundation.

Modified SAD_STUDIELINK application package

peoplecode, SAD_SL_OUT application engine peoplecode,

component peoplecode in

ADM_APPL_MAINTNCE.ADM_APPL_PROG.SavePreChan

ge,SSR_ACAD_PRG_NLD.SSR_STD_PRG_NLD.SavePre

Change and Record peoplecode in

SAD_DERIVED_SL1.EMPLID.Rowinit,SAD_DERIVED_SL1

.EMPLID.SavePreChange,SSR_STD_EDU_NLD.EMPLID.S

avePreChange,SSR_STD_EDU_NLD.SSR_SL_PR_VERF_

NLD.SavePostChange,SSR_STD_PRG_NLD.SSR_SL_STA

TUS_NLD.SavePreChange to confer to the new

requirement.

Recruiting and

Admissions

Copyright Oracle Corporation 2010. All rights reserved. 36

Peoplesoft Enterprise - Campus Solutions - 9.0 Bundle #20

Product Category Incident ID Reported Problem

Description

Problem Description Resolution Description

Test Scores/Loads 2008209001 HCM 8.9 MP1 to HCM

9.0 MP5 Upgrade:

Error in

DLHCSYSE.DMS on

exporting

GRE_SUBJ_CODE

Upgrade-generated DLHCSYSE.DMS references a

record that no longer exists after CS 9.0 Bundle

#17.

See incident 'Workaround' below.

Created upd812865_24.dms file to delete the

'GRE_SUBJ_CODE' rows from system data definition

records PM_PS_REC, PM_PS_REC_WHERE, and

PM_PS_RECUP_WHE due to fact that record

GRE_SUBJ_CODE deleted in CS 9.0 bundle #17 was not

deleted from the HRCS 9.0 Upgrade System Data record

definitions, which is used to build upgrade DMS script

DLHCSYSE.DMS.

Test Scores/Loads 2022305001 SSS File format is

changing

College Board is making changes to the SSS Data

Layout effective 16 December 2010.

Here is a summary of the changes:

Search Year field expanded to two digits (vice one)

Street Address field expanded to 50 characters from

29 characters

City field expanded to 30 characters from 17

characters

Date of Birth field expanded to include a four-digit

year instead of two-digit year

SAT Subject Test Codes are added

Student Data Source Code is added

Modifications were made to the SSS file layout; suspense

and candidate data records and pages; Test Score load &

Post processes to confer to the new layout. The message

SAD_TEST_POST_SSS_PART and its corresponding

schema were updated to include the new suspense fields.

UK - PBI 1990209001 PBI - Academic Plan

Description changed

as editable

Within the course details section, the academic plan

description is defaulted from the academic plan

record. However, there is the requirement

sometimes to alter or amend this description within

a CAS application. The requirement is for the

description field to be editable. Navigation: Student

Admissions > PBI Processing > CAS Maintenance.

In the CAS Maintenance page, a new field is added to let

the user enter the Academic Plan description. A new field

SAD_PB_CTITLE_OVR is added to the SAD_PB_CAS

record to store the user entered academic Plan.

A new step 1 is added to the Derivation of Course Title to

derive from the Course Title Override field.

Recruiting and

Admissions

Copyright Oracle Corporation 2010. All rights reserved. 37

Peoplesoft Enterprise - Campus Solutions - 9.0 Bundle #20

Product Category Incident ID Reported Problem

Description

Problem Description Resolution Description

UK - PBI 2012223001 PBI - Course fees to

be stored by

programme/admit

term

Users have Course fees that change for a

programme each academic year so they need to be

able to store fees for programmes for each admit

term as they will be applying for CAS's for 2 admit

terms at the same time. Currently fees can only be

stored per programme and would need to be

changed manually each year for every programme

and they need the system to store multi years as we

will be applying for CAS's across admit terms at the

same time

Records SAD_PB_CRSECONF, SAD_PB_PLAN_DT,

SAD_PB_PROG_DT were changed to add additional fields.

Changes done on page SAD_PB_CONFIG,

SAD_PB_PLAN, SAD_PB_PROG to add new fields.

Application package SAD_PB_CAS

_DEFAULT:DeriveDefault was changed and validations

were added for new fields at record level.

UK - PBI 2031912001 PBI - Views do not

work with Application

Center security

Find that when a user has built either the

SAD_PB_CASVW or SAD_PB_CASSCYVW view

and has access to all application centers, all users

cannot access saved CAS records.

Modified the security views to add oprid and oprclass fields

as PK fields and removed them from where clause

UK - UCAS 1948019001 UCAS - Performance

issue when

processing a large

number of decisions

via the Quick Decision

Entry

Approximately 2500 records are retrieved by using

the UCAS Code, year of entry and application

centre into this page. We have added the decision

of R and then we are going through the list pressing

the APPLY button. This processes for a long time.

Then we move on to the next record to press apply.

Again this processes for a long time. The user has

to save the page after applying R to 4 records;

otherwise, the user is completely thrown out of

system.

An update has been made to each of the 'Quick' pages to

restrict the search to 300 records and hard coding a

message on the page to indicate that only the first 300

records will be displayed. For each page initially the first 50

records are displayed to optimize the performance on save.

The user can opt to View 100 if required

Recruiting and

Admissions

Copyright Oracle Corporation 2010. All rights reserved. 38

Peoplesoft Enterprise - Campus Solutions - 9.0 Bundle #20

Product Category Incident ID Reported Problem

Description

Problem Description Resolution Description

UK - UCAS 1967508001 UCAS Release to

Clearing page should

not allow release of

RPA, Deferred or

Single Fee Applicants

The UCAS Release to Clearing component

automatically ensures that applicants are either UF

or on choice 6/9 and not declined, however, it

should also ensure that the applicant has not been

admitted via an RPA (field

SAD_UC_IVSTK.SAD_UC_EAS will equal 'R' if this

is the case) as they are not eligible for Clearing, and

that the fee code

(SAD_UC_IVSTK.SAD_UC_FEELEVEL) is equal to

'M' (Multi-Fee) as those who have only paid the

Single fee are not eligible for Clearing. It should also

not allow those with

SAD_UC_APPLREC.SAD_UC_APPYEAR is a value

other than the current application cycle.

Added validation to display a warning on the release to

clearing page for the following records

(1) StarK - EAS is 'R' (RPA - Record Of Prior Acceptance)

(2) StarK - Fee Level is 'S' (Single fee - ineligible for

clearing)

(3) StarN - App Year is greater than current configured year

UK - UCAS 1968794001 UCAS - Accept button

on UCAS

Confirmation Entry

page deletes changed

data

When a user enters a confirmation with a change,

such as adding a value to the Course Change field,

on the UCAS Confirmation Entry page, clicking on

the Accept button clears the change from the page.

On entry to the page any previous course details are

cleared instead of clearing it on click of accept button. Also

created a dummy label with blank label for all the button

fields and made this as the default label to remove the

wrong mouse hover text from appearing.

UK - UCAS 1987403001 UCAS Summary of

Conditions not visible

for external choices

Users would like the Summary of Conditions for

external choices be made visible on the choices tab

of UCAS Applications page. This is stored on the

table PS_SAD_UC_OTH_CH (IvStarC Other Choice

Base Rec).

Modified other institution choices region to add SOC,

course, campus, entry year, month, entry point fields.

UK - UCAS 1994240001 UCAS - STARJ Import

Update - QUALENT3

UCAS have published changes to the specification

of the ivStarJ and ivgStarJ views for the 2011 cycle,

i.e. data provided in November 2011. This requires

an update to the staging table and Import Applicant

Data process to handle the additional values

provided.

Modified ivstarj import process to import QUALENT3 and

not import QUALENT2.

Recruiting and

Admissions

Copyright Oracle Corporation 2010. All rights reserved. 39

Peoplesoft Enterprise - Campus Solutions - 9.0 Bundle #20

Product Category Incident ID Reported Problem

Description

Problem Description Resolution Description

UK - UCAS 1995729001 UCAS - Delayed

Confirmation decision

for 2011

UCAS are introducing a new delayed conditional

decision code for 2011 confirmation processing.

Updates are required to handle the processing of

the new decision code for confirmation processing

for summer 2011.

Allowing confirmation pages to show DF choices.

Generating RD transaction for decision D.

UK - UCAS 2004576001 UCAS Qualifications

page needs to allow

users to update the

result field

UCAS Qualifications page needs to allow users to

update the result field

Created new Qualification pages to allow users to

add/updated qualifications

UK - UCAS 2006080001 Provide ability to

record previous

qualifications required

for UCAS and GTTR

applications

Need flexibility to record prior qualifications for an

applicant which may or may not be specific to an

academic program.

Created new Qualification pages to allow users to

add/updated qualifications

UK - UCAS 2006336001 UCAS Clearing

decision Reject

User is requesting a decision box to be added to the

UCAS Enquiry Entry page to for clearing decision

on UCAS. Currently, UCAS enquiry page does not

allow you to put a decision against the RX

transaction. When transactions are created on this

page a Clearing accept decision is sent to UCAS

(i.e. an RX with a decision of A.)

Modified UCAS Enquiry Entry page to allow users to update

Decision field. Also modified the transaction generation

process to use this decision when creating RX transaction

Recruiting and

Admissions

Copyright Oracle Corporation 2010. All rights reserved. 40

Peoplesoft Enterprise - Campus Solutions - 9.0 Bundle #20

Product Category Incident ID Reported Problem

Description

Problem Description Resolution Description

UK - UCAS 2007117001 UCAS Enquiry view of

cvName should

include Clearing or

Adjustment details

UCAS provide the Clearing status (Status =

130/150) and Adjustment Status

(AdjustmentStatus), including Adjustment

Registration Date (AdjustRegDate) and Adjustment

Expiry Date (AdjustExpDate) in the cvName view for

use when the applicant is not with an institution.

This should be shown when looking up the Personal

ID or Application Code from cvName on the

UCAS/GTTR Enquiry Entry page

(SAD_UC_CLEARING and SAD_UC_GTCLRING).

Users are unable to narrow search criteria as

needed and are not required to enter at least one

search parameter, causing the system to crash.

Modified cvName and cvgName prompts to show

clearing/adjustment details and filter for eligible applicants

UK - UCAS 2009669001 Entering unconditional

accept in clearing on

GTTR Enquiry Entry

page results in UCAS

error code 109

When sending an unconditional clearing accept for

a GTTR applicant, it is being bounced by UCAS

error code 109 because it is including a ' in the free

format box (SAD_UC_GTCLRING).

Modified generate transactions process to derive freeformat

as blank instead of ''

UK - UCAS 2011141001 UCAS CF applicant

has withdrawn

themselves via UCAS

UCAS CF applicant has withdrawn themselves via

UCAS. The program action reason applied by the

UCAS Import process is WAPP BOFF Applicant

Withdrew before Offer. Users have sent an LD

transaction for this applicant.

Modified application choice import to assign proper program

action/reason for withdrawn applications

Recruiting and

Admissions

Copyright Oracle Corporation 2010. All rights reserved. 41

Peoplesoft Enterprise - Campus Solutions - 9.0 Bundle #20

Product Category Incident ID Reported Problem

Description

Problem Description Resolution Description

UK - UCAS 2011765001 UCAS - Need to

identify UCAS

applicants that get

uprated from CI to CF

Users need to be able to identify applicants that

have been uprated from CI to CF by UCAS when

their CF choice has rejected them. Modifying UCAS

configuration setup so a new program action reason

could be applied to maintain application to identify

these cases would fulfill this requirement.

Added new setup for CI to CF updates and modified import

process to set this new program action/reason for CI to CF

updates

UK - UCAS 2011863001 UCAS Confirmation

RD Transactions

incorrectly sent and

get error (14250,86)

When an applicant has had a Confirmation

transaction sent (RD transaction) and a user

searches for them in the Confirmation Entry page, if

they click 'Accept' again without making any

changes and then save the record, the next time the

transactions process is run it incorrectly creates a

new RD transaction and tries to add another row in

the Maintain Applications component. Because it is

invalid, the following error occurs.

A Program Action of Admit is not valid for Effective

Date: 2010-08-18, Sequence #: 1. (14250,86)

Modified the confirmation pages to not reset the "generate

transaction" flag when the buttons accept/reject are clicked

without making any updates

UK - UCAS 2016234001 UCAS - Multiple

Users using Enquiry

Entry page unable to

save - get error (18,2)

When attempting to save the UCAS Enquiry Entry

page where two users have added an entry at the

same time and they are both given the same

Enquiry ID number, the following error occurs.

ERROR: Data being added conflicts with existing

data. (18,2)

Modified the enquiry entry pages and transaction pages to

generate the LineNo field at savetime instead of at

rowinsert

Recruiting and

Admissions

Copyright Oracle Corporation 2010. All rights reserved. 42

Peoplesoft Enterprise - Campus Solutions - 9.0 Bundle #20

Product Category Incident ID Reported Problem

Description

Problem Description Resolution Description

UK - UCAS 2018847001 UCAS RPA applicant

UF amend decision

incorrect

When a record is received from UCAS relating to a

RPA applicant, they are imported as UF and

identified by the field SAD_UC_EAS on IvStarK as

R. If this applicant type wants to change their course

or year of entry, the transaction is being sent to

UCAS as an LD transaction, when it should be an

RA or RW transaction.

Modified generate transactions process: for standard

decision processing, after processing Clearing/Adjustment

records, process RPA application choices creating RA/RW

transactions

UK - UCAS 2026528001 UCAS - Email

Addresses Created

Without Preferred

Flag Set

Email addresses are being created without the

preferred flag set to 'Y' which causes errors in the

Import Applicant Data process.

Modified import process to set preferred flag=Y

UK - UCAS 2031103001 UCAS - Free Format

text not quoted in offer

string for Interview

offers

When entering an Interview offer the Free format

text is not quoted in offer string and the transaction

errors at UCAS.

Modified letter text generation function to enclose free

format in quotes

Class Associations 1804632001 Identify and display

related class sections

within the class

associations

component

Within class associations component, identify and

display the related class sections and component

type.

Modified page CLASS_ASSOC_CMPNT (Class

Associations component page) to display related class

sections.

Class Search 1995775001 Search on course title

keyword does not

work in Dutch

Students should be able to search for classes by

using 'Course Title Keyword' search field. However,

search returns no match when logged in Dutch.

Modified

SSR_STUDENT_RECORDS.SR_ClassData.ClassSearch

Method:RunClassSearch Added conditional logic to use

the related language record when the Language does not

match the base language.

DEST/DEEWR - AUS 1971463001 Scholarship data

incorrectly populating

DEEWR worktable

CLS and CAS Indigenous Payment Scholarship

records are incorrectly populating the work table

(SSR_DEST_SS) where data that has already been

reported for subsequent reporting periods.

Modified the procedure Select-SS-Pass-2 to add conditions

in the select query in srdestwt.sqr

Recruiting and

Admissions

Student Records

Copyright Oracle Corporation 2010. All rights reserved. 43

Peoplesoft Enterprise - Campus Solutions - 9.0 Bundle #20

Product Category Incident ID Reported Problem

Description

Problem Description Resolution Description

Enrollment 1792119001 No Academic Load

found for SetID error

while adding grades if

Academic Load

Determiner is set to

Units By Level

If the Academic Load Determiner on the Level/Load

Rules Table is set to Units By Level, when adding

passing grades to students on the student

enrollment page, a No Academic Load found for

SetID error occurs if the units passed makes the

student jump to the next academic level.

Added a call to gather the academic level value needed

before figuring out the aus academic load in peoplecode

FUNCLIB_CS.TOT_CUMULATIVE-FieldFormula.

Enrollment 1979064002 Enrollment Engine not

obeying Session

Limits when

Enrollment Control

session defined.

When an enrollment control session is defined, the

Enrollment engine should enforce the unique

session limits while not allowing students to enroll in

more units than is defined by the control session.

The enrollment engine is not allowing students to

enroll in units that still fall within both the control

session limit and unique session limit.

Added logic in SRCCETRM.cbl, SRPCETRM.cbl and

SRPCEPRD.cbl programs to obey the sessions limits when

Enrollment Control session is defined.

Enrollment 1986746001 Enrollment engine

continues to process

test scores even after

a valid test score is

found

A student is denied enrollment with the Requisites

Not Met error message when the Requisite requires

a Test Score and the student has more than one

test date for the same Test ID/Component and last

one processed is not a valid test score to pass the

requisite.

Modified the logic in program SRPCAGL3.CBL paragraph

30810-SELECT-VALID-TEST-VALUES to properly stop

checking test scores once a valid value is found.

Enrollment 1991435001 Enrollment Requisites

do not work based on

order of tests in

Define Tests for

Requisites

Depending on the order in which test scores are

returned from the database, a student can not meet

a requirement if he or she has a passing grade on

one test that can be used for the requisite and a

failing grade on another test than can be used.

Added ORDER BY A.TEST_ID in the stored statement

SRPCAATS_S_TESTID in SRPCAATS.DMS.

Student Records

Copyright Oracle Corporation 2010. All rights reserved. 44

Peoplesoft Enterprise - Campus Solutions - 9.0 Bundle #20

Product Category Incident ID Reported Problem

Description

Problem Description Resolution Description

Enrollment 2013365001 After Bundle #18,

student unable to wait

list in another section

of enrolled class;

multiple enrollment

not allowed error

returned

Student is enrolled in a section of a class. Process

quick enroll or enrollment request (or self service)

requesting enrollment in a second section of the

same class, with 'wait list OK' option selected.

Second section is closed with an open waitlist.

Enrollment transaction fails with 'Multiple

Enrollments not allowed for course, add not

processed.'

Same procedure in database patched only through

Bundle #17 processed successfully and put student

on the wait list.

Modified SRPCEPRD.cbl to only reject with a multi

enrollment transaction if it is going to result in a successful

enrollment and not the waitlisted one.

Enrolment Feedback - AUS1856443001 New Enrolment

Feedback File format

Specifications for

QTAC

New Enrollment Feedback file formats that have

been advised will be in effect from December 2008

for Queensland Tertiary Admissions centre (QTAC).

Modified the 2 procedures to acknowledge the new file

format, Load-QTAC-File1 and Load-QTAC-File2, modified

Procedure Write-QTAC-File to include reference to the 3

new variables assigned for the 3 new elements in

srefqtau.sqr.

Grading 2037341001 Lapse Transcript Note

Prints twice after

applying 8.9 Bundle

26 or 9.0 Bundle #19

After applying the latest bundle, Transcript Notes

that print with lapsed grades appear twice on the

transcript, once with the lapse date and once

without.

Removed updating of TSCRPT_NOTE_ID during grade

lapse and grade change process in SRPCEPST.cbl and

srpcepst.dms. The grade lapse note is already inserted in

transcripts note and having it in transcript note id duplicates

the information in the transcripts.

Student Records

Copyright Oracle Corporation 2010. All rights reserved. 45

Peoplesoft Enterprise - Campus Solutions - 9.0 Bundle #20

Product Category Incident ID Reported Problem

Description

Problem Description Resolution Description

Graduation/Degrees 1343494002 Batch graduation

report post process

copies Program

Action Reason value

from previous row

If a student is graduated through the student

program pages, the Program Action Reason field

has a blank value unless populated with one of the

valid values for the program action of COMP. .

However, the student is graduated using the batch

graduation reporting process, the Program Action

Reason field is carried over from the previous

academic program row. This causes a COMP row to

display an invalid reason code value. This is

causing issues for data warehouse users.

Modified sqr program SRGRDDRV.SQR to default a blank

value for the Action Reason field.

NLD - BPV 1964382001 BPV Total Hours

shown on the

application are not

always committed to

database

The BPV total hours can be entered by a user in

which case the field

SAD_BPV_STC_NLD.SAD_TOTHRS_BPV_NLD is

filled. When a user enters the number of hours per

week the correct number of total hours is showed on

the screen in a derived field but the value of

SAD_BPV_STC_NLD.SAD_TOTHRS_BPV_NLD

remains zero. Users expect the field to be

populated with the correct number of total hours

BPV, regardless of the way this number is

generated. Just like the way in which, for example,

the field

SAD_BPV_STC_NLD.SAD_CONTR_LNGT_NLD is

stored in the database.

Modified

SAD_BPV_CTR_D1_NLD,SAD_BPV_CTR_D3_NLD,SAD_B

PV_CTR_NLD,SAD_BPV_CT_ADD_NLD pages and

relevant component record peoplecode in

SAD_BPV_MATCH_NLD.SAD_BPV_STC_NLD.Rowinit,pag

e peoplecode in

SAD_BPV_CTR_D3_NLD.Activate,SAD_BPV_CT_ADD_NL

D.Activate and

SAD_BPV_CTR_NLD,SAD_BPV_DERIVED,SAD_BPV_ST

C_NLD record peoplecode to calculate and assign total bpv

hours correctly to

SAD_BPV_STC_NLD.SAD_TOTHRS_BPV_NLD.

Student Records

Copyright Oracle Corporation 2010. All rights reserved. 46

Peoplesoft Enterprise - Campus Solutions - 9.0 Bundle #20

Product Category Incident ID Reported Problem

Description

Problem Description Resolution Description

NLD - Test Admin 1805616001 RowInit PCode fills

examination Session

dropdownlist with 1

available value but

doesn't ask to save

If the Exam Type filed is changed from blank to

School Exam on the Test Catalog

(Records&Enrollment -Test Administration NLD -

Set Up Test Administration - Test Catalog) set up.

When an existing Test Session with an empty

Examination Session is opened for correction

(Records&Enrollment - Test Administration (NLD) -

Test sessions), the Examination Session field is

filled by rowinit peoplecode with the value School

Examination. Although this is correct, when leaving

this page the panel processor doesn't see that the

page has changed so the user when leaving the

component is not asked to save the page. So

he/she thinks the field is filled when in fact it's not on

the database level. This functionality seems to be

confusing and can sometime lead to incorrect data

entry

Peoplecode was added to the

SSR_TST_SES_NLD.GBL.PostBuild which ensures that

users entering the component are notified of the fact that

values have been prior empty database field values have

been defaulted which requires the component to be saved

prior to exit. The message will fire only for those rows for

which the value was previously empty. FieldDefault

peoplecode on

SSR_TST_SES_NLD.GBL.SSR_TST_SES_NLD.SSR_EXA

_SES_NLD has been removed and added to the PostBuild

recoded.

Schedule of Classes 1803803001 Display Class Units

on Schedule of

Classes page header

Units should be displayed with all Class Schedule

data. It is a critical piece of the scheduling data.

Having to navigate to another page to view is

frustrating and time consuming for users. It would

be nice to pull this information over from the course

catalog and display at the top of the page just as the

Course ID and other catalog information are

handled.

Added Associated Class and Units to display on Schedule

of Classes components/pages.

Student Records

Copyright Oracle Corporation 2010. All rights reserved. 47

Peoplesoft Enterprise - Campus Solutions - 9.0 Bundle #20

Product Category Incident ID Reported Problem

Description

Problem Description Resolution Description

Schedule of Classes 2003876001 Constraint of Print

Class Schedule report

- mtg_pat_inst_array

The Print Class Schedule report (SR201.SQR) fails

when the meeting pattern/instructor data array

exceeds the range of 20. If there are 18, 19 or 20

meeting pattern rows within one section of the Class

Schedule, the Print Class Schedule report fails and

the output file states the error '(SRQ 1500) Array

element out of range (20) for array

'mtg_pat_inst_array' on line 1221.'

Modified sqr program SR201.SQR to accommodate up to

200 meeting pattern and instructor data rows.

Student Self Service 2014387001 PeopleCode error

when Advisor or

Student tries to

access the student's

Planner when planner

includes a course with

a topic

A peoplecode error returns when accessing the

Planner when a student has courses with Topics in

their planner: Even if fixed, the code is pulling the

wrong field, it does not pull the topic description as it

should since the topic information is not returned in

the specified view. This should be fixed as well.

The error was occurring because in

SSS_MY_PLANNER(GBL).SSS_CRSPLN_ITEM.RowInit,

an incorrect value was being assigned to

DERIVED_SSSPLNR.SSR_CLASSNAME_LONG.Label

when a course topic exists. Instead of

&rec_CrseOffVw.DESCRFORMAL.Value, it is now

SSS_CRSPLN_ITEM.CRS_TOPIC_ID.GetRelated(CRSE_T

OPICS.DESCRFORMAL).Value that gets appended

to the course description as part of the link label.

Student Records

Copyright Oracle Corporation 2010. All rights reserved. 48

Peoplesoft Enterprise - Campus Solutions - 9.0 Bundle #20

Product Category Incident ID Reported Problem

Description

Problem Description Resolution Description

Student Services Center2017947001 Display all W grades

in Course History

W grades attached ot the student record as a result

of a Drop (with Penalty) process or through a Term

Withdrawal are not displayed on Course History in

Student, Faculty or Student Services Center. W

grades keyed in directly through Grade processing

or Add a Grade on Enrollment Request are

displayed

By using the delivered functionality of Term

Withdrawal, courses are removed from Course

History that appear on the Transcript with 'W'

grades. Obviously the SQL is attempting to include

enrollments with a "W" status but maybe the final

piece of the SQL should read: " or

CRSE_GRADE_OFF = 'W') ". This is a gap in the

self-service for staff. They need the full course

history.

The request is to have the Course History page

display all courses with a grade (and W is a grade)

as well as current and future enrollment. The

exclusion of "W" grades assigned through the drop

process while including "W" grades entered on a

roster provides an incomplete Course History

In function LoadEnrlOrCart (under component

SSS_MY_CRSEHIST PostBuild), the WHERE clause that

populates rowset &rs_StdntClassData was modified to

remove the ENRL_STATUS_REASON filters.

Transfer Credit 2009137001 Transfer credit model

changing from posted

status to submitted

status.

Creating a transfer credit model in self service

updates the TRNS_CRSE_TERM.MODEL_STATUS

of existing manual transfer credit models from

Posted to Submitted.

In the COBOL copybook SRCCARTP.cbl, section QA000-

UPDATE-STATUS, an IF condition was added to skip

section SQ020-UPDT-MODELTERM when the transfer

credit self-service modeling program is running.

UK - HESA 1960459001 HESA - Updates for

2010/2011 Reporting

Updates required for the Student, ITT and Offshore

returns for the 2010/11 reporting period.

Made annual regulatory changes for HESA 2010-2011.

Changes included modification to the online objects.

Student Records

Copyright Oracle Corporation 2010. All rights reserved. 49

Peoplesoft Enterprise - Campus Solutions - 9.0 Bundle #20

Product Category Incident ID Reported Problem

Description

Problem Description Resolution Description

UK - HESA 1960471001 HESA - Creating flat

file for DLHE return

HESA have confirmed for 2009/10 DLHE reporting

the extract data needs to be reported in a flat file

rather than in XML format. A new process is

required to create a flat file based on existing DLHE

extract data prior to reporting in March 2011.

New component SSR_HE_DLHE was created. New

application engine program SSR_HE_DLHE was created to

record the DLHE details into a flat file at given location.

UK - HESA 1968440001 HESA - Facility to

calculate FTE for

entire HESA

population

The current HESA product calculates FTE for HESA

Population per career. It would more advantageous

if this was calculated per entire HESA population as

opposed to a filter on career. The Year of Study

calculation is executed on the entire population.

Academic Career is made optional on SSR_HE_CAL_FTE

page so that the process can be run for the entire

population.

UK - HESA 1968780001 HESA - Facility to run

extract for students

that are failing

schema or business

validation.

It would be extremely useful to have a facility to be

able to run an extract for a set of students, who are

failing HESA business validation only. At present if a

number of students are failing validation the create

extract process requires the institution to run the

extract as a whole. Such a facility would reduce the

turnaround time for producing a business error free

extract in a timely fashion, which is of paramount

importance.

A file mapping definition HESA VALIDATION IMPORT is

created to load the validation kit errors into a new staging

table. A new flag 'Validation Errors Only' is added to the

Create Extract page to allow the extract to be run for only

records that exist in the staging table. The selection logic for

course, module and student entities is modified to check for

the validation flag and filter the records against the

validation table. Similarly File mapping Definition HESA

VALIDATION IMPORT ITT is created for ITT return.

UK - HESA 1968792001 HESA - Facility to run

extract per career.

At present the HESA extract can be run as a whole

or via plan or single student. It would be useful if

there was functionality to run this per career to

facilitate targeted testing and easy examination of a

population set.

Application Package SSR_HE_EXTRACT_PRC, class

Course_Extraction was changed to consider a new

ACAD_CAREER parameter while processing.

Student Records

Copyright Oracle Corporation 2010. All rights reserved. 50

Peoplesoft Enterprise - Campus Solutions - 9.0 Bundle #20

Product Category Incident ID Reported Problem

Description

Problem Description Resolution Description

UK - HESA 1976761001 HESA - Request

COMDATE be

calculated as the start

date of the earliest

class for the term

The COMDATE details given by HESA are as

follows: This field indicates the date of the student's

initial commencement of studies for this student

instance and may relate to a date prior to the

current academic/financial year. Exchange-in

students should have the date they commenced

their studies at the reporting institution. See HESA

website for additional details:

http://www.hesa.ac.uk/index.php/component/option,

com_studrec/task,show_file/Itemid,233/mnl,09051/h

ref,a%5E_%5ECOMDATE.html/

So this will be the start date of the earliest relevant

class as this is the day that the student commenced

study. If a term starts on '01-AUG-2009' and

finishes on '31-JUL'2010' then a student can start

part way through the year and their COMDATE will

therefore not always be '01-AUG-2009'.

COMDATE derivation is modified to consider the class start

dates that are related to the student term. CONDATE is

derived as the earliest class start date among the student

classes attended instead of the earliest term start date.

UK - HESA 1979233001 HESA Extract

Producing extra

students who should

not be returned into

the current extract

Students with an ssr_he_flag='N' and

ssr_he_hin_ppn_yr=2008 are being included in the

HESA extract on the PS_SSR_HE_INSTANCE

table. Expect only students with a ssr_he_flag='Y'

and ssr_he_hin_ppn_yr=2009 on the

PS_SSR_HE_INSTANCE to be on the extract.

A new parameter HIN Population Only is added to

SSR_HE_EXT_PRC_RC page and application package

SSR_HE_EXTRACT_PRC is modified.

Student Records

Copyright Oracle Corporation 2010. All rights reserved. 51

Peoplesoft Enterprise - Campus Solutions - 9.0 Bundle #20

Product Category Incident ID Reported Problem

Description

Problem Description Resolution Description

UK - HESA 1980566001 Misleading log

messages generated

by HESA extract

process

The process SSR_HE_DATA produces messages in

the log file which are lacking in detail. Most of the

messages do not say which student/instance

number the message refers to, some of the

messages do not say what HESA field they refer to,

whilst just about every postcode and term-time

postcode field value seems to get listed albeit

without stating which student they are for.

Removed unnecessary messages from the

SSR_HE_EXTRACT_PRC application package.

UK - HESA 1983469001 HESA - Student

Return 2009/10 - v1.4

Changes

HESA published version 1.4 of the Student return

2009/10 specification on 30-APR-2010. This

includes changes to the business rules for a number

of fields.

Modified the derivation logic of selected fields in

SSR_HE_EXTRACT_PRC application package.

UK - HESA 1983773001 Running the HESA

Extract process

without the Student

option checked

causes buffer errors

If you run the HESA Extract process with the

Course, Module and Student options checked the

process works fine. If you subsequently then run it

without the Student option checked it causes buffer

errors in the student extract data because

SSR_HE_DATA.Extract.Step03 PeopleCode

deletes from PS_SSR_HE_INSTA_EX and

PS_SSR_HE_IN_EX_FL. You would not always

need to re-run the student extract so it needs to be

changed so that this data is not deleted if the

Student option isn't checked.

For example if you've run the process for all 3

options and have generated the XML file and found

some validation errors for a course or module that

doesn't affect the student data then you would fix

the data in the source tables and then just re-run the

course and / or module extracts.

Code is modified to delete records in tables

PS_SSR_HE_INSTA_EX and PS_SSR_HE_IN_EX_FL only

when the Extract is run for Student Entity. When the

Student option is not selected, records are not deleted.

Student Records

Copyright Oracle Corporation 2010. All rights reserved. 52

Peoplesoft Enterprise - Campus Solutions - 9.0 Bundle #20

Product Category Incident ID Reported Problem

Description

Problem Description Resolution Description

UK - HESA 1987030001 HESA - Nationality

code mapping

incorrectly used for

Domicile

The Codes and Mappings table used for mapping

Nationality values is also used for the Entry Profile

Domicile field, but this is incorrect because for some

countries, the PS country code (eg REU Reunion

Island) needs to map to one code (eg FR France)

for Nationality but a different code (eg RE Reunion)

for Domicile. However, the Domicile codes are not

listed so the incorrect Nationality code is being

returned for Domicile.

Record SCC_HE_NATIONAL changed to add a new

column SCC_HE_DOMICILE to map Country to Domicile.

The record was updated to populate prompts for Nationality

and Domicile fields and to populate the corresponding

description fields on page SCC_HE_NATIONALITY. The

derivation of DOMICILE is updated to reference the new

mapping.

UK - HESA 1987368001 HESA - Duplicate

Qualifications

Awarded entities

created

In cases where two Qualifications Awarded records

are defined in HESA Instance Data one of the

records is derived twice rather than each record

being derived.

As two records can be present for SSR_HE_QUAL_AWD

for same instance, Application Package

SSR_HE_EXTRACT_PRC was changed to update class

QualAwarded_Fields_Extract so that the two records are

treated separately.

UK - HESA 1997021001 HESA DISALL

derivation needs

additional step to

consider Impairment

Record

Please use the impairment record as part of the

derivation step for DISALL for next year's HESA

Return (2011). The impairment record isn't used at

all at the moment for DISALL. Users would need to

look at the request to use the Disability Claim value

from the Impairment record.

A new mapping to Disability Allowance is added. Modified

the derivation logic in

SSR_HE_EXTRACT_PRC.Instance_Fields_Extract

application class to add the additional step to consider

impairment record.

UK - HESA 1997609001 HESA - Extract

Performance - Further

Improvements

Further improvements are required to the extract

performance to reduce the run time for a full

student population to less than 4 hours

Modified SSR_HE_DATA App Engine and

SSR_HE_EXTRACT_PRC.Instance_extraction application

class to reduce the number of times the instance class is

instantiated.

Student Records

Copyright Oracle Corporation 2010. All rights reserved. 53

Peoplesoft Enterprise - Campus Solutions - 9.0 Bundle #20

Product Category Incident ID Reported Problem

Description

Problem Description Resolution Description

UK - HESA 2003775001 HESA - DOMICILE

field using latest

record in reporting

period instead of

domicile on entry

The HESA Domicile field in the Entry Profile

instance should record the "country code of the

student's permanent or home address prior to entry

to the course". However, the Oracle Field

Derivation guide says that if there is no value

against the Entry Profile Data page then "Select the

most recent Residency Self-Report record with the

Date Reported on or before the reporting period end

date."

Modified derivation logic in

SSR_HE_EXTRACT_PRC.Entry_Profile_Fields_Extract

application class to consider Residency Self-Report record

with the latest Date Reported prior to COMDATE. If no

record is found then the record with the earliest date

reported date on or after COMDATE is considered.

UK - HESA 2008885001 HESA: UCASAPPID

is not being extracted

when

STDNT_CAR_NBR in

ACAD_PROG does

not match

ADM_APPL_DATA

The UCASAPPID field is not being extracted for

some students where the STDNT_CAR_NBR value

in PS_ACAD_PROG is different to the value in

PS_ADM_APPL_DATA

Modified derivation logic in

SSR_HE_EXTRACT_PRC.Instance_Fields_Extract

application class to handle scenarios where the student’s

Career Number is advanced when a new UCAS application

is matriculated and the student already has an existing

Student Career/Program record.

UK - HESA 2011319001 HESA - Entry Profiles

for returning students

where COMDATE is

not in current

reporting year

An Entry Profile record is only extracted when the

COMDATE is in the reporting period. The extract

process does not have the ability to create entry

profiles for retuning students where the COMDATE

does not fall in the current reporting period. The

following is taken from the HESA website:

Compulsory for instances where

Instance.COMDATE is in the current reporting year

or where the Instance has not been previously

reported. Optional in cases where previously

supplied EntryProfile data needs to be corrected.

New column has been added to record

SSR_HE_INSTA_EX with corresponding field on HESA

Instance - Entry Profile. In

Instance_Extraction.SSR_HE_EXTRACT_PRC (Application

Class) method extract has been changed to assign value to

the new field while creating new header record.

Entry_Profile_ Extraction Class is updated to consider the

value from SSR_HE_ENT_PROF.

Student Records

Copyright Oracle Corporation 2010. All rights reserved. 54

Peoplesoft Enterprise - Campus Solutions - 9.0 Bundle #20

Product Category Incident ID Reported Problem

Description

Problem Description Resolution Description

UK - HESA 2014539001 HESA - Student on

Module extraction

does not take into

account OEE

modules correctly

The class end date in PS_CLASS_TBL is '31-JUL-

2008' but the end date against the student in

PS_STDNT_ENRL_OEE is '01-SEP-2009'.

PS_CLASS_TBL end date can't be changed to pull

the class into the Student on Module entity for this

student as this will then potentially pull the class in

for other students that have no activity the reporting

period. For OEE classes the extract needs to use

the dates in PS_STDNT_ENRL_OEE. This same

logic applies to the FTE and STULOAD calculations.

Modified the method extract in

SSR_HE_EXTRACT_PRC.StudentOnModule_Extraction

application class to consider the OEE modules correctly.

UK - HESA 2014647001 HESA - UCASAPPID

not appearing on

extract for ucas

student

The UCASAPPID does not appear on the extract for

a student with a ucas app number.

Modified derivation logic in

SSR_HE_EXTRACT_PRC.Instance_Fields_Extract

application class to consider the second step in the

derivation irrespective of any default value defined for step

3.

UK - HESA 2028139001 Meta data for

Calculate Full-Time

Equivalence page is

broken

Meta data for Calculate Full-Time Equivalence page

on Page Control Data table is broken. As a result,

DataMover script abends when it tries to import

PSPNLCNTRLDATA into non-Unicode databases.

PTHDGSHOW, PTHDGROWACTBTNS fields of

PSPNLCNTRLDATA table were containing Invalid values

due to improper Grid property settings on Calculate FTE

(SSR_HE_CALC_FTE) Page.Grid properties are reset to

valid values.

Student Records

Copyright Oracle Corporation 2010. All rights reserved. 55

Peoplesoft Enterprise - Campus Solutions - 9.0 Bundle #20

Product Category Incident ID Reported Problem

Description

Problem Description Resolution Description

UK - HESA 2038147001 HESA - PHDSUB field

derivation

The field PHDSUB is only extracted where

Instance.RCSTDNT is not 99. The HESA

documentation specifies the following:

All instances where Instance.RCSTDNT is not 99

and Course.COURSEAIM = D00, D01 and

Instance.REDUCEDI = 00 or 04. Optional for all

other instances where Course.COURSEAIM = D00,

D01 and Instance.REDUCEDI = 00 or 04

As this is optional for students where

Instance.RCSTDNT is 99 this part of the derivation

needs to be removed.

Derivation logic for field PHDSUB has been modified in

SSR_HE_EXTRACT_PRC.Instance_Fields_Extract

application class so that it is extracted without reference to

Instance.RCSTDNT, i.e. where Course.COURSEAIM =

D00, D01 and Instance.REDUCEDI = 00 or 04.

UK - HESA 2039017001 EFFDTCHECK:

Invalid number of

parameters (2,-1)

SSR_HE_PLAN.SSR_

HE_FLAG.RowInit

Error on Acad Plan

After applying CS9 Bundle #19 when adding a new

plan or searching for a plan on the Academic Plan

Table, the following error occurs: EFFDTCHECK:

Invalid number of parameters (2,-1)

SSR_HE_PLAN.SSR_HE_FLAG.RowInit PCPC:395

Statement:3

There were no changes made to the PeopleCode in

bundle #19. However, the issue does not occur in

environments on bundle #18/PT 8.50. So it seems

like an issue with PeopleTools 8.51.

Modified a sql in SSR_HE_PLAN.SSR_HE_FLAG.RowInit

peoplecode. An 'AND' condition was missing and the

parameters to effdtcheck were incorrect. The 'AND'

condition has now been added and the correct parameters

are being passed.

Student Records

Copyright Oracle Corporation 2010. All rights reserved. 56

Peoplesoft Enterprise - Campus Solutions - 9.0 Bundle #20

Product Category Incident ID Reported Problem

Description

Problem Description Resolution Description

AP Interface 607350002 Payment Group on

Vendor Setup Shows

on Initial Vendor Loc

for SA Student

NAVIGATION: Home, Manage Student Financials,

Refund Customers

Process, AP Refunds

SA student refunds to the first address type have

the correct payment group included on the message

sent to Financials. Subsequent refunds to different

address types for the student do not have a

payment group included on the message. The

payment group is not being updated in the

SF_VENDOR_PAY table. Also, the AP Set Control -

Vendor page allows for entry of a 3 character pay

group. This page is associated to record

SF_AP_VNDR_OPTN. The pay group field in

underlying tables used in the vendor processing

have the pay group field defined at 2 characters.

See SF_VENDOR_PAY.PYMNT_GROUP_CD.

Changes were made to both Student and Org logic to

correct the issue with the missing Payment Group Code.

SF_IND_VNDR.CREATEOI.Step02 and

SF_ORG_VNDR.CREATEOV.Step02 were modified to

populate the PYMNT_GROUP_CD field. Changes were

also made to the field length of SF_AP_VNDR_PAYGRP

from 3 to 2.

AP Interface 1248512002 Control Group

ID,Vendor ID and

Voucher ID Are Not

Saved With Leading

Zeros

NAVIGATION: Home, Manage Student Financials,

Refund Customers

Process, AP Refunds

On the SA side, the Control Group ID,Vendor ID and

the Voucher ID are not saved with leading zeros

when processing AP Interface's integration to

Finance 8.4/8.8. When a new vendor is created on

Financials 8.4/8.8, the vendor id is prefixed with

leading zeros. Since SA creates it's own vendor ids,

the vendor id, voucher id, and control group id

generated by SA should be the same format as

Financials for data consistency.

Enhancements were made to the new version of the AP

Interface (SSF_AP_INTFC) to zero-fill the voucher id and

control group fields.

Student

Financials

Copyright Oracle Corporation 2010. All rights reserved. 57

Peoplesoft Enterprise - Campus Solutions - 9.0 Bundle #20

Product Category Incident ID Reported Problem

Description

Problem Description Resolution Description

AP Interface 1586085002 Control Group for AP

Interface Field

Lengths For CS and

FIS Do Not Match

There is a voucher control group counter in HRCS

8.9 for the next control group when the next student

vendor voucher group is created in HRCS 8.9. The

voucher control group counter in HRCS 8.9 uses

only 6 digits while the voucher control group number

in FIS 8.4 is a 10-digit number. The field length

should be the same on each application.

The field GRP_AP_ID_LASTUSED was modified;

increasing the length to 10 from 6.

AP Interface 2020025002 SF_AP_INTFC fails

on insert with unique

constraint error

Create Vendors and Vouchers' fails with unique

constraint error when inserting to vendor contact

table. The application engine

SF_ORG_VNDR.INSCNTCT.Step02.SQL should

check the max(effdt).

Changes were made to the SQL in

SF_ORG_VNDR.INSCNTCT.Step02 to check for the max

effdt from ORG_CONTACT.

GL Interface 2016822001 Create a new process

to send specific

transactions directly

to the general ledger.

Create a generic application fee calculation process

for the AAWS on line application. In addition, create

a new process to send the transactions directly to

the general ledger. (See Admissions incident

2016826000 for further information.)

Created a generic application fee calculation process as

well as created a process that sends transactions directly to

the GL (SSF_GL_TRANS). See Admissions incident

2016826000 for further information.

Refunding 660463002 Level 1 Approval

worklist are not

showing student

name

When reviewing worklist items collections,

cashiering worklist items show students name,

Level 1 approval do not show the student name.

This makes it very difficult to locate a particular

student's refund on the worklist. It is also

inconsistent with all the other worklist items which

do display the student's name.

Changes were made to Activity Definitions, Generate

Refund and Generate Org Refund to use the

REFUND_WRK1.NAME field for populating the worklist

record.

Student

Financials

Copyright Oracle Corporation 2010. All rights reserved. 58

Peoplesoft Enterprise - Campus Solutions - 9.0 Bundle #20

Product Category Incident ID Reported Problem

Description

Problem Description Resolution Description

Refunding 672229002 Different Operator

Security Used by

Online Refunding

Methods

NAVIGATION: Home, Manage Student Financials,

Refund Customers

Use, Student Refund

Use, Online Refund With Extra Amount

A userid with no operator defaults can successfully

post a Student Refund, but a Refund With Extra

Amount

fails, as it's looking to the operator default setup

during the processing.

Changes were made to PeopleCode

DERIVED_SF.BUSINESS_UNIT.RowInit to initialize the

Business Unit value.

Refunding 672921002 AP Refund Process

Does Not Generate

Report When

Interfacing to Fin. 8.4

NAVIGATION: Student Financials, Refunds, AP

Refunding, Create Vendors and Vouchers

(SF_AP_INTFC)

The AP Refund request page

(RUNCTL_AP_REFUND) has a "Generate Report"

checkbox. When interfacing to Financials 8.4, and

the "Generate Report" box is checked, no report is

created. When interfacing to E&G Financials 7.5, a

report of the refunds is created.

The report only flag was removed from the page for both

the Create Vendors and Vouchers process (SF_AP_INTFC)

and the Create Refund Vouchers process

(SSF_AP_INTFC). The app engine processes were

modified to no longer read that run control parameters.

Refunding 1132830002 Check / Voucher Info

Not Consistently

Displaying on Refund

Details Page

The RowInit PeopleCode of Check / Voucher Info

on the Refund Details page

(ITEM_LINE_RFND_SP) was written to only work

when navigating through Customer Accounts. The

Refund Details page can be accessed from other

areas, for example Student Payments, however the

check / voucher number do not display. Please fix

the PeopleCode so that the Check / Voucher Info on

Refund Details is always displayed.

Changes were made to PeopleCode

DERIVED_SF.GET_LINE_SP.FieldChange to determine

information for AP method.

Student

Financials

Copyright Oracle Corporation 2010. All rights reserved. 59

Peoplesoft Enterprise - Campus Solutions - 9.0 Bundle #20

Product Category Incident ID Reported Problem

Description

Problem Description Resolution Description

Refunding 1244218002 Batch Refund

Approval SFPREFAP

Database agent will

generate 2

transactionids for the

same refund

Running Batch refund approval will create one

transactionid for each refund and an instanceid for

each refund approver on a worklist. When items

are marked worked the inststatus will flip to a value

of 2 and all other instanceid's for this transactionid

will be deleted from PSWORKLIST and

REFUND_WL, PS_REFUND_HDR is updated with

the date of the approval.

IF the process is run for the same batch on a

different day, a NEW tranactionid will be generated

for the same refund. This new worklist item cannot

be removed from the worklist. When attempting to

work this item the user is brought to the search

page for REFUND_SF_APPR and told no matching

values were found (listing the refund number,

emplid and refund number)

If the user clicks the search again they get error

message - This page is accessible only via a

Worklist (14810,271). The only way you can access

this page is through a worklist entry.

Changes were made to the SQL in

SSF_REFND_APP.MAIN.Step02.DoSelect to ignore

refunds that have already been added to the worklist.

Student

Financials

Copyright Oracle Corporation 2010. All rights reserved. 60

Peoplesoft Enterprise - Campus Solutions - 9.0 Bundle #20

Product Category Incident ID Reported Problem

Description

Problem Description Resolution Description

Refunding 1379019002 Batch refunding will

not correctly populate

information for a

Direct Deposit Advice

NAVIGATION: Refund Customers, Inquire, Refunds

by ID (Check/Voucher Info link and the Refund

Detail link)

PROBLEM: Online student refunding works fine.

But if a refund is generated in batch, and that refund

creates a Direct Deposit Advice rather than a paper

check, the Refund Details page will contain the

amount of the refund listed as a check rather than a

direct deposit. Further, attempting to open the

Check/Voucher Info page will result in an error citing

that the refund has been cancelled or not finished.

Changes were made to the Batch Refunds COBOL

program (SFPREFND.CBL/DMS) to correctly set the refund

format for direct deposit refunds.

Refunding 1457313001 SF: Incorporate Direct

Deposit through

Accounts Payable

Interface

The A/P Interface process already incorporates the

SF_VNDR_BANK_AC record.

Additional changes:

1. Provide a page to record the direct deposit and

bank information in self service for a student.

2. Provide Administrative pages to record bank and

direct deposit information on behalf of students and

organizations.

3. Modify the App Engine process to look for direct

deposit and bank setup and then pass the payment

method to Financials.

4. Provide the ability to override the direct deposit

refund method and have a check printed for a

selected student or for an organization.

Enhancements were made to deliver a new AP Interface

(SSF_AP_INTFC) to support Direct Deposit Refunds.

Student

Financials

Copyright Oracle Corporation 2010. All rights reserved. 61

Peoplesoft Enterprise - Campus Solutions - 9.0 Bundle #20

Product Category Incident ID Reported Problem

Description

Problem Description Resolution Description

Refunding 1580352003 Corporate Sponsor

Refund Generates

Error Using Refund

Format of Paper

Check

When posting a refund on the Corporate Sponsor

Refund page to an organization for an emplid, and

the refund format is changed from A (automatic

check) to P (paper check) an error message is

generated. The error is "Corporate Organizations

are only allowed to use Automatic Check or Paper

Check 14840,1000".

Changes were made to

REFUND_WRK1.REFUND_FORMAT.FieldEdit

PeopleCode to correct this error.

Refunding 1643888002 Refund with Extra

amount page does

not refresh grid after

posting.

When a refund is posted on REFUND_SF (the

refund with extra amount page) the student balance

will refresh after posting but the grid showing

available payments for refunding will continue to

display the payments that have already been fully

refunded.

Changes were made to Refund pages to ensure once

refund is posted, no further action can be taken.

Refunding 1683584001 Refunds can be

issued to yourself

A payment or charge posted by your own emplid

number yields error message 15,13. You are not

allowed to update your own data. (15,13). However,

that error will not pop up if you are issuing yourself a

refund.

Changes were made to REFUND_WRK1.EMPLID.FieldEdit

and REFUND_WRK1.EMPLID_OLD.FieldEdit to ensure

student/sponsor cannot issue refunds to themselves.

Refunding 1719555002 Student Refund page

is not refreshed after

Tuition Calculation

When Tuition Calculation is required for a student

who has a refundable credit on their account and

the operator enters the Student Refund page to

issue a refund, pressing the Tuition Calc refund

button will cause Tuition Calc to run but will not

refresh the data on the page to show that the credit

is no longer refundable in the original amount.

Changes were made to PeopleCode

DERIVED_SF.TUIT_CALC_PB.FieldChange to refresh the

page after tuition has been recalculated.

Refunding 1719707002 Refund to Org

Process Displays

Wrong Field for

Organization Name

The page REFUND_ORG_SF uses the

EXT_ORG_TBL.OTH_NAME_SORT_SRCH field to

display the organization name. This page should

use the EXT_ORG_TBL.DESCR field to show the

organization name.

The REFUND_ORG_SF page was modified to use

EXT_ORG_TBL.DESCR to display the Organization Name.

Student

Financials

Copyright Oracle Corporation 2010. All rights reserved. 62

Peoplesoft Enterprise - Campus Solutions - 9.0 Bundle #20

Product Category Incident ID Reported Problem

Description

Problem Description Resolution Description

Refunding 1736335001 Student Refund page

will allow for selection

of an inactive address

when selecting the

Address Type

On the Student Refund page is an edit box that has

a prompt to identify the Address Type to be used on

the student's refund. When the magnifying glass is

pressed, the results will show Address Types

available for this particular student, along with the

address associated with that Address Type. The

results will include addresses, however, that are

Inactive, allowing the operator to select what they

think is valid, but is not.

A new view SSF_ADDRESS3_VW was created for address

type prompting to only show active addresses.

Refunding 1741078001 Enh Req to hide

SSF_RUN_SFPREFN

D_5 on the

component at the App

Designer level

After upgrading to 9, customers noticed that this

page is editable to a user unless security prevents

them from accessing the page. They would like to

have it marked as "Hidden" on the component at the

App Designer level.

Changes were made to Component RUN_SFPREFND to

hide the SSF_RUN_SFPREFND_5 Page item.

Refunding 1749626002 Refunds to sponsors

sometimes appear on

Review by ID and

sometimes do not

display.

When a refund is posted to a sponsor entering the

Review by ID page should show the refund for the

student to whose account the refund was posted.

This refund will not appear when you first use the

page, but if you exit to View Customer Accounts and

then return to the page you will be able to see it.

Changes were made to PeopleCode

REFUND_WRK1.REFUND_EMPLID.RowInit to only show

refunds for the student and not the sponsor on the Review

Student by ID page. Sponsor Refunds can continue to be

reviewed on the Ind Sponsors Refunds by ID page.

Refunding 1768252001 Batch Refunding

Does Not Allow

Change In Refund

Method

The batch refunding job does not allow for change

in Refund Method. Online refunding does permit for

the change in refund method. Batch Refunding

should allow for the change in refund method to be

consistent with online refunding.

Changes were made to the Batch Refund Run Control page

to allow changes to the Refund Method field. Modifications

were also made to the COBOL program (SFPREFND) to

support this change.

Student

Financials

Copyright Oracle Corporation 2010. All rights reserved. 63

Peoplesoft Enterprise - Campus Solutions - 9.0 Bundle #20

Product Category Incident ID Reported Problem

Description

Problem Description Resolution Description

Refunding 1868638001 Error message for not

having a corporate

address during

refunding should be

changed

Currently, if an address is not found for an external

organization during the refund process, the error

message that is given cites "You must select a

Refund Address for the Addr Usage". This should

be changed to reflect the true problem, which is that

an address has not been found for the external org

contact type, and give the contact type being used.

Changes were made to Batch Refunding (SFPREFND) and

Online Org Refunds

(REFUND_WRK1.RUN_ORG_OPTION.FieldEdit) to use a

new message that is appropriate for missing organization

addresses.

Refunding 1886011001 Earnings Code

required for refunds to

External Orgs when

using the Accounts

Payable method for

refunding

Using an Item Type in which the Earnings Code

(NonTaxable) is set to blank, post an excess

payment to an External Org account. Then use the

batch refund process to refund to refund that

payment. The payment will not be refunded and an

error message will state that an Earnings Code is

missing. Since batch refunding to external

organizations can only be accomplished via

Accounts Payable, this is a bug.

Changes were made to Batch Refunding (SFPREFND) to

ignore earnings code for organizations when the method is

Accounts Payable.

Refunding 1900293001 Refund with Extra

Amount allows

transaction without

specifying an address

Refund with Extra Amount allows transaction to be

saved without specifying an address. Address

should be a required field, as an error will occur

when the Create Vendors and Vouchers process

runs for transactions that do not have address data.

However, if the address is not entered, but the post

refund button is clicked, a refund transaction will be

created. This differs from a regular refund post

where an error is given if an attempt is made to post

the refund without specifying an address.

Changes were made to

REFUND_WRK1.RUN_OPTION.FieldEdit to check for an

address when an Extra Amount is specified.

Student

Financials

Copyright Oracle Corporation 2010. All rights reserved. 64

Peoplesoft Enterprise - Campus Solutions - 9.0 Bundle #20

Product Category Incident ID Reported Problem

Description

Problem Description Resolution Description

Refunding 1920109001 Warning message

has incorrect wording

and is hardcoded in

Corporate Sponsor

Refund page

Navigate to Student Financials > Refunds >

Corporate Sponsor Refund page if the corporate

sponsor has more than one students found for it.

The message is worded incorrect and states: More

the one student found for Refund Sponsor ID.

Please select a Student ID. It is also hardcoded on

the peoplecode of

REFUND_WRK1.SSF_RFND_ORG_SPON.FieldCh

ange instead of using the message catalog

(14810,471).

Changes were made to PeopleCode

REFUND_WRK1.SSF_RFND_ORG_SPON.FieldChange to

use the message catalog entry 14810, 471 when more than

one corporate sponsor exists.

Refunding 1936648001 Issue with Review

Corporate Sponsor by

ID and View

Corporate Sponsor by

Date pages

On Campus Solutions 9.0 accessing the pages :

Student Financials>Refunds>Review Corporate

Sponsor by ID and Student

Financials>Refunds>View Corporate Sponsor by

Date the links 'Check / Voucher Info' and 'Voucher

Info' do not perform any action. The page simply

refreshes but does not bring you to the voucher info.

Changes were made to PeopleCode

REFUND_WRK1.PAY_CHECK_REFUND.FieldChange to

display refund information for the Corporate Sponsor review

pages.

Tut Calc 1961636001 Overriding a Tuition

Group Containing

GST Applicable

Charges Fails

Tuition calculation will fail when a student has been

assessed GST applicable charges by one tuition

group, and the original tuition group is overridden.

The error received is 'Cannot post this charge.

(14816,85) To post this charge the item type

requires that the amount be greater than or equal to

zero.'. The student account will contain charges

from the original tuition group and the tuition group

used to override.

Changes were made to COBOL programs SFPBKFEE and

SFPGRPCL to resolve the error.

Tut Calc 1961675002 AGE_BOT Criteria

Does not Calculate

Age Correctly

Tuition Group Criteria AGE-BOT does not calculate

the age as of Beginning of Term Correctly.

Changes were made to COBOL program SFPSTDNT to

calculate age for the AGE-BOT and AGE-EOT variables

correctly.

Student

Financials

Copyright Oracle Corporation 2010. All rights reserved. 65

Peoplesoft Enterprise - Campus Solutions - 9.0 Bundle #20

Product Category Incident ID Reported Problem

Description

Problem Description Resolution Description

Tut Calc 1979080002 Open cursors are not

disconnected in SF

COBOL processes

SFPQGUSS,

SFPQKORG and

SFPCRITR.

A few SF COBOL programs require modifications to

close the following cursors:

SFPQGUSS.CBL:

SQL-CURSOR OF I-PAYTTBL

SFPQKORG.CBL:

SQL-CURSOR OF U-QPOST

SQL-CURSOR OF S-ITEM-PAYID

SFPCRITR.CBL

SQL-CURSOR OF S-CRITSEQ

Changes were made to COBOL programs SFPQGUSS,

SFPQKORG and SFPCRITR to close open cursors.

SFPQGUSS.CBL: SQL-CURSOR OF I-PAYTTBL,

SFPQKORG.CBL: SQL-CURSOR OF U-QPOST, SQL-

CURSOR OF S-ITEM-PAYID, SFPCRITR.CBL: SQL-

CURSOR OF S-CRITSEQ.

Tut Calc 2028765001 Transaction Fees

Posting to Wrong

Session Code

When a Transaction Fee is set to post by session,

and the fee applies to multiple sessions for a

student, the incorrect session is written to

ITEM_SF/ITEM_LINE_SF. The multiple fees will

post, but one will have an incorrect session.

Changes were made to SFPFECAL.CBL to initialize

session code when processing transaction fees and Charge

By Session is used.

Student

Financials

Copyright Oracle Corporation 2010. All rights reserved. 66

Peoplesoft Enterprise - Campus Solutions - 9.0 Bundle #20

Product Category Incident ID Reported Problem

Description

Problem Description Resolution Description

Addresses 1957018001 Invalid Search Record

is used in Seasonal

Addresses page

Issue 1:

Pre-req: ID should not have any addresses data

1) Navigate Campus Community > Personal Info >

Biographical > Addresses/Phone > Seasonal

Addresses

2) ID = CC0030, Search

Expected

No Matching Data found message should be

displayed

Actual:

System opens the Seasonal Addresses page and

allows user to add Seasonal Address detail. But the

user is not supposed to enter Seasonal Address to

someone who doesn't already have an address. If

user still enters seasonal address it will not be

applied.

Note: The search record used the record

PEOPLE_SRCH. Instead it should use a search

record that includes a view that queries the

ADDRESSES record to return rows only for

EMPLID's who have a row in PS_ADDRESSES.

Issue 2:

1) Navigate Campus Community > Personal Info >

Biographical > Addresses/Phone > Seasonal

Addresses

2) ID = CC0001, Search

3) In Address Type list box,

Expected:

Only Campus and Home should be displayed ( as

we can apply seasonal address only to existing

Modified the Address field from drop down list to a Prompt

Address field would display only Active – Current/Future

dated address types associated to the emplid

If existing seasonal address is not longer existing/active,

appropriate message would be displayed.

Campus

Community

Copyright Oracle Corporation 2010. All rights reserved. 67

Peoplesoft Enterprise - Campus Solutions - 9.0 Bundle #20

Product Category Incident ID Reported Problem

Description

Problem Description Resolution Description

Attachments 1973846001 Need to define

SCC_ATTACH_IMP

as a system record.

The rows in SCC_ATTACH_IMP must be delivered

to the customer as they contain system data that is

required by the attachments framework. The

SCC_ATTACH_IMP record is currently not set as a

system record. This record needs to be defined as a

system record.

A row with RECNAME of ‘SCC_ATTACH_IMP’ and

IMPORT_OPTION of ‘N’ has been inserted into the

PS_PM_PS_REC table.

Communication Generation1929189001 CommGen is not

updating checklists

correctly when the

same checklist item is

used multiple times

When using the same checklist item multiple times

under one checklist code, Communication

Generation completes the communication, then

updates to complete the checklist item at seq 100,

as well as the checklist status to complete. When

processing the communication corresponding to the

checklist at seq 200, CommGen will also update

that checklist item to complete even though the

checklist status is complete.

Modified join criteria of SQL in App Engine Process -

SCC_COMMGEN Section: XupdComm Step07

peopleCode.

Communication Generation1967657001 Hardcoded page title

for

SCC_CG_QRY_SELE

CT

Page: SCC_CG_QRY_SELECT. Path: Set Up

SACR, Common Definitions, Communications,

Communication Data Source. Click on a Query

lookup icon. Title of page is hardcoded in the

following Record PeopleCode:

[SCC_CG_QRY_WRK.SAD_SELECT_QRY.FieldCh

ange]

&result = DoModal(Page.SCC_CG_QRY_SELECT,

"Select Query", - 1, - 1);

Modified the people code in call to the secondary page, to

get the related message from the Message Catalog, rather

than hard coding.

Campus

Community

Copyright Oracle Corporation 2010. All rights reserved. 68

Peoplesoft Enterprise - Campus Solutions - 9.0 Bundle #20

Product Category Incident ID Reported Problem

Description

Problem Description Resolution Description

Communication Generation1995231001 Commgen Joint

Salutation Name field

cleared when saving,

causes error message

When amending an existing Communication

Generation run control with a new EMPLID,

selecting a new letter code and template, then

saving on the basis that the other settings remain

valid, the system shows the error message "Joint

Salutation Name Usage is Required. (14000,280)

Joint Salutation Name Usage is Required.", and

clears the value in the Joint Salutation Name field.

The user must reset this field, that was OK

beforehand, and the save again.

Removed code to Default and Gray Joint Salutation Field

on FieldChange of EMPLID and CG_COMM_ID_OPTION to

retain Joint Salutation values.

Communication Generation1999252001 View Generated

Communication link

does not appear with

certain

Communication

Generation run

control parameters for

missing data

On the process parameters page, when the Missing

Critical Data parameters are set to:

Produce Communication = Y

Complete Communication = N

For a Person Communication, the View Generated

Communication link does not appear on the

Communication Management page even though the

process ran to success and the output was

produced.

Removed complete communication check from

COMM_MANAGEMENT.PostBuild Code to make View

Communication Link Visible irrespective of Communication

is produced or not.

Communications 1993702001 Self Service >

Campus Personal

Information > User

Preferences-Set

Communication

Preferences link issue

The "Set Communication Preferences" link on the

Self Service > Campus Personal Information > User

Preferences is not behaving correctly in some

situations. It is visible when it should not be

according to the Campus Community Installation

settings pagewhen the multiple communication

methods it not activated.

Add code in the related Components to correct the behavior

by either hiding or displaying the fields based on the set-up

done, and, display an appropriate message if an emplid has

invalid communication preferences defined.

Campus

Community

Copyright Oracle Corporation 2010. All rights reserved. 69

Peoplesoft Enterprise - Campus Solutions - 9.0 Bundle #20

Product Category Incident ID Reported Problem

Description

Problem Description Resolution Description

Communications 2013996002 CS90 upgrade makes

Comm Data Sources

unmanageable

The XMLP data sources get moved by

mvprdexp.dms within the upgrade:

-- XML Publisher Data Source

EXPORT PSXPDATASRC;

EXPORT PSXPDATASRCLNG;

EXPORT PSXPSCHEMAFLMN;

EXPORT PSXPSMPLDTMN;

This moves any and all XML data sources from

source to target, including any custom data sources

created in the source environment (these would not

exist in DMO). however, Communication Data

Sources created in the target environment are not

moved. this creates the mismatch as described.

The XML data source definitions are stored in table

PSXPDATASRC. The Communication data source

definitions are stored in table

PS_SCC_CG_DTASRC. The former is exported as

part of the upgrade process (mvprdexp.dms), the

latter is not. In order to update a communication

data source through the SCC_CG_DTASRC

component, you have to have a row in both

PSXPDATASRC and PS_SCC_CG_DTASRC. The

assumption underlying the behavior in this

component is that you either have a row in both

tables, or in none. However, the upgrade leaves

customers with a row in PSXPDATASRC without

the corresponding row in PS_SCC_CG_DTASRC.

This renders the SCC_CG_DTASRC component

unusable for this particular data source.

The IMPORT_OPTION field in the PS_PM_PS_REC record

has been set to 'I' for the SCC_CG_DTASRC,

SCC_CG_CUST_DTA and SCC_CG_GEN_DTA rows.

Campus

Community

Copyright Oracle Corporation 2010. All rights reserved. 70

Peoplesoft Enterprise - Campus Solutions - 9.0 Bundle #20

Product Category Incident ID Reported Problem

Description

Problem Description Resolution Description

Constituent Services 2024196001 AAWS - Transaction

Management

Process, the

PERSON_BASIC_SY

NC message has

blank MsgData in

published payload

AAWS script run Transaction Management Process

(AF Program: SCC_SL_SMP) was run to Success in

S900P25 a new ID e.g. "0067" was created in CS

db. With that 2 messages were published from CS9.

But at the subscription in HR91 db one of the msg

was ERROR, The XML of the Errored transaction

was a bit odd, the MsgData is blank. The Error

Message says, "Message name

PERSON_BASIC_SYNC not in message data.

(119,5)

SCC_HR_INTEGRATION.Handlers.PersonBasicSy

nc.OnExecute Name:OnNotify PCPC:1723

Statement:19".

The code in App Class

CS_PERSON_SERVICES:Person:AddPersonCS_v1_1:impl

AddPersonCS was modified to use the latest integration

broker built in functions to create a publish the

PERSON_BASIC_SYNC and DSPERSON_BASIC_SYNC

messages.

Constituent Transaction Mgmnt2000366002 CTM: AAWS

documentation is

missing info on how to

create and use unit

tests for Entities

The GA version of the "AAWS Developers

Guide_External.docx" does not include information

on how to take advantage of the ability to create and

run unit tests for existing and new Entities created

by the users.

Creating and Running Unit Test documentation

should be added inside the section called :

"Extending AAWS".

Campus

Community

Copyright Oracle Corporation 2010. All rights reserved. 71

Peoplesoft Enterprise - Campus Solutions - 9.0 Bundle #20

Product Category Incident ID Reported Problem

Description

Problem Description Resolution Description

Constituent Transaction Mgmnt2008490001 CTM: Posting a

submitted transaction

from the Transaction

Staging component

posts all related

transactions

When admin user posts a submitted transaction

from the Transaction Staging component, all the

related submitted transactions get posted. Instead,

only the transactions for which the user presses the

Post Transaction Data button should be posted.

When post transaction occurs, the following logic

should be in place:

-> Realtime (s-service user submits a transaction):

Only the specific transaction gets posted. Other

related transactions are not posted.

-> Manual (admin user presses Run S/M/P or Post

Transaction Data button from the Const Staging

component):

All related transactions in Submit status get posted

at the same time.

-> Manual (admin user presses Run S/M/P or Post

Transaction Data button from the Transaction

Staging component):

Only the specific transaction in Submit status gets

posted.

-> Batch:

Only the Transaction Code selected in the Run Ctrl

page gets posted.

Modified the code so it will work as follows:

- Realtime (s-service user submits a transaction): Only the

specific transaction gets posted. Other related transactions

are not posted.

- Manual (admin user presses Run S/M/P or Post

Transaction Data button from the Const Staging

component): All related transactions in Submit status get

posted at the same time.

- Manual (admin user presses Run S/M/P or Post

Transaction Data button from the Transaction Staging

component): Only the specific transaction in Submit status

gets posted.

- Batch: Only the Transaction Code selected in the Run Ctrl

page gets posted.

Campus

Community

Copyright Oracle Corporation 2010. All rights reserved. 72

Peoplesoft Enterprise - Campus Solutions - 9.0 Bundle #20

Product Category Incident ID Reported Problem

Description

Problem Description Resolution Description

Constituent Transaction Mgmnt2008893001 CTM: Search record

for Constituent

Staging component

does not display all

related transactions

for a same Temp ID

When transactions are partitioned by Constituent

and a Temp ID has multiple related transactions, the

search record to access the Constituent Staging

component only displays the latest transaction

performed by the Temp ID. So if the admin user

enters in the search fields the Temp ID and the

name of a transaction, the search record may not

return a valid value even though the transaction is in

fact tied to the Temp ID.

Modified the sql of search records to select the temp id and

transaction code from the Transaction Mapping record

SCC_SL_TRNMAP which stores any transaction that the

constituent has participated in.

Constituent Transaction Mgmnt2012436001 CTM: Addition of

Transaction Status

value called 'Pending'

A new Transaction Status value called 'Pending'

should be added.

Constituent Transaction Mgmnt2025736001 CTM: Some fields

required to be

populated inside the

Entity Registry are not

marked as required

Inside the Entity Registry page (SCC_ENTITY_REG

page), the following fields are required to be

populated for the good functioning of the entity, but

the fields are not marked as required. User can

save w/o populating them.

- Name

- Status

- Element Name

Made the following fields as required in the Entity Registry

record SCC_ENTITY_REG.

- Name SCC_ENTITY_NAME

- Status SCC_STATUS

- Element Name SCC_ELEMENT_NAME

Events 1945562001 Slow performance on

edit of emplid when

adding attendee to an

event

When adding an attendee to an event using page

EVENT_ATTENDEE in component

EVENT_ATTENDEES, an emplid is entered. The

emplid is validated to determine that it is not already

an attendee for this event. When the event has a

large volume of attendees (as much as 10,000 or

more), the validation routine takes so long the

session times out. Even if the session does not time

out the performance is bad.

The validation of emplid is done by populating a scroll with

all the emplids for the considered event number and looped

through. This code at the record field level people code

modified to use a 'SqlExec' to check whether the emplid is

already an attendee.

Campus

Community

Copyright Oracle Corporation 2010. All rights reserved. 73

Peoplesoft Enterprise - Campus Solutions - 9.0 Bundle #20

Product Category Incident ID Reported Problem

Description

Problem Description Resolution Description

External Search/Match 2026849001 SPLIT_SINGLE ID:

External Search

Match gives

unexpected search

results when a Search

is invoked

Users are experiencing this behavior in the Single

Instance configuration with regard to unexpected

behavior with search results for the first search of

Internal HCM search when EMPLIDs have

additional names that do not meet the criteria being

searched for but which are associated with an

EMPLID that does. This search result only occurs

on the first search, if the second search is different

than the first search( Selective search is replaced

with Overall search). If the user merely repeats the

same type of search over again, they will get the

same result.

ESM Core code was not passing a SearchRuleNumber

,modified the following classes to set it and pass it across.

SCC_EXTERNAL_SM:CORE:iNPUTDATA add property

SearchRuleNumber;

SCC_EXTERNAL_SM:OnlineSearchMatchManager

ProcessResults;

SCC_EXTERNAL_SM:CORE:ResultsEngine BuildResults

method.

SCC_EXTERNAL_SM:Results.OnlineResultsBuilder.BuildR

esults method;

External Search/Match 2026859001 SPLIT_Single ID:

Multiple rows for NID

and Marital Status

does not seem to get

imported

While trying to do an Import of a Person with

multiple rows for NID and Marital Status in the HR

database to CS database, the person gets imported

but the multiple rows seem to be missing. Only a

single row comes in along with the import.

Have to set the Default values for Required fields .

FERPA 1945495001 Add and Delete

buttons are not clearly

visible in FERPA

restrictions page

There are a few places on the FERPA restrictions

page where the Add and Delete buttons are not

clearly visible against the white background.

Changed the Background Style of the grid Row Action

Buttons to ‘SSSBUTTON_ACTIONLINK’

Campus

Community

Copyright Oracle Corporation 2010. All rights reserved. 74

Peoplesoft Enterprise - Campus Solutions - 9.0 Bundle #20

Product Category Incident ID Reported Problem

Description

Problem Description Resolution Description

HECH Integration 2030988001 CS-Higher Education

Constituent

Hub(HECH)

Connector

CS-HECH Connector enables higher education

institutions to integrate the person data directly

between CS and UCM (Higher Education

Constituent Hub) systems. This initiative enables

direct integration of constituent and the related/child

data between the HECH and the Campus Solutions

app using Web services whose WSDLs are

compatible and do not require a middleware layer in

between.

Delivered the transformations and peoplesoft integration

objects to enable the integration between CS and

HECH(UCM) through Constituent Web Services(CWS).

Identification Data 1993411001 Deleting Parent

External_System_id

leaves Orphans =

Buffer Error

When deleting the parent row for a student with

multiple entries on External System ID it creates a

"No Matching Buffer" error. For example, adding a

new External System ID for an existing row, and

deleting the parent row (after returning to the page

again), it would not delete all the child record but

only the maximum effective dated row.

Added code to check if any historic rows exist in level2

when the record is deleted at level1, and give an error, so

that no level2 records are left orphans.

Names 2019519001 Adding a person

causes name to

display across 2 lines

After applying Campus Solution 9.0 Bundle #18, the

name appears (LAST NAME is below the FIRST

NAME) on two separate lines when adding a new

person on Campus Community.

SavePostChange peoplecode has been added to the

Add/Update a person components so that the Name

Display Framework is invoked after adding a new person.

Personal Data 1968289001 Inactive Languages

are available on CS

pages and cause

error at save

Inactivating Profile content item does not remove it

from the available CS item list. When attempting to

add an inactive item such as an inactive language to

an emplid's languages page get a misleading error.

Created a new SQL view which is having the active

languages only, and used that view as a prompt table in the

Languages page.

SEVIS 2016636006 SEVIS Release 6.6

Batch System

Changes

This is a request for SEVIS Release 6.6. updates to

the 2010 CIP codes. In addition, The

EVDepTerminationReasonType lookup table in the

SEVIS Table schema will be modified to remove

code 03 for Child over 21.

SEVIS Release 6.6 Batch System Changes: Provided

DataMover script to insert(new and deprecated) CIP codes

for 2010. Changes include modifications to SQRW objects

CCSEVI20.SQC and CCSEVDS.SQC.

Campus

Community

Copyright Oracle Corporation 2010. All rights reserved. 75

Peoplesoft Enterprise - Campus Solutions - 9.0 Bundle #20

Product Category Incident ID Reported Problem

Description

Problem Description Resolution Description

Self-Service: Emergency Cnct1981600001 Unable to edit

emergency contact in

student center for new

entries

When a student needs to enter a emergency

contact for the first time, the edit link will not work

until they click the box to use "same address" as

student, then the edit address link will work. Primary

permission list does have the ORG setup for USA.

The StartAddrEditPage() API is invoked by any page

which is used to capture Address details and it opens up

country specific Sub page which is not working properly in

Emergency contact page since no value was set for

Country field in DERIVED_ADDR record

Modified the code to set the country field in

DERIVED_ADDR record , based on the availability of

values for country fields in the following two pages ( In the

order of preference)

1. Country valued specified in “Org defaults by

Permissions” page for the current logged in user’s Primary

Permission list

2. Country value specified in “Installation Table” page on

SETUP HRMS folder.

Self-Service: Holds/To Do1996986001 Email link in the Your

Holds detail page in

9.0 creates error

message -

SS_CC_HOLD_SEC

When you open up the delivered page

SS_CC_HOLD_SEC. The field

DERIVED_CCSRVC1.LINK_EMAIL is an external

link, but under the External Link section, it is set to

"Static". This radio button should be "Dynamic" for

external links to function correctly. This will not

open up the email client if set to Static.

The External link property has been set to Dynamic, which

resolved the issue

Student Services Center2009634002 Redundant row of

buttons on the

Visa/Permit Data

Page via Student

Service Center

Find redundant rows of action buttons at bottom of

Visa/Permit Data page (SCC_BIO_DEMO_VISA)

when navigating via the Student Services Center.

Buttons in row 1: 1) OK, and 2) Cancel.

Buttons in row 2: 1) OK, 2) Cancel, 3) Apply, and 4)

Refresh.

Used DoModal(), instead of TransferPage(), in

SCC_BIO_DEMO.HR_LBL_WRK.VISA_PERMIT_LBL.Field

Change event to transfer to Visa/Permit Data page.

Campus

Community

Copyright Oracle Corporation 2010. All rights reserved. 76