My Oracle Support Banner

E1: 41: Can the Data Relationship Functionality be Extended to the Item Master (F4101) Table? (Doc ID 2598544.1)

Last updated on OCTOBER 14, 2019

Applies to:

JD Edwards EnterpriseOne Inventory Management - Version 9.2 and later
Information in this document applies to any platform.

Goal

In the JD Edwards EnterpriseOne Applications Financial Management Fundamentals Implementation Guide it describes how to setup data relationships functionality and it mentions two tables that support the functionality, the Business Unit Master (F0006) and the Contract Master (F5201).

Is it possible to extend this functionality to the Item Master (F4101)?

For Example:

  1. Sales Category Code 4 would be the Basis Column. In this example 777 (Mountain Bikes) is entered.
  2. Sales Category Code 5 and Commodity Class would be Relationship Columns linked to Sales Category Code 4.
  3. In this example 158 (Bike Accessories) would be a valid value for Sales Category Code 5 and ACC (Accessories) would be a valid value for the Commodity Class.
  4. Other values in the underlying UDC tables that have nothing to do with Mountain Bikes or Bike Accessories would be filtered out and not available in the list of values presented for Sales Category Code 5 and Commodity Class.
     

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.