Skip to main content

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)

Hi @Curious_User ,

Try using the PLSQL developer and re-compile the invalid objects and refresh. If these invalid objects aren’t cleared might need to create a ticket and investigate with the related vertical since there were no issues occurred during the IFS Development Update.

Thanks & Regards,

Vageesan

Hi @Curious_User ,

Try using the PLSQL developer and re-compile the invalid objects and refresh. If these invalid objects aren’t cleared might need to create a ticket and investigate with the related vertical since there were no issues occurred during the IFS Development Update.

Thanks & Regards,

Vageesan

Thank you @Vageesan ,

 

We ran the below and it fixed the issue. (Note needs to be run as sys or sysdba)

 

SET SERVEROUTPUT ON SIZE UNLIMITED
SET FEEDBACK OFF

DECLARE
  err_count NUMBER;
BEGIN
  SELECT COUNT(*) INTO err_count FROM dba_errors;
  IF err_count > 0 THEN
    DBMS_OUTPUT.PUT_LINE('Invalid objects found: ' || err_count);
    DBMS_OUTPUT.PUT_LINE('Recompiling...');
    UTL_RECOMP.RECOMP_SERIAL;
    DBMS_OUTPUT.PUT_LINE('Compilation completed.');
  ELSE
    DBMS_OUTPUT.PUT_LINE('No invalid objects found.');
  END IF;
END;
/

 

 

Reply


Terms & ConditionsCookie settings