Skip to main content
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?
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.

“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.

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 ? 

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!

@daprlk

Do you still have the problem? :thinking:

 

Reply


Terms & ConditionsCookie settings