Last updated on DECEMBER 21, 2015
Applies to:Oracle Fusion Purchasing Cloud Service - Version 126.96.36.199.0 and later
Oracle Fusion Purchasing - Version 188.8.131.52.0 and later
Information in this document applies to any platform.
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms