My Oracle Support Banner

E1: 31: F3111.CPNB Does Not Match F4111.LNID When Using the R31410 (Order Processing) W/PreFlush & 21CFR11 Auditing Turned On (Doc ID 2687190.1)

Last updated on JULY 03, 2020

Applies to:

JD Edwards EnterpriseOne Shop Floor Control - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

F3111.CPNB does not match F4111.LNID when using the R31410 (Order Processing) with Pre-Flush and Auditing (21CRF11) is turned on  (Code of Federal Regulations)

When Audit Tool CFR11 is activated (ON), and Work Order Processing (R31410) setup to Pre flush (issue) components, R31410 inserts lines in WO Parts List and Cardex with different F3111.CPNB does not match F4111.LNID  (IM transaction)

When not pre-flushing material with R31410 and Work Order issues (P31113) is used to issue the parts, the F3111.CBNB and the F4111.LNID match perfectly. 

AUDITING TURNED OFF:  

  1. Insert into F3111.
  2. Read the max CPNB from F3111
  3. Program is set to “AddMode” so it Increments CPNB by 1.
  4. Insert into F4111 setting LNID = CPNB value determined in Step 3.

After the record is inserted into the F3111, the record has not been committed to the DB and cannot be read from the database yet. When it hits step 2, it attempts to read the max CPNB value from F3111 where It does not find a value.
The Program is set to “AddMode” which increments the CPNB by 1 (0+1=1). It then writes the value of 1 to F4111 in the LNID.

 

AUDITING TURNED ON:  
After the record is inserted into F3111_ADT, the record is committed and is immediately available to be read from the database. When it hits step 2 it reads the max CPNB from F3111 which is 1.
The program is set to “AddMode” so it increments the CPNB by 1 to 2 (1+1=2).  It then writes the value of 2 to F4111 in the LNID which is WRONG.
 

Changes

 

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
Changes
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.