E1: 47: EDI - Document Number (EDOC) Defined in Database as Float and Numeric 9 in Data Dictionary Causes Work with Inbound EDI Orders (P47010) Not to Display the Records (Doc ID 2858615.1)

Last updated on MARCH 26, 2022

Applies to:

Goal

The customer has a 3rd party software inserting records into the EDI Purchase Order Header - Inbound (F47011) and EDI Purchase Order Detail - Inbound (F47012).  The customer is inserting a value in EDI - Document Number (EDOC) which is larger than 9 digits. The database for EDOC is defined as float. The EDOC data dictionary item is defined with a size of 9 numeric. Work with Inbound EDI Orders (P47010) does not find the record and the EDI report displays ******** characters.

Can the customer make a change to the Data Dictionary without causing any issues?

What other fields can be used for the EDI - Document Number?

Solution

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