This mode is used to define relationships between items and entities such as old item numbers or supplier item numbers.
You can assign multiple cross-reference types to an item.
This mode has three sections:
1. Item section is used to enter information into the worksheet and validate the information.
2. The ‘Cross Reference’ section is used to Create, Update or Delete a Cross Reference to an Item.
3. The ‘Cross Reference DFF’ section is used for descriptive flexfields.
Item Number, Organization, Cross Reference Type and Cross Ref Value are the unique identifier of the record.
Item Description is a read only field and it will populate the master item description.
Update and Delete Cross References are allowed.
Cross Reference Form
To open the user form, double-click in a cell in the Cross Reference Section on the row you wish to populate the Cross Reference data (must be below row 10).
The following ‘Cross Reference’ form will display:
The fields displayed are the columns that were on the active sheet when the Wizard was initialized. You can enter data directly into the form and use the list of values supplied.
• Item Number must exist in the Items section and is a required field.
• Cross Reference Type - This is a required field.
• Applicable To All Organizations – This is a required field.
• Organization – If ‘Applicable to All Org’ is ‘No’ then this is a required field.
• Cross Ref Value – This is a required field. When creating a cross reference this field needs to be populated with a value, if it doesn’t already exist. If the value does exist, it will display the current cross reference value when it is downloaded.
• New Cross Ref Value – When updating a cross reference, this field needs to be populated with a value and will overwrite any value in the ‘Cross Ref Value’ field.
• ‘Cross Ref Description’ and ‘Dff Cross Reference’ – Data for these fields can be created and any existing data updated.
GTIN – Cross Reference Type
• Unit of Measures only required if the profile ‘INV: GTIN Cross Reference Type’ is set to same as ‘Cross Reference Type’. If error persists on this UOM field then check this profile in Oracle.
• If the following error is received “'SS_ITEM_XREF' & 'GTIN' are not supported” “an Oracle patch is required - Please refer to ‘API For GTIN Cross Reference Ends With Error SS_ITEM_XREF Cross Reference Types IS Not Supported (Doc ID 1936086.1)” in Oracle support.
• Due to an Oracle API limitation, updating duplicate GTIN Cross References (same UOM and same GTIN Value) are not supported. Workaround is to delete it and create a new one with the updated information. These can be done in one go.
Cross Reference Customization Callout
To enable customization of Cross Reference values, you must ensure that the "More4Apps: IW Enable Extension Pkg" profile in Oracle is set to 'Yes'. Once this is done, you can enter your own PL/SQL to validate the Cross Reference values based on your specific business requirements. For example, if you only want to allow creation in V1 Organization, you can set the appropriate SQL in the custom package. This functionality is made possible by the Item Wizard Custom Package.
Set the Cross Ref Upload Action to ‘Create’ and select an organization other than V1 as shown below:
Then upload the data as per the standard upload process. When the upload is complete the organization field will fail with the error “You are not allowed to create/update on this organization”.
Refer to the Custom Package section of this document for instructions on how to initiate this feature.
Cross Reference DFF Form
To open the Cross Reference DFF form, double-click in a cell in the Cross Reference DFF section on the row you wish to populate the Cross Reference DFF data (must be below row 10), or click the ‘Cross Reference DFF’ tab on the Cross Reference form.
The following ‘Cross Reference DFF’ form will display:
If you previously downloaded your Item first (See the Download Translations section), and there are some DFFs you wish to load, enter the DFF for upload.
When these are populated along with the Cross Reference section the record can be uploaded.
Refer to section:
