How to customize Concurrent Program Setup Objects without Value Set.
说明
Usually, Oracle uses this .lct (AFCPPROG.lct) file that extracts all the value sets. Is there a way to customize the Concurrent Program to run without the value sets?
原因
Usually, the .lct files are Oracle proprietary and support doesn’t handle customization. In this specific case, the resource kit 1.4 (StatRK_FND.sql) brings a solution to limit the extraction of the value set.
解决办法
Solution. 1. Download the Resource Kit 1.4 2. Unzip the Resource Kit 1.4 file. 3. Edit the StatRK_FND.sql file, and uncomment the solution listed at line 670 “AOL Concurrent Programs wo Value Sets”. 4. Run this script against the Stat Repository.
