You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

NegotiationAwardAcceptancePVO via Data Transforms (Data Load) ORA-12899: value too large for column

edited May 19, 2026 3:43PM in ERP Integrations

CONTEXT

Starting with Fusion 26B, we have started loading data from Fusion BICC PVO
FscmTopModelAM.PrcExtractAM.PonBiccExtractAM.NegotiationAwardAcceptancePVO
into Oracle Autonomous Database (ADB) using ADB Data Transforms (Data Load).

The data load fails with errors reported in the execution log.

❗ Error from Data Transform Execution Log

ORA-12899: value too large for column ITEMNUMBER (actual: 269, maximum: 255)

From the log:

  • Column: ITEMNUMBER
  • Actual value length: 269
  • Maximum allowed during load: 255

🔍 Critical Additional Information from the Log

The execution log also shows the internal field definition used during the load:

Field Definitions for table COPY$T0Q6X5BJAT6CW6COSPVJITEMNUMBER      CHAR(1020)    Terminated by ","    Enclosed by """ and """

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!