R12.2 Pji_fp_xbs_accum_f_n4.xdf Fails with ORA-01426: Numeric Overflow
(Doc ID 2308135.1)
Last updated on NOVEMBER 15, 2022
Applies to:
Oracle Project Planning and Control - Version 12.1.2 and laterInformation in this document applies to any platform.
Symptoms
On : 12.2.o
EBS Upgrade:AutoPatch R120 pl pji_fp_xbs_accum_f_n4.xdf
While running for the CUP patch - 10124646 with upgrade driver with adpatch with options=nocopyportion,nogenerateportion, getting the below-mentioned error.
ERROR
-----------------------
SQL> CREATE INDEX "PJI"."PJI_FP_XBS_ACCUM_F_N4" ON "PJI"."PJI_FP_XBS_ACCUM_F" ("PROJECT_ID", "PERIOD_TYPE_ID", "RBS_AGGR_LEVEL", "WBS_ROLLUP_FLAG", "PRG_ROLLUP_FLAG", ABS(NVL("SUP_INV_COMMITTED_COST",0))+ABS(NVL("PO_COMMITTED_COST",0))+ABS(NVL("PR_COMMITTED_COST",0))+ABS(NVL("OTH_COMMITTED_COST",0)))
PCTFREE 10 INITRANS 11 MAXTRANS 255 COMPUTE STATISTICS
2 3 STORAGE(INITIAL 16384 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 4 FREELIST GROUPS 4 BUFFER_POOL DEFAULT)
4 5 TABLESPACE "APPS_TS_TX_IDX"
6 ;
CREATE INDEX "PJI"."PJI_FP_XBS_ACCUM_F_N4" ON "PJI"."PJI_FP_XBS_ACCUM_F" ("PROJECT_ID", "PERIOD_TYPE_ID", "RBS_AGGR_LEVEL", "WBS_ROLLUP_FLAG", "PRG_ROLLUP_FLAG", ABS(NVL("SUP_INV_COMMITTED_COST",0))+ABS(NVL("PO_COMMITTED_COST",0))+ABS(NVL("PR_COMMITTED_COST",0))+ABS(NVL("OTH_COMMITTED_COST",0)))
*
ERROR at line 1:
ORA-01426: numeric overflow
Index PJI_FP_XBS_ACCUM_F_N4 does not exist in PJI.
CREATE INDEX "PJI"."PJI_FP_XBS_ACCUM_F_N4" ON "PJI"."PJI_FP_XBS_ACCUM_F" ("PROJECT_ID", "PERIOD_TYPE_ID", "RBS_AGGR_LEVEL", "WBS_ROLLUP_FLAG", "PRG_ROLLUP_FLAG", ABS(NVL("SUP_INV_COMMITTED_COST",0))+ABS(NVL("PO_COMMITTED_COST",0))+ABS(NVL("PR_COMMITTED_COST",0))+ABS(NVL("OTH_COMMITTED_COST",0)))
PCTFREE 10 INITRANS 11 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 16384 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 4 FREELIST GROUPS 4 BUFFER_POOL DEFAULT)
TABLESPACE "APPS_TS_TX_IDX"
Start time for statement above is Thu Sep 14 13:09:59 UTC 2017
ORA-1426 error occured during Index creation.
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 |