Some more interesting tips with Oracle EBS Validation Set in R12. A Frequent Request is to Filter some of the other valuesets by Date e.g. only Purchase Orders between two date. To Do this we need to Create a From Date Value Set of type FND_STANDARD_DATE.

The list of Purchase Orders in the Validation Set need to be filter by this date. You would think that the value returned by FND_STANDARD_DATE would be a date but it is not. It is a character that needs formatted e.g. TO_DATE(, ‘YYYY/MM/DD HH24:MI:SS’),

So in the Validation Table Information screen do the following

 l_reqid := fnd_request.submit_request
_date  >=

   TO_DATE(:$FLEX$.FIN_PO_FROM_VS, 'YYYY/MM/DD HH24:MI:SS')
(application =>
,program => 'XX...' -- child prg short name
,description => ''
,start_time => SYSDATE
,sub_request => TRUE
,argument1 => xx.xx1 -- child prg arguments
);

fnd_request.wait_for_request ...