My Oracle Support Banner

Error When Creating Project Or Template ORA-01422 Or USER_DEFINED_EXCEPTION (Doc ID 303290.1)

Last updated on FEBRUARY 06, 2018

Applies to:

Oracle Project Foundation - Version 11.5.10.2 to 12.1.2 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.

Symptoms

When trying to create a new project in self-service web applications the following error occurs:

ERROR
1. ORA-1422: exact fetch returns more than requested number of rows in Package PA_FIN_PLAN_UTILS
Procedure GET_OR_CREATE_AMOUNT_SET_ID
2. User-Defined Exception in Package PA_PROJ_FP_OPTIONS_PUB.Get_FP_Options Proecedure
pafpcpfb.copy_wp_budget_versions->PA_FP_PLANNING_TRANSACTION_PUB.Add_wp_plan_type
3. User-Defined Exception in Package PA_PROJ_FP_OPTIONS_PUB.Create_FP_Option Procedure
pafpcpfb.copy_wp_budget_versions->PA_FP_PLANNING_TRANSACTION_PUB.Add_wp_plan_type
4. User-Defined Exception in Package PA_FP_PLANNING_TRANSACTION_PUB Procedure
PA_FP_PLANNING_TRANSACTION_PUB.Add_wp_plan_type
5. User-Defined Exception in Package pa_fp_copy_from_pkg Procedure copy_wp_budget_versions
6. User-Defined Exception in Package PA_PROJ_TASK_STRUC_PUB Procedure copy_structures_tasks_bulk
7. User-Defined Excpetion in Pakcage PA_PROJ_TASK_STRUC_PUB Procedure Copy_Structure
8. API: PA_PROJ_TASK_STRUC_PUB.CO

When trying to create a structure for a new template the following error occurs:

Error
1. Row 1 Error - ORA-01422: exact fetch returns more than requested number of rows in
Package PA_FIN_PLAN_UTILS Procedure GET_OR_CREATE_AMOUNT_SET_ID
2. Row 1 Error - User-Defined Exception in Package PA_PROJ_FP_OPTIONS_PUB.Get_Default_FP_Options
Procedure PA_FP_PLAN_TXN_PUB.add_planning_transactions->
PA_FP_PLANNING_TRANSACTION_PUB.Add_wp_plan_type.
3. Row 1 Error - User-Defined Exception in Package PA_PROJ_FP_OPTIONS_PUB.Create_FP_Options Procedure
PA_FP_PLAN_TXN_PUB.add_planning_transactions->PA_FP_PLANNING_TRANSACTION_PUB.Add_wp_plan_type.
4. Row 1 Error - User-Defined Exception in Package PA_FP_PLANNING_TRANSACTION_PUB Procedure
PA_FP_PLANNING_TRANSACTION_PUB.Add_wp_plan_type
5. Row 1 Error - User-Defined Exception in Package PA_FP_PLANNING_TRANSACTION_PUB Procedure
add_planning_transactions
6. Row 1 Error - PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: User-Defined Exception
in Package PA_PROJECT_STRUCTURE_PVT1 Procedure CREATE_STURCTURE_VERSION

When trying to create a project in forms the following error occurs after entering quick entry data and clicking on OK:

API: PA_PROJ_TASK_STRUC_PUB.COPY_STRUCTURE SQL ERROR MESSAGE:
USER-DEFINED EXCEPTION

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.