...
An admin can change the OPI Region in System tables Napa TC Projects (TA_PROJ) table.
...
If the project is a MOD and not approved (has no approval number) you will need to contact DSD Support.
(NOTE: Since the topic is about projects without approval none of these transfer procedures can be used)
Transfer of a MOD Project (project numbers start with a letter (O-21-0076) with an approval/certificate number regularly uses either procedure
NAPA_NACIS.SP_UPDATE_MOD_REGION (Used for projects with Canadian certificate numbers)
or NAPA_NACIS.SP_UPDATE_FOREIGN_MOD_REGION (Used for Projects with a foreign certificate number)
(NOTE: BUT since the topic is about projects without approval neither MOD procedure can be used)
And the developer needs to update the region on these tables based on Mod_ID_num, Mod_rvsn_dt found in the MOD_Proj record.
UPDATE mod_proj SET rgn_cd
UPDATE mod_aprv SET rgn_cd
UPDATE mfr_pub_supp SET rgn_cd
UPDATE mod_aprv_cert SET rgn_cd
UPDATE mod_aprv_cert_doc SET rgn_cd
UPDATE mod_aprv_mdl SET rgn_cd
UPDATE mod_aprv_ac SET rgn_cd
UPDATE mod_inst SET rgn_cd
UPDATE mod_aprv_rvs SET rgn_cd