Getting Unique Constraint error on generate journal process
We have moved some entries from AM to GL. Then we made some adjustment in the asset and run depreciation and close depreciation process with following check selected:
Rerun depreciation close
Reverse Posted Entries
It generate the reversal entries and some new entries. but when run generate journal process then getting following error:
File: e:\pt85304c-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1623 Error Position: 0 Return: 805 - ORA-00001: unique constraint (FINADM.PS_DIST_LN) violated Failed SQL stmt: UPDATE PS_DIST_LN_JG_VW SET JOURNAL_ID = :1, JOURNAL_DATE = TO_DATE(:2,'YYYY-MM-DD' ), FISCAL_YEAR = :3, ACCOUNTING_PERIOD = :4, GL_DISTRIB_STATUS = 'D', JOURNAL_LINE = :5,DTTM_STAMP=C AST(SYSTIMESTAMP AS TIMESTAMP) WHERE PROCESS_INSTANCE = 84903 AND GL_DISTRIB_STATUS = 'J' AND PROJE CT_ID=:6 AND ACCOUNT=:7 AND ALTACCT=:8 AND DEPTID=:9 AND OPERATING_UNIT=:10 AND PRODUCT=:11 AND PROG RAM_CODE=:12 AND AFFILIATE=:13 AND CHARTFIELD1=:14 AND CURRENCY_CD=:15 AND FOREIGN_CURRENCY=:16