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.
The create view failed with the following 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.
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms