My Oracle Support Banner

E1 47: R47021 Completed with Errors "Failed to Find Column xxxx in F47022" in JDE.Log (Doc ID 2004149.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

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

    JDB9900267 - Failed to find requested column -- CRAM in the table F47022
    JDB9900418 - Failed to find requested column CRAM in the table F47022
    JDB9900267 - Failed to find requested column -- BTAN in the table F47022
    JDB9900418 - Failed to find requested column BTAN in the table F47022
    JDB9900267 - Failed to find requested column -- GBTAN in the table F47022
    JDB9900418 - Failed to find requested column GBTAN in the table F47022


Steps to Duplicate:
==============
1. Create and save a 1 line purchase order.
2. Print Purchase Order (R43500) and generate EDI PO outbound to populate F47016 and F47017.
3. Using Inbound EDI Order Acknowledgment Revisions (P47020) populate Minimum Required Fields for EDI P.O. Acknowledgment Detail - Inbound (F47022).
4. Populate Minimum Required Fields for EDI P.O. Acknowledgment Header - Inbound (F47021).
5. Set Status Codes and enter a '1' to compare inbound data to data in the Outbound EDI Purchase Order tables (F47016 and F47017) in EDI Inbound PO Acknowledgment (R47021) processing option.
6. Run EDI Inbound PO Acknowledgment (R47021).
7. Review the JDE.LOG and view the contents. Note the error messages.
8. Check the Order Detail and notice the order status was correctly updated by EDI Inbound PO Acknowledgment (R47021)

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


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