Integrity Constraint Error Viewing Work Order Invoices

Issue/Symptom/Question

User receives error when trying to view invoices in the Work Order/Maintenance Contract Billing window.

Integrity constraint violated (orig_cus_place_guid) ORA-06512: at "PENTA.

Applies To

PENTA for Windows > Service Management > Invoicing > Work Order / Maintenance Contract Billing

Resolution/Fix/Answer

The error occurs when an invoice is created and the customer ID is changed. The resolution is to cancel the invoice and re-create the invoice. 

If this does not resolve your error, please submit a Service Desk ticket and reference this article.  Please provide the following information in your Service Desk ticket:

  • User ID of the user receiving the error
  • Screenshot of the error