Skip to main content
Solved

Error creating analysis for Inventory Control Plan


Forum|alt.badge.img+17

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)

Best answer by dameenda

HI 

It seems like there is a customization running, would it be possible to remove the customization and create analysis.

 

View original
Did this topic help you find an answer to your question?

2 replies

Forum|alt.badge.img+10
  • Hero (Employee)
  • 208 replies
  • Answer
  • August 29, 2024

HI 

It seems like there is a customization running, would it be possible to remove the customization and create analysis.

 


Forum|alt.badge.img+17
  • Author
  • Superhero (Customer)
  • 224 replies
  • August 29, 2024

Yes, that was it. our developer updated the code and it now works. Thanks!


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings