EPC: Incorrect Syntax Near 'TA1' At Step PC_PRICING.PC_D_S.DELETE (SQL), Incorrect Syntax Near 'SRC' At Step PC_PRICING.MN1200.LOCK (SQL) (Doc ID 2240714.1)

Last updated on MARCH 06, 2017

Applies to:

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

Symptoms

PC_PRICING fails with Incorrect Syntax errors on Microsoft SQL Server.  

Errors

1. Step PC_PRICING.PC_D_S.DELETE (SQL)

DELETE PS_PROJ_RES_TA14 TA1 WHERE TA1.PROCESS_INSTANCE = xxxxxxx AND TA1.PC_DISTRIB_STATUS = 'R'

Incorrect syntax near 'TA1' [SQL Server]Statement(s) could not be prepared.


2. Step PC_PRICING.MN1200.LOCK (SQL)

UPDATE PS_PROJ_RESOURCE SRC SET SRC.PC_DISTRIB_STATUS = 'L', SRC.PROCESS_INSTANCE = xxxxxxx WHERE (SRC.CST_DISTRIB_STATUS = 'N' OR SRC.BI_DISTRIB_STATUS IN ('N', 'U') OR SRC.REV_DISTRIB_STATUS = 'N' ) AND SRC.SYSTEM_SOURCE NOT IN ('PRC', 'PRP', 'PRR') AND 1=1 AND SRC.PC_DISTRIB_STATUS <> 'L'

Incorrect syntax near 'SRC' [SQL Server]Statement(s) could not be prepared.

Steps

1. Navigate to menu: Project Costing > Utilities > Pricing
2. Run PC_PRICING.

                                                          

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