My Oracle Support Banner

WSE1: 03: Troubleshooting World to E1 AR Conversion (Doc ID 639815.1)

Last updated on MARCH 08, 2022

Applies to:

JD Edwards World Accounts Receivable - Version A7.3 cume 11 and later
JD Edwards World Install/Upgrade/Migration - Version A7.3 cume 11 and later
Information in this document applies to any platform.

Purpose

 This document describes the causes and resolutions for issues related to processing of Accounts Receivable data in the conversion of World data to EnterpriseOne.

NOTE: The World to EnterpriseOne AR Conversion programs use the records from the World F0311 and convert the records to the appropriate E1 AR tables -- F03B11, F03B112, F03B13 and F03B14. 

Troubleshooting Steps

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
Purpose
Troubleshooting Steps
 Issues
 Issue 1: The Migration Database Analyzer report (P98888) give the message, "OW Idx Validation Failed-Dup Recs Exist", for the Accounts Receivable Ledger (F0311) data.  How does this program determine if there are duplicates in the F0311?
 Issue 2:  Some converted records in the Enterprise One tables are not complete or not in balance. For example, a spread receipt does not currently net to zero.  What are the available options for converting this type of data?
 Issue 3:  The system returns an error indicating the F03B11P is missing when executing the F0311 A/R Ledger Conv-F03B11 (P0311QD1).
 Issue 4:  There an excessive number of discrepancies listed on the World to OneWorld Conversion Exception Report (R0311QD1) when running the AR conversion programs (P0311QD1, P0311QD2).
 Issue 5: The Conversion Audit Report (P03961) show many pages of records that are not the same in World and EnterpriseOne.
 Issue 6: After upgrading to JDE World A9.3 we noticed that the World to E1 conversion programs, reports and files are listed as Obsolete on the program name in SVR (Software Versions Repository).  We plan on migrating to EnterpriseOne and would like to verify if these programs/reports/files are obsolete.
 Issue 7:  The World to OneWorld Conversion - F03B13/14 (P0311QD2) populates the Bank Account (GLBA) in the F03B13 with 00000000 when there is a write off (RA document type in World) of a Finance Charge (RF document type in World), and it is causing issues with voiding the receipt with the write-off on it. 
 Issue 8:  After migrating JDE World data to the data source in EnterpriseOne, the Advanced Payment Terms (F00141) in EnterpriseOne is empty, but the F0014 (Payment Terms) does have all the terms.  How can we get the Advanced Payment Terms in the EnterpriseOne environment?
References

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