EAR9.2: Build View PS_DFW_AR_ERROR_CD Fails With SQL2021N In DB2 in Image 13 (Doc ID 2056194.1)

Last updated on SEPTEMBER 22, 2015

Applies to:

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

Symptoms

The create view failed with the following error:

Error:
-------
DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned:SQL20211N The specification ORDER BY or FETCH FIRST n ROWS ONLY is invalid.
SQLSTATE=428FJ

Script:
--------
CREATE VIEW FSDEMO.PS_DFW_AR_ERROR_CD (AR_MSG_NUM, AR_ERROR_CD, MESSAGE_TEXT) AS SELECT DISTINCT E.AR_MSG_NUM , E.AR_ERROR_CD , M.MESSAGE_TEXT FROM PS_AR_ERROR_TBL E , PSMSGCATDEFN M WHERE E.AR_MSG_NUM=M.MESSAGE_NBR AND M.MESSAGE_SET_NBR=6035 ORDER BY E.AR_MSG_NUM

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