When Importing Purchase Orders Ship To Organization Field is Too Short (Doc ID 1992415.1)

Last updated on DECEMBER 21, 2015

Applies to:

Oracle Fusion Purchasing Cloud Service - Version 11.1.9.2.0 and later
Oracle Fusion Purchasing - Version 11.1.9.2.0 and later
Information in this document applies to any platform.

Symptoms

When trying to import purchase orders,  getting the following error:

Record 1: Rejected - Error on table PO_LINE_LOCATIONS_INTERFACE, column SHIP_TO_ORGANIZATION_CODE.
ORA-12899: value too large for column "FUSION"."PO_LINE_LOCATIONS_INTERFACE"."SHIP_TO_ORGANIZATION_CODE" (actual: 11, maximum: 3)
 

Steps to Reproduce
The issue can be reproduced at will with the following steps:
1. Prepare Purchase Order Import template file where SHIP_TO_ORGANIZATION_CODE length is larger than 3
2. Run Purchase Order Import program
2. Error is present in the import log file


Cause

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 hundreds of Community platforms