Problem:

The working list record count displayed in Biotics5 comes from the field working_list.working_list_record_count, but that field is only updated when the working list is saved in the Biotics5 interface. The count will get out of sync if records are deleted or updates are made to working lists via SQL.

 

Solution:

To update the working list record counts, install the attached procedure by running it while logged in as the biotics_dlink user and then run this statement in SQL Plus or TOAD:

 

execute WL_UPDATE_COUNTS