R12:JL:AP: JLZZPCWH Error "ORA-01422: exact fetch returns more than requested number of rows" in Company Withholding Applicability
(Doc ID 2229891.1)
Last updated on JULY 28, 2022
Applies to:
Oracle Financials for the Americas - Version 12.1.3 and laterOracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.
Symptoms
On : 12.1.3 version, Colombian Payables
When attempting to see Company Applicability,
the following error occurs.
ORA-01422: exact fetch returns more than requested number of rows.
The issue can be reproduced at will with the following steps:
1. Responsibility: Oracle Payables - Colombia localization
2. Path: Colombia Localization -> Company Applicability
3. Query the Legal Entity
The following error occurs:
ORA-01422: exact fetch returns more than requested number of rows.
The issue started after updating the geography setup in TCA.
Cause
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
Symptoms |
Cause |
Solution |