Hi Community,

I have problem to search a transaction in Inventory Transactions History – list view.

In below picture You can see Transaction ID 1230035. I can search this in Single view -Inventory Transaction History but no in list view, getting below error.

“Server error messages:

c624b4e0-269c-4a99-b0fe-2935c64203c0

Ifs.Fnd.FndSystemException: Unexpected error while calling server method AccessPlsql/Invoke ---> Ifs.Fnd.FndServerFaultException: ORA-01722: invalid number

Failed executing query (ORA-01722: invalid number

ORA-06512: at "IFSAPP.INVENTORY_TRANSACTION_HIST_CFP", line 451

ORA-06512: at "IFSAPP.INVENTORY_TRANSACTION_HIST_CFP", line 462)

   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(String intface, String operation, Object requestBody, Object responseBody, FndRequestContext requestContext, Boolean forcedSync)

   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)”

I believe this is something to do with a custom filed that I created recently called Product family in list view. The CF is read only, fetching Product family field value from Inventory part. Search in the view worked fine until we have created the first OESHIP transaction today, which transaction ID is 1230035. Search other type of transaction code like Arrival and NREC works fine. Any search include transaction ID 1230035 in result does not work… For example I can still query transaction ID 1230034 or 1230036 but not 1230034..1230036 because this result includes 1230035. 

Could anyone give us any advice why we are getting the error and what we should do?

We are using App 9, thanks.