Web Access screen profile lock check box not checked when there is a profile lock

Web Access screen profile lock check box not checked when there is a profile lock

Due to an issue in the Fusion Servicing Director applications, the Web Access screen Profile Lock check box is not able to show the lock or able to unlock the Profile Lock. Your local IT or database administrator can use the procedures below to clear the lock.

This lock occurs when the borrower enters incorrect account identification information three times while creating a new user account. This is called a Profile Lock, because it prevents the creation of the borrower's Profile or new user account going forward, until the lock is removed.

Workaround:

The Web Access screen is found on the Fusion Servicing Director Customer Service application Right-Click menu.

  1. Confirm the borrower account information entered on the new user account web page. The borrower is prompted for the following account information:
    • Loan Number
    • First Name
    • Last Name
    • Tax ID Number
    • Property ZIP Code
  2. Compare the borrower entered account information to the information in the Fusion Servicing Director Customer Service application.
  3. Find the difference between what the borrower is entering and what is shown in the Customer Service application.
    Note: The account information must match exactly, such as the first name Robert will not be matched to the name Bob.
  4. Request your system administrator or IT staff to edit the SQL command query below, replacing the placeholders (a) and (b) in the command (leaving the single quotes in place):
    • <EmployeeUserName> = The Servicing Director employee username requesting the removal of the lock.
    • <Loan Number> = The 10-digit Loan Number of the borrower.
    • UPDATE Service.dbo.BorrowerWebProfileUser SET ProfileLock = 0, ResetBy = '<EmployeeUserName>' WHERE SSN  IN (Select TaxIDNumber from Borrower where LoanID = '<Loan Numer>')
  5. Enter the edited SQL command query on a SQL Server Management Studio New Query screen connected to the Service database on the Fusion Servicing Director server.
  6. Click the SQL Server Management Studio Execute button (or press the F5 key) to execute the edited SQL command query.
    Note: When the execution is done, the bottom of the New Query screen will indicate Command(s) completed successfully.
  7. Exit SQL Server Management Studio, and when prompted to save any changes, select No.
  8. Tell the borrower which part of the account information they need to change to correctly match the account information and have them try again.
Submit a case through Case Management to increment Request for Change 00300144.

ArticleNumber:

000070870