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 28, 2018
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