My Oracle Support Banner

Colombia Globalization APP-JL-62481: Ora-06502: Pl/Sql Numeric Or Value Error: when validate (Doc ID 754884.1)

Last updated on MAY 17, 2018

Applies to:

Oracle Financials for the Americas - Version 12.0.4 and later
Information in this document applies to any platform.
This problem can occur on any platform.
Financials for the Americas - Version: 12.0.4
Oracle Application R12
Colombia/Argentine Globalization
jlzzpwhb.pls

Symptoms

-- Problem Statement:
On 12.0.4 in Production with Colombia Globalization
When attempting to validate an invoice, the following error is listed:

ERROR:
APP-JL-62481: ORA-06502: PL/SQL numeric or value error: character to number conversion error
occurred in JL_ZZ_AP_WITHHOLDING_PKG.Store_into_Temporary_Table

-- Steps To Reproduce:
Colombian Payables > Invoices > Entry > Invoices create an invoice try validating it.
Error message will be displayed

-- Business Impact:
The issue has the following business impact:
It is not possible to create Withholding Taxes or Validate Invoices for
Colombia

Changes

 

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!


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