My Oracle Support Banner

Frm-40212 Lov Attribute Field Error On Attachment Addition Rule Form (Doc ID 1389912.1)

Last updated on SEPTEMBER 16, 2019

Applies to:

Oracle Order Management - Version and later
Information in this document applies to any platform.
Form:OEXATRUL.FMB - Attachment Addition Rules


On : version, Product Utilities

When attempting to to enter a partial lookup value within the "Attribute Value" field of the Order Management "Attachment Addition Rules" (OEXATRUL) form,
the following error occurs.

The find is successful when using a % sign to search, then it builds the list-of-values.
This behaved as expected on 11.5.9.

"FRM-40212: Invalid value for field ATTRIBUTE_DISPLAY_VALUE"

The issue can be reproduced at will with the following steps:
1. Login with Order Management Manager Responsibility
2. Setup->Orders->Attachments->Documents
3. Query on "Documents" form
4. Clink on "Addition Rules" button, which opens the OEXATRUL form
5. In "Attachment Addition Rules" form, Add one row to the "Rules" section.
6. Enter Group Number, Attribute Value (Bill To)
7. Enter partial lookup value "ASSOC" and enter <TAB>

Giving FRM-40212: Invalid value for field ATTRIBUTE_DISPLAY_VALUE

Partial Search on Attribute Value does not build/display the list of values as expected.

The issue has the following business impact:
Due to this issue, users cannot a partial value to reduce the list of "Attribute Values"
when creating Addition Rules for a document.


Recently upgraded the database from to 11g.


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

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