Question

Multi-Company Voucher Entry Error

  • 30 November 2021
  • 5 replies
  • 62 views

Userlevel 5
Badge +9

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?


5 replies

Userlevel 5
Badge +8

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

Userlevel 5
Badge +9

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

 

Userlevel 5
Badge +8

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

Userlevel 5
Badge +9

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.

Userlevel 5
Badge +5

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

Reply