Setup a new store in Oracle RMS

To Setup a new store in RMS follow the steps given below 

• Step 1: First open the browser and type the given URL:

  http://shk-oratestapp02.hk.oracle.se:7783/RetailWorkspace/faces/faces/RetailWorkspace.jspx

  login screen will be displayed.

• Step 2: Click on the login button mentioned in the top right corner and log-in with your username and password. A new window will open.
• Step 3:Expand the Merchandising  tab and select the option called RMS.  One pop-up window will appear with two button called run and cancel. 
• Step 4:Click on run, it will redirect to RMS main screen. 
• Step 5: Select the option called Actionmentioned in the top left corner of the screen, after clicking on that it will show various elements of Action tab. 
• Step 6: Now select option Organization hierarchyit will open a new form window. 
• Step 7:Select Store on the tree structure. Click New. The Store Maintenance window opens. 
• Step 8:In the Store Type field, select the store type as “Company”.
• Step 9:In the Store field, enter a unique ID and description for the store.
• Step 10:In the (10 chars)and (3 chars) fields, enter 10-character and 3-character abbreviations for the store.
• Step 11:In the Manager field, enter the name of the manager who is responsible for the store.
• Step 12:In the VAT Region field, enter the ID of the VAT region, or select it from LOV (list of values) button and select the VAT region.
• Step 13:In the District field, enter the ID of the district, or select it from LOV.
• Step 14:In the Store Open Date field, enter the date when the store opens.
• Step 15:In the Start Order Days field, enter the number of days before the store opens that merchandise should be ordered.
• Step 16:In the Channel field, enter the ID of the channel to which the store belongs, or click the LOV button and select the channel.
• Step 17:In the Currency field, enter the currency code, or click the LOV button and select the currency.
• Step 18:In the Language field, enter the language code, or click the LOV button and select the language.
• Step 19:In the Transfer Entity field, enter the transfer entity ID, or click the LOV button

  and select the transfer entity.

• Step 20:In the Org Unit ID field, enter the org unit ID, or click the LOV button and select

  the organizational unit.

• Step 21:Add the address to the store.
• Step 22:Click Zoning Locsand enter the pricing store field and cost location.
• Step 23:Click on Like Storebutton and enter the store number in like store field.
• Step 24:Enter optional information in the remaining fields as necessary.
• Step 25:Click OKto save your changes and close the window.

How to Check the Store creation

• Open the Toad and Check that store entry is inserted in the table named Store_add by typing the below query:

Select * from store_add 

• Openthe UC4 scheduler in a new browser window using the below URL and provide username and password: 

http://shk-oratestdb02.hk.oracle.se:7777/AM_DEV/Intro.html

• Click on “Start the Application Manager” and then click on 
• Select the Chain icon from top menu bar and search for the batch called “Store_add_down” in the search box.
• Select the batch mentioned above and click on Request Button and then submit
• After Completing the batch Check the new Store entry in the following tables by writing a simple select statement in Toad:
• 1. Item_Loc.
  2. Repl_Item_Loc.
  3. Item_Loc_Soh.
  4. Store

If entries are there in the above mentioned tables means you have successfully created a new store in RMS.