How to resolve FRM-40735 or ORA-1403 errors within the Service module?

 This error can occur in many areas of Service Requests, Contact Center and Tasks when performing various operations such as:

Service Request Form (CSXSRISR) 
Opening Task Form 
Opening Charges Form 
Search Instance Flashlight Usage 
Attempting to Use Find SR Form or Ctrl-F11 in CSXSRISR 
Trying to Submit Service Request 
Attempting to Submit Charges 

Contact Center Form (CSCCCCRC) 
Save a Customer in Contact Center 
Click SR Tab in Contact Center 
Dashboard Drilldown 
Orders Tab 

The error can occur in many other operations as well. The above is not meant to be an full listing, but merely examples of where this can occur.  As well, the below listing of errors is meant to be a sample list.  If you are receiving this error how do you resolve?