Error in Journal Generator processing from TR
Hi users,
We are using as aplication version 9.2, when we are trying to process the jounal generator, we have this following error.
File: e:\pt85308b-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1623 Error Position: 0 Return: 8610 - [Microsoft][SQL Server Native Client 10.0][SQL Server]The column name 'JOURNAL_DAT E' is specified more than once in the SET clause. A column cannot be assigned more than one value in the same SET clause. Modify the SET clause to make sure that a column i Failed SQL stmt: UPDATE PS_TRA_ACCTG_LINE SET JOURNAL_ID = :1, JOURNAL_DATE = :2, FISCAL_YEAR = , ACCOUNTING_PERIOD = :4, GL_DISTRIB_STATUS = 'D', JOURNAL_LINE = :5,JOURNAL_DATE=GETDATE() WHERE PROC ESS_INSTANCE = 15290 AND GL_DISTRIB_STATUS = 'J' AND (FOREIGN_AMOUNT > 0 OR (FOREIGN_AMOUNT =0 AND MONETARY_AMOUNT >= 0 )) AND ACCOUNT=:6 AND DEPTID=:7 AND OPERATING_UNIT=:8 AND FOREIGN_CURRENCY=:9 A ND CURRENCY_CD=:10 AND LEDGER=:11