My Oracle Support Banner

PO APPROVAL STUCK WITH ORA-29861 ERROR IN ACTIVITY: DELETE_PDF_ATTACHMENTS (Doc ID 2574826.1)

Last updated on AUGUST 11, 2022

Applies to:

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

Symptoms

After RUP patching PO approval workflow shows an error during Activity:Delete PDF Attachments and the following error is seen.

Error:

ORA-29861: domain index is marked LOADONG/FAILED/UNUSABLE
PO_COMMUNICATION_PVT.DELETE_PDF_ATTACHMENT(PO_COMMUNICATION_PVT.DELETE_PDF_ATTACHMENTS:In Exception handler) WF_ENGINE_Util.Function_Call(PO_COMMUNICATION_PVT.DELETE_PDF_ATTACHMENTS, POAPPRV,)

Steps to reproduce:

1.  Create new Purchase Order (PO)
2.  Submit for Approval
3.  Encounter the error in Workflow
4.  Note the In Process status

Changes

 Applied RUP Patch

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


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