My Oracle Support Banner

CSTPGLXF - Transfer Periodic Cost Distributions To GL - ERROR APP-FND-01564: Erro ORACLE 1406 em FDFGDF just in Brazilian Portuguese Language (Doc ID 1990884.1)

Last updated on JUNE 18, 2018

Applies to:

Oracle Cost Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Reports for Applications Technology

CSTPGLXF - Transfer Periodic Cost Distributions to GL - ERROR

Error just in Brazilian Portuguese Language
In English, the error doesn’t occur.

Probably: The Latin special characters in - “Sumariar por Período Contábil”
Exceed 30 characters long in “GL Transfer Mode” parameter.

Error:
APP-FND-01564: Erro ORACLE 1406 em FDFGDF

Causa: Ocorreu um erro em FDFGDF, porque ORA-01406: o valor da coluna extraída foi truncado.

A instrução SQL que estava sendo executada no momento do erro era: SELECT LC.MEANING FROM CST_LE_COST_TYPES CLCT, FND_LOOKUPS LC WHERE CLCT.LEGAL_ENTITY =:a1 AND CLCT.COST_TYPE_ID = :a2 AND CLCT.GL_TRANSFER_MODE = LC.LOOKUP_CODE AND LC.LOOKUP_TYPE = 'XLA_GL_TRANSFER_MODE' e foi executada pelo arquivo &ERRFILE.
 

ERROR
-----------------------

APP-FND-01564: Erro ORACLE 1406 em FDFGDF





STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. run Transfer Periodic Cost Distributions to GL


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.