Skip to main content
Solved

Error message '(full) year must be between -4713 and +9999, and not be 0'


Forum|alt.badge.img+10

All,

IFS8. It pop up error message as follow when I  release Shop Order. I put details behind the picture

 

 

Ifs.Fnd.FndSystemException: Unexpected error while calling server method AccessPlsql/Invoke ---> Ifs.Fnd.FndServerFaultException: ORA-01841: (full) year must be between -4713 and +9999, and not be 0
   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.Invoke(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.FndPLSQLSelectCommandReader.Read(Boolean prepare)
   at Ifs.Fnd.AccessProvider.PLSQL.FndPLSQLSelectCommand.ExecuteCursorReader(String recordType, Int32 fetchSize)
   at Ifs.Fnd.Data.ADONetProvider.FndAPCommand.ExecuteDbDataReader(CommandBehavior behavior)

 

And I get warning message on Debug Console

 

Does anybody know how to find what is causing this issue?

 

Best answer by Bright Zhao

SaaAvinak wrote:

can you check if any event is triggered when you release Shop Order and if that event is correctly configured?
 

  1. Identify the event being triggered 
  2. disable the event and perform the action again
  3. if it worked after disabling the event then the event/event action is not configured correctly.

Hope that helps 

Regards

Thanks for your quick responding! You are right. There is 1 Event Activon of LU ShopOrd. I disable it then no error message. 

BR 
 

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

2 replies

SaaAvinak
Do Gooder (Customer)
Forum|alt.badge.img+7
  • 18 replies
  • August 15, 2024

can you check if any event is triggered when you release Shop Order and if that event is correctly configured?
 

  1. Identify the event being triggered 
  2. disable the event and perform the action again
  3. if it worked after disabling the event then the event/event action is not configured correctly.

Hope that helps 

Regards


Forum|alt.badge.img+10
  • Author
  • Hero
  • 49 replies
  • Answer
  • August 15, 2024
SaaAvinak wrote:

can you check if any event is triggered when you release Shop Order and if that event is correctly configured?
 

  1. Identify the event being triggered 
  2. disable the event and perform the action again
  3. if it worked after disabling the event then the event/event action is not configured correctly.

Hope that helps 

Regards

Thanks for your quick responding! You are right. There is 1 Event Activon of LU ShopOrd. I disable it then no error message. 

BR 
 


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