My Oracle Support Banner

Cloud Data Management - Error "ORA-12899: value too large for column “AIF_TARGET_APPL_PROPERTIES”.“PROPERTY_TYPE” (actual: 61, maximum: 60)" When Initializing NetSuite Source System (Doc ID 2942758.1)

Last updated on MAY 09, 2023

Applies to:

Oracle Planning and Budgeting Cloud Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

When NetSuite saved search contains fields with id longer than 60 characters, data source initialization fails with following error -

ORA-12899: value too large for column "AIF_TARGET_APPL_PROPERTIES"."PROPERTY_TYPE" (actual: 61, maximum: 60)
java.sql.SQLException: ORA-12899: value too large for column "AIF_TARGET_APPL_PROPERTIES"."PROPERTY_TYPE" (actual: 61, maximum: 60)
Error in DatasourceSetup - initializeNetSuiteSource

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.