Cannot Identify Contents & Format Of Seeded LOV On Form From *.fmb File

(Doc ID 1542441.1)

Last updated on APRIL 06, 2017

Applies to:

Oracle Inventory Management - Version 11.5.10.CU2 to 12.2 [Release 11.5.10 to 12.2]
Information in this document applies to any platform.

Goal

WARNING: This Note discusses CUSTOMIZATIONS to Oracle Seeded Code. The note is provided for educational/informative purposes only. You can explore the techniques discussed at your own risk. Oracle Corp and Oracle Support CANNOT support Customized code.

You want to assign a custom LOV to the field MISC_TRX.TRANSACTION_SOURCE in the form INVTTMTX.
From the personalization utility within the forms application it appears that the LOV currently assigned to this field is ENABLE_LIST_LAMP but you cannot find such an LOV in the form when you open it up with Forms Builder.

You are able to generate the two columns of the LOV that are displayed when entering on the form with the following query:

What is the query currently in use to populate the LOV associated with the field MISC_TRX.TRANSACTION_SOURCE within the INVTTMTX form?
What is the proper way to do this?

Solution

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