Oracle Retail Merchandising System Interview Questions & Answers

  1. Question 1. What Are Seasons And Phases?

    Answer :

    A season is a specific selling period during the year, and a Phase is a smaller time period within a season. A season may have multiple phases. However while creating a season if a phase is not created under it then a phase with same name and dates as the season is automatically created for the season. For example, a season has to have at least one phase under it.

    Seasons and phases are used in Replenishment.  The items are on replenishment during the dates of the selected season and phase.

  2. Question 2. Should Phase Dates Be Within Season Dates?

    Answer :

    The phase dates need not necessarily be always within season dates. This is because sometimes you may have items crossing seasons. For instance, sometimes you can have a transitional phase that bridges the two seasons. There are some items which transcend from one season to another and hence are associated to a phase which lies in both seasons.

    RMS only uses Season and Phases as attributes or to do things such as create item lists and allows overlaps because they have no critical functionality based on those seasons or phases.

  3. Oracle 11g Interview Questions

  4. Question 3. What Are Concession Items?

    Answer :

    Concession Items are items that are not owned by the retailer but are captured for future use.  The supplier rents a space from the retailer, and the retailer never owns the items.

  5. Question 4. What Are Consignment Items?

    Answer :

    Consignment Items are items that are purchased from the supplier only when the items are sold to a customer.

  6. Oracle 11g Tutorial

  7. Question 5. Should Concession Items Create Tran_data Records?

    Answer :

    All the Merchandise Operations Management (MOM) products ensure that no inventory updates can happen for a concession item.  These validations are handled at the application level.

    For example, in Retail Warehouse Management System (RWMS)/Store Inventory Management (SIM), the application does not allow a concession item to be added as a part of any transaction. The same applies for RMS as well.

  8. Sales Interview Questions

  9. Question 6. How Can Concession Items Create Tran_data Records For Inventory Transactions That Are Interfaced Into Rms?

    Answer :

    Using scripts to manually generate these transactions will create such records.  Since item type validation is conducted at the application level, RMS does not validate for the item type at the package level again while consuming data from an external system (RWMS/SIM).  If external systems other than SIM/RWMS are used, make sure that these systems validate that no transactions are done on these items.

  10. Question 7. What Is A Sellable Complex Pack Item?

    Answer :

    A sellable pack is a pack item that consists of multiple items that are sold as one item.  These items are generally sold as one unit as a benefit to the consumer, either in convenience or price savings.  The strategy is, therefore, to encourage the customer to purchase more.

  11. Oracle BPM Interview Questions

  12. Question 8. What Are The Component Items For The Sellable Pack Item?

    Answer :

    The pack can contain different items and/or multiples of the same item. Component items can come from different departments. Also, component items can come from multiple suppliers/origin countries.

  13. Question 9. How Does Retail Merchandising System (rms) Settle The Retail Price Of The Sellable Pack Item?

    Answer :

    The retail price will default to the sum of the cost of the components plus the pack’s department’s markup, but can be changed. 

  14. Oracle GoldenGate Interview Questions

  15. Question 10. Can We Order Or Transfer A Sellable Pack Item?

    Answer :

    The Sellable Pack cannot be ordered or transferred unless the pack is set up as both valuable and orderable. 

  16. Question 11. How To Track Inventory Of Sellable Pack Item?

    Answer :

    Inventory is kept and viewed at the component item level.  Pack “inventory” can be viewed when manually requested, but is not held in Retail Merchandising System (RMS).  RMS allows users to view the inventory of Sellable Complex Pack Items through the Sellable Pack Build (packable) screen in the Inventory Menu. 

  17. Oracle Streams Interview Questions

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

    Answer :

    If the retail of the pack provides a discount, the discount is prorated across the component items at the time of sale and will show as a markdown on the stock ledger. 

    If the retail of the pack is greater than the sum of the retail of the components, the overage will be prorated across the component items at the time of sale.

  19. Oracle 11g Interview Questions

  20. Question 13. For A Complex Pack With Pack Type As Vendor, Should The Vendor Pack Cost Change When Component Item Cost Changes Are Done?

    Answer :

    The Vendor Pack cost is not based on the component costs.  Vendor packs are groups of items that come in packs predefined by the vendor. The vendor determines the cost of the pack.

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

    Answer :

    The Buyer Pack Cost equals the sum of the cost of the components. Buyer packs are a pack of items that a buyer groups together to simplify the ordering process.

  22. Question 15. Why Does Not The Unit Cost (unit_cost) Updated In The Item_loc_soh Table For A Vendor Pack Item After A Cost Change?

    Answer :

    Pack items will not have a unit cost stored in the ITEM_LOC_SOH table. Stock for a pack item is determined at the component level and therefore a unit cost is not applicable for a pack item. Hence the unit cost is not updated in the ITEM_LOC_SOH table for a vendor pack item after a cost change.

  23. Oracle BI Publisher Interview Questions

  24. Question 16. What Packages Or Functions In Rms Use Unit_cost Column In The Item_loc_soh Table?

    Answer :

    In general, UNIT_COST column in the ITEM_LOC_SOH table is updated and used when the STD_AV_IND = ‘S’ in SYSTEM_OPTIONS table, otherwise AV_COST is used (i.e., STD_AV_IND = ‘A’  SYSTEM_OPTIONS table).

    The following list of modules use column UNIT_COST in the ITEM_LOC_SOH table for different purposes:

    • costextb.pls
    • delitemb.pls
    • invadjb.pls
    • ioattrb.pls
    • itappb.pls
    • lkitemsqlb.pls
    • lkstexeb.pls
    • mrt.pc
    • stkupld.pc
  25. Question 17. 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 Warehouse While It Is ‘y’ For Store?

    Answer :

    Taxable indicator (taxable_ind) is sent to the Point Of Service (ORPOS) system, this is not applicable for warehouses. Because ITEM LOCK table is maintained for both store and warehouse locations, at warehouses RMS assigns a default value which will not be used for anything.

  26. Oracle Application Framework Interview Questions

  27. Question 18. What Is The Significance Of Creating ‘loc=0’ Record On Price_hist Table During The Item Approval?

    Answer :

    Loc=0 record in PRICE_HIST gives the initial base retail for the item. This is for reporting or audit purposes only.

  28. Sales Interview Questions

  29. Question 19. What Is Reclassification?

    Answer :

    • Reclassification is the process through which an item or item list is moved from one department/class/subclass to another.
    • Reclassification is initiated on-line individually or using an Item List An effective date is specified.
    • Reclassification occurs in the overnight batch Items are reclassified the night before the effective date.
  30. Question 20. What Checks Are Performed In Retail Merchandising System (rms) For An Item Under Reclassification?

    Answer :

    • RMS will check to see if the item has the UDA (User Defined Attributes) that is required for the new Merchandise hierarchy, if it does not the item will be rejected.
    • RMS will check to see if the item has default UDA’s, if it does not, it will still reclassify the item but, a warning message will be written to a report.
    • If the item is on any not-yet-processed “unit and value” stock count. If it is, it can not be reclassified. 
    • If the item is part of a consignment department and it is being reclassified to a non-consignment department and vice versa reclassification fails.
    • If the item is forecastable, RMS will check to ensure the new merchandise hierarchy has a domain in Retail Demand Forecasting (RDF). If a domain is not associated with the new merchandise hierarchy, the reclassification will be rejected. If there is a domain change in RDF, RMS will write all store sales history for the item to the forecasting download.
    • The item exists in another reclassification event.
    • If the item level of the item is not equal to 1, then it cannot be reclassified. .
    • One or more items on the reclassification event exist on approved partially received orders.
    • If item is in a simple pack, it will fail reclassification. The item can only be reclassified along with its component item. 
    • If item is a pack item, it cannot be reclassified from merchandise to consignment department. 
  31. Oracle Core Dba Interview Questions

  32. Question 21. What Transactions Are Affected Due To Reclassification?

    Answer :

    • Inserts records into the Point Of Sale (POS) download and writes a transaction code.
    • Inserts records into TRAN_DATA with an in and out record.
    • The Open To Buy(OTB) is updated to reflect changes.
    • History, such as sales history, is NOT moved.
    • Stock Ledger transactions are created to move the current on-hand inventory from the old merchandise hierarchy to the new merchandise hierarchy.
  33. Question 22. Can You Create A Merchandise Reclassification In Rms Without Specifying An Item Or Item List?

    Answer :

    You can setup a dynamic item list and select all items in the class to be included in it and then use the item list to reclassify the class.  You cannot reclassify all the items in a class without using an item list.  After you setup the dynamic item list, there is an option to ‘Use’ the item list, and it will allow the user to select a reclassification.

  34. Question 23. What Is The Use Of Pending Merchandise Hierarchy?

    Answer :

    The use of Pending Merchandise Hierarchy is to change the structure of the merchandise hierarchy itself.

    For example:

    suppose you have the following hierarchy:

    Dept 1: Class 1001: Subclass 101

    Dept 1: Class 1002: Subclass 201

    Dept 2: Class 2001: Subclass 211

    Now suppose you want to move Class 1002 into Dept 2.

    Using Pending Merchandise Hierarchy you can make this move so the structure will look like this:

    Dept 1: Class 1001: Subclass 101

    Dept 2: Class 1002: Subclass 201

    Dept 2: Class 2001: Subclass 211

    A item reclassification is different.  It could be used to move the items between departments, but it would not affect the structure of the merchandise hierarchy itself.

  35. Oracle Retail Sales Audit Interview Questions

  36. Question 24. What Is A Ticket?

    Answer :

    A ticket is a tag that is affixed to an item in the store. The purpose of the ticket is to carry information on the item that cannot be usually depicted on the product.

  37. Oracle BPM Interview Questions

  38. Question 25. What Does It Contain?

    Answer :

    A ticket contains important information about the product. Information like the item code, price of the product, particular instructions for handling the product, etc:

  39. Question 26. What Is A Ticket In Rms?

    Answer :

    In RMS the ticketing functionality allows the retailer to specify the type of information the ticket should contain as regards the product.

  40. Oracle SCM Interview Questions

  41. Question 27. Where Does Ticketing Happen?

    Answer :

    The setting of the format of the ticket or making the ticket type as well as manual initiation of requisitioning a ticket happens in RMS. While the actual printing of the tickets are done by an external application viz; Avery

  42. Oracle GoldenGate Interview Questions

  43. Question 28. What Is Auto Generation Of Tickets?

    Answer :

    Auto generation or auto printing of tickets is the process by which a specified ticket type is automatically printed when the item associated with it through a purchase order gets

    • Approved
    • Received
    • Undergoes a permanent price change
  44. Question 29. What Is A Ticket Type?

    Answer :

    A ticket type broadly defining the characteristics of a ticket according to the nature of information it contains, and the nature of the item it is meant to get affixed on.

  45. RPM Package Manager (RPM) Interview Questions

  46. Question 30. How Are Items Associated To A Ticket Type?

    Answer :

    Individual items can be associated to tickets through the Request Ticket window in RMS. Multiple items are associated through the help of an item list or a Purchase order through the same window.

  47. Question 31. What Is The Functionality Behind The “routing Location” In Rms?

    Answer :

    Some retailers require a Routing Location for consolidation of Import Orders.  These are distribution centers which are not cross dock locations and also not stock holding locations.  Items are not received at these routing locations; the locations are only used for consolidation purposes.  From an inventory perspective, a Routing Location is outside the RMS definition of a regular store or warehouse location. Therefore, it will be created as part of the Outside Location functionality.

  48. Question 32. What Is The Significance Of “routing Location” Field On The Purchase Order (po) Screen?

    Answer :

    The Order Header Maintenance has been amended with a new field called “Routing Location” from RMS 13.1.x onwards.   This will serve as the “Ship To” location for consolidation purposes.

  49. Salesforce Report And Dashboard Interview Questions

  50. Question 33. What Are The Limitations To The “routing Location” Functionality On The Po Screen?

    Answer :

    Previous versions of RMS (versions prior to RMS were designed to default the routing location only if the following criteria were satisfied:

    • Order should be an import order.
    • Order should have all Stores and no Warehouse (WH).
    • Order should have items attached to it.
  51. Oracle Streams Interview Questions

  52. Question 34. Under What Conditions Would The “routing Location” Be Populated On The Po Screen?

    Answer :

    If a supplier/supplier site is associated to a routing location, the same will be defaulted at the order header as soon as the supplier/supplier site is added.  Validation to check if the order is an import order has been removed (i.e., there is no need to validate whether or not the order is an import order).

  53. Question 35. What Are The New Functionalities Introduced For “routing Location”?

    Answer :

    • The “Routing Location” field om the Purchase Order screen is editable.  This field is editable for all order types.
    • Even if defaulted, the user has the option to remove the routing location.
    • The value in this field is not mandatory.
    • There is no validation on the location type.
    • Users will be able to add a routing location even if it is not associated at supplier/supplier site level.
  54. Question 36. How Is Total Elc Calculated?

    Answer :

    ELC calculation logic is based on the values of ELC_COMP.CALC_BASIS and ELC_COMP.COST_BASIS.

    ELC_COMP.CALC_BASIS decides whether the expense component is calculated on per-unit basis or value basis. ELC_COMP.COST_BASIS decides whether expense is calculated on Supplier cost or Order cost. 

    If COST_BASIS is ‘S’, ITEM_SUPPLIER_COUNTRY.UNIT_COST is used to calculate expense. If COST_BASIS is ‘O’, ORDLOC.UNIT_COST is used. 

    Table ELC_COMP stores details of expense components along with rates, currency, cost_basis, calc_basis, etc. Table ORDLOC_EXP stores expense value at order, item, location and expense component level.

  55. Oracle BI Publisher Interview Questions

  56. Question 37. Is There A Table Where The Total Elc Inclusive The Elc Cost Components Is Stored?

    Answer :

    There is no table that stores Total ELC value by summing up all components.

    Total expense is displayed on ORDHEAD by summing up individual component expense values.

  57. Question 38. Will Total Elc Be Calculated When The Items Are Received In The Warehouse?

    Answer :

    Yes. This is based on the fact that the ELC costs are pretty much determined at item setup, but those costs are only updated when receiving happens

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

    Answer :

    Whenever cost changes are extracted for an item, accordingly all the cost components dependent on supplier cost get updated (ITEM_EXP_DETAIL).   If RECALC_ORDER_IND is ‘Y’ for the cost change, then all the orders for the item which are approved and not yet received get updated with the new unit cost and corresponding expenses.  Thus, Estimated Landed Cost (ELC) also gets updated.  If RECALC_ORDER_IND is ‘N’ for the cost change, then order cost does not get updated.

  59. Question 40. What Is The Base Cost For Calculating Order Cost As Well As The Estimated Landed Cost?

    Answer :

    The base cost for the order is ITEM_SUPP_COUNTRY_LOC.UNIT_COST. The landed cost for a purchase order will be (ITEM_SUPP_COUNTRY_LOC.UNIT_COST) X ORDER Quantity + Expenses.

  60. Oracle Application Framework Interview Questions

  61. Question 41. How Is The Cost Component Total Expense Zone (texpz) Calculated?

    Answer :

    TEXPZ (Total Expense Zone) – This component will be used to store the total of the expenses for each Item/Supplier/Zone/Discharge Port combination. It will total all expenses that have an Expense Type of ‘Zone’ within the Item Expenses dialog.  This total will be added together with the Total Expense Country, the Total Duty, and the item’s Unit Cost to come up with the Total Estimated Landed Cost of the Item/Supplier/Country combination

  62. Question 42. What Is Edi?

    Answer :

    EDI (Electronic Data Interchange) provides a method for retailers and suppliers to transmit business documents. EDI translation programs convert outgoing and incoming files to the appropriate flat file or EDI format. 

    RMS EDI programs either create an output file if the data is being transmitted to the supplier or accept an input file initiated by the supplier. In all cases, the file is translated by the customer’s EDI translation software application. 

  63. Oracle Core Dba Interview Questions

  64. Question 43. How To Use Edi?

    Answer :

    You must indicate which EDI transactions are supported by the supplier. If the supplier requests product activity, you can indicate whether the data should be transmitted on a daily or weekly basis. 

    Also you should indicate the variance allowed for cost changes by monetary amount and by percentage. Cost changes received from the supplier that are within the tolerated range are automatically approved by the system after you accept changes.

  65. Question 44. Where Are The Daily Sales Information Held Before Being Transmitted To The Supplier?

    Answer :

    EDI_DAILY_SALES holds daily sales information for SKUs of suppliers transmitting daily EDI activity reports. It will hold sales quantities of SKUs at the location and the transaction date level. 

    The table will only hold information regarding regular sales. It will be populated during the processing of POSUPLD. 

    Records will be purged according to the EDI_DAILY_RPT_LAG indicator on SYSTEM_OPTIONS.

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

    Answer :

    Setting the EDI_SALES_RPT_FREQ in SUPS table to ‘W’, Sales and stock information will be downloaded weekly, so EDI_DAILY_SALES will not be updated.

  67. Question 46. How Is The Edi_daily_sales Deleted?

    Answer :

    Running the post processing for EDIDLPRD patch will delete data from the EDI_DAILY_SALES table.

  68. Question 47. Where And How Can We Set Up The Data In Hts_import_country_setup Table In Oracle Retail Merchandising System (rms) Release 13.1.x?

    Answer :

    The setup must be done manually, as it varies from country to country. 

    The basic steps are as follows:

    1. Make an entry into HTS_IMPORT_COUNTRY_SETUP table for the country.  (Back-end entry)
    2. Create a Harmonized Tariff Schedule (HTS) chapter from the HTS Heading Maintenance Window [htshead].
    3. Create Quota Category.
    4. Create required HTS from the Harmonized Tariff Schedule Window [hts].

    A typical entry in the HTS_IMPORT_COUNTRY_SETUP would be:


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

  69. Question 48. Is There An On-line Or Gui Form To Do This?

    Answer :

    No, prior to RMS Release 13.1.x, HTS was configured for one country.  From RMS Release 13.1.x onwards, HTS has been generalized for use by any country.

  70. Question 49. What Value Should Be Used For The Hts Format_mask?

    Answer :

    As this value depends on the country, you should to consult your business team to determine the proper format. 

  71. Question 50. What Is The Difference Between Internal Finisher And External Finisher?

    Answer :

    Internal finishers are part of the warehouse where some tasks are performed on the merchandise. These are not used to store merchandise. Internal finishers have much of the same functionality of a normal virtual warehouse in Retail Merchandising System (RMS) except for the following:

    1. It cannot be attached to Stores as the Default Warehouse
    2. It cannot be the From Location nor the To Location of a Transfer. It can only be selected as a middle point on a 2 legged transfer
    3. Can be part of Allocation
    4. Cannot order to an Internal Finisher
    5. Cannot Replenish To/From an Internal Finisher

    External finishers on the other hand are created as Partners. External finishers are finishing location not part of the organizational hierarchy. External finishers are included as a location within the Item/Location Inventory (ITEM_LOC_SOH) table providing full range of inventory buckets to review.

  72. Question 51. Why Are Deals Not Applied For Dsd (direct Store Delivery) Purchase Orders When The Unit Cost Is Changed Manually?

    Answer :

    The Retail Merchandising System (RMS) Purchase Order dialog prompts the user with a “Yes/No” message asking if manual costs should be overwritten when applying deals on ORDHEAD form. However, same user interaction is not provided for DSD orders created through the Application Programming Interface (API). The assumption with DSD orders is that the receiving location (store) has a better idea what the supplier’s cost is at the time of receiving than does the corporate system so RMS don’t override any cost that were manually entered because the end result may be a higher cost. Any changes to this process will have to be built on a custom basis because they will not be applicable to the business processes of all clients.

  73. Question 52. What Are The Conditions To Generate An Unit & Amount Stockcount Regarding Item Status And Soh Value?

    Answer :

    To generate a Unit & Amount Stockcount you have to implement the follow conditions:

    1. 3rd Party Stock Count – Unit and Amount Option should be Set to “NO” under store admin.
    2. Only sellable items can be counted.
    3. Items with status of A, C, D, Q, I  will be on the Stock Count for any SOH.
    4. Items with status I & D will only be on the Stock Count if there is negative or positive SOH, not 0 SOH.
    5. Nonranged items should not appear on the stock count.
    6. Nonsellable packs will not appear on the stock count.
    7. Is mandatory to have have item location records.
  74. Question 53. Is There Anyway To Revert Items Back To ‘a’ctive Status When They Have Been Accidentally Set To Pending Delete?

    Answer :

    When an item is deleted from itemmaster screen, the item_master.status for that item will still be what it was previously. If Active, item_master.status will still be ‘A’. However, it will have a record in DAILY_PURGE. Whatever items those are in DAILY_PURGE will have status in the itemmaster screen as ‘Delete Pending’. We do not have a form/process/functionality within RMS to remove the item from *Delete Pending*. Item will be deleted from the tables during dlyprg.pc batch run. But it will have to go through some validations before it can be deleted. Those that failed validation will not be purged and an entry will be inserted into DAILY_PURGE_ERROR_LOG. If you do not want to delete the item, you can remove the corresponding record from DAILY_PURGE and DAILY_PURGE_ERROR_LOG tables.

  75. Question 54. How Do I Change The Supplier On A Saved Or Approved Po?

    Answer :

    The system does not allow Supplier update on a saved or  approved PO. You will need to cancel the PO and create  a new PO with the correct Supplier.

  76. Question 55. Can You Setup A Different Purchase Order Type Default For The Po Form?

    Answer :

    The Purchase Orders form always defaults a PO type of ‘Standard Purchase Order’. Although the default value cannot be changed, the user can change the type once the form opens.

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

    Answer :

    The default values for Default Ship to and Bill  on the PO header are defined in the Supplier Purchasing region of the Financial options form.

    Setup/organizations/Financial options->   Supplier-Purchasing alternate region

    Define the Ship to and Bill to fields

  78. Question 57. When Does A Purchase Order Line Get Closure Status ‘closed For Receiving’?

    Answer :

    Purchasing automatically closes shipments for receiving and invoicing based on Tolerances that you specify in the Purchasing Options window. Once all shipments for a given line are received and invoiced within these tolerances, purchasing automatically closes the line 

  79. Question 58. When Does A Purchase Order Get The Closure Status ‘closed’?

    Answer :

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

  80. Question 59. What Is The Difference Between The Control Actions ‘on Hold’ And ‘freeze’ For A Purchase Order?

    Answer :

    You can place a Purchase order ‘On hold’ only at the header level. This approves the purchase order while preventing printing, receiving, invoicing, and future approval until you remove the hold. You can ‘Freeze’ only at the header and release level. You freeze a Purchase order when you want to prevent any future modifications to the Purchase order. When you freeze a Purchase order, you can still receive and pay for goods you already ordered. If you use a Requisition template or AutoSource to source requisition lines from a Purchase order line, Purchasing does not automatically update the corresponding sourcing information when you freeze a purchase order with which you source requisition lines. If you freeze a purchase order, you have to update the corresponding information in the Requisition Templates or the AutoSource Rules window.

  81. Question 60. What Is The Difference Between The Field ‘firm’ In The ‘terms And Conditions’ Window And In The Alternate Region ‘more’ In The Po Shipments?

    Answer :

    The field ‘Firm’ in the ‘Terms and Conditions’ indicates that the Purchase order is firm. Firm your purchase order when you want to indicate to Master Scheduling/MRP or your manufacturing application that it should not reschedule this purchase order. The Field ‘Firm’ in the alternate region ‘more’ in the  PO shipments indicates that the Purchase order shipment is firm. Firm your purchase order shipment when you want to indicate to Master Scheduling/MRP or your manufacturing application that it should not reschedule this purchase order shipment .

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

    Answer :

    Oracle Purchasing will not allow unit price update on Inventory line items

    when the line is received or billed because accounting transactions have already taken place.   The difference between the PO price and invoice price will be recorded in the Invoice Price Variance Account which will show up on the Invoice Price Variance report.  If you have mistakenly entered the incorrect price on the PO, then you can workaround this by cancelling or backing out the invoice and processing a return on the receipt which will allow unit price update.

  83. Question 62. Is There A Security Model For Approving Purchase Orders Based On The Buyer’s Login Id Within A Certain Amount ?

    Answer :

    By doing the below steps, you will assign an amount to the buyer which he can not approve an order that exceeds this amount.

    Login to RMS 

    Navigate: Control > Setup > User Role Privileges

    Set the required amount in the ‘User Role Privileges’ screen.

  84. Question 63. Is It Available To Have Two Level Approval That Can Be Done On A Purchase Order?

    Answer :

    There is no two level approval

  85. Question 64. What Is The Difference Between Automatic And Semi-automatic Replenishment?

    Answer :

    Automatic replenishment causes automatic creations of orders and automatic approvals of those orders. Approvals are handled through the RPLAPPRV batch.   Semi- automatic replenishment causes automatic creations of orders, but orders need to be manually approved.

  86. Question 65. Which Orders Are Purged Due To Inventory Management Supplier Minimum Constraint?

    Answer :

    The RPLAPPRV batch will look through all orders created, but will only approve automatic replenishment related orders.  It also will purge orders if Inventory Management Supplier has a minimum order constraint and order purge below minimum is set.

    The RPLAPPRV batch differentiates between automatic and semi-automatic replenishment-created orders using the ORD_INV_MGMT.ORD_APPROVE_IND flag.  If ORD_APPROVE_IND  = ‘Y’, then the order was created in the replenishment process with the intention of being approved during the order approval validation process (Automatic); otherwise it will not (Semi-Automatic).

    Exactly what RMS data tables/data fields are needed as inputs for the DC Replenishment Min/Max Calculation? Specifically looking at how on-order (PO) and on-hand (stock) totals per item per location.

    The replenishment batch Rplext.pc looks into the REPL_ITEM_LOC and ITEM_LOC_SOH tables to determine the Recommended Order Quantity (ROQ) in the ORDTEMP table. Batch Rplbld.pc further generates orders. Inventory availability at warehouses (for DC replenishment) is calculated by the Rplext.pc batch based on details in ITEM_LOC_SOH table.

  87. Question 66. 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?

    Answer :

    The inventory is checked at the source warehouse, which is a stock-holding location. So in a multi-channel environment it would be a virtual warehouse.

  88. Question 67. 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?

    Answer :

    1. When determining the individual ROW of stores, it does not matter which replenishment method the stores themselves are using, as long as they have forecasts. 
    2. The attributes of the WH are used to determine the ROW for each store. 
    3. This will allow the WH to use one replenishment method to stock the WH (during the supplier cycle) and the stores to use a different replenishment method for WH to store ordering (during the store cycle).
  89. Question 68. Which Version Of Business Intelligence (bi) Publisher Is Required For Rms 13.1.x Reports?

    Answer :

    For RMS version 13.1 or RMS version 13.1.1, Oracle BI Publisher version is required.

  90. Question 69. Which Version Of Business Intelligence (bi) Publisher Is Required For Rms 13.0.x Reports?

    Answer :

    BI Publisher Enterprise Edition bundled with Oracle Business Intelligence Suite Enterprise Edition (OBIEE) is required.

  91. Question 70. Can The Data Source Name Be Different Than ‘rms13’ While Setting Up The Jdbc Connection On Bi Publisher?

    Answer :

    In all reports, there is a .xdo. Those xdo files have a default data source set to “RMS13” out of the box.  Therefore it is required to set up the JDBC connection with a data source name of “RMS13” when using reports out of the box.  The data source name in .xdo file needs to match with the data source name defined for the JDBC connection.

  92. Question 71. How Do We Define Environmental Variables While Setting Up Rms For Bi Publisher?

    Answer :

    This is explained in chapter 12 on “Setting up Oracle Business Intelligence Publisher” in “RMS 13.0.1 Back-end Configuration and Operations Guide – Volume 3”. 

    RMS.env file should have environmental variables set up as in the example below:




    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 example is the HTTP listen port as defined in /Apache/Apache/conf/httpd.conf file for BI Publisher.

    Note:- While opening BI publisher reports from RMS application, if it fails with error “FRM-92020:invalid URL” please confirm above settings in .env file.

  93. Question 72. Where Is The Report Repository In Bi Publisher?

    Answer :

    Report Repository needs to be set up as “File System” type and its value is set to the folder where Admin, Demo  Files, Reports, Tools and Users folders are created.  This can be viewed by clicking on the Admin tab and then Report Repository under System Maintenance for BI Publisher.

  94. Question 73. Is It Required To Have Bi Publisher To Generate Rms Reports?

    Answer :

    BI Publisher is required in version 13.0.1 or later.  With the RMS 13.0.1 release, reports have been rewritten using BI Publisher and RDF reports have been discontinued.

  95. Question 74. Are The Saved Search User Specific?

    Answer :

    Yes, it is specific to application user.

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

    Answer :

    Perform these steps:

    1. Save the color palette in your local machine.
    2. In Forms Builder, open the Form requiring the color change.
    3. Select [Edit] -> [Preferences].
    4. Enable the ‘Select Color Mode’ on General Tab and click OK.
    5. Open the main campus.
    6. Select [Edit] -> [Import] -> [Color Palette].
    7. Select the color palette which was saved in Step 1 and click OK.
    8. Save the campus and compile the respective form.
  97. Question 76. What Is The Impact Of Delaying The Authorization Process?

    Answer :

    At a high level, the impact will be in the sense that inventory will not be accurate until the authorization is processed.  In addition, RMS cannot start the amount part of the stock count.

    • The main impact is with regard to late-posting transactions. Ideally this should just mean sales, as other transactions flow from SIM to RMS in real time. Late-posting sales would update the snapshot if they are entered prior to authorizing the count. 
    • Inventory/stock ledger overlay will not occur until after authorization. 
    • Between the count and the date of authorization, the average cost of the item may change, which may impact the cost of inventory. 
  98. Question 77. In Sim, Is There Any Process Whereby Skus Not Entering The Count Would Be Defaulted To Zero?

    Answer :

    For U&A all items that have been extracted and are not counted will default to zero and be considered counted.

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

    Answer :

    RMS has an Inventory Adjustment Reason Code Maintenance Window [rsninvad].  This window allows you to maintain a list of reasons for inventory adjustments.  Reasons are used to indicate why the total stock on hand should be increased or decreased.  For example, you may need to decrease the stock on hand due to shrinkage. 

    To navigate to this window:

    From the main 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 reason codes.

  100. Question 79. Why Do Some Transactions Update The Stock Counts While Others Do Not?

    Answer :

    In Store Inventory Management (SIM): 

    Some transactions can happen during a Unit & Amount (U&A) stock count while other transactions should be prevented from happening during a count. Sales and inventory adjustments can update the snapshot; sales because SIM cannot control that information unlike all the receiving and shipping transactions, and inventory adjustments because these sometimes are required in case something breaks during the count. 

    In Retail Price Management (RPM): 

    The behavior should be consistent across the transaction types.  Customers using SIM will want to avoid updating the snapshot, as SIM does not do this.

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

    Answer :

    Oracle Purchasing will not allow unit price update on Inventory line items when the line is received or billed because accounting transactions have already taken place. The difference between the PO price and invoice price will be recorded in the Invoice Price Variance Account which will show up on the Invoice Price Variance report. If you have mistakenly entered the incorrect price on the PO, then you can work around this by cancelling or backing out the invoice and processing a return on the receipt which will allow unit price update.