It looks like the CUST_ACC_SITE_ID and ORIG_SYS_REFERENCE table out of Sync for the customers

We are getting the following error when the business tries to save a new customer account in Oracle.

Value for orig_system_reference must be unique.

Question 1: What causes this?

Question 2: How do we to go about to fix it?

I did find the following on Oracle support:

Error 'Value for orig_system_reference must be unique' When Creating a New Customer in Customer Form (Doc ID 3036599.1

To implement the solution, please execute the following steps: 1)  Run the following SQL to determine the highest existing value in the fields that use the database sequence:SELECT max(CUST_ACCT_SITE_ID)