GTM_TRANSACTION_LINE Flex Field Definition Displayed Incorrectly on Transaction Line Manager Layout (Doc ID 2123579.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

ACTUAL BEHAVIOR
---------------
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.


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


STEPS
-----------------------
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.

Cause

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