Restrict LOV of Standard Form to your requirement using Form Personalizaiton

Suppose you need to restrict the following LOV to current year's values only

You have to follow the following steps to achieve this

1) Open the form (.fmb) in Oracle Forms Developer. you can get the form name as shown below

2) Open the record group attached to the LOV and copy the query as shown below

 




select period_name, period_year, period_num from gl_period_statuses_first_60_v where ledger_id = :budget.ledger_id order by period_year asc, period_num asc

3) As you have obtained the query attached to the LOV now you can modify the LOV using the following steps

i) amend the query according to your requirement

SELECT   period_name, period_year, period_num FROM gl_period_statuses_first_60_v WHERE ledger_id = :budget.ledger_id AND period_year = TO_CHAR (SYSDATE, 'YYYY') ORDER BY period_year ASC, period_num ASC

ii) Do the Form Personlizations as shown below

Cheers ...

Last Screen shot shows the restricted LOV