JLZZPSWH Errors ORA-01403 FRM-40735 ORA-06502 In Supplier Applicability Form (Doc ID 2074649.1)

Last updated on NOVEMBER 05, 2015

Applies to:

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

Symptoms

On : 12.2.4 version, Argentina Payables

When attempting to update the Supplier Applicability,
the following errors occur.

ORA-01403 No Data Found.
FRM-40735: POST-QUERY trigger raised unhandled exception ORA-06502.

The issue can be reproduced at will with the following steps:

1. Responsibility: Oracle Payables - Argentina localization - upgrade from 11 to 12.2.4
2. Path: Localization -> Setup -> Supplier Applicability (JLZZPSWH.fmb 120.15.12020000.8 - latest version)
3. Query a supplier
The following error occurs when querying the supplier:

ORA-01403 No Data Found.
FRM-40735: POST-QUERY trigger raised unhandled exception ORA-06502.

The Tax Authority Type field (TAX_TYPE_DSP) in the Supplier withholding Applicability form is truncating causing the error.

Workaround: Reducing the value entered in the lookup works, but this is not feasible.

The issue has the following business impact:
Due to this issue, users cannot update the record.

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