My Oracle Support Banner

E1: 42: 47: R42500 Does Not Ship Confirm Sales Order Line Which Was Generated and Updated By R47131 (Doc ID 3043977.1)

Last updated on AUGUST 30, 2024

Applies to:

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

Symptoms

If a Sales Order line is appended to an existing Sales Order through the R47131 (Ship Confirm Batch Application) report, and subsequently, the lot or location is updated using the same R47131 report, the R42500 process will not perform ship confirmation for that Sales Order line, despite the availability of inventory.

Below error can be seen in the log of report R42500:

Steps:

  1. Create a Sales Order using P4210 application.
  2. Create an entry in P47130 for the same sales order so that a new line with BLANK Lot-Location is added in the Sales Order. Ensure there is no inventory available on this lot-location.
  3. Run report R47131.
  4. New line (Line number 2) is created on the Sales Order with BLANK Lot-Location.
  5. Run R42500 report.
  6. Ship confirm was unsuccessful as there is no item available on the BLANK lot-location.
  7. Create another entry in P47130. This time update Sales Order (Line number 2) Lot-Location number with a lot number where inventory is available.
  8. Run R42500 report.
  9. Ship confirm was unsuccessful.
  10. In P47130 a new record was inserted by R42500 with BLANK Lot-Location.
  11. In the logs of Report R42500, Primary Key violation can be seen while trying to insert the record in F47132 (EDI Purchase Order Change Detail - Inbound) table.

Cause

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
Symptoms
Cause
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.