/
TDD Failed Cannot insert duplicate key in object dbo.tmpTPPAdj

TDD Failed Cannot insert duplicate key in object dbo.tmpTPPAdj

Owned by Knowledge Assistant
yesterday at 1:58 pm
Description of Issue

Tyler Deploy failing to upgrade due to a duplicate Payment Plan data condition.

  • Log shows Violation of PRIMARY KEY Constraint 'PK_tmpTPPAdj'. Cannot insert duplicate key in object 'dbo.#tmpTPPAdj'. The duplicate key value is (Bill Id)

Context

  • Tyler Deploy

  • TDD

  • Accounts Receivable

  • Payment Plans

Cause

Two non-voided Status payment plans contain the same linked bill to both. 

Issue only occurs when using Transfer bill GL balances to payment plan GL balances in Payment Plan Settings and the original bill is missing a TPP Activity Type Adjustment. This adjustment is what reduces the original individual bill to zero when the balance is initially transferred to a category 45 payment plan bill. 

Resolution

The oldest payment plan must be updated with a Void Status. Contact Enterprise ERP Revenue Support for further assistance.

Additional Information