I want to sync a PPM validation to a third party data that comes as a flat file. I could import the data in PPM's validation tables and then flush the cache or import the data into a new db table and build the validation dynamically with an SQL statement on the top of it... but I'd like to know if there's a best practice approach in this scenario?
Is it a Drop Down Validation. If it is then you convert the flat file into excel and then use XML import utility to import the validation. So when ever the validation from the 3rd party changes you have to do it again. Also I have seen that there can be a request type which can be utilized to automatically update the validations through some execution steps.
Unfortunately, your solution can't be applied to our case, because it requires a manual action. The solution I'm talking about has to be fully automated, because there's a big chance that the validation could be updated daily. In my mind it looks more like a scheduled PPM report which executes some script/program/pl sql and refreshes the validation.