Cause:
Unable to initialize state monitor.
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 499
ORA-06512: at line 1
at oracle.apps.fnd.cp.gsm.GenCartComm.initService(GenCartComm.java:233)
at oracle.apps.fnd.cp.gsm.GenCartComm.<init>(GenCartComm.java:80)
at oracle.apps.fnd.cp.gsf.GSMStateMonitor.<init>(GSMStateMonitor.java:62)
at oracle.apps.fnd.cp.gsf.GSMStateMonitor.init(GSMStateMonitor.java:74)
at oracle.apps.fnd.cp.gsf.GSMServiceController.<init>(GSMServiceController.java:66)
at oracle.apps.fnd.cp.gsf.GSMServiceController.init(GSMServiceController.java:111)
at oracle.apps.fnd.cp.gsf.GSMServiceController.main(GSMServiceController.java:428)
Solution:
Check the OPP log file using below command
$ ps -ef|grep -i FNDOPP
Restart “Service Manager” and then restart “Output Post Processor”.
