An Oracle White Paper

April 2012

Introduced in Release 6.0

E29324-01

Referenced Item Collections Replaced

# Overview

Applications: All applications using extended attributes

Focus Area: Extended attributes

Using the qualitative lookup extended attribute, you can now create extended attributes that reference existing ADMN lists for core fields such as allergens, additives, countries, etc. All common lookups are available. This feature will replace Referenced Item Collections. Reference Item Collections are being deprecated.

# The Basics

Via ADMN you can now define an extended attribute as “Qualitative Lookup”. Next you will select a style and then finally you will select a “Lookup Category”. In this list you will find many of the core attributes described in ADMN.

Example 1: This is an example of adding the Lookup Category to the EA. In this case you are adding “Allergens”.

Figure 1. Lookup category added to extended attribute

Example 2: This example represents the extended attribute created in Example 1 when it is used on a specification. Note that the Style must be carefully thought through in order to determine the most efficient method for managing data. In this example, we do not recommend using the multi-select check boxes functionality for Allergens.

Figure 2. Extended attribute used on specification

Referenced Item Collections Replaced March 2012 Oracle Corporation World Headquarters 500 Oracle Parkway Redwood Shores, CA 94065 U.S.A. Worldwide Inquiries: Phone: +1.650.506.7000 Fax: +1.650.506.7200 oracle.com | Copyright © 2012, Oracle and/or its affiliates. All rights reserved. This document is provided for information purposes only and the contents hereof are subject to change without notice. This document is not warranted to be error-free, nor subject to any other warranties or conditions, whether expressed orally or implied in law, including implied warranties and conditions of merchantability or fitness for a particular purpose. We specifically disclaim any liability with respect to this document and no contractual obligations are formed either directly or indirectly by this document. This document may not be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose, without our prior written permission. Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. UNIX is a registered trademark licensed through X/Open Company, Ltd. 1010