Interview Questions.

Q1. What Is The Functionality Behind The "routing Location" In Rms?

Some outlets require a Routing Location for consolidation of Import Orders.  These are distribution centers which aren't cross dock locations and additionally no longer stock keeping locations.  Items are not received at these routing locations; the locations are most effective used for consolidation functions.  From an inventory attitude, a Routing Location is outside the RMS definition of a regular shop or warehouse place. Therefore, it will be created as a part of the Outside Location functionality.

Q2. How To Track Inventory Of Sellable Pack Item?

Inventory is kept and considered on the aspect item degree.  Pack "inventory" may be considered whilst manually asked, but isn't always held in Retail Merchandising System (RMS).  RMS allows customers to view the inventory of Sellable Complex Pack Items thru the Sellable Pack Build (packable) display in the Inventory Menu. 

Q3. Which Version Of Business Intelligence (bi) Publisher Is Required For Rms thirteen.1.X Reports?

For RMS model 13.1 or RMS model thirteen.1.1, Oracle BI Publisher model 10.1.3.Four.Zero is required.

Q4. Does The Elc For An Approved & Not Received Purchase Order Get Updated When Cost Change Extracted?

Whenever fee changes are extracted for an object, hence all of the fee components depending on supplier price get updated (ITEM_EXP_DETAIL).   If RECALC_ORDER_IND is 'Y' for the value alternate, then all of the orders for the item which might be authorized and no longer yet obtained get updated with the brand new unit fee and corresponding costs.  Thus, Estimated Landed Cost (ELC) additionally gets updated.  If RECALC_ORDER_IND is 'N' for the fee exchange, then order fee does now not get up to date.

Q5. What Are The New Functionalities Introduced For "routing Location"?

The "Routing Location" field om the Purchase Order display is editable.  This subject is editable for all order kinds.

Even if defaulted, the user has the choice to do away with the routing vicinity.

The cost in this subject isn't always mandatory.

There isn't any validation at the area kind.

Users may be capable of add a routing location even though it is not related at provider/supplier web page degree.

Q6. How Are Items Associated To A Ticket Type?

Individual objects may be associated to tickets through the Request Ticket window in RMS. Multiple gadgets are associated thru the help of an item list or a Purchase order thru the equal window.

Q7. Where And How Can We Set Up The Data In Hts_import_country_setup Table In Oracle Retail Merchandising System (rms) Release thirteen.1.X?

The setup ought to be finished manually, because it varies from usa to u . S . A .. 

The primary steps are as follows:

Make an entry into HTS_IMPORT_COUNTRY_SETUP table for the united states of america.  (Back-quit access)

Create a Harmonized Tariff Schedule (HTS) chapter from the HTS Heading Maintenance Window [htshead].

Create Quota Category.

Create required HTS from the Harmonized Tariff Schedule Window [hts].

A regular access within the HTS_IMPORT_COUNTRY_SETUP could be:

INSERT INTO HTS_IMPORT_COUNTRY_SETUP VALUES ('IN', 'FMXXXX"."XXXX"."XX', four);

Where columns are Import Country ID, HTS Format Mask, HTS Heading Length.

Q8. How Do I Change The Supplier On A Saved Or Approved Po?

The system does now not allow Supplier replace on a saved or  authorized PO. You will need to cancel the PO and create  a new PO with the precise Supplier.

Q9. If The Pack Type Is Buyer , Then Will The Component Item Cost Change Affect The Buyer Pack Cost?

The Buyer Pack Cost equals the sum of the fee of the additives. Buyer packs are a p.C. Of items that a client companies collectively to simplify the ordering procedure.

Q10. Can You Create A Merchandise Reclassification In Rms Without Specifying An Item Or Item List?

You can setup a dynamic item listing and choose all gadgets within the class to be blanketed in it and then use the object list to reclassify the class.  You can't reclassify all of the gadgets in a class without the use of an object listing.  After you setup the dynamic item list, there's an option to 'Use' the object listing, and it will permit the user to pick out a reclassification.

Q11. How Is The Cost Component Total Expense Zone (texpz) Calculated?

TEXPZ (Total Expense Zone) – This component could be used to save the entire of the prices for each Item/Supplier/Zone/Discharge Port aggregate. It will overall all charges that have an Expense Type of ‘Zone’ within the Item Expenses dialog.  This overall may be introduced together with the Total Expense Country, the Total Duty, and the object’s Unit Cost to give you the Total Estimated Landed Cost of the Item/Supplier/Country combination

Q12. If Edi Functionality Is Not Used, How Can Rms Be Stopped From Holding Data In Edi_daily_sales Table?

Setting the EDI_SALES_RPT_FREQ in SUPS desk to 'W', Sales and stock records could be downloaded weekly, so EDI_DAILY_SALES will no longer be up to date.

Q13. Will Total Elc Be Calculated When The Items Are Received In The Warehouse?

Yes. This is primarily based at the truth that the ELC costs are pretty a great deal determined at item setup, however the ones charges are handiest up to date while receiving takes place

Q14. What Is The Difference Between The Field 'company' In The 'phrases And Conditions' Window And In The Alternate Region 'more' In The Po Shipments?

The subject 'Firm' in the 'Terms and Conditions' indicates that the Purchase order is firm. Firm your purchase order while you need to indicate to Master Scheduling/MRP or your production software that it ought to no longer reschedule this purchase order. The Field 'Firm' in the alternate place 'greater' in the  PO shipments shows that the Purchase order shipment is company. Firm your purchase order cargo when you need to suggest to Master Scheduling/MRP or your manufacturing utility that it need to no longer reschedule this purchase order shipment .

Q15. Can The Data Source Name Be Different Than 'rms13' While Setting Up The Jdbc Connection On Bi Publisher?

In all reports, there is a .Xdo. Those xdo documents have a default information supply set to "RMS13" out of the box.  Therefore it's far required to installation the JDBC reference to a statistics supply name of "RMS13" whilst using reviews out of the field.  The statistics source name in .Xdo record needs to match with the data supply call described for the JDBC connection.

Q16. When Looking At Inventory Inputs, Is Rms Looking At Values For The Physical Or For The Virtual Warehouse Or Does It Depend On The Specific Input?

The stock is checked at the supply warehouse, which is a stock-conserving vicinity. So in a multi-channel surroundings it'd be a virtual warehouse.

Q17. How Do You Change The Unit Price On A Po Line Once The Line Has Been Received Or Invoiced?

Oracle Purchasing will no longer permit unit price replace on Inventory line gadgets whilst the road is received or billed because accounting tractions have already taken vicinity. The distinction between the PO price and bill rate can be recorded in the Invoice Price Variance Account so that you can display up on the Invoice Price Variance document. If you have mistakenly entered the wrong rate on the PO, then you can paintings around this by way of cancelling or backing out the invoice and processing a go back at the receipt so as to permit unit rate update.

Q18. How Will Retail Merchandising System (rms) Handle Discounts On Sellable Pack Items?

If the retail of the % affords a reduction, the bargain is prorated across the aspect objects at the time of sale and could display as a markdown on the stock ledger. 

If the retail of the p.C. Is more than the sum of the retail of the components, the overage could be prorated across the element gadgets at the time of sale.

Q19. What Is The Difference Between Automatic And Semi-automated Replenishment?

Automatic replenishment reasons automatic creations of orders and automatic approvals of those orders. Approvals are handled through the RPLAPPRV batch.   Semi- automated replenishment causes computerized creations of orders, but orders want to be manually permitted.

Q20. What Is A Sellable Complex Pack Item?

A sellable percent is a percent object that includes a couple of objects which might be bought as one object.  These items are typically offered as one unit as a advantage to the purchaser, either in comfort or rate savings.  The approach is, consequently, to inspire the patron to purchase greater.

Q21. Where And How Can We Configure The Unit Count Inventory Adjustment Reason Codes In Rms?

RMS has an Inventory Adjustment Reason Code Maintenance Window [rsninvad].  This window lets in you to preserve a list of reasons for inventory adjustments.  Reasons are used to signify why the overall stock reachable should be elevated or reduced.  For instance, you could want to lower the inventory accessible due to shrinkage. 

To navigate to this window:

From the principle menu, select Control => Setup => Inventory Adjustment Reason => Edit (or View).   The Inventory Adjustment Reason Code Maintenance window opens, allowing you to Add/Maintain or View inventory adjustment purpose codes.

Q22. How Can We Standardize/set Up The Screen Color Of Individual Rms Forms?

Perform these steps:

Save the color palette in your neighborhood machine.

In Forms Builder, open the Form requiring the colour alternate.

Select [Edit] -> [Preferences].

Enable the 'Select Color Mode' on General Tab and click on OK.

Open the main campus.

Select [Edit] -> [Import] -> [Color Palette].

Select the colour palette which turned into stored in Step 1 and click OK.

Save the campus and bring together the respective shape.

Q23. What Is Auto Generation Of Tickets?

Auto generation or car printing of tickets is the procedure by means of which a distinctive ticket kind is routinely printed while the item associated with it thru a purchase order receives

Approved

Received

Undergoes a permanent price alternate

Q24. Is There A Table Where The Total Elc Inclusive The Elc Cost Components Is Stored?

There is no desk that shops Total ELC fee by summing up all components.

Total fee is displayed on ORDHEAD by means of summing up individual issue expense values.

Q25. What Value Should Be Used For The Hts Format_mask?

As this fee depends at the u . S ., you have to to consult your business team to determine the proper format. 

Q26. Should Phase Dates Be Within Season Dates?

The section dates want not always be usually inside season dates. This is due to the fact every now and then you could have items crossing seasons. For example, once in a while you can have a tritional segment that bridges the two seasons. There are some items which trcend from one season to some other and as a result are related to a phase which lies in each seasons.

RMS best uses Season and Phases as attributes or to do things including create object lists and allows overlaps due to the fact they have no vital capability based on those seasons or phases.

Q27. What Tractions Are Affected Due To Reclassification?

Inserts information into the Point Of Sale (POS) down load and writes a traction code.

Inserts information into TRAN_DATA with an inside and out file.

The Open To Buy(OTB) is updated to reflect adjustments.

History, together with income records, is NOT moved.

Stock Ledger tractions are created to move the present day on-hand inventory from the vintage merchandise hierarchy to the brand new products hierarchy.

Q28. How Do We Define Environmental Variables While Setting Up Rms For Bi Publisher?

This is explained in chapter 12 on "Setting up Oracle Business Intelligence Publisher" in "RMS thirteen.0.1 Back-cease Configuration and Operations Guide - Volume three". 

RMS.Env report should have environmental variables set up as in the instance below:

ORACLE_RMS_REPORTS_HOST=http://mspps003.Us.Oracle.Com:7777/ 

ORACLE_RMS_REPORTS_SERVER=xmlpserver 

ORACLE_RMS_RWSERVER=xmlpserver/Guest/rms13/

All the files and directories from STAGING_DIR/rms/application/rms13/reports/* need to be copied to Reports/Guest/rms13 folder on BI Publisher. Port 7777 in the instance is the HTTP pay attention port as defined in /Apache/Apache/conf/httpd.Conf document for BI Publisher.

Note:- While beginning BI writer reports from RMS software, if it fails with blunders "FRM-92020:invalid URL" please verify above settings in .Env document.

Q29. Under What Conditions Would The "routing Location" Be Populated On The Po Screen?

If a supplier/provider site is related to a routing place, the identical might be defaulted on the order header as quickly as the supplier/provider site is delivered.  Validation to test if the order is an import order has been removed (i.E., there is no want to validate whether or not the order is an import order).

Q30. What Is Reclassification?

Reclassification is the system via which an object or object list is moved from one department/class/subclass to another.

Reclassification is initiated on-line individually or the usage of an Item List An powerful date is designated.

Reclassification happens inside the overnight batch Items are reclassified the night time before the effective date.

Q31. Can We Order Or Trfer A Sellable Pack Item?

The Sellable Pack can not be ordered or trferred unless the % is installation as each precious and orderable. 

Q32. What Is A Ticket In Rms?

In RMS the ticketing capability lets in the store to specify the type of records the price ticket ought to contain as regards the product.

Q33. In Sim, Is There Any Process Whereby Skus Not Entering The Count Would Be Defaulted To Zero?

For U&A all objects which have been extracted and aren't counted will default to 0 and be taken into consideration counted.

Q34. What Is The Significance Of "routing Location" Field On The Purchase Order (po) Screen?

The Order Header Maintenance has been amended with a brand new area called "Routing Location" from RMS 13.1.X onwards.   This will serve as the "Ship To" location for consolidation purposes.

Q35. If You Have An Item That Is On Dynamic Replenishment At The Warehouse And Some Stores Have A Replenishment Method Other Than Dynamic, How Does Warehouse Replenishment Account For Those Locations?

When determining the person ROW of stores, it does now not depend which replenishment technique the stores themselves are using, as long as they have got forecasts. 

The attributes of the WH are used to determine the ROW for every save. 

This will allow the WH to apply one replenishment approach to stock the WH (in the course of the provider cycle) and the shops to use a one-of-a-kind replenishment technique for WH to save ordering (during the store cycle).

Q36. What Is The Significance Of Creating 'loc=zero' Record On Price_hist Table During The Item Approval?

Loc=0 file in PRICE_HIST offers the preliminary base retail for the object. This is for reporting or audit purposes simplest.

Q37. Are The Saved Search User Specific?

Yes, it's far particular to software person.

Q38. What Is The Impact Of Delaying The Authorization Process?

At a high degree, the impact might be in the feel that stock will no longer be accurate till the authorization is processed.  In addition, RMS cannot begin the quantity part of the inventory rely.

The essential effect is with regard to late-posting tractions. Ideally this need to just mean sales, as other tractions glide from SIM to RMS in real time. Late-posting sales would update the photograph if they're entered prior to authorizing the depend. 

Inventory/stock ledger overlay will not occur until after authorization. 

Between the depend and the date of authorization, the average value of the item may change, which might also impact the fee of stock. 

Q39. What Is The Difference Between The Control Actions 'on Hold' And 'freeze' For A Purchase Order?

You can region a Purchase order 'On keep' handiest at the header level. This approves the acquisition order even as preventing printing, receiving, invoicing, and future approval until you cast off the hold. You can 'Freeze' most effective at the header and launch level. You freeze a Purchase order when you need to save you any future adjustments to the Purchase order. When you freeze a Purchase order, you could still obtain and pay for items you already ordered. If you use a Requisition template or AutoSource to source requisition strains from a Purchase order line, Purchasing does no longer mechanically update the corresponding sourcing facts whilst you freeze a buy order with which you supply requisition strains. If you freeze a purchase order, you have to replace the corresponding data in the Requisition Templates or the AutoSource Rules window.

Q40. Is There Anyway To Revert Items Back To 'a'ctive Status When They Have Been Accidentally Set To Pending Delete?

When an item is deleted from itemmaster display screen, the item_master.Fame for that item will nevertheless be what it changed into previously. If Active, item_master.Status will nevertheless be 'A'. However, it'll have a report in DAILY_PURGE. Whatever objects those are in DAILY_PURGE can have reputation in the itemmaster display as 'Delete Pending'. We do not have a form/system/capability inside RMS to take away the item from *Delete Pending*. Item might be deleted from the tables during dlyprg.Computer batch run. But it will have to undergo some validations earlier than it may be deleted. Those that failed validation will no longer be purged and an entry might be inserted into DAILY_PURGE_ERROR_LOG. If you do not want to delete the item, you may put off the corresponding file from DAILY_PURGE and DAILY_PURGE_ERROR_LOG tables.

Q41. Is There A Security Model For Approving Purchase Orders Based On The Buyer's Login Id Within A Certain Amount ?

By doing the beneath steps, you may assign an quantity to the client which he can not approve an order that exceeds this amount.

Login to RMS 

Navigate: Control > Setup > User Role Privileges

Set the required amount inside the 'User Role Privileges' screen.

Q42. What Are The Component Items For The Sellable Pack Item?

The percent can include unique objects and/or multiples of the same item. Component objects can come from exclusive departments. Also, aspect gadgets can come from multiple suppliers/foundation countries.

Q43. Is There An On-line Or Gui Form To Do This?

No, previous to RMS Release thirteen.1.X, HTS became configured for one country.  From RMS Release thirteen.1.X onwards, HTS has been generalized to be used by using any united states of america.

Q44. Can You Setup A Different Purchase Order Type Default For The Po Form?

The Purchase Orders form usually defaults a PO form of 'Standard Purchase Order'. Although the default fee cannot be changed, the consumer can alternate the type as soon as the shape opens.

Q45. What Is Edi?

EDI (Electronic Data Interchange) offers a way for shops and providers to trmit enterprise files. EDI trlation programs convert outgoing and incoming files to the suitable flat file or EDI layout. 

RMS EDI packages either create an output report if the records is being trmitted to the dealer or accept an input document initiated by way of the provider. In all instances, the file is trlated with the aid of the patron's EDI trlation software utility. 

Q46. What Are Concession Items?

Concession Items are items that are not owned by way of the store however are captured for future use.  The supplier rents a space from the store, and the retailer in no way owns the objects.

Q47. When Does A Purchase Order Get The Closure Status 'closed'?

When all lines for a given header are closed, Purchasing mechanically closes the document.

Q48. On A Simple Vat (svat) Environment You Have Store And Warehouse Under The Same Vat Region And You Range One Item To Store As Well As Warehouse Via Sitmain Batch, Why The Taxable_ind Is 'n' For Warehou

Taxable indicator (taxable_ind) is despatched to the Point Of Service (ORPOS) system, this isn't always applicable for warehouses. Because ITEM LOCK table is maintained for both save and warehouse locations, at warehouses RMS assigns a default value so as to not be used for whatever.

Q49. What Is A Ticket Type?

A ticket type broadly defining the characteristics of a price ticket consistent with the nature of facts it consists of, and the nature of the item it is meant to get affixed on.

Q50. How Do I Get A Value To Default For The Ship-to And Bill-to Fields On The Po Header?

The default values for Default Ship to and Bill  at the PO header are described inside the Supplier Purchasing area of the Financial alternatives shape.

Setup/businesses/Financial alternatives->   Supplier-Purchasing alternate vicinity

Define the Ship to and Bill to fields