Skip Navigation
Expand
Staff Account optlist limits
Answer ID 12907   |   Last Review Date 09/30/2024

Is there a limit to how many staff accounts I can create?

Environment: 

Staff Accounts
Oracle B2C Service

Resolution: 

The Staff Account editor does not enforce a hard limit on the number of accounts you can create.  However, accounts do use optlists to facilitate the real-time communication of changes. In particular, an optlist is used to define the staff hierarchy used in assignment fields.  An optlist only supports a threshold of 40,000 records and as such there is a "soft limit" associated with the number of accounts you can add.

When more than 40,000 records are added to an individual optlist an error will be displayed in the Info log for the site.  The info log can be accessed in the Navigation area under Configuration -> Site Configuration -> Logs.  If you have exceeded this number, an error will be added to this log whenever you edit an account.  The error will be similar to:

File: optlist/optl_util.c
Line: 490
In Fcn: optl_error
Description:
Optlist Error
Optlist ID: 180
Description: Optlist item count (XXXXX) exceeds the maximum threshold of 40000.

 

  • XXXXX shows the number of records the site currently has.
  • Optlist ID 2 relates OPTL_ACCOUNTS_HIER
  • Oplist ID 3 relates OPTL_ACCOUNTS_ASSIGN
  • Optlist ID 4 relates OPTL_ACCOUNTS_VIEWS
  • Oplist ID 5 relates OPTL_ACCOUNTS_NOT_DISABLED
  • Optlist ID 143 relates OPTL_ACCOUNTS_LOGGED_IN
  • Oplist ID 171 relates OPTL_ACCOUNTS_ASSIGN_TASKS
  • Optlist ID 180 relates OPTL_ACCOUNTS_WITH_DISABLED

The reason this is referred to as a soft limit is, even when this threshold has been exceeded the product can function properly.  If you exceed this limit functionality impairment can occur and the probability of functionality impairment increases as more records are added above this threshold.

The difficulty in communicating a hard limit is because the actual configuration of your guides and the site significantly impacts what functionality will and won't work. Best Practice is that you do not exceed the soft limit of 40,000 in order to ensure the product performs efficiently and without error. If you experience functionality impairment associated with exceeding this limit you will be required to remove records to resolve the problem. 

Notify Me
The page will refresh upon submission. Any pending input will be lost.