...

update eps_proposal set status_code='6' where proposal_number='1234';

Fix Fiscal Year on PD Unrecovered F&A

...

Institutional Proposal (IP)

...

Update IP Status

select * from proposal_status;

...

update proposal set status_code='5' where proposal_sequence_status='ACTIVE' and proposal_number='00173838';

Award

...

Fix Award Stuck in 'Pending' State (Edit button doesn't appear)

...

update award set award_sequence_status='ACTIVE' where award_sequence_status='PENDING' and award_id='111111';

...

Maintenance Tables

...

...

Add New State to State Table

...

insert into ps_grant_prefix values ('ABC', sysdate, 'admin', 1, sys_guid());

Grant Admin permissions to a user (full access)

exec give_user_admin_permissions('efitzp01'); -- Replace with user's UTLN