GTM_TRANSACTION_LINE Flex Field Definition Displayed Incorrectly on Transaction Line Manager Layout

(Doc ID 2123579.1)

Last updated on APRIL 04, 2016

Applies to:

Oracle Global Trade Management - Version 6.3.6 to 6.4.2 [Release 6.3 to 6.4]
Information in this document applies to any platform.


A flex field definition is created for a user defined attribute for the GTM_TRANSACTION_LINE table. The Flex Field is defined to be of field type 'PickList'. When viewing the manager layout that has this additional field added, the flex field is displayed as a regular text field instead of the defined field type of PickList.

It is expected that the newly added flex field would be of the "PickList" type, and contain the 'find/list/view/new' button options.

The issue can be reproduced with the following steps:

1. Navigate to Configuration and Administration -> User Configuration -> Flex Field Definition
2. Create a new flex field definition for table GTM_TRANSACTION_LINE and assign it an attribute (Ex. Attribute5).
3. Select 'PickList' for Field Type and select a Query Table ID (Ex. CONTACT)
4. Navigate to Configuration and Administration -> User Configuration -> Manager Layout
5. Create a customer manager layout by copying the "GTM Transaction Line" layout in the PUBLIC domain
6. Add the field to the manager layout and assign it a label and value of 'User Defined Attribute X', where x is the attribute number chosen in step 2.
7. Assign the manager layout to a screen set which is assigned to the user menu
8. Navigate to the respective newly created screen from the menu.
9. Open a transaction line and the newly added flex field will be displayed as a regular text field instead of a PickList.

Note:  The issue is not only restricted to field type 'PickList'. The same behavior is observed when creating a field with type 'FixedDropList' and 'FlexPickList'.  The flex field definition type of 'PickList' is used here as an example.



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