Financial Management - PSFT (MOSC)

MOSC Banner

ARUPDATE aborted by arithmetic overflow error on the SQL Server platform

edited Jan 28, 2013 2:28PM in Financial Management - PSFT (MOSC) 2 commentsAnswered
This topic was reported as SR and I think this is the useful information for users using the SQL Server platform.

Scenario:

ARUPDATE aborted by the error of “Arithmetic overflow error converting expression to data type int”at the following application engine steps.

1. AR_PGG_SERV.CC_ROUN2.Step03
2. AR_POSTING.PST_PYMT.UPD_TOT

This issue will occur on the following conditions;

 - DBMS platform is SQL Server. Issue does not replicate on Oracle DB.
 - This issue can be replicated when both items and payments are created with the amount more than 2147483648.
 - (This condition only for #1) Using Cash Clearing features in AR.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center