E1: 43: EDI PO Acknowledgement (R47021) Failed To Find Requested Columns PMPN, PNS (Doc ID 1669176.1)

Last updated on NOVEMBER 06, 2015

Applies to:

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

Symptoms

On : 9.1 version, EDI - Distribution
EDI Inbound PO Acknowledgment (R47021)
Tools release 9.1
Platform: Linux

When attempting to run EDI Inbound PO Acknowledgment (R47021) the job completes successfully but leaves the following errors in the JDE.LOG. Client is using the Linux Platform.

JDE LOG ERROR
-----------------------
JDB9900418 - Failed to find requested column Production Number (PMPN) in the table F47022
JDB9900267 - Failed to find requested column Production Number Short (PNS) in the table F47022

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create and save a 1 line purchase order.
2. Using Inbound EDI Order Acknowledgment Revisions (P47020) populate Minimum Required Fields for EDI P.O. Acknowledgment Detail - Inbound (F47022).
3. Populate Minimum Required Fields for EDI P.O. Acknowledgment Header - Inbound (F47021).
4. Set Status Codes in EDI Inbound PO Acknowledgment (R47021) processing options.
5. Run EDI Inbound PO Acknowledgment (R47021).
6. Review the JDE.LOG and view the contents. Note the error messages.
      •    JDB9900418 - Failed to find requested column Production Number (PMPN) in the table F47022
      •    JDB9900267 - Failed to find requested column Production Number Short  (PNS) in the table F47022
7. Check the Order Detail and notice the order status was correctly updated by EDI Inbound PO Acknowledgment (R47021)

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Minor impact. Logs fill up with bogus error messages, but job still runs successfully.IC

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