ORA-12705: Cannot access NLS data files when running BSP Cash Flow

(Doc ID 1546322.1)

Last updated on OCTOBER 04, 2016

Applies to:

Oracle Financial Services Balance Sheet Planning - Version 6.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

On Oracle Financial Services Balance Sheet Planning (BSP) 6.0, when attempting to run Cash Flow Data, the following error occurs:

ERROR

2013-03-27 15:57:51,725 INFO com.oracle.bsp.udf.StreamGobbler1 :: | strBatchId : BSP_200082_20130307 | strComponentId : OFSRM | Process ID : 200082 | User ID : ADMIN |
2013-03-27 15:57:53,646 INFO com.oracle.bsp.udf.StreamGobbler1 :: Error(Oracle Financial Services Application error) (203105) Oracle drv_oci error:
2013-03-27 15:57:53,646 INFO com.oracle.bsp.udf.StreamGobbler1 ::
2013-03-27 15:57:53,646 INFO com.oracle.bsp.udf.StreamGobbler1 :: OCI Function: [0] - olon(), orlon()
2013-03-27 15:57:53,646 INFO com.oracle.bsp.udf.StreamGobbler1 :: Oracle Error: [12705] - ORA-12705: Cannot access NLS data files or invalid environment specified
2013-03-27 15:57:53,646 INFO com.oracle.bsp.udf.StreamGobbler1 ::
2013-03-27 15:57:53,646 INFO com.oracle.bsp.udf.StreamGobbler1 :: Driver Function: drv_oci::Connect()
2013-03-27 15:57:53,646 INFO com.oracle.bsp.udf.StreamGobbler1 ::
2013-03-27 15:57:53,646 INFO com.oracle.bsp.udf.StreamGobbler1 :: MB(AttachDB()) Error attaching to database: ORCL
2013-03-27 15:57:53,788 INFO com.oracle.bsp.udf.BSPExtComponet :: Final CFE return status :1
2013-03-27 15:57:53,788 INFO com.oracle.bsp.udf.BSPExtComponet :: CFE execution Failed
2013-03-27 15:57:53,788 INFO com.oracle.bsp.udf.BSPCfeCall :: CallRunOff_proc is not executed either CFE execution failed or its not a new Bussiness scenario
2013-03-27 15:57:53,788 INFO com.oracle.bsp.udf.BSPCfeCall :: RUNOFF CFE call completes ********


The issue can be reproduced at will with the following steps:

1. Entered and Extracted the MM
2. Entered Balance Driver data
3. Entered Pricing Driver Data
4. Run Metadata Synchronization
5. Run the Cash flow data – using Calculate option from Financial Plan Default DF - Values are not getting generated for Financial Elements under Accounts

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