Wednesday, 15 April 2015

Region Interface - Shipping

                    
Interface Tables:

WSH_REGIONS_INTERFACE
WSH_REGIONS_TL_INTERFACE

Base Tables:

WSH_REGIONS
WSH_REGIONS_TL

Create Country:
Insert the following data into Interface tables  
Generate Sequence_ID and use the same for both the INTERFACE tables.
Region_Type=0
Country and Country_Code should be NOT NULL.
Other values like state, city, parent_region_id should be NULL

Run ‘Region Interface’ import program to create COUNTRY records.

Create State:
Insert the following data into Interface tables
Generate Sequence_ID and use the same for both the INTERFACE tables.
Region_Type=1
Country, Country_Code, State, State_Code should be NOT NULL.
Parent_Region_ID should be the region_id of the corresponding COUNTRY record.
Other values like city, Postal_Code_From, Postal_Code_To should be NULL

Run ‘Region Interface’ import program to create STATE records.

Create City:
Insert the following data into Interface tables
Generate Sequence_ID and use the same for both the INTERFACE tables.
Region_Type=2
Country, Country_Code, State, State_Code, City_City_Code should be NOT NULL.
Parent_Region_ID should be the region_id of the corresponding STATE record.
Other values like area, Postal_Code_From, Postal_Code_To should be NULL

Run ‘Region Interface’ import program to create CITY records

Create Area/ Pincode:
Insert the following data into Interface tables
Generate Sequence_ID and use the same for both the INTERFACE tables.
Region_Type=3
Country , Country_Code, State, State_Code, City_City_Code, Area, Postal_Code_From, Postal_Code_To should be NOT NULL.

Run ‘Region Interface’ import program to create Area/ Pincode records.


6 comments:

  1. nice blog good information about oracle fusion financials all modules training
    This listing is virtually very useful.
    Thank you for sharing the ones most important weblog submission net web sites.
    For more about information please check the internet site oracle all modules trainings

    ReplyDelete
  2. Thanks for sharing very good information about OCI Punchout.
    OCI Punchout

    ReplyDelete
  3. Thanks for sharing article about What is OCI Punchout
    What is OCI Punchout

    ReplyDelete
  4. Such a nice blog, I really like what you write in this blog, I also have some relevant Information about Best HR Training In Hyderabad | Hr training institute in Hyderabad! if you want more information.
    Oracle Fusion HCM Online Training
    Oracle Fusion SCM Online Training
    Oracle Fusion Financials Online Training
    Big Data and Hadoop Training In Hyderabad

    ReplyDelete