Add Attribute Fields to Rate Offering and Rate Record

This feature provides you with a property driven approach for adding Flex Attribute Fields (Text, Number and Date) to your Rate Offering and Rate Record New, Edit and View UIs. The property approach for selecting the Flex Attribute Fields to add to the UIs was employed here since the more standard approach, utilizing Manager Layout capabilities would be a huge undertaking due to the Rate Cost screen which is why it was never done.

The Property approach supports the standard set of Flex Attribute Fields provided for an object:

ATTRIBUTE (1-20) VARCHAR2(150)
ATTRIBUTE_NUMBER (1-10) NUMBER
ATTRIBUTE_DATE (1-10) DATE

To add the desired Flex Attribute Fields to the UI (New, Edit and View) - the following Properties must be configured:

Flex Attribute Properties:

Field Name	Property to set	Example	Explanation
Attribute	glog.ui.displayFlexAttributes.<FINDER_SET_GID> Where <FINDER_SET_GID> = RATE_OFFERING or RATE_GEO	1:label.fieldName1,2:label.fieldName2,3:label.fieldName3	Specifies the flex attribute fields with respective labels to display on the front end. It should be specified as comma separated values of <flex field attribute>:<flex field attribute label>. For example if we have to display attribute1 with label as "User Defined Attribute 1", then the value should be specified as "1:label.attribute1". If multiple are there then separate the value by comma.
Attribute_Number	glog.ui.displayFlexAttributeNumbers.<FINDER_SET_GID> Where <FINDER_SET_GID> = RATE_OFFERING or RATE_GEO	4:label.Number4,5:label.Number5	Specifies the flex attribute number fields with respective labels to display on the front end. It should be specified as comma separated values of <flex field attribute number>:<flex field attribute number label>. For example if we have to display attribute number1 with label as "User Defined Attribute Number 1", then the value should be specified as "1:label.attributeNumber1". If multiple are there then separate the value by comma.
Attribute_Date	glog.ui.displayFlexAttributeDates.<FINDER_SET_GID> Where <FINDER_SET_GID> = RATE_OFFERING or RATE_GEO	6:label.Date6,7:label.Date7	Specifies the flex attribute date fields with respective labels to display on the front end. It should be specified as comma separated values of <flex field attribute date>:<flex field attribute date label>. For example if we have to display attribute date1 with label as "User Defined Attribute Date 1", then the value should be specified as "1:label.attributeDate1". If multiple are there then separate the value by comm

Field Name

Property to set

Example

Explanation

Attribute

glog.ui.displayFlexAttributes.<FINDER_SET_GID>

Where <FINDER_SET_GID> = RATE_OFFERING or RATE_GEO

1:label.fieldName1,2:label.fieldName2,3:label.fieldName3

Specifies the flex attribute fields with respective labels to display on the front end. It should be specified as comma separated values of <flex field attribute>:<flex field attribute label>. For example if we have to display attribute1 with label as "User Defined Attribute 1", then the value should be specified as "1:label.attribute1". If multiple are there then separate the value by comma.

Attribute_Number

glog.ui.displayFlexAttributeNumbers.<FINDER_SET_GID>

Where <FINDER_SET_GID> = RATE_OFFERING or RATE_GEO

4:label.Number4,5:label.Number5

Specifies the flex attribute number fields with respective labels to display on the front end. It should be specified as comma separated values of <flex field attribute number>:<flex field attribute number label>. For example if we have to display attribute number1 with label as "User Defined Attribute Number 1", then the value should be specified as "1:label.attributeNumber1". If multiple are there then separate the value by comma.

Attribute_Date

glog.ui.displayFlexAttributeDates.<FINDER_SET_GID>

Where <FINDER_SET_GID> = RATE_OFFERING or RATE_GEO

6:label.Date6,7:label.Date7

Specifies the flex attribute date fields with respective labels to display on the front end. It should be specified as comma separated values of <flex field attribute date>:<flex field attribute date label>. For example if we have to display attribute date1 with label as "User Defined Attribute Date 1", then the value should be specified as "1:label.attributeDate1". If multiple are there then separate the value by comm

To provide an example, the Properties above are configured below for both <FINDER_SET_GID> = RATE_OFFERING and RATE_GEO.

Flex Attribute Rate Offering and Rate Geo Example

With the Property Set configuration above, the Rate Offering and Rate Records will display the Flex Attributes as shown below.

For the Rate Offering -if any one of the three Properties is set, a new tab - Flex Attributes - will be displayed on the Rate Offering Manager -as shown below.

Flex Attribute Tab on Rate Offering Manager

Navigating to the Flex Attributes tab will show the configured Flex Attributes setup via the Properties.

Flex Attribute Tab on Rate Offering Manager

Like the Rate Offering - if any one of the three Properties is set, for the Rate Record, a new tab - Flex Attributes - will be displayed on the Rate Record Manager - as shown below.

Flex Attribute Tab on Rate Record Manager

Navigating to the Flex Attributes tab will show the configured Flex Attributes setup via the Properties above.

Flex Attribute Tab on Rate Record Manager

Below are the Flex Attributes as shown on the View manager layouts for the Rate Offering and Rate Record.

Flex Attribute Rate Offering View

Flex Attribute Rate Record View

This feature expands information access regarding your Rate Offerings and Rate Records - this additional information can be used to help with planning, execution and settlement activities.

Steps to Enable

To enable this feature, the Properties below must be configured. This page is accessed via Configuration and Administration > Property Management > Property Sets.

NOTE: Only the DBA.ADMIN user can access and use the Property Sets page.

glog.ui.displayFlexAttributes.<FINDER_SET_GID>
- Where <FINDER_SET_GID> = RATE_OFFERING or RATE_GEO

glog.ui.displayFlexAttributeNumbers.<FINDER_SET_GID>
- Where <FINDER_SET_GID> = RATE_OFFERING or RATE_GEO

glog.ui.displayFlexAttributeDates.<FINDER_SET_GID>
- Where <FINDER_SET_GID> = RATE_OFFERING or RATE_GEO

The examples above were based on the Properties as configured below: Property Setup Example

Property Setup Example