My Oracle Support Banner

E1: 74: Intrastats - Tax Update - Sales (R0018I1) Displays the Error Message "Value for Transaction Nature code not found in UDC 74/NT" (Doc ID 3021490.1)

Last updated on MAY 10, 2024

Applies to:

JD Edwards EnterpriseOne Sales Order Management - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

The following error message “*** Value for Transaction Nature code not found in UDC 74/NT ***” is displayed in the output of the R0018I1(Intrastats - Tax Update – Sales) process even though it does not use this option in the processing options. Also, this error message is false because UDC 74/NT is set.

Steps to reproduce:

  1. Setup UDC 74/NT Nature of Transaction for company 00070: Code = 00070SOS EU, Description 01 = Sales to customer, Description 02 = 10.
  2. Branch/Plant 70 of the company 00070 is from France.
  3. The customer 202020 is from Ireland.
  4. Both countries (France and Ireland) are set as members of European Community in UDC 74/EC.
  5. Set an Intrastat Commodity code (P744102).
  6. Set a code in the Sales Reporting Code 03 UDC 41/S3.
  7. Set Sales Category Code 3 and Shipping Commodity Class in the Category Codes of the item APINTRASTAT.
  8. Create two sales order from Branch = 70, to customer 202020, for the item APINTRASTAT.
  9. Run R0018I1 Intrastat Update - Sales process for the first sales order using the first options of the processing options 1 from tab Transaction: “To use the Reporting Code method, enter the Sales Reporting Code (1-5) which contains the Nature of Transaction. = 3”. Do not set any System Code and User Defined Codes.
  10. The system created a record in F0018T Intrastat Revision table for this sales order. However, the output of the R0018I1 process displays the error: *** Value for Transaction Nature code not found in UDC 74/NT *** .
  11. Run R0018I1 Intrastat Update - Sales process for the second sales order using only the second options of the processing options 1 from tab Transaction: “To use the User Defined Code method, enter the UDC table which contains the Nature of Transaction. If no values are entered in this option, table 74/NT will be used. System Code = 41 and User Defined Codes = S3
  12. The system created a record in F0018T Intrastat Revision table for this sales order. However, the output of the R0018I1 process displays the same the error: *** Value for Transaction Nature code not found in UDC 74/NT *** .

When running R0018I1, the system has to not check the setup in UDC 74/NT, accordingly with the setup of the processing options.

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.