E1: 42: R42800 Sales Order Update Is Creating "I" Batch Types Rather Than "IB" (Doc ID 2022156.1)

Last updated on MAY 11, 2016

Applies to:

JD Edwards EnterpriseOne Sales Order Processing - Version 9.1 to 9.1 [Release 9.1]
Information in this document applies to any platform.

Symptoms

When running Sales Update (R42800) the batch is created with an "I" batch type (as was used in World Accounts Receivable) rather than an "IB" batch type (which is what EnterpriseOne Releases were designed to use).

This was determined to be caused by a corrupted value in the F0009 General Constants table.  The customer had a value of blank in the SEPF SeparatorFlex (Use New A/R Flag).  At the present time,  code exists to check the value of this flag to determine whether World Accounts Receivable is being used (in which case, set the Batch Type to "I") , or whether EnterpriseOne Accounts Receivable is being used (if the value is "1" or "2")--set the Batch Type to IB.  Because customer's value was blank in this table, it was interpreting as World A/R and setting the Batch Type to "I"

In order for the customer to correct this situation where they had an incorrect value of blank, they had to use SQL to update the value of SEPF to a "1" and then completely restart services for the new value to take effect   Please note that this value should NOT be changed after data exists--especially making a change between Accounts Receivable and Accounts Receivable -- Line of Business processing as documented in Document:1982405.1 - E1: 03B: Overview and Set Up of Accounts Receivable Constants and Enhanced Accounts Receivable Constants for Line of Business and Date-Effective Category Code Processing (P0000, F0009, F0010)

9.1 Bug 21281671 was entered to request that this code that had been required at coexistent releases Xe and ERP 8.0 be removed.  Coexistence between World and EnterpriseOne is not supported after the Xe and ERP8.0 releases.

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