Is there a database verify job (like UCC7DBVR) in r12 and 12.1?
There is a new DBVR for r12 and r12.1 is called the CAL2DBVR Utility. This is documented in the Programming Section. AND, the good news is it was designed to not only report, but to optionally fix the problems it finds.