Issue/Symptom/Question

When one of our users attempted to perform the Final Close for June for BS XX, he received the error message "An error has been detected in a SQL statement..." Please review to determine why the error occurred. 

An error has been detected in a SQL Statement.

ACP003 -1 ORA-00001: unique constraint (PENTA.ACCT_BAL_PK) violated

insert_acct_bal()

Applies To

PENTA for Windows

Accounting Period Close

Resolution/Fix/Answer

If you experience this problem please submit a Service Desk ticket and reference this article.  Please provide the following information in your Service Desk ticket:

• Screenshot of the error
• User ID of user experiencing the error
• Balance Sheet OU ID 
• Period number and date that is being closed