Returns an 'Error' Customer order on planned to released

Hi @MORCXGUDLA ,

Click on the View Detail link of the given error dialog and see the details. 

Also you can click on the Copy error detail to the clipboard to get the error details copied. 

Please add those details and we can get an idea as why this error comes.

/Sangeetha

++ Kindly check below ‘Error’ trace details..

Ifs.Fnd.FndSystemException: Unexpected error while calling server method AccessPlsql/Invoke ---> ORA-00001: unique constraint (IFSAPP.TRANSACTION_SYS_LOCAL_PK) violated

   at ifs.fnd.services.plsqlserver.service.PlsqlInvocationProcessor.convertError(Unknown Source)
   at ifs.fnd.services.plsqlserver.service.PlsqlInvocationProcessor.invokeImpl(Unknown Source)
   at ifs.fnd.services.plsqlserver.service.PlsqlInvocationProcessor.invoke(Unknown Source)
   at ifs.fnd.services.plsqlserver.service.PlsqlProxy.invoke(Unknown Source)
   at ifs.fnd.services.plsqlserver.service.PlsqlProxy.invoke(Unknown Source)
   at ifs.fnd.services.plsqlserver.service.PlsqlProxy.invoke(Unknown Source)
   at ifs.fnd.gateway.client.IfsClientGateway.doPost(IfsClientGateway.java:458)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
   at ifs.fnd.gateway.IfsAbstractGateway.service(IfsAbstractGateway.java:160)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
   at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179)
   at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:525)
   at org.jboss.web.tomcat.security.BasicAuthValve.invoke(BasicAuthValve.java:75)
   at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
   at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:241)
   at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:437)
   at org.apache.coyote.ajp.AjpProtocol$AjpConnectionHandler.process(AjpProtocol.java:381)
   at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
   at java.lang.Thread.run(Thread.java:619)

   ### client/server border ###

   at Ifs.Fnd.AccessProvider.FndConnection.ParseErrorHeader(FndBuffer buffer, FndManualDecisionCollection decisions)
   at Ifs.Fnd.AccessProvider.FndConnection.UnMarshalResponseHeader(Stream responseStream, FndManualDecisionCollection decisions)
   at Ifs.Fnd.AccessProvider.FndConnection.HandleHttpSuccessResult(HttpWebResponse result, FndManualDecisionCollection decisions, String operation, FndBodyType responseBodyType, Object responseBody)
   at Ifs.Fnd.AccessProvider.FndConnection.InvokeInternal(Object requestBody, Object responseBody, String intface, String operation, FndRequestContext requestContext, FndManualDecisionCollection decisions, Boolean forcedSync)
   --- End of inner exception stack trace ---
   at Ifs.Fnd.AccessProvider.FndConnection.InvokeInternal(Object requestBody, Object responseBody, String intface, String operation, FndRequestContext requestContext, FndManualDecisionCollection decisions, Boolean forcedSync)
   at Ifs.Fnd.AccessProvider.FndConnection.InvokeInternal(String intface, String operation, Object requestBody, Object responseBody, FndRequestContext requestContext, Boolean forcedSync)
   at Ifs.Fnd.AccessProvider.FndConnection.InvokeSync(String intface, String operation, Object requestBody, Object responseBody)
   at Ifs.Fnd.AccessProvider.PLSQL.FndPLSQLCommandCollection.Invoke()
   at Ifs.Fnd.AccessProvider.PLSQL.FndPLSQLCommand.ExecuteNonQuery()
   at Ifs.Fnd.AccessProvider.PLSQL.FndPLSQLSelectCommand.ExecuteReader(String recordType)
   at Ifs.Fnd.AccessProvider.PLSQL.FndPLSQLSelectCommandReader.ReadCursor(Boolean prepare)
   at Ifs.Fnd.AccessProvider.PLSQL.FndPLSQLSelectCommandReader.Read(Boolean prepare)
   at Ifs.Fnd.AccessProvider.PLSQL.FndPLSQLSelectCommand.ExecuteCursorReader(String recordType, Int32 fetchSize)
   at Ifs.Fnd.Data.ADONetProvider.FndAPCommand.ExecuteDbDataReader(CommandBehavior behavior)

Sangeetha Jayamaha wrote:

Hi @MORCXGUDLA ,

Click on the View Detail link of the given error dialog and see the details. 

Also you can click on the Copy error detail to the clipboard to get the error details copied. 

 

Please add those details and we can get an idea as why this error comes.

/Sangeetha

Thank you, Sangeetha. Sure done.

Hi @MORCXGUDLA 

1. What is this application version? App9 ? UPD?
2.  Do you get this error only for this Customer Order.. ?  Or is it common for all the customer Orders? 

/Sangeetha

Thanks Sangeetha,

This is IFS 7.5 TRACK SP 7.

This ‘Error’ is for all common Customer Orders only..

Kind Regards

Sekhar

Kindly help me in this regard..