My Oracle Support Banner

E1: 76B: Brazil Sales Order Entry (P4210) From Spreadsheet Copy & Paste Does Not Populate All the Lines in Brazil Localization Files (F76422 and F76B4210) (Doc ID 2994873.1)

Last updated on FEBRUARY 27, 2024

Applies to:

JD Edwards EnterpriseOne Sales Order Processing - Version 9.2 and later
Information in this document applies to any platform.


When Sales Order Entry (P4210) is used with Spreadsheet Copy & Paste to create a Brazil Localization Sales Order with more than 7 lines, Sales Order Detail Tag File - Brazil – 42 (F76422) and Tag file F76422 - Sales Order Detail - BRA - 76B (F76B4210) are not created with the same number lines.

Steps to Duplicate

  1. Create a spreadsheet with 10 lines and 3 columns populated.
    1. Line Number, Item Number and Quantity Ordered.
    2. Enter non-sequential line numbers.
    3. Larger Line Numbers precede smaller line numbers in some cases.
  2. Set Processing Options in the Version of Brazil Localization Sales Order Entry (P4210)
    1. Set Process Tab Option #3 (Display Header or Detail) = 1 (Add Header First)
    2. Set Process Tab Option #5 (Display Before Accept Prompt) = 1 (prompt to display changes before accepting order)
  3. Enter Brazil Localization Sales Order Entry (P4210) Enter Header Data and click OK twice to go to Detail.
    1. In the first line number cell paste in the line numbers column from the spreadsheet only. Move the cursor to the quantity field.
    2. Copy the first 10 Item Number and Quantity values from the spreadsheet.
    3. Paste the data into the Item Cell and the 10 rows are populated. Position the cursor on the first Revenue Business Unit cell of the grid.
    4. Manually key in a different Revenue Business Unit on all 10 lines. Click OK.
  4. The Order Acceptance screen appears. Click the Place Order Button to save the order.
  5. Click OK on Brazil Header (P4210BR)
  6. Click OK on Brazil Detail (P4210BR) and save order.
  7. Use Customer Service Inquiry to inquire on the Order, select a line and Click OK.
    1. When the header is displayed, click OK twice.
    2. Select the first Sales Order Detail (F4211) line and take the Row Exit to Regional Info.
    3. On the SO Detail Brazilian Information screen for the order line, all the fields are blank because the data from the SO Brazil Detail screen was not saved in the F76422 and F76B4210 Brazilian Tag files.
  8. Enter Databrowser. Check Sales Order Detail Tag File - Brazil – 42 (F76422). Find the order.
    1. Confirm that only 4 of 10 sales order lines were created.
  9. Then check Tag file F76422 - Sales Order Detail - BRA - 76B (F76B4210). Find the order.
    1. Confirm that that only 4 of 10 sales order lines were created.


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.