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:

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

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