Value Set for latest 13 AR periods with statuses C,F and O Order by period year

Hi All,

Table Name :-  (select * from gl_period_statuses where set_of_books_id=1 and application_id=222 and period_name not like 'ADJ%'  order by period_year desc, period_num desc) a

Value :             a.PERIOD_NAME

Where/Order By :   a.closing_status in ('C','F','O') and rownum<13 order by a.period_year desc, a.period_num desc

is compiling But when we open in front end I am encountering an error

Please help.Do we have any Seeded Value Set or what mistake I am doing.