Unable To Find Some Item On Template Assignment Form when Item length have more than 40 characters

(Doc ID 2317678.1)

Last updated on OCTOBER 31, 2017

Applies to:

Oracle Financials for India - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, GST

Unable to find some Item on Template Assignment form
There are some of item which item code length have more than 40 Var-char. All such items are not populated on Template Assignment form(Item Registration>Item Like>Find Item)

ERROR
-----------------------
FRM-40735:WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-06502

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

Navigation: Resp:Oracle Financial India>Item Definition > Defined Item classification
Item Registration>Item Like>Find Item

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot review item definitions

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