My Oracle Support Banner

E1: 49T: Enhance Sales Transportation Arranged Import (R49T20) To Pass Additional Field Values to Tag Table F49T211 (Doc ID 3027740.1)

Last updated on JUNE 21, 2024

Applies to:

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

Symptoms

Multiple OT* fields that are present in the F49T20 table (list below) , are not passed to the F49T211 table after the R49T20 (Sales Transportation Arranged Import) is executed.

The request is to add logic to pass these data items (when populated with valid data) from the F49T20 table (Shipment Staging Table) to the F49T211 (Sales Detail Secondary Tag Table).

The use case involves mapping the XML file from OTM to populate the 9 fields in the F49T20 (or F49T40). When executing the R49T20 or R49T40, it would be beneficial to have the data copied to the F49T211; data in this table is used for reporting and shipping documents.

Transpo Plan Ref 1 OTE1REF1

Transpo Plan Ref 2 OTE1REF2

Transpo Plan Ref 3 OTE1REF3

Transpo Plan Char 1 OTCHAR1

Transpo Plan Char 2 OTCHAR2

Transpo Plan Char 3 OTCHAR3

Transpo Plan Math 1 OTMATH1

Transpo Plan Math 2 OTMATH2

Transpo Plan Math 3 OTMATH3

Changes

 

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
Changes
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.