My Oracle Support Banner

Workflow EDRPSIGF, Event "oracle.apps.edr.file.approve", Sometimes Ends in Error, "Error in Workflow EDRPSIGF/766004 User-Defined Exception" and "ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE" (Doc ID 2553790.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Process Manufacturing Process Execution - Version 12.2.5 and later
Oracle E-Records - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.5 version, Electronic Signatures

After setting profile EDR:Security Level High to Yes, it seems that it is necessary to run "E-records Indexed XML Element Maintenance" in order to see new E-Records,
so it has been scheduled to be run every 15 minutes .

This seems to cause the workflow EDRPSIGF to sometimes end in error.
The event is oracle.apps.edr.file.approve
If the workflow is resubmited the issue gets resolved.

ERROR
-----------------------
Error in Workflow EDRPSIGF/766004 User-Defined Exception
An Error occurred in the following Workflow.
Item Type = EDRPSIGF
Item Key = 766004
User Key =

Error Name = 1
Error Message = User-Defined Exception
Error Stack =
EDR_PSIG_PAGE_FLOW.PROCESS_RESPONSE(EDRPSIGF, 766004, -29861, ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE)
Wf_Engine_Util.Function_Call(EDR_PSIG_PAGE_FLOW.PROCESS_RESONSE, EDRPSIGF, 766004, 142122, RUN)

Activity Id = 142122
Activity Label = PSIG_ESIGN_PAGE_FLOW.PSIG_PROCESS_PAGE_RESPONSE
Result Code = #EXCEPTION
Notification Id =
Assigned User =

Changes

 

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


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