My Oracle Support Banner

E1: 42: Item Cross Reference FAQ (P41026/P4104/P4210/P42101/P4310) (Doc ID 2363953.1)

Last updated on APRIL 24, 2023

Applies to:

JD Edwards EnterpriseOne Sales Order Management - Version XE and later
JD Edwards EnterpriseOne Sales Order Processing - Version XE and later
JD Edwards EnterpriseOne CRM Sales Order Entry - Version XE and later
JD Edwards EnterpriseOne Inventory Management - Version XE and later
JD Edwards EnterpriseOne Sales Order Entry - Version XE and later
Information in this document applies to any platform.


This document provides answers to some frequently asked questions on Item Cross Reference (P41026/P4104/P4210/P42101/P4310).

Questions and Answers

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
Questions and Answers
 Question 1: Is there a batch program that will apply substitute items to previously created order lines?
 Question 2: Should Item Cross Reference (P4104) allow entry for multiple records with same 2nd Item Number (LITM), Address Number (AN8), Cross-Reference Type Code (XRT), and Expiration Dates (EXDJ) but different Cross Reference Item Numbers (CITM)?
 Question 3: Is there an interoperability process to populate the Cross Reference File (F4104)?
 Question 4: Can a different X-Ref type (XRT) be used for a customer number cross reference other than 'C'? For example a 'T'.
 Question 1: Is there a way to enter F4104 records using the parent type of functionality if each of the sold to/ship to records are tied to a parent?
 Question 2:  Is there a method to create C type item/customer cross reference records at the Ship To level?
 Question 3: Why isn't the Customer Item Number (CITM) displaying in Customer Service Inquiry, P4210 and screen even once the P4104 is setup properly?
 Question 4: Is it possible to create a sales order (P4210) using customer part numbers?
 Question 5: When using substitute on a sales order generated from a sales quote, is it normal for the sales quote to re-open?
 Question 6: How is the MCU populated in the F4104 table?
 Question 7: Why does P4210 sales order entry program fetches item description fields (DSC1 and DSC2) value from item master (P4101) program for the substitute item (item cross referenced in P4104) and not from item cross reference program (P4104)?

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