Skip to main content

Our accounting manager gets an error when trying to add. We upgraded from Apps9 to Apps10 in september. Is this a permission issue?

 

Server error messages:

27c5939b-b368-4783-88a8-0e30bbada061

 

Ifs.Fnd.FndSystemException: Unexpected error while calling server method AccessPlsql/Invoke ---> Ifs.Fnd.FndServerFaultException: ORA-06553: PLS-306: wrong number or types of arguments in call to 'EXIST_ADD_INVESTMENT_INFO'

 

Failed executing query (ORA-06553: PLS-306: wrong number or types of arguments in call to 'EXIST_ADD_INVESTMENT_INFO')

   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)

 

 

Any idea of where to start?

Can you please let us know if you have Fixed Assets installed?     In app9 above error was reported if Fixed Assets was not installed (solution 229197) -- it is possible this same issue exists in App10 and you may need to log a support case

Thanks for the quick response ,What would tell me if fixed assets are installed?

 

Please go to installed components (solution manager-system information and utilities-installed components) and see if you have component identity:  FIXASS 

FIXASS component is not installed. We were on APPS9 UPD6 and did not have this error. Error must be after UPD6 on APPS9. I will open a case.

Hi @arebbeadle 

When end user tries to save this voucher entry record, system calls this method ADD_INVESTMENT_INFO_API.EXIST_ADD_INVESTMENT_INFO to perform some actions. I checked the signature (definition) of this method in app 9 and app 10 as mentioned below

app 9
----------------------------------------------------
FUNCTION Exist_Add_Investment_Info (
   source_ref_ IN VARCHAR2,
   company_    IN VARCHAR2,
   keyref1_    IN VARCHAR2,
   keyref2_    IN VARCHAR2,
   keyref3_    IN VARCHAR2,
   keyref4_    IN VARCHAR2,
   keyref5_    IN VARCHAR2 ) RETURN VARCHAR2
IS
  

app 10
-------------------------------------------------------
FUNCTION Exist_Add_Investment_Info (
   source_ref_    IN VARCHAR2,
   company_       IN VARCHAR2,
   keyref1_       IN VARCHAR2,
   keyref2_       IN VARCHAR2,
   keyref3_       IN VARCHAR2,
   keyref4_       IN VARCHAR2,
   keyref5_       IN VARCHAR2,
   multi_company_ IN VARCHAR2 DEFAULT 'FALSE') RETURN VARCHAR2
IS

In app 10 we can see additional parameter multi_company_  is there and may be still app 9 implementation of this method exists in some of this method invokes in app 10 upgraded datbase as well, because this type of error occurred when the number of arguments of a method (e.g : source_ref_, company_,... are aruments of this method) or type of the argment of a method (e.g :  source_ref_  argument can hold string type value) is not exactly same in the location where this method acctually called. This types of issues can be easily investgated and please create a case to IFS support center, so we will be able to identify the issue efficiently.

 

Thank You and Best Regards,

Dammika

Terms & ConditionsCookie settings