Financial Management - PSFT (MOSC)

MOSC Banner

Error in Journal Generator processing from TR

edited May 2, 2014 10:41AM in Financial Management - PSFT (MOSC) 4 commentsAnswered ✓

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center