My Oracle Support Banner

How To Modify DSNO Interface File Definition to Add a consolidated Master BOL to map multiple BOL's (Doc ID 1348509.1)

Last updated on JANUARY 30, 2022

Applies to:

Oracle EDI Gateway - Version 11.5.10.2 and later
Information in this document applies to any platform.

Goal

The Issue:
Trying to add a consolidated Master BOL to map multiple BOL's, for shipments to large customers using for EDI DSNO Transactions. There was and attempt to modify "DSNO Interface File Definition" Map WSH_DSNO_FF Level 1Delivery. However the Process and Column are greyed out.

The Above was seen with the Navigation Ecommerce Gateway > Interface File Definition.
In the transaction field, query on DSNO% . For the following DSNO transaction/mapping, scroll down to the 1000 record number range to try to modify.

Transaction - DSNO (OUT: Outbound Shipment Notice/Manifest)
Map - WSH_DSNO_FF
Level- 1:Delivery

In the Interface file block, you will find the Interface Columns are not
selectable and it is not possible to add or modify the column names.

NOTE: The actual 856 process is working fine. The normal DSNO xxxx file is generated but the objective is to have a Master BOL to be part of the DSNO xxxx file.

Based on the above:
1. Can the interface table be modified to ADD columns to the interface table and THEN do the mapping for the Master BOL
OR
2. Can an existing data element be used for the required Master BOL so that all the BOLs are associated with the record


Solution

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
Goal
Solution


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