8 Replies Latest reply on Mar 31, 2013 8:41 PM by Bill Robinson

    Easy way to update REFERENCE NUMBER in Exceptions

      We are trying to re-vamp our exception process and one method requires an easy way to update the REFERENCE NUMBER on existing eceptions on a given component template.


      What about a quick SQL command to update specific values in the Oracle dbase? (just playing jazz here...)


      The current and new REFERENCE NUMBER will be unique, so that should rule out confusion or anything like that.

      If such a process/step exists, it also cannot change any of the other data (duration, notes....)


      I am currently running BBSA v8.2.3 on a RedHat server, using Oracle databases.