EAP: Voucher Build Process AP_VCHRBLD Fails With Numeric Value Out Of Range. SQLSTATE=22003 (Doc ID 2097091.1)

Last updated on JANUARY 14, 2016

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9 and later
Information in this document applies to any platform.

Symptoms

When there are 10 or more  Billing Invoice lines with negative Gross Ext amount on Intercompany Invoices flowing from Billing to AP, Voucher Build process AP_VCHRBLD fails with Numeric value out of range. SQLSTATE=22003.


Note:Excise tax to be enabled at Voucher BU level/Supplier  level

Note: This is DB2 specific. In Oracle Environment there are no issues.

ERROR
-----------------------
-- 03.20.52 ............(FS_EXSLIB.ECRVSGN.UPDAMT) (Do When)
%SelectInit(EXS_AECALC_AET.TEMP_FLD) SELECT COUNT(*) FROM PS_EXS_TXCWA_TAO1
WHERE PROCESS_INSTANCE = 6083037 AND BUSINESS_UNIT = 'IND01' AND EXS_SIGN_FLG
= 'A'
/
-- 03.20.52 Process 6083037 ABENDED at Step FS_EXSLIB.ECRVSGN.UPDAMT (Action Do When) -- RC = 8601
ROLLBACK
/
-- 03.20.52 SQL Error: [IBM][CLI Driver] CLI0165E Error in row. SQLSTATE=01S01
[IBM][CLI Driver] CLI0111E Numeric value out of range. SQLSTATE=22003 (SQLSTATE 22003) -99999


Replication:
-----------------------
1.  Setup Supplier for Excise Duty tax in DB2 environment.

2.  Associate the same Supplier to a  Customer.

3.  Created BI Invoice for 10 lines with  negative amounts.

4.  Interface to AP

5.  Run Voucher Build process.

Process abended with following error:

- 14:11:29.264 ............(FS_EXSLIB.ECRVSGN.UPDAMT) (Do When)
%SelectInit(EXS_AECALC_AET.TEMP_FLD) SELECT COUNT(*) FROM PS_EXS_TXCWA_TAO1
WHERE PROCESS_INSTANCE = 64028 AND BUSINESS_UNIT = 'IND01' AND EXS_SIGN_FLG =
'A'
/
-- 14:11:29.794 Process 64028 ABENDED at Step FS_EXSLIB.ECRVSGN.UPDAMT
(Action Do When) -- RC = 8601
ROLLBACK
/
-- 14:11:30.009 SQL Error: [IBM][CLI Driver] CLI0165E  Error in row.
SQLSTATE=01S01
[IBM][CLI Driver] CLI0111E  Numeric value out of range. SQLSTATE=22003
(SQLSTATE 22003) -99999


Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms