R12 Java.sql.SQLException Error While Opening Spread Curves Setup Page

(Doc ID 1664421.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Project Planning and Control - Version 12.1.3 to 12.2.3 [Release 12.1 to 12.2]
Information in this document applies to any platform.


Encountered a java.sql.SQLException error while opening spread curves setup page in Project Management module:

Setup > Spread curves.

Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT spread_curve_id,
name name,
description description,
effective_start_date effective_from, effective_end_date effective_to ,
decode( pa_fp_spread_curves_utils.is_spread_curve_in_use( spread_curve_id), 'Y','DisableDelete', 'EnableDelete') Delete_SW, record_version_number
FROM pa_spread_curves_vl
WHERE name != 'Fiscal Calendar'

## Detail 0 ##
java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error


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