singe
Member
We are upgrading from 8.12 to 9.1. Unfortunately, Oracle has made some changes to P0005S (User Defined Code Search and Select) which make it very inefficient when searching by description on a UDC with many records. In this case, we have 5000+ records in the UDC for COUN (county) and it takes over 5 minutes to return the records.
I have created a new UDC lookup P550005S (just a clone of the 8.12 version of P0005S) which is more efficient. I have set the Visual Assist in the Data Dictionary for data item COUN to use P550005S, but the problem is it does not pass in the form interconnect values for the system and UDC codes (00|CT). How can I make these values pass in without having to modify every application that use the COUN field? Does the UDC rule only work with P0005S?
Thanks!!
I have created a new UDC lookup P550005S (just a clone of the 8.12 version of P0005S) which is more efficient. I have set the Visual Assist in the Data Dictionary for data item COUN to use P550005S, but the problem is it does not pass in the form interconnect values for the system and UDC codes (00|CT). How can I make these values pass in without having to modify every application that use the COUN field? Does the UDC rule only work with P0005S?
Thanks!!