Identifing the error messages on ROAIMMP when you have a memo problem

Problem Description : 

 Resolution : 

Hello Larry,

Please run immediate process disbursement from ROAIMMP and review (and attach) the resulting log file. If it says "ERROR DELETING MEMO", it is the same issue as before, but the fix may be different depending on the student's data.

If the error message is "ERROR DELETING MEMO", please run the follow sql selects and attach the resulting output:

1. To select from RPRATRM:

spool rpratrm

set null ~

set lin 1000

select spriden_id, rpratrm_pidm, rpratrm_term_code,rpratrm_fund_code,rpratrm_memo_amt, rpratrm_memo_date from spriden, rpratrm where spriden_change_ind is null and spriden_pidm = rpratrm_pidm and rpratrm_aidy_code = '&ampaid_year'

and rpratrm_pidm = &amppidm

order by rpratrm_fund_code, rpratrm_term_code; spool off

2. To select from RPRAWRD:

spool rprawrd

set null ~

set lin 1000

select spriden_id, rprawrd_pidm, rprawrd_aidy_code, rprawrd_fund_code, rprawrd_memo_amt, rprawrd_memo_date from spriden, rprawrd where spriden_change_ind is null and spriden_pidm = rprawrd_pidm and rprawrd_aidy_code = '&ampaid_year'

and rprawrd_pidm = &amppidm

order by rprawrd_fund_code;

spool off

3. Select all memos for the student from TBRMEMO:

spool tbrmemo

set null ~

select * from tbrmemo

where tbrmemo_pidm = &amppidm;

spool off

If rpedisb_number.log contains a different error, please run the following scripts, instead:

1. Data from TBRMEMO

spool tbrmemo

set null ~

set line 1000

select * from tbrmemo

where tbrmemo_term_code = '&ampterm'

and tbrmemo_pidm = &amppidm;

spool off

2. Data from RPRATRM:

spool rpratrm

set null ~

set lin 1000

select * from rpratrm

where rpratrm_aidy_code = '&ampaidy'

and rprawrd_pidm = &amppidm

order by rpratrm_fund_code,rpratrm_term_code;

spool off

3. Data from RPRAWRD:

spool rprawrd

set null ~

set lin 1000

select * from rprawrd

where rprawrd_aidy_code = '&ampaidy'

and rprawrd_pidm = &amppidm

order by rprawrd_fund_code;

spool off

If you have any questions, please let me know. I can be reached tomorrow between 5 am and 4 pm EST at (6100 278-6301 or via an update to the service request. If you prefer to respond via email, please reply with history so that the summary field which contains the thread id is included in your response. 

Summary: Please call me at (770) 358-5239 [THREAD ID: 1-3G1AYF]

Regards,

Sharon

Sharon Weinberg

ActionLine, Banner Financial Aid Support Analyst Toll Free 800-223-7036 ext. 5787309 * Tel 610-578-7309 * Home Office 610-278-6301 * Fax 610-578-3309 

CONFIDENTIALITY: This email (including any attachments) may contain confidential, proprietary and privileged information, and unauthorized disclosure or use is prohibited. If you received this email in error, please notify the sender and delete this email from your system. Thank you.

 Revision Date : 3/6/2008