My Oracle Support Banner

Error App-Jl-62481: Ora-01422: Jl_zz_ap_withholding_pkg When Awt Type Code = Turn_bsas (Doc ID 1256664.1)

Last updated on AUGUST 14, 2019

Applies to:

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


When attempting to pay an invoice, and error is returned

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


To view full details, sign in with your My Oracle Support account.

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

In this Document

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