R12 E-Business Suite Workflow Services Fail To Start After Patching Due To Errors 'oracle.apps.fnd.cp.gsm.GenCartCommException: ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at "APPS.FND_CP_GSM_IPC" (Doc ID 2286490.1)

Last updated on JULY 21, 2017

Applies to:

Oracle Workflow - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

E-Business R12 Workflow, Workflow Agent Listener related issues

 



After applying a list of patches, workflow services fail to start with the following error:

oracle.apps.fnd.cp.gsm.GenCartCommException: ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "APPS.FND_CP_GSM_IPC", line 539
ORA-06512: at line 1

oracle.apps.fnd.cp.gsc.SvcComponentContainerException: Could not instantiate GSMSvcComponentContainerStateMachine -> oracle.apps.fnd.cp.gsc.StateMachineException: Could not instantiate GenCartComm with cpid=30499 -> oracle.apps.fnd.cp.gs
m.GenCartCommException: ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "APPS.FND_CP_GSM_IPC", line 539
ORA-06512: at line 1

  at oracle.apps.fnd.cp.gsm.GSMSvcComponentContainer.initializeStateMachine(GSMSvcComponentContainer.java:221)
  at oracle.apps.fnd.cp.gsc.SvcComponentContainer.start(SvcComponentContainer.java:782)
  at oracle.apps.fnd.cp.gsm.GSMSvcComponentContainer.main(GSMSvcComponentContainer.java:418)


The issue can be reproduced at will with the following steps:

1. start workflow services

2. Confirm the above error is received.


The issue has the following business impact:

Due to this issue, users cannot use workflow notification.

Changes

The issue started after the following patches were applied:

IAS Patch 22447165 and 22458773
22974534 - OWF.B
19835592 - ICX.B
22922530 - ECX.B
22724663 - IBY.B
23527993 – FNDLIBR

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