My Oracle Support Banner

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

Last updated on MAY 31, 2019

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

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
Cause
Solution


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