EAR9.1: ARUPDATE Aborted By Arithmetic Overflow Error On The SQL Server Platform (Doc ID 1559288.1)

Last updated on NOVEMBER 27, 2019

Applies to:

Symptoms

 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

Error
-----------

1. -- 22.44.35 Process 12668 ABENDED at Step AR_PGG_SERV.CC_ROUN2.Step03 (Action SQL) -- RC = 8601 ROLLBACK / -- 22.44.35 SQL Error: [Microsoft][SQL Server Native Client 10.0][SQL Server] Arithmetic overflow error converting expression to data type int [Microsoft][SQL Server Native Client 10.0][SQL Server]The cursor was not declared. (SQLSTATE 37000) 16945
2. -- 13.25.15 Process 11434 ABENDED at Step AR_POSTING.PST_PYMT.UPD_TOT (Action SQL) -- RC = 8601 ROLLBACK / -- 13.25.15 SQL Error: [Microsoft][SQL Server Native Client 10.0][SQL Server] Arithmetic overflow error converting expression to data type int [Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.(SQLSTATE 01000) 3621

Step 1: The error at the step of AR_PGG_SERV.CC_ROUN2.Step03
-------------------------------------------------------------

1. Create 11 items like as follows:
   • 185650956 JPY
   • 435442418 JPY
   • 158898470 JPY
   • 337790778 JPY
   • 165459820 JPY
   • 175447063 JPY
   • 224150914 JPY
   • 162466660 JPY
   • 313800140 JPY
   • 185138769 JPY
   • 156490529 JPY
2. Run ARUPDATE to post 11 items.
3. Create deposits with the amount 2500736517 JPY.
4. Create Payment Worksheet to apply 1 payment to 11 items.
5. Run ARUPDATE again, the arithmetic overflow error will occur.

Step 2: The error at the step of AR_POSTING.PST_PYMT.UPD_TOT
-------------------------------------------------------------

1. Create 2 items like as follows:
   • 1,050,000,000 JPY
   • 1,575,000,000 JPY
2. Run ARUPDATE to post 2 items.
3. Create 1 deposit and 2 payments with the following amounts:
   • Total amount：2,625,000,000 JPY
   • Payment amounts：1,050,000,000 JPY / 1,575,000,000 JPY
4. Create payment worksheet to apply.
5. Run ARUPDATE again, the arithmetic overflow error will occur.

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.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.