Distribution - JDE1 (MOSC)

MOSC Banner

R47002C Failure for EDI 852 Inbound- JDE 9.2

edited Feb 8, 2018 1:12PM in Distribution - JDE1 (MOSC) 2 commentsAnswered

Client is using F47002C to populate F47121/F47122 tables for EDI 852 Product Activity in JDE 9.2. The field delimeter is a comma (,) and text qualifier is double quotes (") in F47002C and the source flat file.

After running R47002C the following error is given in the work center.

CAUSE . . . . Insert failed for the Record with the key fields A1,852   ,          ,

              under one of the following conditions :

              - Duplicate Key fields

              - Fields have special characters

              - Fields are not of the correct data type

RESOLUTION. . Verify you have right values for all the fields.

When troubleshooting, it appears that when every field, alpha and numeric, are surrounded with Double Quotes in the flat file then the fields are updated correctly. To do this would require additional coding on the flat file. Is there any way to avoid surrounding every field (text and numeric) with double quotes and still process with R47002c?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

E1 Distribution Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center