ORA-01858 Error When Baselining Financial Plan Working Version

(Doc ID 352678.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Project Management - Version 11.5.9 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.
Checked for relevance on 05-Feb-2013
Checked for relevance on 20-Oct-2014

Symptoms

When attempting to Baseline Budget (Either Cost budget and Revenue budget) gives errors.

The following error occurs:

ERROR
1. ORA-01858: a non-numeric character was found where a numeric was expected in
Package PJI_PJP_FP_CURR_WRAP Procedure get_ent_dates_info
2. ORA-01858: a non-numeric character was found where a numeric was expected in
Package PJI_FM_PLAN_MAINT_T_PVT Procedure PRORATE
3. ORA-01858: a non-numeric character was found where a numeric was expected in
Package PJI_FM_PLAN_MAINT_T_PVT Procedure PRORATE_TO_OTHER_CALENDAR
4. ORA-01858: a non-numeric character was found where a numeric was expected in
Package PJI_FM_PLAN_MAINT_T_PVT Procedure PRORATE_TO_ALL_CALENDARS
5. ORA-01858: a non-numeric character was found where a numeric was expected in
Package PJI_FM_PLAN_MAINT Procedure SEC_SLICE_CREATE_T
6. ORA-01858: a non-numeric character was found where a numeric was expected in
Package PJI_FM_PLAN_MAINT Procedure CREATE_SECONDARY_T_PVT
7. ORA-01858: a non-numeric character was found where a numeric was expected in
Package PJI_FM_XBS_ACCUM_MAINT Procedure PLAN_BASELINE_PVT
8. ORA-01858: a non-numeric character was found where a numeric was expected in
Package PJI_FM_XBS_ACCUM_MAINT Procedure PLAN_BASELINE
9. ORA-01858: a non-numeric character was found where a numeric was expected in
Package PA_FIN_PLAN_PVT Procedure Baseline_FinPlan
10. User-Defined Exception in Package PA_FIN_PLAN_PUB Procedure Baseline


STEPS
The issue can be reproduced at will with the following steps:
Create a budget.
Click Baseline button.

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