My Oracle Support Banner

Ledger Errors "Numeric or value error. Please check field length and data type" (Doc ID 3067080.1)

Last updated on MARCH 17, 2025

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 23.1 and later
Information in this document applies to any platform.

Symptoms

SVC_FIF_GL_ACCT has lower max length than FIF_GL_ACCT for PRIMARY_ACCOUNT field

According to Oracle Retail Merchandising Foundation Cloud Service Data Model 24.0.201.0:

The table SVC_FIF_GL_ACCT - This is a staging table used for Admin API spreadsheet upload process. It is used to temporarily hold data before it is uploaded/updated in FIF_GL_ACCT table - has PRIMARY_ACCOUNT length of 15,0

The table FIF_GL_ACCT shows the max length for PRIMARY_ACCOUNT as 18 digits.

 

Steps to Reproduce:
-------------------
Attempt to upload a General Ledger Accounts insert containing PRIMARY_ACCOUNT with a length of 16-18 digits - Error - Numeric or value error. Please check field length and data type.

Business Impact:
-------------------
Cannot insert General Ledger Accounts with PRIMARY_ACCOUNT of 16 digits via spreadsheet upload.

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.