Oracle Time and Labor Layouts - Changing Prompts

One of the simpler requirements in OTL layout customizations is to change the prompt and other labels appearing on the layout. The following steps guides to achieve this.

Sample Requirement

In the timecard entry layout, change the prompt for Expenditure Type from "Type" to "Exp Type"

Steps

1. Identify the name of the layout to be modified. You can use the below SQL to identify the name of the layout.
Oracle Time and Labor: Identify Layout



2. Once you have the layout name, execute the below SQL which will display all components in the layout.

SELECT comp.component_name

      ,comp.region_code

      ,attr.name attribute_name

      ,attr.attribute_label_long   attribute_prompt

      ,region.attribute_label_long region_item_prompt

FROM   hxc_layout_components comp

      ,hxc_layouts_vl        lay

      ,ak_region_items_vl    region

      ,ak_attributes_vl      attr

WHERE  lay.layout_id = comp.layout_id

AND    attr.attribute_code(+) = comp.attribute_code

AND    region.region_code = comp.region_code

AND    region.attribute_code = comp.attribute_code

AND    lay.layout_name = '&Layout'

ORDER  BY comp.sequence;

 3. Identify the component from the result set. This can be done easily since the label appearing on the front end will be listed either as ATTRIBUTE_PROMPT or as REGION_ITEM_PROMPT.

4. Navigate to "AK Developer" responsibility and navigate to "Define Regions" page.

5. Query up the Region Code from the result set on the screen.

6. Open "Region Items" page and query for the attribute code from the result set

7. Scroll to "Long Label" field and change the prompt to new value. Save the record.

Verify Results

Navigate to the page again to verify the results.

Warning

The region is usually shared with other layouts. If you want to change only one layout, then it will be better to create a custom attribute and customize the required layout to use the custom attribute, instead of the standard layout