In R12.2.2 Workflow mailer fails to start with error ORA-06512: at "APPS.FND_CP_GSM_IPC"
Workflow mailer is failing to start in R12.2.2. Below is the complete error message.
LOG_ID_UNKNOWN : oracle.apps.fnd.cp.gsc.Logger.Logger(String, int) : Logging to System.out until necessary parameters are retrieved for Logger to be properly started.
LOG_ID_UNKNOWN : oracle.apps.fnd.cp.gsm.GSMSvcComponentContainer.initializeStateMachine() : BEGIN
LOG_ID_UNKNOWN : oracle.apps.fnd.cp.gsc.SvcComponentContainer.getNewWorkflowContext() : BEGIN
Oct 18, 2013 4:26:35 AM oracle.ias.cache.CacheInternal logLifecycleEvent
INFO: JOC is initialized from oracle.apps.jtf.cache.IASCacheProvider.init, ver=11.1.1.2.0, distribute=true, vid=37, coordinator=0, discover list=[[172.16.24.165:12345] segID=1]
Could not start Service Component Container -> oracle.apps.fnd.cp.gsc.SvcComponentContainerException: Could not instantiate GSMSvcComponentContainerStateMachine -> oracle.apps.fnd.cp.gsc.StateMachineException: Could not instantiate GenCartComm with cpid=2728606 -> oracle.apps.fnd.cp.gsm.GenCartCommException: ORA-01403: no data found