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 JANUARY 28, 2017

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
-----------------------





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


Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms