My Oracle Support Banner

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

Last updated on OCTOBER 24, 2022

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.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.