Supplier Address Records Load is failing with ORA-12899 value too large for column "FUSION"."PORA-12899OZ_SUP_ADDRESSES_INT"."IMPORT_ACTION"

(Doc ID 2031180.1)

Last updated on FEBRUARY 08, 2017

Applies to:

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

Symptoms

On : 11.1.9.2.0 version, Supplier Creation

When attempting to load Supplier Addresses, running in to these errors for 8 records out of 1751 records.

ERROR
-----------------------
Record 134: Rejected - Error on table POZ_SUP_ADDRESSES_INT, column ADDRESS_LINES_PHONETIC.
second enclosure string not present
Record 135: Rejected - Error on table POZ_SUP_ADDRESSES_INT, column IMPORT_ACTION.
ORA-12899: value too large for column "FUSION"."POZ_SUP_ADDRESSES_INT"."IMPORT_ACTION" (actual: 25, maximum: 10)

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Submit the job - - 'Load File to Interface '
2. Job Completes with error.


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