Record Print Status Errors out after a Custom Index Created.
We created an Custom Index on IBY_PAYMENTS_ALL and below is definition of same. After this index is created the Record Print Status Job which confirms Payment Process Request is erroring out. Does any one knows why and index is causing the Job to fail.
create index empcustom.HUMIBY_IBY_PAYMENTS_ALL_N2 on IBY.IBY_PAYMENTS_ALL(NVL(PAPER_DOCUMENT_NUMBER,PAYMENT_REFERENCE_NUMBER))
tablespace EMPCUSTOMD
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 1M
next 1M
minextents 1
maxextents unlimited
pctincrease 0
);