Question

PL/SQL error when adding a new Shop Order

  • 30 September 2019
  • 5 replies
  • 415 views

Userlevel 2
Badge +3
Hi,
I come across an error when adding a new Shop Order.
The error is as below.

Server error messages:
6737a415-d237-4619-a979-f1b1db266565

Ifs.Fnd.FndSystemException: Unexpected error while calling server method AccessPlsql/Invoke ---> Ifs.Fnd.FndServerFaultException: ORA-06502: PL/SQL: numeric or value error

Failed executing statement (ORA-06502: PL/SQL: numeric or value error
ORA-06512: at line 16
ORA-06512: at "MELL1APP.ERROR_SYS", line 259
ORA-06512: at "MELL1APP.ERROR_SYS", line 1059
ORA-06512: at "MELL1APP.SHOP_ORD_API", line 24428
ORA-06512: at "MELL1APP.SHOP_ORD_API", line 24468
ORA-06512: at "MELL1APP.SHOP_ORD_API", line 17474
ORA-06512: at "MELL1APP.SHOP_ORD_API", line 17499
ORA-06512: at "MELL1APP.SHOP_ORD_API", line 17519
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)

Can someone kindly advise?

5 replies

Userlevel 2
Badge +1
This could be an issue with the length of the "KEY_STRING_VALIDATE" parameter of FND_SETTING_TAB. The error could appear when there is a violation of the string length. The object (Shop Orders, in this instance) can be created by changing those value to the appropriate length. Please take the following action: Go to Solution Manager->System Parameters window - And query for the Parameter "Define the characters which should not appear in key fields" - Select the Value as " (..)&%_<>=;~ " from the drop-down or past this in the field.
Userlevel 4
Badge +4

“ORA-06502: PL/SQL: numeric or value error” is a very generic error that can be reported for scenarios like incompatible variable types are set in the code or when the character length of a variable is not sufficient.

Only way is to technically debug the error and note the place where the error hits.

Userlevel 3
Badge +6

Do you have access to the db package shop_ord_api ? Because you could start by looking at Those Lines in the error. 

 

what ifs version and update are you running ? 

Userlevel 2
Badge +3

Do you have access to the db package shop_ord_api ? Because you could start by looking at Those Lines in the error. 

 

what ifs version and update are you running ? 

I am using App10 version of IFS Application. Yes, I do have access to the aforementioned db package - will certainly look at the lines in error. Thank you for this!

Badge +2

@daprlk

Do you still have the problem? :thinking:

 

Reply