My Oracle Support Banner

E1: F31: P41500 and R41500 Does Not Correctly Process Lean Manufacturing Transactions (LC, LM, LH, LP) (Doc ID 2337035.1)

Last updated on NOVEMBER 22, 2019

Applies to:

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

Symptoms

E1 9.2 / P41500 and R41500 Manual Inventory to GL Reconciliation
P41500 and R41500 does not correctly process Lean Manufacturing transactions (LC, LM, LH, LP).

P41500 (and R41500) does not "read" all of the Transaction IDs associated with a Lean Production ID.

1. If the lean completion (PF3012) involves a multi-level Bill of Material (i.e. sub-assembly) (and R31802A Manufacturing Accounting is run), P41500 does not 'find' the lower level
   (sub-assembly) completion (LC) and issues (LM) so an imbalance occurs (3038 error- Item Ledger and GL do not balance).

2. If more than one lean completion (PF31012) is performed on the same Production ID and R31802A is run, P41500 does not find the 2nd, 3rd, etc.
    completion (LCs from the 2nd, 3rd, etc Transaction ID) and issues (LMs from the 2nd, 3rd, etc Transaction ID) so an imbalance occurs (3038 error-Item Ledger and GL do not balance).

The P/R41500 generates correct reconciliation records for Lean completions ONLY if the Bill of Material is single level AND ONLY if a single Completion (LC) against the production ID is
performed and, Variance Accounting (R31804) has NOT been run (see closed Bug 27221669). However, once Lean Variance Accounting RF31210 is run over the transaction ID when checking the P41500 for the lean transactions to reconcile the transactions are out of balance with the G/L showing double the item ledger on the top screen even though the transactions are actually in balance

The level of linking of F4111 and F0911 records appears to be incorrect. F4111 is using Production ID, which could be a summary of many Transaction IDs (FF31201 Cross Reference).
The F0911 fetch is only pulling the Document Number from the first Transaction ID to gather information.

Expected: Retrieve all of the F0911 records that correspond to each Transaction ID associated with a Lean manufacturing Production Plan when processing reconciliation records in P41500 and R41500.

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.