My Oracle Support Banner

WS: 31: F3 Exit from Super Backflush Can Create Inconsistent Data in the Files, A7.3, A8.1 (Doc ID 1347659.1)

Last updated on MAY 23, 2017

Applies to:

JD Edwards World Shop Floor Management - Version A7.3 cume 12 to A7.3 cume 16 [Release A7.3]
JD Edwards World Shop Floor Management - Version A8.1 cume 2 to A8.1 cume 6 [Release A8.1]
JD Edwards World Shop Floor Management - Version A9.1 and later
Information in this document applies to any platform.
A7.3 and A8.1 procedural information to improve comprehension of Super Backflush and transaction sets.


Symptoms

Pressing function key F3 (exit) from Super Backflush (P31123) along with the programs that Super Backflush calls, can create inconsistent data in the files that are updated. This situation can be caused by Exiting with F3 from Super Backflush when warned that an over completion is about to occur.

Pressing the F3 function key after quantity is reported and warning 014O Warning -Quantity creates Overcompletion, is encountered.  Backing out of the transaction set, results in inconsistent data update to the files.

When the Work Order Quantities Status (P31122 in A7.3) program is checked,  it confirms that completed units in the work order header are not updated, but the detail of the actual units reported is (F31122).

In A8.1, the Production Status program (P31226) can be used to check what data is updated.

Alternatively, query the files directly by work order number to confirm what was updated and what was not. The files to query are as follows:

Changes

Hours and Quantities (P311221)

WO Quantities Status:

  1. The header information of the screen comes from the Work Order Master table (F4801) and when Completions (P31114) are performed, P31114 updates the completed quantity in the header.
  2. The detail information comes from the Shop Floor Control Routing Instructions table (F3112).
  3. When Super Backflush (P31123) is performed, once the values are entered and accepted in the first screen (P31123), the values update the Quantity Shipped (SOQS) field in the work order routing file (F3112).

A7.3 or A8.1

Super Backflush (P31123) programs transaction flow is:

• Work order completions (P31114)
• Work order inventory Issues (P31113)
• Hours and Quantities (P311221)

Bug 10727138   : FILES OUT OF BALANCE/F3 - SAR: 4242912
As of A8.1 c4 warning 157Y was incorporated in SuperBackflush so that when performing a blind Work Order Issues and a non-blind Work Order Completion from Super Backflush, and user tries to F3 out of P31114, the following warning message is given, to let know that this action will cause Cardex Transactions to be out of balance.  It is not mentioned in the warning text, but in some cases, Hours and Quantities could be out of balance too, specially in A9.1 and above cause P31113 and P311221 are called before the P31114.

The warning error added is 157Y - Warning F3 will cause Cardex imbalance

CAUSE: Other Cardex transactions have been written based on the PO setup in Super Backflush and F3 at this stage will prevent the logical flow of the process.

RESOLUTION: Hit enter to avoid imbalance in the files.

A9.1 and above

Completions (P31114) is enhanced with OVER COMPLETION Tolerance processing options. If an over completion exceeds the tolerance defined, the system generates a hard error. On the other hand, if the tolerance processing options are not set up, a soft warning / error is displayed in the case of Over Completion, but allows infinite over completions.

This enhancement is not available for A7.3 or A8.1 as Super Backflush (P31123) is re-designed for the A9.1 release to support the Advanced Lot and Actual Cost enhancements. These enhancements require the called programs (P31113, P311221 and P31114) be invoked in a different order as follows:.
• Work order inventory Issues (P31113)
• Hours and Quantities (P311221)
• Work order completions (P31114)

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!


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