Application not listed in Submitted/Unsubmitted list OAS

Issue/Description:

Customer submitted an application in OAS but is unable to see the application in the Submitted or Unsubmitted lists. Also unable to locate the application in the application lookup in the Admin section of OAS.

Troubleshooting Steps (Include necessary screenshots):

1. Log into OAS and verify that the application is not showing
2. Go to Admin > Application look up – Is the application showing when searching the look up?
3. Query OAS database – Appintakeforminstances table for the application
4. Verify the statusid – If the statusID matches error state (List of codes at the bottom of the article) it will not display in the lists in OAS. This is most common with the statusid = 4.

Resolution:

1. Update the appintakeforminstances statusid to 1 in the Appintakeforminstances table

update AppIntakeFormInstances

set AppIntakeFormInstanceStatusID = 1

where AppIntakeFormInstanceID =

2. Log into OAS and verify that you can search for the application (If it does not show in the list, check application lookup)
3. Have the user verify that the application is available for them
4. Have the user verify the data in the form and attempt to resubmit

Additional Information:

Below are the statusids and their meanings. Anything in a status 9 (complete) cannot be resent and can cause duplicate data in permitting systems.

InProcess = 1 - Application is in process or has just been submitted - default status

SubmitStart = 2 - Application submitted to permit system - not success or error

SubmitSuccess = 3 - Application success on submit to permit system

SubmitError = 4 - Application error on submit to permit system

PaymentSuccess = 5 - Application payment made needs to be sent to permit system

PaymentError = 6 - Application payment attempted but error returned from processor

ProjectCreatorSuccess = 7 - Application successfully sent to project creator queue

ProjectCreatorError = 8 - Application successfully sent to project creator queue

Complete = 9 - Application paid, submitted, completed, sent to project creator

SupplementalApplicationSubmitError = 10 - The supplemental application errored on submit

GeneralSubmitError = 11 - Application errored on submission process (not in a specific tracked area)

LetterProcessError = 12 - Application errored on trying to process letters

ProjectCreatorStart = 13 - Application is preparing to be sent to project creator queue

SupplementalApplicationSubmitStart = 14 - The supplemental application is preparing to be sent to project creator queue

SupplementalApplicationSubmitSuccess = 15 - The supplemental application submited successfully

LetterProcessStart = 16 - Application is preparing letters to process

Additional resource links (example: Microsoft Troubleshooting URLs)

If a new folder is added to a project, permissions to the folder need to be updated. To update permissions to a folder for groups in a project, follow these instructions:

1. In the project, click Info, Groups

2. Select the Group and Select the Permissions button

3. Select the desired Preset label

4. Apply the preset to folder that needs to be changed or updated

5. Click Save