Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
languagesql
themeEclipse
title2. Insert a new grant prefix
insert into ps_grant_prefix values ('ABC', sysdate, 'admin', 1, sys_guid());


Error in Fund Source / Grants Integration - Change the status from Error so that the row processes again.

Request: User error occurred for some reason in the fund/grant and the user wants the proposal to be "reset" so that PeopleSoft processes it again.

Example Ticket: INC0917104

Code Block
languagesql
themeEclipse
title1. Reset PS return status on TUPS_GRANT
update KCSO.TUPS_GRANT set PS_RETURN_STATUS = ' '  where award_number='103786-00001' and ps_ras_transaction_id = '000000037066' and PS_RETURN_STATUS = 'E';

Add/Update PeopleSoft Accountant Code assignments

...