AHM: New Segment Values Entered In Non-Us Language Not Saved In FND_FLEX_VALUES_TL (Doc ID 343695.1)

Last updated on SEPTEMBER 19, 2016

Applies to:

Oracle General Ledger - Version: 11.5.10.2
This problem can occur on any platform.

Symptoms

When an new segment value is created using the Account Hierarchy Manager (AHM) and a non-US language, such as Canadian French, only a row for the US language is inserted into FND_FLEX_VALUES_TL.

The segment values created with AHM while using the non-US language are not available on the LOV on the GL
Accounts form when trying to create new account combinations. Accounts that were created with AHM
and the American English language are available.

An error is received on the Segment Values form when querying a segment value with AHM and non-US lanaguage:
APP-FND-01564: ORACLE error 1403 in fdxmlcrc
Cause: fdxmlcrc failed due to ORA-01403: no data found.
The SQL statement being executed at the time of the error was: and was executed from the file
&ERRFILE.

 

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