Question

Tax Proposal issue

  • 28 July 2023
  • 1 reply
  • 81 views
N
Rank
Userlevel 4
Badge +7

Hi Getting below issue while running automatic tax proposal 

 

 

Please help

Server error messages:
f2c77078-c49a-491e-ae17-ff9d4baa5f7a

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

Failed executing statement (ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06512: at line 50
ORA-06512: at "IFSAPP.TAX_REPORT_VALUE_API", line 3920
ORA-06512: at "IFSAPP.TAX_REPORT_VALUE_API", line 3920
ORA-06512: at "IFSAPP.TAX_REPORT_VALUE_API", line 3977
ORA-06512: at "IFSAPP.TAX_REPORT_VALUE_API", line 2688
ORA-06512: at "IFSAPP.TAX_REPORT_VALUE_API", line 2694
ORA-06512: at "IFSAPP.TAX_REPORT_VALUE_API", line 2816
ORA-06512: at "IFSAPP.TAX_REPORT_VALUE_API", line 2822
ORA-06512: at "IFSAPP.TAX_PROPOSAL_API", line 7694
ORA-06512: at "IFSAPP.TAX_PROPOSAL_API", line 7734
ORA-06512: at "IFSAPP.TAX_PROPOSAL_API", line 7757
ORA-06512: at line 24)
   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)

 

1 reply

T
Rank
Userlevel 7
Badge +18

Hi, 

Try same, use a new tax report using a template like S005. 

That would help identify the source of the issue. In other words, do we have bad data in tax transactions or is the user created tax report the cause. 

 

A sample tax report is shown that used tax template S005. 

 

This is just a test, to better isolate the issue. - You would later delete the proposal and the report.  Do not attempt to complete the testing tax report. Just do the same steps as you did when the error was created. Do not go any further, we want to be able to delete this test report. 

Best regards, 

Thomas

Reply


Terms & ConditionsCookie settings