E1: 47: R47042C Not Properly Creating Flat File for Record Type and Record Sequence (Doc ID 1677041.1)

Last updated on NOVEMBER 06, 2015

Applies to:

JD Edwards EnterpriseOne EDI - Version 9.0 to 9.0 [Release 9.0]
Information in this document applies to any platform.

Symptoms

E1 Release: 9.0
Program ID: R47042C Invoice Flat file conversion

When a sales order that has a detached adjustment applied to it is extracted to a flat file via R47042C,  the Detail Charges (C record type from the F470473) record is being incorrectly written with the EDTY (record type) and EDSQ   (sequence) elements in the 6th and 7th position of the record, instead of the 1st and 2nd position.                                  
.                                                                            
STEPS TO REPRODUCE:                                                          
1. Create a detached adjustment definition, adjustment                        
detail, and schedule and attach it to a customer.                            
2. Enter a one line sales order and verify the detached                      
adjustment appears in Price History.                                          
3. Run the R42565 EDI extraction                                              
4. Run the R47042C flat file conversion and view the flat                    
file.  Notice the Detail Charges (C record type from the                      
F470473) record is being incorrectly written with the EDTY                    
(record type) and EDSQ (sequence) elements in the 6th and                    
7th position of the record, instead of the 1st and 2nd                        
position.

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