E1: 42: Database Recod Lock Updating F4102 MRPC Net Change Flag (Doc ID 2000444.1)

Last updated on NOVEMBER 06, 2015

Applies to:

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

Symptoms

When creating a SD order using P42101 ZJDE0005 based on a SB order for an item having Net Change Flag(F4102.MRPC) NULL, the SD order is not saved in database and the Net Change Flag(F4102.MRPC) is not updated with '1'.

Steps:

  1. P4101/P41026:  Create an item and assign it to B/P 30; verify the F4102.MRPC (MRP Net change indicator) value is NULL
  2. P4210 ZJDE0004 (Sales Order Entry = SB Order Type): Enter a blanket order (SB) for the item and verify MRP Net change indicator =>  F4102.MRPC is 1
  3. Run R3482 MRP over the item and check F4102.MRPC = NULL
  4. P42101 ZJDE0005 (Sales Order Entry = SD Order Type): Enter a direct ship order (SD) for the item, line released from the blanket (Row Exit => Blanket Release) => Submit and Close
  5. P42101 ZJDE0005: Query for SD order, no data returned
  6. Verify MRP Net change indicator, F4102.MRPC = NULL

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms