ECA: Received Fatal Peoplecode Error When Attaching Rate Set To The Contract - SQL Error in Compile. (2,277) CA_DETAIL_PROJ.CONTRACT_NUM.SavePostChange PCPC:863 Statement:9 (Doc ID 2280572.1)

Last updated on JULY 10, 2017

Applies to:

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

Symptoms

On : 9.2 version, Contract Entry

Attach a new project/activity to a contract line that has more than 1000 lines already attached.

ERROR
-----------------------

Message 1:
A fatal PeopleCode SQL error occurred. Please consult your system log for details.

Message 2:
SQL Error in Compile. (2,277) CA_DETAIL_PROJ.CONTRACT_NUM.SavePostChange PCPC:863 Statement:9

During the execution of SQL, an error occurred in the Compile phase of SQL execution. The preceding message should have identified the details of the SQL being executed.

In Logs.
PSAPPSRV.22405 (999) 1-112069 16.22.55 0.003731 SQL error. Function: SQLExec
  Error Position: 0
  Return: 0 - ORA-01795: maximum number of expressions in a list is 1000
  Statement:
  Original Statement: DELETE FROM PS_GM_AWD_FUND_PD WHERE CONTRACT_NUM = :1 AND PROJECT_ID NOT IN ('0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109774','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0000109775','0
PSAPPSRV.22405 (999) 1-112070 16.22.55 0.000276 ErrorReturn-> 277 - SQL Error in Compile. (2,277) CA_DETAIL_PROJ.CONTRACT_NUM.SavePostChange PCPC:863 Statement:9


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Navigate to Customer Contracts > Create and Amend

1) create a rate based contract and save
2) go to line tab and click "contract terms" to navigate to related project
3) attach project/activities to the contract (note attach more than 1000 lines to this component) and save to get the error

A fatal PeopleCode SQL error occurred. Please consult your system log for details.

SQL Error in Compile. (2,277) CA_DETAIL_PROJ.CONTRACT_NUM.SavePostChange PCPC:863 Statement:9

During the execution of SQL, an error occurred in the Compile phase of SQL execution. The preceding message should have identified the details of the SQL being executed.


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