fnd load details

how to copy the fnd tables data from one instance to another instance using fndload

fndload apps/apps@devdb 0 y download testcfg.lct out.ldt fnd_application_tl appsname=fnd

how to insert the data into fnd_territories from back end

using the below package we can insert / update the data into fnd_territories_tl and fnd_territories.

   fnd_territories_pkg.load_row (
      x_territory_code=> :territory_code,
      x_eu_code=> :eu_code,
      x_iso_numeric_code=> :iso_numeric_code,
      x_alternate_territory_code=> :alternate_territory_code,
      x_nls_territory=> :nls_territory,
      x_address_style=> :address_style,
      x_address_validation=> :address_validation,
      x_bank_info_style=> :bank_info_style,
      x_bank_info_validation=> :bank_info_validation,
      x_territory_short_name=> :territory_short_name,
      x_description=> :description,
      x_owner=> :owner,
      x_last_update_date=> :last_update_date,
      x_custom_mode=> :custom_mode,
      x_obsolete_flag=> :obsolete_flag,
      x_iso_territory_code=> :iso_territory_code
   );

apart from the above package we need to use the below package to insert the data into fnd_currencies

fnd_currencies_pkg.load_row (  x_currency_code in varchar2,
  x_derive_effective in date,
  x_derive_type in varchar2,
  x_global_attribute1 in varchar2,
  x_global_attribute2 in varchar2,
  x_global_attribute3 in varchar2,
  x_global_attribute4 in varchar2,
  x_global_attribute5 in varchar2,
  x_global_attribute6 in varchar2,
  x_global_attribute7 in varchar2,
  x_global_attribute8 in varchar2,
  x_global_attribute9 in varchar2,
  x_global_attribute10 in varchar2,
  x_global_attribute11 in varchar2,
  x_global_attribute12 in varchar2,
  x_global_attribute13 in varchar2,
  x_global_attribute14 in varchar2,
  x_global_attribute15 in varchar2,
  x_global_attribute16 in varchar2,
  x_global_attribute17 in varchar2,
  x_global_attribute18 in varchar2,
  x_global_attribute19 in varchar2,
  x_global_attribute20 in varchar2,
  x_derive_factor in number,
  x_enabled_flag in varchar2,
  x_currency_flag in varchar2,
  x_issuing_territory_code in varchar2,
  x_precision in number,
  x_extended_precision in number,
  x_symbol in varchar2,
  x_start_date_active in date,
  x_end_date_active in date,
  x_minimum_accountable_unit in number,
  x_context in varchar2,
  x_attribute1 in varchar2,
  x_attribute2 in varchar2,
  x_attribute3 in varchar2,
  x_attribute4 in varchar2,
  x_attribute5 in varchar2,
  x_attribute6 in varchar2,
  x_attribute7 in varchar2,
  x_attribute8 in varchar2,
  x_attribute9 in varchar2,
  x_attribute10 in varchar2,
  x_attribute11 in varchar2,
  x_attribute12 in varchar2,
  x_attribute13 in varchar2,
  x_attribute14 in varchar2,
  x_attribute15 in varchar2,
  x_iso_flag in varchar2,
  x_global_attribute_category in varchar2,
  x_name in varchar2,
  x_description in varchar2,
  x_owner in varchar2)