See the attached documents and Rank and Distribution Data Consistency help topic.

As of 5.8.4, all Biotics instances include the DDF_UPDATE_SUBNATIONAL & DDF_UPDATE_NATIONAL procedures which will update the values for all records where DDF is null or does not match the calculated value. To use the procedure to update the values:

1. Log into SQL Developer, Tora, Toad or SQLPlus as the biotics_dlink user.
2. Run the following SQL statements:
   set serverout on size UNLIMITED;
   exec ddf_update_subnational;
   commit;
   
   Attached is a log file showing how to log into SQLPlus to run this procedure and the expected result.