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