Oracle eBS經驗分享

ERP 中選不到國別

Reference : Notes, 277121.1與404331.1.

新增SQL如下 :

INSERT INTO FND_TERRITORIES (TERRITORY_CODE,
                             LAST_UPDATE_DATE,
                             LAST_UPDATED_BY,
                             CREATION_DATE,
                             CREATED_BY,
                             LAST_UPDATE_LOGIN,
                             ISO_NUMERIC_CODE,
                             NLS_TERRITORY,
                             OBSOLETE_FLAG,
                             ISO_TERRITORY_CODE)
                     VALUES ('ME',
                             SYSDATE,
                             1168,
                             SYSDATE,
                             1168,
                             0,
                             499,
                             'MONTENEGRO',
                             'N',
                             'MNE');