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.
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 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 =
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