EGL9.2: FS_JGEN - Failed With Invalid User.table.column, Table.column, Or Column Specification (Doc ID 2206873.1)

Last updated on DECEMBER 09, 2016

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

On :  9.2 version, Journal Generator

When running Journal Generator to generate a journal from Payroll to Geneeral Ledger, FS_JGEN - Failed with invalid user.table.column, table.column, or column specification  


ERROR
-----------------------
(FS_JGEN_JRNL.JLine.GetLines) (Do Select)

File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1703  Error Position: 558  Return: 1747 - ORA-01747: invalid user.table.column, table.column, or column specification
Failed SQL stmt: SELECT NULL, 0, 0, 'PY00071354', '2016-11-18', 0, A.ACCOUNT, ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', SUM(A.MONETARY_AMOUNT), SUM(A.FOREIGN_AMOUNT), A.FOREIGN_CURRENCY, ' ', 0, 0, SUM(A.STATISTIC_AMOUNT), ' ', 'Payroll', ' ', TO_CHAR(A.ACCOUNTING_DT,'YYYY-MM-DD'), A.CURRENCY_CD, 'ACTUAL', ' ', 0 FROM PS_HR_ACCTG_LINE A   WHERE A.PROCESS_INSTANCE = 1556281 AND A.GL_DISTRIB_STATUS = 'J'  AND EXISTS (SELECT 'X' FROM PS_JGEN_TR30SEL4 D WHERE D.PROCESS_INSTANCE=1556281 AND D.CHARTFIELD=' ' AND A. =D.RANGE_FROM_30)  GROUP BY A.ACCOUNT, A.FOREIGN_CURRENCY, A.ACCOUNTING_DT, A.CURRENCY_CD


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run Journal Generator FS_JGEN for Payroll Definition


Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms