My Oracle Support Banner

E1: 42: When Ship Confirm (P4205) Splits Line it Does Not Copy Characterize Object Fields to Split Line it Creates in Media Object Categories (F00166) Table (Doc ID 2943899.1)

Last updated on JULY 02, 2023

Applies to:

JD Edwards EnterpriseOne Sales Order Entry - Version 9.1 to 9.2 [Release 9.1 to 9.2]
Information in this document applies to any platform.


When Ship Confirm (P4205) is used to perform a partial shipment and splits a line that had an attached text note, it does not copy the Characterize Object fields populated in the Media Object Categories (F00166) table to the split line it creates.

Steps to Duplicate

  1. In Work with Media Object Category Constants (P00167):
    1. Enter GT3211A
    2. Click Find and Sales Order Detail appears in the grid.
    3. Select the record
  2. Go into the Media Object Category Constants Revisions (P00167):
    1. On General tab, check the checkbox for two fields one of which is a Date field.
    2. On the Alternate Keys tab, check the Business Unit Checkbox.
    3. On the Categories Tab, check the Category Code 1 checkbox and save the settings.
  3. Now use Sales Order Entry (P4210) to create a 1-line Sales Order for 50 Units
    1. Take the Row Exit to Detail Attachments
    1. On the Attachment Manager click “+” to add a text note.
    2. Select the Text Attachment Button
    3. Type in and Save your Text Note
    4. The Text attachment object appears in the Attachment Manager
    5. Right-click on the Text Attachment Object and select “Characterize” from the drop-down list.
    6. On the Media Object Category Revisions, General Tab, populate the Description and Creation Date fields.
    7. On the Alternate Keys tab, populate the Branch Plant.
    8. On the Categories Tab, populate Category Code 1 and click the green checkmark to save
    9. On the SO Detail Revision (P4210) screen, paper clip appears. Click Save.
  4. After saving the order, use the Databrowser to find the record created in the Media Object Categories (F00166) table.
    1. Enter GT4211 in the Object Name
    2. Enter <Order Number>* in the Generic Text Key
    3. Click Find
    4. Confirm the Media Object Categories fields such as “Description” have been populated on the Sales Detail record
  5. Go into Work with Shipment Confirmation (P4205)
    1. Enter Order Number
    2. Click Find
    3. Take the Form Exit to Confirm Shown Rows
    4. Change the Quantity Shipped from 50 to 20 to perform a partial shipment and split the line and click OK.
  6. Return to Customer Service Inquiry (P4210) and click Find:
    1. The original line 1.000 has the paperclip
    2. The split line 1.100 has the paperclip
  7. Go into SO Detail Revisions, select the split line, right-click on the attachment and select Characterize from the drop-down list.
    1. The Media Object Category fields are blank on the attachment for the split line. They were not copied from the original line.
  8. Return to Databrowser for Media Object Categories (F00166) and click Find
    1. There was no record created for the split Line 1.100



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

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