PS_PC_FLEX_VW Has Incorrect LENGTH Function In SQL (for SQL Server) - When Running script cp_delvw_crtvw.sql via Change Assistant. (Doc ID 2181878.1)

Last updated on SEPTEMBER 19, 2016

Applies to:

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

Symptoms

On :  9.2 version, Other

PS_PC_FLEX_VW has incorrect LENGTH function in SQL (for SQL Server)  

Upgrading to Financials 9.2 PUM #20 from PUM #9. During the "Create Views" step of Change Assistant, the "cp_delvw_crtvw.sql" script failed on the PS_PC_FLEX_VW view:


For now, I've modified the SQL to correct the invalid function so the script could run successfully. We don't use the Project Costing module, by the way.

ERROR
-----------------------
Msg 195, Level 15, State 10, Procedure PS_PC_FLEX_VW, Line 26838
'LENGTH' is not a recognized built-in function name.

The SQL for this view has an invalid function LENGTH. For SQL Server, this should be LEN.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. As part of 9.2 PUM #20 upgrade, running cp_delvw_crtvw.sql throws the above error for PS_PC_FLEX_VW in SQL server environment


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