You can review any predefined or new lookup types in the Receivables Lookups window. You can update a lookup type only if its access level is either User or Extensible. Receivables requires that lookup types that have an access level of System remain unchanged for its own internal use.
You can always update lookup types that you create. However, although you can make a lookup inactive, you cannot delete a record from a lookup type, regardless of its access level.
Note: When defining your organization types during Oracle Receivables setup, you need to switch to the Oracle Purchasing responsibility, navigate to the Lookups window, then define the ORG_TYPE lookup. Then, switch back to the Receivables responsibility to continue Oracle Receivables setup.
For detailed information about defining and updating lookups, see: Application Utilities Lookups and Application Object Library Lookups.
Attention: Lookups in Receivables are maintained by the FND_LOOKUP_VALUES table, which requires that values in both the LOOKUP_TYPE column and the MEANING column be unique. Since this requirement is new, you may have legacy data in the MEANING column that Receivables would now consider to be duplicate data.
In these situations, where you might have duplicate data in a lookup, Receivables will append the "at" sign (@) to all subsequent duplicates in order to differentiate the entries from each other and to satisfy the requirement that each entry be unique.
For example, you might have a LOOKUP_TYPE of "Flavors," a LOOKUP_CODE of "Vanilla," and a MEANING of "Ice Cream Flavor." This same MEANING, then, might be used in your LOOKUP_CODEs for "Mint Chip," "Chocolate," and "Butter Pecan." Receivables will adjust the multiple "Ice Cream Flavor" entries in the MEANING column this way: @1@Ice Cream Flavor, @1@@Ice Cream Flavor, and @1@@@Ice Cream Flavor, and so on. Note that the number 1 (as in @1@) may change, depending upon the selected value.