Add Dependent Custom Field for Business Subclassification in Redwood Supplier Registration

We have a requirement to enhance the Redwood Supplier Registration functionality, specifically within the Business Classification page.

Currently, Oracle provides sub-classification options only for Minority-Owned classifications. However, for other seeded or user-defined classifications, there is no provision to define or capture sub-classifications.

To address this, we are looking to add a custom field named "Sub Classification" on the Business Classification page. The key requirement is that this custom field should support a dependent List of Values (LOV) — meaning the available values in the "Sub Classification" field should dynamically change based on the value selected in the seeded "Business Classification" field.