EGL: Brazilian Localization - Error During Bundle Application Local BRA - FMS 9.1 Bundle #21 (Doc ID 2255469.1)

Last updated on MAY 05, 2017

Applies to:

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

Symptoms

During bundle application - Local BRA - FMS 9.1 Bundle #21 below error occurs:

Message Reason: File: Data MoverSQL error. Stmt #: 0 Error Position: 0 Return: 8601 - [Microsoft][SQL Server Native Client 11.0][SQL Server]The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, unless TOP, OFFSET or FOR XML is also specified.
[Microsoft][SQL Server Native Clie
Failed SQL stmt: CREATE VIEW PS_SPF_FILE_VW_BRL (COMPANY, SPF_GROUP_BRL, SPF_RUNCNTRL_BRL, SPF_FILEID_BRL, SPF_SEQ_FILE_BRL, SPF_SEQ_BATCH_BRL , SPF_DTTM_BRL, VALUE2, DESCR (200,0)
SQL Error. Error Position: 0 Return: 8601 - [Microsoft][SQL Server Native Client 11.0][SQL Server]The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, unless TOP, OFFSET or FOR XML is also specified.

[Microsoft][SQL Server Native Clie
CREATE VIEW PS_SPF_FILE_VW_BRL (COMPANY, SPF_GROUP_BRL, SPF_RUNCNTRL_BRL, SPF_FILEID_BRL, SPF_SEQ_FILE_BRL, SPF_SEQ_BATCH_BRL , SPF_DTTM_BRL, VALUE2, DESCR2, DATE_FROM, DATE_TO, SPF_VERSION_BRL) AS SELECT A.COMPANY ,F.SPF_GROUP_BRL ,B.SPF_RUNCNTRL_BRL ,B.SPF_FILEID_BRL ,B.SPF_SEQ_FILE_BRL ,W.SPF_SEQ_BATCH_BRL ,W.SPF_DTTM_BRL ,B.SPF_INFO_STAT_BRL ,X4.DESCR ,A.DATE_FROM ,A.DATE_TO ,A.SPF_VERSION_BRL FROM PS_SPF_RUNCNT_BRL A , PS_SPF_INFO_FL_BRL B , PS_SPF_FILE2_BRL F , PS_SPF_ST_DESCR_VW X4 , PS_SPF_SEQFILE_BRL S , PS_SPF_INFO_WS_BRL W WHERE A.SPF_RUNCNTRL_BRL = B.SPF_RUNCNTRL_BRL AND X4.SPF_INFO_STAT_BRL = B.SPF_INFO_STAT_BRL AND B.SPF_INFO_STAT_BRL IN ('F', 'S', 'I', 'C', 'E', 'G', 'L', 'X') AND S.SPF_FILEID_BRL = B.SPF_FILEID_BRL AND S.SPF_RUNCNTRL_BRL = B.SPF_RUNCNTRL_BRL AND S.SPF_SEQ_FILE_BRL = B.SPF_SEQ_FILE_BRL AND F.SPF_FILEID_BRL = B.SPF_FILEID_BRL AND W.SPF_FILEID_BRL = S.SPF_FILEID_BRL AND W.SPF_RUNCNTRL_BRL = S.SPF_RUNCNTRL_BRL AND W.SPF_SEQ_FILE_BRL = S.SPF_SEQ_FILE_BRL ORDER BY W.SPF_DTTM_BRL, B.SPF_RUNCNTRL_BR...

Error: SQL execute error for CREATE VIEW PS_SPF_FILE_VW_BRL (COMPANY, SPF_GROUP_BRL, SPF_RUNCNTRL_BRL, SPF_FILEID_BRL, SPF_SEQ_FILE_BRL, SPF_SEQ_BATCH_BRL , SPF_DTTM_BRL, VALUE2, DESCR2, DATE_FROM, DATE_TO, SPF_VERSION_BRL) AS SELECT A.COMPANY ,F.SPF_GROUP_BRL ,B.SPF_RUNCNTRL_BRL ,B.SPF_FILEID_BRL ,B.SPF_SEQ_FILE_BRL ,W.SPF_SEQ_BATCH_BRL ,W.SPF_DTTM_BRL ,B.SPF_INFO_STAT_BRL ,X4.DESCR ,A.DATE_FROM ,A.DATE_TO ,A.SPF_VERSION_BRL FROM PS_SPF_RUNCNT_BRL A , PS_SPF_INFO_FL_BRL B , PS_SPF_FILE2_BRL F , PS_SPF_ST_DESCR_VW X4 , PS_SPF_SEQFILE_BRL S , PS_SPF_INFO_WS_BRL W WHERE A.SPF_RUNCNTRL_BRL = B.SPF_RUNCNTRL_BRL AND X4.SPF_INFO_STAT_BRL = B.SPF_INFO_STAT_BRL AND B.SPF_INFO_STAT_BRL IN ('F', 'S', 'I', 'C', 'E', 'G', 'L', 'X') AND S.SPF_FILEID_BRL = B.SPF_FILEID_BRL AND S.SPF_RUNCNTRL_BRL = B.SPF_RUNCNTRL_BRL AND S.SPF_SEQ_FILE_BRL = B.SPF_SEQ_FILE_BRL AND F.SPF_FILEID_BRL = B.SPF_FILEID_BRL AND W.SPF_FILEID_BRL = S.SPF_FILEID_BRL AND W.SPF_RUNCNTRL_BRL = S.SPF_RUNCNTRL_BRL AND W.SPF_SEQ_FILE_BRL = S.SPF_SEQ_FILE_BRL ORDER BY W.SPF...

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