Create Accounting – Receiving Error With "Ora-01406: Fetched Column Value Was Truncated" While Logged in Arabic Language

(Doc ID 2362429.1)

Last updated on MARCH 16, 2018

Applies to:

Oracle Purchasing - Version 12.1 and later
Information in this document applies to any platform.

Symptoms

While attempting to submit the Create Accounting – Receiving Concurrent while logged in Arabic language, while selecting the ledger LOV, the following error occurs:

ERROR
-----------------------
تطبيق-FND-01564: خطأ أوراكل 1406 في FDFGDF

السبب: فشل FDFGDF بسبب ORA-01406: تم بتر قيمة العمود المسحوب

جملة
SQL الجاري تنفيذها في وقت حدوث الخطأ كانت: SELECT MEANING FROM
XLA_LOOKUPS XLK, XLA_SUBLEDGER_OPTIONS_V XSO WHERE
XLK.LOOKUP_TYPE = 'XLA_ACCT_TRANSFER_MODE' AND XLK.LOOKUP_CODE =
XSO.SUMMARY_REPORT_FLAG AND XSO.APPLICATION_ID = 707 AND
XSO.LEDGER_ID = :a1 وتم تنفيذها من الملف &ERRFILE


Translated in English:


APP-FND-01564: ORACLE error ORACLE 1406 in FDFGDF

Cause: FDFGDF failed due to ORA-01406: fetched column value was truncated

The SQL statement being executed at the time of the error was: SQL SELECT MEANING FROM XLA_LOOKUPS XLK, XLA_SUBLEDGER_OPTIONS_V XSO WHERE
XLK.LOOKUP_TYPE = 'XLA_ACCT_TRANSFER_MODE' AND XLK.LOOKUP_CODE = XSO.SUMMARY_REPORT_FLAG AND XSO.APPLICATION_ID = 707 AND
XSO.LEDGER_ID :a1 and was executed from the file &ERRFILE.



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login in Arabic language, Using a Cost Manager SLA
2. Go to Reports- Run-Single request- select Create Accounting – Receiving program
3. Under parameters, go to Ledger parameter-> error occurs

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