Database Error When Trying to Approve the Requisition - ORA-01502: index 'APPLSYS.WF_ITEM_ACTIVITY_STATUSES_PK' (Doc ID 2101933.1)

Last updated on JANUARY 31, 2016

Applies to:

Oracle Purchasing - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

Using Purchasing, Version 12.2.4


Actual:
Upon submitting an upgraded incomplete requisition for approval, errors are being encountered.

Expected:
Upon submitting an incomplete - upgraded requisition - for approval - errors should not be encountered.

Error:
APP-PO-14142: In Exception of Start_WF_Process()-PO_REQAPPROVAL_INIT1.Start_WF_Process: In Exception handler :
ORA-01502: index 'APPLSYS.WF_ITEM_ACTIVITY_STATUSES_PK' or partition of such index is in unusable state


Replication Steps:
The issue can be reproduced at will with the following steps:
1. Upgraded - Incomplete requisition is queried in the requisition summary form.
  - Open button is selected - enter requisition form opens
2. Submission for approval is attempted
3. Error is encountered - in the actual form - and the approval submission does not take place.




Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms