...
| Code Block |
|---|
| language | sql |
|---|
| theme | Eclipse |
|---|
| title | 2. Remove value for GG Tracking ID from selected proposal |
|---|
|
update s2s_app_submission set GG_TRACKING_ID=null where proposal_number='1234'; |
Update Opportunity Title
Request: The opportunity title on an application contains an unsupported character, resulting in an error which states "Must be an alphanumeric character or punctuation".
| Code Block |
|---|
| language | sql |
|---|
| theme | Eclipse |
|---|
| title | 1. Update the proposal AND s2s tables with the new title, replacing the invalid character with the correct one |
|---|
|
update eps_proposal set program_announcement_title='DoD Peer Reviewed Alzheimer''s, Research Partnership Award' where proposal_number='5997';
update s2s_opportunity set opportunity_title='DoD Peer Reviewed Alzheimer''s, Research Partnership Award' where proposal_number='5997'; |
Fix Missing/Invalid Fiscal Year on PD Unrecovered F&A
...