E1: 41: P41500 Error 3038 and Cannot Unreconcile IC or IM Doc Types (Doc ID 2257027.1)

Last updated on APRIL 19, 2017

Applies to:

JD Edwards EnterpriseOne Inventory Foundation - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

On : 9.2 version, Inventory

ACTUAL BEHAVIOR
---------------
When reconciling IC and IM doc types in P41500 after re-inquiring they still show error Error is 3038 Item Ledger and G/L do not balance and you are unable Unreconcile them. The issue only occurs with IC and IM doc types.

EXPECTED BEHAVIOR
-----------------------
Reconciled transactions should not still be in error and user should be able to unreconcile IC and IM doc types.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1) P41500. Locate inventory data for an IC (inventory completion) doc type that has more than one F4111 records and is out of balance with the F0911. In this case we had the manufacturing group create the data then we went in and changed one of the F4111 records and increased it by .01. Error is 3038 Item Ledger and G/L do not balance.
 
2) Take the form Exit to Journal Entry and add a new one ton increase by .01.
 
3) Choose Select JE Adjustment and select the JE just added.
 
4) Click on Reconcile and it appears to have been corrected.
 
5) Check the Include Reconciled Transactions check box and click find again. Note the transaction still shows error 3038 and is off by the same amount.
 
6) Click Unreconcile. Note that nothing happens and it did not unreconcile.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot unreconcile IC and IM doc types.

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