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;

    Attached is a log file showing how to log into SQLPlus to run this procedure and the expected result.