Hello Community,
Our Business has run into an issue where we ended up with 2 Invalid Objects that can no longer be compiled, where IFS provides and Application Error.
Impacted Objects are:
FND_TRK_LU_DMO_Q_N - Rule Set
FND_TRK_LU_DMO_Q_R - Rule Set
when trying to compile we get this error
here is the Detail of the error:
Ifs.Fnd.FndSystemException: Explorer: An Unhandled Exception has occurred ---> Ifs.Fnd.FndSystemException: Unexpected error while calling server method CompileInvalidObjects/CompileInvalidObjects ---> Ifs.Fnd.FndServerFaultException: ORA-00940: invalid ALTER command
Failed executing statement (ORA-00940: invalid ALTER command
ORA-06512: at "AGIL1APP.DATABASE_SYS", line 3213
ORA-06512: at line 1)
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, Boolean integrationGateway)
--- 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, Boolean integrationGateway)
at Ifs.Fnd.AccessProvider.FndConnection.InvokeInternal(String intface, String operation, Object requestBody, Object responseBody, FndRequestContext requestContext, Boolean forcedSync, Boolean integrationGateway)
at Ifs.Fnd.AccessProvider.Activity.FndActivityContext.Invoke(String intface, String operation, Object request, Object response)
at Ifs.Fnd.AccessProvider.Activity.FndActivityCommand.ExecuteNonQuery(Object request, Object response)
at Ifs.Application.ManageInvalidObjects.ServerInterface.Ifs.Application.ManageInvalidObjects.ICompileInvalidObjects.CompileInvalidObjects(OracleUserObjectTable oracleUserObjects)
at Ifs.Application.ManageInvalidObjects.CompileInvalidObjects.commandCompileAll_Execute(Object sender, FndCommandExecuteEventArgs e)
at Ifs.Fnd.Windows.Forms.FndCommand.OnExecute(Component component)
at Ifs.Fnd.Windows.Forms.FndContextMenuStrip.ExecuteCommand(ToolStripMenuItem menuItem, EventArgs e)
at Ifs.Fnd.Windows.Forms.FndToolStripMenuItem.OnClick(EventArgs e)
at System.Windows.Forms.ToolStripItem.HandleClick(EventArgs e)
at System.Windows.Forms.ToolStripItem.HandleMouseUp(MouseEventArgs e)
at System.Windows.Forms.ToolStripItem.FireEventInteractive(EventArgs e, ToolStripItemEventType met)
at System.Windows.Forms.ToolStripItem.FireEvent(EventArgs e, ToolStripItemEventType met)
at System.Windows.Forms.ToolStrip.OnMouseUp(MouseEventArgs mea)
at System.Windows.Forms.ToolStripDropDown.OnMouseUp(MouseEventArgs mea)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.ToolStrip.WndProc(Message& m)
at System.Windows.Forms.ToolStripDropDown.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
--- End of inner exception stack trace ---
This happened after we applied IFS 10 UPD 21 into our IFS Test environment but did not occur during our IFS Development Update.
Any help is much appreciated. (we are at a loss on this one)
