EAP: Voucher Build abneds at Step FS_VATCALC.UPDBSAMT.STEP01 (Doc ID 2024827.1)

Last updated on AUGUST 07, 2017

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Voucher Build abends at Step FS_VATCALC.UpdBsAmt.Step01 with divisor equal to zero error.

Created a Voucher with a Statistical amount through a Quick Invoice, and ran Voucher Build. It goes to No Success with an error.

ERROR
Voucher Build Process ABENDED at Step FS_VATCALC.UpdBsAmt.Step01 (SQL) -- RC = 1476 (108,524) with divisor is equal to zero

Failed SQL stmt: UPDATE PS_VAT_CALC_TAO4 SET VAT_TX_AMT_BSE_TMP = TRUNC(((((VAT_TRANS_AMT) / (RATE_DIV))) * (RATE_MULT)),5), VAT_BASIS_BSE_TMP = TRUNC(((((VAT_BASIS_AMT) / (RATE_DIV))) * (RATE_MULT)),5), VAT_AMT_BSE_TMP = TRUNC(((((VAT_CALC_AMT) / (RATE_DIV))) * (RATE_MULT)),5), VAT_RCVRY_BSE_TMP = TRUNC(((((VAT_RCVRY_AMT) / (RATE_DIV))) * (RATE_MULT)),5), VAT_D_ADJ_BSE_TMP = TRUNC(((((VAT_DSCNT_ADJ) / (RATE_DIV))) * (RATE_MULT)),5), VAT_D_RCV_BSE_TMP = TRUNC(((((VAT_DSCNT_RCVRY) / (RATE_DIV))) * (RATE_MULT)),5), VAT_REBATE_BSE_TMP = TRUNC(((((VAT_REBATE_AMT) / (RATE_DIV))) * (RATE_MULT)),5) WHERE PROCESS_INSTANCE = 1257822

File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1623  Error Position: 74  Return: 1476 - ORA-01476: divisor is equal to zero

 STEPS
1. Navigate to Accounts Payable > Vouchers > Add/Update > Quick Invoice, and create a voucher for VAT applicable vendor.
2. Enter Voucher with 2 invoice lines: 1 with merchandise amt $210.80 and the other with $0.00
3. Enter Distribution Details for Voucher Line 1: account 66000 amt 210.80
4. Enter Distribution Details for voucher Line 2: account 990002 and on the Statistics tab with the Statistics Amount $10
5. Run Voucher build
6. Process abends at Step FS_VATCALC.UpdBsAmt.Step01 with the above error

Changes

 

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