Skip to main content

I’ve created a new LoV using SQL Developer for use on our timeclock Start Production screen>Op ID field. I copied the LoV that was already assigned to that field and changed two of the fields to make the view more useful to our employees, and I matched the grants to the original view as well. I can see the LoV in the SQL Query Tool, and I can view all the data (which appears to be pulling correctly), but when I try to use it on the time clock, the list is completely empty with no error or indication of why.

Has anyone else had this experience? Any input would be appreciated. Thank you!

Hi,

 

Were all of the caches below refreshed after the new view was deployed?

 

If so and the LoV is still empty, could you open up the debug console and then use the LoV. Then locate the Server Invoke line and see if the query looks correct or has any filters. Example below shows this being used on the Shipment form for the Shipment Type LoV.

 

 

Regards

 

Telha


Reply