Skip to main content

He there,

I have 2 different problems about demand planner on version 10 up.10.

  1. TNS PROBLEM

I configured demand planner server on application server clearly but i though TNS cant resolved on server. 

If i start like this on “cmd”, it works. But when i clicked normally to ForecastServer it cant resolve TNS for some how, any idea?

set TNS_ADMIN=C:\Oracle\product\12.2.0\client_1\network\admin

start "" "C:\Program Files\IFS Applications\Demand Plan Server 64\DemandPlanServer\ForecastServer.exe"

  1. DECODE Problem

My demand planner working like Turkish NLS Parameter on the database level some how, but the region settings on server is English (United States), and databased configured for English language.

When i use “Qualify Parts” option after “Aggregate Daily”, i got error messages from the client about decode transformation problems. I checked the FORECAST_PART view, so it is include standart GEN_YES_NO_API.DECODE method and it is works normally. But the demand planner application cant resolve the decode method as i expected for some how, if u have a trick about this let me know please.

  • (I checked the user settings on what i connected user to demand planner, the language settings is English,
  • I checked the NLS_DATABASE_PARAMETERS parameters, results are NLS_LANGUAGE: AMERICAN AND NLS_TERRITORY: AMERICA,
  • I checked the standart language xml files on demand planner, so i see empty content on “DemandServeren.xml” but “DemandServerSTD.xml” file is full. I tried to changed “DemandServeren.xml” but not solved)

     

Hi ​@0guz,

 

First of all, it is not recomended to install any service on an application server (esp. production env.).

For demand server installation you can follow the Demand Plan Server setup page(https://docs.ifs.com/techdocs/Foundation1/020_installation/400_installation_options/130_add-on_cmp/demand/default.htm)

While lu and field value is in turkish, most probably IPR user you set in your database tab of demand server, has its last session been logged with language tr.

you can use a specific user dedicated just for demand planner with english local settings.

 

 

 

 

Hi ​@0guz,

 

First of all, it is not recomended to install any service on an application server (esp. production env.).

For demand server installation you can follow the Demand Plan Server setup page(https://docs.ifs.com/techdocs/Foundation1/020_installation/400_installation_options/130_add-on_cmp/demand/default.htm)

While lu and field value is in turkish, most probably IPR user you set in your database tab of demand server, has its last session been logged with language tr.

you can use a specific user dedicated just for demand planner with english local settings.

 

 

 

 

You nailed it 🙂 Thanks a lot!

I’ll definitely keep your suggestions in mind.
Turns out the system really does work based on the last session language of the Oracle user what i setup in on demand server.

Honestly, that should’ve been the first thing I checked, but it never even crossed my mind. You’re awesome!

Best regards.

Reply


Terms & ConditionsCookie settings