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.
nice blog good information about oracle fusion financials all modules training
ReplyDeleteThis 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
Thanks for sharing very good information about OCI Punchout.
ReplyDeleteOCI Punchout
Great Article.
ReplyDeleteOCI PunchOut
Thanks for sharing article about What is OCI Punchout
ReplyDeleteWhat is OCI Punchout
Nice Blog, I saw Somany unknown topics in this Blog. Thanks For sharing,Keep it up.
ReplyDeleteOracle Fusion HCM Online Training
Oracle Fusion SCM Online Training
Oracle Fusion Financials Online Training
Big Data and Hadoop Training In Hyderabad
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.
ReplyDeleteOracle Fusion HCM Online Training
Oracle Fusion SCM Online Training
Oracle Fusion Financials Online Training
Big Data and Hadoop Training In Hyderabad