Axis RightFax 8.5 Guía de instalación descargar pdf (Pagina 61)

10-7

2. Set your currency storage default by running the following insert statement (example using

GBP as new storage default) as the DBA user:

INSERT INTO UOM (TYPE, UOM_CODE, UOM_SHORT_DESCRIPTION,

UOM_LONG_DESCRIPTION, UOM_RANK, IS_STORAGE_DEFAULT,

IS_DISPLAY_DEFAULT, DOMAIN_NAME) VALUES (‘CURRENCY’, ‘GBP’, ‘UK

POUND’, ‘UK POUND’, 1, ‘Y’, ‘Y’, ‘DBA’)

Oracle Transportation Management still needs currency rates to convert between the currencies you

use. You can download rates from the IMF website. (This populates the DEFAULT rate in the

CURRENCY_EXCHANGE_RATE table.) The problem is that all rates from the IMF are against USD. You

have two alternatives to using USD centric IMF rates:

 Write an API that uses another source than the IMF to bring in exchange rates stated against

your currency storage default.

Update the rates you need manually or use a CSV process while again entering your needed

rates against your preferred currency. You can do this nightly, monthly or in any other

frequency.

 In the glog.properties property file or the CUSTOM property set, set glog.currency.base to

your currency storage default (e.g. EUR). This makes Oracle Transportation Management

triangulate through the currency of your choice.

This means that Oracle Transportation Management will have all DEFAULT rates stated against your

base currency and triangulates using your base currency.

Accounting for Missing Time Zones

The UTC pl/sql package depends on java running in Oracle to do time zone conversions. Some time

zones are not accounted for in the java.util.TimeZone class. The solution to this problem involves a

new (and optional) "missing_time_zone" table, which has the following structure:

Column

Value

TIME_ZONE_GID

NOT NULL VARCHAR2(128)

ALT_TIME_ZONE_GID

NOT NULL VARCHAR2(128)

ADJ_FACTOR

NOT NULL NUMBER

So for example, if you had a location that specified a time zone of "FOO", and you wanted "FOO" to be

treated the same as "America/New_York", you would specify a missing_time_zone record of:

time_zone_gid = 'FOO'

alt_time_zone_gid = 'America/New_York'

adj_factor = 0

The adj_factor is added to the time_zone_offset. So if the time_zone_offset for America/New_York

was -5, and you wanted 'FOO' to have an offset of -4, you could set the adj_factor to 1.

Some of the missing Australian time zones are accounted for in the java code itself. The defaults

established in the code for the Australian time zones can be overridden via the missing_time_zone

table.

1 2 ... 56 57 58 59 60 61 62 63 64 65 66 ... 105 106

Comentarios a estos manuales

Sin comentarios

Axis RightFax 8.5 Guía de instalación Pagina 61

Comentarios a estos manuales

Relacionado con productos y manuales para Software Axis RightFax 8.5