AnsweredAssumed Answered


Question asked by tibin on Jan 16, 2013
Latest reply on Mar 13, 2013 by navzjoshi00
I am getting error when linking a benefit plan to a cost plan.


1. Open the cost plan..
2. Link a benefit plan.
3. Clicking on save button displays the "Error 500: Internal server error"

Please find the attached screen shots.

Please not that this happens for a specific cost plan not for others.

The linked benefit plans start date is 2012 and end date is 2027, Total Benefit is $4527500, Current operations is $44500500 and Proposed operations is $29330200.
There are 12 benefit plan records.

When I change the end date to 2024 or delete some of the benefit plan records(8 out of 12), then it works.

Requesting your help in resolving this ASAP.

Here is the SQL Trace / Error Log:

NDE:PSTM@1a271dd: FAIL: [CA Clarity][Oracle JDBC Driver][Oracle] ORA-01461: can bind a LONG value only for insert into a LONG column.

Please find the Full Trace attached