NegotiationAwardAcceptancePVO via Data Transforms (Data Load) ORA-12899: value too large for column
CONTEXT
Starting with Fusion 26B, we have started loading data from Fusion BICC PVOFscmTopModelAM.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 """
Tagged:
0