How to Increase the Value Limit in the Action Reason Client LoV

You can increase the limit of 25 values in any client list of values (LoV) used in Oracle HCM Cloud. Here’s an example procedure to increase the values to more than 25 in the action reason client LoV used in termination pages.

The example uses this test data:

• Action: Resignation
• Associated Action Reasons (30 count): Resignation Reason 01 to Resignation Reason 30

Note: Increasing the count of values in the client LoV may lead to performance degradation and affect user experience.

Create and Enable Sandbox

1. Click Navigator > Configuration > Sandboxes.
2. Click Create Sandbox.
3. Enter the Name.
4. Select the Active check box for the HCM Experience Design Studio and Page Composer options.
5. Click Create and Enter.

Verify Count of Action Reasons on Termination Page

1. On the Home page, select My Client Groups > Employment > Termination.
2. Search and select the person for whom you want to see the action reasons.
3. On the Terminate Work Relationship page, select the Resignation action and expand the action reason.
   Note: You will see 25 action reasons are displayed (Personal Reasons, Resignation Reason 01 to Resignation Reason 24).

Configure the Action Reason LOV to Display More Than 25 Items

1. On the Tools menu, select Page Composer.
2. Click the Structure tab, and then select the action reason field.
3. In the Confirm Shared Component Edit dialog box, click Edit.
4. Scroll down to the bottom of the page and drag the tool bar upward so that you see the page components.
5. Click the Edit Component link next to the secureInputSearch component.
6. In the Confirm Shared Component Edit dialog box, click Edit.
7. Click the searchSection component, and then click the Show the properties of searchSection icon on the toolbar. The data URL for the component is displayed in the dialog box.
8. Copy the value in the Data Url field to a text editor. The value will be as follows: #{backingBeanScope.TerminationWhenAndWhyBean.terminationReasonDataURL}
   Note: The Data URL value is used to fetch the REST API response. By default, this value is limited to 25. You can increase the default value by adding your desired parameter limit.
9. Edit the value to append a limit clause at the end (#{'&limit=50'}). The number 50 signifies that 50 rows need to be shown in the action reason field. The edited value will be as follows: #{backingBeanScope.TerminationWhenAndWhyBean.terminationReasonDataURL}#{'&limit=50'}
10. Expand the Data Url field and select Override.
11. Expand the Data Url field again and select Expression Builder.
12. Copy the edited value from step 9 to the Type a value or expression field and then click OK.
13. Click Apply, and then click OK.
14. Click Close to exit Page Composer.
15. Navigate to the action reason field in the Terminate Work Relationship page. You will see all the configured values in the action reason field.