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.
PC_PRICING fails with Incorrect Syntax errors on Microsoft SQL Server.
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.
1. Navigate to menu: Project Costing > Utilities > Pricing
2. Run PC_PRICING.
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