Error App-Jl-62481: Ora-01422: Jl_zz_ap_withholding_pkg When Awt Type Code = Turn_bsas

(Doc ID 1256664.1)

Last updated on APRIL 13, 2018

Applies to:

Oracle Financials for the Americas - Version 12.0.6 and later
Information in this document applies to any platform.

Symptoms



When attempting to pay an invoice, and error is returned

ERROR
-----------------------
APP-JL-62481: ORA-01422: exact fetch returns more than requested number of rows occurred in JL_ZZ_AP_WITHHOLDING_PKG.Initialize_Withholding_Name with parameters ( AWT Type Code = TURN_BSAS, Tax Id = 45143, Vendor Id = 12003 while performing the following operation: Obtain tax name attributes for the supplier

IMPORTANT: this error only happens for Invoices with AWT Type Code = TURN_BSAS

### Steps to Reproduce ###
The issue can be reproduced at will with the following steps:

1. Enter an invoice with AWT Type Code = TURN_BSAS
2. Try to pay the invoice
3. Get the error

### Impact on Business ###
Due this issue, users cannot calculate withholdings when AWT Type Code = TURN_BSAS

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