Hello All,
I am using IFS Apps 10 UPD 22, and I have setup and activated an Inventory Control Plan for a part that is currently in stock. I have scheduled daily checks, however, I have noticed they are not creating. I attempted to manually create one via RMB on the control plan header, however, I received an error message. I have confirmed I have the necessary permission grants. According to the help, I have completed all necessary prerequisites, and I’m at a loss as to why it would be generating an error. Any guidance would be greatly appreciated!
Server error messages:
e5c8e3b3-a041-475b-be66-17efb17cbfcb
Ifs.Fnd.FndSystemException: Unexpected error while calling server method AccessPlsql/Invoke ---> Ifs.Fnd.FndServerFaultException: ORA-01403: no data found
Failed executing statement (ORA-01403: no data found
ORA-06512: at line 17
ORA-06512: at "IFSAPP.INVENTORY_ANALYSIS_API", line 3214
ORA-01403: no data found
ORA-06512: at "IFSAPP.NSC_SHOP_ORDER_ANALYSIS_INS", line 52
ORA-04088: error during execution of trigger 'IFSAPP.NSC_SHOP_ORDER_ANALYSIS_INS'
ORA-06512: at "IFSAPP.INVENTORY_ANALYSIS_API", line 3711
ORA-06512: at "IFSAPP.INVENTORY_ANALYSIS_API", line 3773
ORA-06512: at "IFSAPP.INVENTORY_ANALYSIS_API", line 3793
ORA-06512: at "IFSAPP.INVENTORY_ANALYSIS_API", line 2571
ORA-06512: at "IFSAPP.INVENTORY_ANALYSIS_API", line 2575
ORA-06512: at "IFSAPP.INVENTORY_ANALYSIS_API", line 3039
ORA-06512: at "IFSAPP.INVENTORY_ANALYSIS_API", line 3219
ORA-06512: at line 10)
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.PLSQL.FndPLSQLCommandCollection.Invoke()
at Ifs.Fnd.AccessProvider.PLSQL.FndPLSQLCommand.ExecuteNonQuery()
at Ifs.Fnd.AccessProvider.PLSQL.FndPLSQLSelectCommandReader.Read(Boolean prepare)
at Ifs.Fnd.Data.ADONetProvider.FndAPCommand.ExecuteDbDataReader(CommandBehavior behavior)
