9.1 Brazilian Localization: Error When Applying Local BRA - SCM 9.1 Bundle #21

(Doc ID 2244273.1)

Last updated on MARCH 15, 2017

Applies to:

PeopleSoft Enterprise SCM Purchasing - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

Error when applying Local BRA - SCM 9.1 Bundle #21

During bundle application : LOCAL BRA - SCM 9.1 BUNDLE #21 it shows the error message:
 
ERROR
" 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. "


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