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!
Question
Custom LoV on Timeclock
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.