Monday, January 28, 2008

No of Rows displayed in a JSP page (Oracle Apps 11.5.9)

Number of rows in a page is governed by profile option 'JTF_PROFILE_DEFAULT_NUM_ROWS'. The value of this profile option can be any positive number. If a user want to change it's value using JTF menu, then available values are determined by lookup type 'JTF_DISPLAY_ROWS_LOOKUP_TYPE'. Lookup codes associated with this lookup type tell the number of rows to be displayed in a page. Seeded value of this lookup codes are

  • 5
  • 10
  • 15
  • 25
  • 30
  • 50
  • 100
if you want more number of rows in a jsp page then you have 2 options
  1. Change the value of profile option 'JTF_PROFILE_DEFAULT_NUM_ROWS' for a specific user/responsibility using sys admin responsibility.
  2. Add a new lookup code with value for lookup code =1000, meaning = 1000 and let user change it using Profile->Display Preferences and change the value associated with 'Display rows Per Page'

No comments:

Post a Comment