PENTA.F703_DETAIL_PK violated error

Issue/Symptom/Question

Error when trying to complete Prepare Invoices for Printing step.

An error has been detected in a SQL Statement. 

INR034 -1 ORA-00001:unique constraint (PENTA.F703_DETAIL_PK) violated

fill_li - insert into f703_detail table

Applies To

Penta for Windows

Billing & Accounts Receivable > Automated Invoice Processing > Prepare Invoices for Printing

Resolution/Fix/Answer

Invoice on parent job X had X number of line item jobs, itself and these a few others. All X jobs had line item X, but for 1 job its line item type was "I" and for all the other jobs the line item type was "H". Also for job X, the distribution type for line X was Lump Sum, but for the same line on the other jobs, it was Cost Plus. Updating the line items so they match resolved the error.

If you experience this problem and are unable to determine the root cause of the error, please submit a Service Desk ticket and reference this article.  Please provide the following information in your Service Desk ticket:

  • Job ID
  • Invoice Cycle Number
  • User Id
  • Screenshot of error message