Payables and Cash Management - EBS (MOSC)

MOSC Banner

Record Print Status Errors out after a Custom Index Created.

edited Nov 29, 2012 4:22PM in Payables and Cash Management - EBS (MOSC) 2 commentsAnswered

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

  );

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center