My Oracle Support Banner

Unable To Pass Shipping Method Name As On PO To Create ASN Through FBDI (Doc ID 2389088.1)

Last updated on APRIL 20, 2018

Applies to:

Oracle Fusion Receiving - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Goal

Trying to create an ASN for a PO. We are importing the ASN data through FBDI. The import fails with an error "ORA-12899: value too large for column "FUSION"."RCV_HEADERS_INTERFACE"."CARRIER_METHOD" (actual: 20, maximum: 2)"

The Shipment method we are providing in template is AGS-Truckload-Ground as on PO. But in Shipping method we could just see Carrier name as "AGS" Attached screenshot and template used for loading.

Carrier Name, Carrier Equipment is available but these are missing in frontend.

FBDI Template
Carrier Method is available in [RCV_HEADERS_INTERFACE] worksheet but the data size is only 2 bytes
 

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!


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