Use the Refresh of Classification Denormalization program to perform a data refresh to populate the HZ_CLASS_CODE_DENORM denormalization table. This table is populated from these source tables:
FND_LOOKUP_TYPES_TL
FND_LOOKUP_VALUES
HZ_CLASS_CATEGORIES
HZ_CLASS_CATEGORY_USES
HZ_CLASS_CODE_RELATIONS
You should schedule this program to periodically run, but manually run the program under the following circumstances:
The first time you install a patch which contains the classification feature.
Every time you enter or update classification related data outside of the Administration tab. For example, run the program if you enter or update lookups in Oracle Receivables.
Every time you install a HZ or FND patch that has added more seeded data for classifications.
Attention: In order to see the changes you have made, you must bounce the middle tier.
Class Category: Enter the class category that you want to refresh data for. If you leave this parameter blank, the entire HZ_CLASS_CODE_DENORM denormalization table is refreshed.
Debug: Specify if you want to run the program in debug mode or not.
SQL Trace: Specify if you want to do SQL statement tracing or not.