Can not Upload the Geography Data of Japan (Doc ID 2051355.1)

Last updated on DECEMBER 09, 2015

Applies to:

Oracle Fusion Financials Common Module Cloud Service - Version 11.1.9.2.0 and later
Information in this document applies to any platform.

Symptoms

Can not upload the geography data of Japan.

Reproduce steps:
1.Create the csv file to upload the Japanese Geography data like the following:

 
BatchId RecordTypeCode PrimaryGeographyName CountryCode LevelNumber SourceId ParentSourceId LanguageCode
  0 日本 JP 1 XXXXXXX6   US
  1 愛知県 JP 2 XXXXXX1 XXXXXXX6 US
  1 秋田県 JP 2 XXXXXX2 XXXXXXX6 US
  1 青森県 JP 2 XXXXXX3 XXXXXXX6 US
  1 千葉県 JP 2 XXXXXX4 XXXXXXX6 US

 

 

 

 

 

 



2.Go to task "Manage File Import Activities"
3.Press Create icon.
4.Upload the Japan geography data:
  <Enter Import options>
  Name        : JP Geographies
  Description : JP Geographies
  Object      : geography

  File Type   : Text file
  Upload From : Desktop
  File Name   : GePlanet JP geographies.csv
  Data Type   : Comma Separated
  Header Row Included : On
  Seeded        : Off
  Import Mapping :

  <Map Fields>

Column Header Example Value Ignore Object Attribute
BatchId US Off ImpGeography BatchId
RecordTypeCode 0 Off ImpGeography RecordTypeCode
PrimaryGeoGraphyName 日本 Off ImpGeography PrimaryGeoGraphyName
CountryCode JP Off ImpGeography CountryCode
LevelNumber 1 Off ImpGeography LevelNumber
SourceId XXXXXXX6 Off ImpGeography SourceId
ParentSourceId   Off ImpGeography ParentSourceId
LanaguageCode US Off ImpGeography LanaguageCode

 * ESS Job "Import Customer Relationship Management Object Files" and "Load Geography Data" were launched.
   And these ESS jobs ended successfully without any errors.

5. Go to task "Manage Geographies" to check the result.
6. Search the Country Code "JP".
7. Go to "Hierarchy Defined"
   * Can not see any Japan Geography data.

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