Interview Questions.

Top 100+ Oracle Retail Sales Audit Interview Questions And Answers

fluid

Top 100+ Oracle Retail Sales Audit Interview Questions And Answers

Question 1. What Is Significance Of "home Store" Indicator In Resa? Explain In Detail?

Answer :

If a shop employee is assigned a domestic keep in the Employee Maintenance form, the Store Day Find form will show simplest data for that given keep while Edit/View is selected from the movement field. To view all of the shops assigned to the consumer in ReSA (the Employee Maintenance form), click the refresh button and pick the Assigned Stores radio button. 

Question 2. How To Populate "sa_export_options" Using Resa User Interface (ui) ?

Answer :

sa_system_options isn't updated from RESA UI but is populated at time of set up by way of running the script sa_system_required.Sq. 

Oracle 11g Interview Questions
Question three. How Can User Know Whether It Is A Single Or Multilevel Audit Scenario? Is There Any Indicator Or Value Exist For This?

Answer :

This information is maintained at the Store Data window of the Store Maintenance form inside the Retail Merchandising System (RMS). The multi-degree audit settings for character shops are saved on the ds_store_data table. Stores are described as multi-degree audit stores whilst the system_code discipline is ‘MLA’and the imp_exp field is ‘I’ for a specific save. If these settings are not described for a shop, then ReSA defines the shop as a unmarried stage audit keep. Single level audit might be described if the consumer chooses ‘Point Of Sale (POS)’ as an import for a given store. 

Question 4. What Condition Should Exist For Store Based On Which Saexpgl Batch Picks Up The Data To "stg_fif_gl_data" Table?

Answer :

SAEXPGL exports totals to Oracle Financial Application wellknown ledger for: 

Sales transactions 
Tenders 
Paid-ins 
Paid-outs 
Taxes 
This export batch module works through first getting the store day. Then it reveals the totals to export and verifies that character totals contain no mistakes for either the shop/day (if keep/day is the unit-of-paintings described by means of the person) or save/day/general (if save/day/overall is the unit-of-work described by means of the user). Next the module looks at the SA_FIF_ORA_CROSS_REF desk to decide which Oracle account ID (Cost Center ID) it needs to export to. Determine if the chosen shop/day/general has been previously exported; in that case, reverse the preceding posting, and put up the modern day changes to the General Ledger (GL) staging table. Finally it moves the statistics to the Oracle staging GL_INTERFACE. (No RMS staging desk is involved.)

Oracle 11g Tutorial
Question 5. How To Find Out What Roles A User Have, And If Those Roles Have The Correct Privileges?

Answer :

To verify whether or not a person became granted a privilege, or a position become granted a privilege, you may use the subsequent (for this situation, RMSDEV101A is used): 

Check to look if the consumer became granted the device privilege directly: 

SQL> desc dba_sys_privs 

SQL> pick out * from dba_sys_privs where grantee = 'RMSDEV101A';

If the end result for the above query does now not show the system privileges granted for the consumer, test to look what roles the user changed into granted, after which test to peer what privs has been granted to that position:

SQL> desc dba_role_privs 

SQL> choose * from dba_sys_privs wherein grantee = 'DEVELOPER'; 

Whenever you want to look what roles and device privileges a consumer has and what gadget privileges are assigned to precise roles, you ought to have a look at the dba_role_privs and dba_sys_privs views. 

From a ReSA attitude a user ought to have the following privileges to create totals and perspectives: 

Create any view 
Create any procedure 
Alter any procedure 
Drop any view 
Drop any manner
Accounts and Finance for Managers Interview Questions
Question 6. On The System Option Form, In Retail Sales Audit (resa), There Are Two Fields In The Compare Store Criteria Block, Date To Determine Comp. Store Status And No. Elapsed Days To Determine Comp. Status. What Are These Fields Used For In Resa?

Answer :

These are used for the Flash Sales reviews – permitting the commercial enterprise to determine while a shop has enough buying and selling records. The date to determine comp. Status may be primarily based on 3 elements: save open date, remodel date, or gather date. These dates are held on the store table inside the Retail Merchandising System (RMS).

Question 7. Does Only Point Of Sale (pos) Data Come Through Retail Sales Audit (resa)?

Answer :

Stock Counts, Receipts, Transfers and Inventory Adjustments aren't sent via ReSA. These varieties of transactions can either be supported by way of Retail Store Systems (RSS) or loaded directly into the Retail Merchandise System (RMS) from the POS. Transfer Ins, Transfer Outs, Receipts, and Return to Vendor (RTVs) may be loaded immediately into RMS using add documents. 

Main transactions processed with the aid of ReSA are the subsequent:

Sales
Returns
Exchanges
Voids
Post Voids
Paid In / Paid Out
No Sales
Pull
Loan
Open
Close
Fuel Transactions (e.G. Tank Dips, Meter Readings, etc…) 
NOTE: Not all POS structures guide all of those transactions.

Accounts and Finance for Managers Tutorial Auditing Interview Questions
Question eight. What Does The ‘dclose’ Transaction Signify In Retail Sales Audit (resa)?

Answer :

ReSA requires the ‘DCLOSE’ transaction in both multi-level and unmarried degree audit situations. This transaction indicates to ReSA that every one Point of Sales (POS) transactions were obtained. Once the ‘DCLOSE’ transaction is acquired, ReSA will not receive any more RTLOGs for the given save/day.

Question 9. What Happens When Retail Sales Audit (resa) Receives The ‘dclose’ Transaction In Both A Multi-stage And Single Level Audit Scenario?

Answer :

When the ‘D CLOSE’ file is acquired from the Point of Sale (POS) in a multi-level audit state of affairs, ReSA updates the Data Status to ‘Fully Loaded’. If errors are determined, ReSA units the Audit Status to ‘Store Errors Pending’. If no errors are located, ReSA units the Audit Status to ‘Audited’ and Store Status will be Worksheet.

 When the ‘D CLOSE’ document is received from the POS in unmarried stage audit state of affairs, ReSA updates the Data Status to ‘Fully Loaded’ and the Store Status to ‘Closed’. If errors are found, ReSA units the Audit Status to ‘HQ Errors Pending’. If no errors are discovered, ReSA sets the Audit Status to ‘Audited’.

Retail Interview Questions
Question 10. How Does Retail Sales Audit (resa) Know That A Store Will Be Trickle Polled?

Answer :

There is no placing in ReSA to define if a store could be trickle polled. The best requirement is to ship a ‘DCLOSE’ transaction to ReSA on the quit of the day. If a Retail Transaction Log (RTLOG) is loaded however does now not include the ‘DCLOSE’ transaction, the Data Status is up to date to ‘Partially Loaded’. If the ‘DCLOSE’ transaction is acquired the Data Status is updated to ‘Fully Loaded’.

Retail Management Tutorial
Question 11. The Sagetref.Computer Program, In Retail Sales Audit (resa), Creates A “credit Card Mappings” File. What Is In This File?

Answer :

Sagetref.Computer read the sa_cc_val and writes to the credit score card mappings report. This table is used to hold records for credit score card validation. This desk holds the prefix variety, credit card quantity period, and sort of validation (modulus 10 or none) for a selected credit card.

This table is maintained by using the DBA or IT Group. There are not any the front-give up displays.

Sales Interview Questions
Question 12. Does Retail Sales Audit (resa) Have Its Own Sku/upc Tables That Are Populated By Sagetref.Computer?

Answer :

ReSA does now not have its own SKU/UPC tables. Sagetref.Pc creates a number of output files from one-of-a-kind RMS tables such as ITEM_MASTER, VAR_UPC_EAN and so on and the saimptlog.Computer batch application reads the documents to carry out field stage validation. Some examples of those output files are a listing of all valid SKUs, UPCs, promotions, codes, tenders, and many others…

Oracle 11g Interview Questions
Question 13. What Exactly Does The Saimptlogfin.Laptop Batch Program Do In Retail Sales Audit (resa)?

Answer :

Saimptlogfin.Laptop creates a stability group entry (SA_BALANCE_GROUP table) for the shop/day, cancels post voided transactions, updates the Data Status to ‘Fully Loaded’ if the ‘DCLOSE’ transaction is obtained (sets Store Status to ‘Closed’ if single degree audit). It additionally removes lacking transaction information which might be now gift because of loading statistics out of sequence.

Question 14. Does The Savouch.Computer Program In Retail Sales Audit (resa) Perform Validation On Vouchers?

Answer :

Yes, this application performs minimal validation (voucher quantity is numeric). The validation does no longer test if a voucher has formerly been redeemed. If this is important, a rule will want to be described in ReSA to perform the validation.

Question 15. Can Sales And Returns Occur On The Same Transaction Record In Retail Sales Audit (resa)?

Answer :

Yes, ReSA identifies a status on the item stage (item_status discipline on the SA_TRAN_ITEM table). 

The 3 statuses are Sale, Return and Void. A Sale or Return transaction can include any variety of gadgets with different statuses; but, ReSA identifies a Sale transaction as internet money being paid into the until and a Return transaction as internet money being paid out of the until. ReSA identifies an Exchange transaction while no money modifications fingers.

NOTE: The transaction kind is held in SA_TRAN_HEAD while the person transaction kind is recorded within the SA_TRAN_ITEM desk.

Sales and advertising Interview Questions
Question sixteen. On Page 1 Of The Totals Calculation Definition Wizard In Retail Sales Audit (resa), There Is A Question “is This Total A Component Of The Over/short Or Miscellaneous Total?” Is This Only Used To Define Which Total Screen The Defined Total Will Appear?

Answer :

Yes, this is only used to outline the shape the full will be displayed on, the Over/Short or the Miscellaneous Totals form. 

Auditors use Over/Short Totals to carry out store balancing (gentle balance). In this display there are 2 sections: 

Accounted For – These totals represent what is physically counted in the till. (e.G. Overall coins handy, overall exams, and so forth…) 

Accountable For – These represent what should be inside the till (e.G. Sales, Returns, etc...). These totals can either come from the Point of Sale (POS) or ReSA can calculate these totals. 

Auditors use Miscellaneous Totals for other types of analysis (e.G. Loss prevention totals), that could don't have any relevance to the Over/Short screen.

Question 17. On The Top Of Page 2 Of The Totals Calculation Definition Wizard In Retail Sales Audit (resa), There Is A Question “does This Total Correspond To A Value In Pos?” Where Will The Total Value Be Displayed When This Is Set To ‘yes’ Or ‘no’?

Answer :

If that is set to ‘Yes’, it suggests the overall is anticipated from the Point of Sale (POS) together with a Declared Tender Total; therefore, the value will be displayed on the POS Reported column. 

If this is set to ‘No’, it indicates the ReSA will calculate this value based totally on either uncooked facts or existing totals; therefore, the value will be displayed on the System Calculated column.

Retail Management Interview Questions
Question 18. On The Bottom Of Page three Of The Totals Calculation Definition Wizard In Retail Sales Audit (resa), There Is A List Box For Display Group And A Display Group Details Button. What Tables Hold This Information And What Purpose Do They Serve?

Answer :

The Display Group list box defines in what order the total may be displayed on the described form in ReSA. This information is hung on the sa_total_head desk in the display_order discipline.

The Display Group Details button displays all different totals that are defined to be displayed on the equal form, general category and proportion the same display group placing for the given overall. If multiple general has the identical show order, then they will be displayed alphabetically. This records isn't always held on one specific discipline, but instead queries more than one fields at the sa_total_head desk.

Accounts and Finance for Managers Interview Questions
Question 19. What Is The Difference Between A Total And An Audit Rule In Retail Sales Audit (resa)?

Answer :

Totals in ReSA can either come from the Point of Sale (POS) or other external structures thru the Retail Transaction Log (RTLOG). ReSA also can calculate the full itself based on uncooked transaction facts or current totals. Totals are utilized in performing store balancing (over/brief), evaluation inside ReSA and exporting to current transactions as well as totals. If a rule fails, the machine generates an exception i.E; the store defines if the mistake may be overridden as well as what structures the mistake affects. This system impact prevents a bottleneck inside the export technique with the aid of simplest prohibiting the export of the transaction or total to the systems described in the machine effect. Even if the transaction or total is in mistakes, ReSA will nevertheless export it to different systems so long as they are now not described in the machine effect for the given error.

Question 20. What Is The Difference Between A Table Driven Audit And A Sub Program Driven Audit In Retail Sales Audit (resa)?

Answer :

Table driven audits are created the usage of the Rules Calculation Definition Wizard in ReSA whilst sub software pushed audits are tough coded audits which include the validations protected in saimptlog.Laptop (e.G. Card variety validation).

Chartered accountant Interview Questions
Question 21. What Is The “file Type” List Box Used For In The Rules Calculation Definition Wizard In Retail Sales Audit (resa)?

Answer :

The choice in this area determines the parameters and nation-states that need to be associated with the rule. For example, if Transaction Tender Level Error is selected because the file type then the machine will automatically default the sa_tran_head and sa_tran_tender tables as the essential geographical regions. 

This is a manner of helping the introduction of guidelines, through defaulting the nation-states foraround this and consequently no new Record Types can be introduced to the code_detail table.

Question 22. I Am An Hq Auditor, And I Want To Start Working On A Store Day, But I Can't Get Into The Form In Edit Mode. What Should I Do?

Answer :

In a multi-stage surroundings, simplest the store employees can close the day - and this must be done prior to HQ Auditing the store.

Question 23. What Are The Definitions Of The Different Store Status Options On The Store Day Find Form In Retail Sales Audit (resa)? What Triggers A Store Status To Change To Close? At What Store Status Can The Store/day Be Deleted?

Answer :

Worksheet – When a shop is described as a multi-level audit save (both save employees and HQ auditors will use ReSA), the store is loaded into ReSA in a Worksheet fame. The store/day may be deleted in this repute. 

Fuel Closed – This fame is most effective used for gas shops that will be exporting to Oracle Site Fuels Management (SFM). Stores are loaded into ReSA in a Worksheet status; but, the audit can not start until the day is closed in SFM first. When this is carried out, ReSA updates the repute to Fuel Closed. The store/day can be deleted on this status. 

NOTE: SFM will ship again a record signifying that the store transactions had been processed and reconciled. This will represent Fuel Closed – and allow the information to be labored on in ReSA. 

Closed – In a multi-degree audit state of affairs, the shop employee must near the store day once all errors have been corrected or overridden. This updates the store status to Closed and makes the shop/day to be had to the HQ auditor. In a unmarried stage audit situation in which only HQ auditors are the use of ReSA, the shop is loaded into ReSA in a Closed reputation. The shop/day can't be deleted on this fame

Oracle Forms And Reports Interview Questions
Question 24. What Is The Difference Between Accountable For And Accounted For Totals On The Over/quick Form In Retail Sales Audit (resa)?

Answer :

Accounted For:These totals represent what's bodily counted within the until. (e.G. Overall cash reachable, general assessments, etc…). These totals are anticipated from the Point of Sale (POS) or some other outside device. 

Accountable For:These totals constitute what must be in the until (e.G. Sales, Returns, and so on...). These totals can either come from the POS or ReSA can calculate those totals.

Auditing Interview Questions
Question 25. When Are Vouchers Items And When Are They Tenders?

Answer :

Vouchers are gadgets while they may be sold to a customer. Vouchers are tenders when they are redeemed by way of a customer for merchandise.

Question 26. What Is The Purpose Of The Item Summary And Tender Summary Forms In Resa?

Answer :

The Item Summary shape serves 3 purposes:

It is used to search for all the transactions in which the particular item exists for a given store/day.
The u precise transaction and consider the info at the Transaction Detail shape.
It is used to carry out a mass item exchange for a specific item quantity to another valid item variety for a given keep/day.
If ReSA generates an invalid item range mistakes, the store can create the precise item inside the Retail Merchandising System (RMS) and use this form to re-validate the object number. Since the object now exists in RMS, ReSA will cast off all invalid item variety mistakes for the chosen object for the given store/day. 

The Tender Summary form is used to look for all of the transactions in which a particular gentle type institution become used for a given keep/day.

Oracle Financials Interview Questions
Question 27. What Is Escheatment?

Answer :

Escheatment is the manner of forwarding monies of amazing, non-expiring vouchers to the right governing authorities after a described period of time from the date of issuance.

Retail Interview Questions
Question 28. How Does A Retailer Turn This Functionality Off If They Do Not Practice Escheatment?

Answer :

If a retailer does not need to apply the escheatment functionality they will not take a look at the Escheatment indicator at the System Options form. Since the store will not be escheating those monies to governing government, the store will claim these monies as income; consequently, they have to define when these tremendous vouchers could be claimed as income on the Voucher Options window at the System Options form. The retailer nevertheless have to run the saescheat.Computer software so as to claim those vouchers as income.

Question 29. On The Escheatment Window Located On The System Options Form, In Resa, There Are Four Indicators (issue, Recipient, Store And Hq). What Is The Purpose Of Selecting These Indicators, Especially Since All Four May Be Set To Yes Simultaneously?

Answer :

In the USA, every country has unique escheatment regulations. We have created a degree of hierarchy in ReSA for escheatment regulations (Store, Issuer, Recipient and HQ). When defining each escheatable state or country, the store will indicate how many degrees of the hierarchy could be checked. 

The voucher have to be past the escheatable variety of days (SA_VOUCHER_OPTIONS.ESCHEAT_NO_DAYS). The application will check if a state or u . S . Exists for the first stage of the hierarchy, the Store. If so, it'll check if this kingdom or us of a is defined within the Escheatment Options and whether or not or not the Store indicator is about for that partner. If a suit is discovered, ReSA will escheat the voucher quantity to the state or u . S . A . Of the Store. 

If no match is found at the store level, the program will carry out the equal exams as outlined above thru the whole escheatment hierarchy until a fit is found. If no healthy is observed, the retailer will declare the voucher as profits.

Oracle Retail Merchandising System Interview Questions
Question 30. How Are The Escheatment Rules Determined In Resa? Are They Determined By The State Where The Voucher Was Sold Or The State Where The Recipient Of The Voucher Resides?

Answer :

The Escheatment capability in ReSA is pushed by means of the hierarchy of Store, Issuer, Recipient, & HQ. When appearing escheatment, ReSA assessments if there may be an address for the primary degree of the hierarchy, the Store. If so, it assessments if the country or united states of america is defined in the Escheatment table in ReSA. If the kingdom or us of a exists at the desk it then assessments to peer if the Store indicator for that kingdom or u . S . A . Is ready to yes. If so, ReSA escheats those monies to that kingdom or u . S .. If no state or united states exists for the store, or one does however does not exist at the Escheatment table, or it does exist on the table however the Store indicator is set to no, then ReSA tests the subsequent level, Issuer, and so on. If no suits are determined after ReSA exams all 4 ranges of the hierarchy, then the store claims the voucher as profits. 

If claimed as sales, this is a non-merchandise kind of bill. 
An access within the companion table (escheatment authority be described to indicate to whom the monies can be sent. 
If a voucher is redeemed after it has been escheated, it's miles the obligation of the retailer to gather these monies from the government 
Only the high-quality voucher quantity is escheated.
Question 31. Does The Sa Escheat.Computer Batch Program In Resa Create A File Or Does It Insert Into The Retail Invoice Matching (reim) Tables? If This Populates The Tables, What Will Happen If The Retailer Does Not Have Reim?

Answer :

SA  ESCHEAT.Computer most effective creates a total and writes this to the SA_ESCHEAT_TOTAL table. The SAEXPIM.Laptop program reads from this desk. This program is owned by using ReIM.

If the retailer does not have ReIM, then a custom interface might need to be written to read the SA_ESCHEAT_TOTAL table to export the records into the retailer’s appropriate utility

Question 32. If The Retailer Does Not Perform Escheatment, Can The Saescheat.Computer Program In Resa Be Used To Claim These Outstanding Vouchers As Income?

Answer :

Yes, the SAESCHEAT.Computer program will help this function. If the store does no longer carry out escheatment, they need to not test the Escheatment Indicator on the System Options form. If this indicator isn't set, the Escheatment button is disabled; but, the Vouch. Opt. Button remains enabled. The retailer could click on this button to open the Voucher Options window. In this window, the store will outline within the first column whilst the voucher could be claimed as profits (the quantity of days after issuance). In the second column, the store will define whilst the voucher could be purged from ReSA (the variety of days after claiming the voucher as income). The retailer will define this standards for each Tender Type ID assigned to the Tender Type Group of ‘Voucher’.

Oracle Accounts Payable Interview Questions
Question 33. Is There A Complete Standard Output Of Data For Archiving Data In Resa?

Answer :

Transactions may be exported to Retail Data Warehouse (RDW) for reporting. Transactions may be saved on-line in ReSA for modern utilization or purged whilst they're no longer wished.

Sales Interview Questions
Question 34. What Triggers The System To Know Resa Can Start Exporting?

Answer :

No special event in ReSA triggers the device to start exporting, as an alternative the retailer defines while the export packages will run within the batch agenda. When these programs run (i.E. Saexprms.Laptop, saexprdw.Computer, saexpgl.Computer, etc…), they test errors impacting that export exist for a shop day. If no longer, then the statistics can be exported. The Retail Merchandising System (RMS) is the most effective system that ReSA will export some ‘smooth’ transactions even supposing errors impacting RMS exist in other transactions. This is dependent on the Unit of Work putting inside the System Options for ReSA. When set to Store, all RMS mistakes ought to be corrected or overridden for a store/day before any records is exported. When set to Transaction, handiest easy transactions are exported to RMS even if different RMS mistakes are terrific. In later releases of ReSA 10.1.X, it can now export a few ‘smooth’ transactions to RDW (Retail Data Warehouse) similar to how it is doing it for RMS.

Question 35. Does Resa Accept And Process Dsd (direct To Store Delivery) Transactions?

Answer :

ReSA most effective helps the DSD state of affairs while a charge is made by using the store to the vendor. ReSA requires that those bills be entered within the Point of Sale (POS) or different Retail Transaction Log (RTLOG) compatible structures as ‘Paid Out’ transactions.

Included on this Paid Out transaction are the subsequent data:

Amount paid
Vendor ID
Invoice Number
Proof of Delivery Number
This records is loaded into ReSA and exported to Retail Invoice Matching (ReIM).

The store is likewise required to create an entry for the DSD inside the Retail Merchandising System (RMS) the use of the Quick Order Entry screen. On this screen they may enter the vendor, invoice range or proof of delivery number, and suggest if the vendor store. RMS will export this transaction to ReIM as nicely. ReIM will healthy this RMS transaction with the ReSA transaction to verify a price became made. This bill will then be exported to the store’s AP financial machine with a ‘Paid’ indicator.

NOTE: ReSA does now not deal with the actual receiving of the stock. This needs to be finished the usage of either RMS interfaces or Retail Store Systems (RSS).

Question 36. Does The Retail Merchandising System (rms) Batch Program Posupld.Pc Still Perform The Same Validation Routines If Resa Is Installed?

Answer :

If ReSA is on (gadget options.Sales_audit_ind set to ‘Y’), a few statistics is taken from the ReSA report rather that being appeared up; but, pretty a bit of validation remains achieved. Value Added Tax (VAT) and forex information isn't demonstrated (on keep and currencies). Merchandise hierarchy isn't validated.

Sales and advertising Interview Questions
Question 37. According To The Operations Guide, The Saexprms.Laptop Program In Resa Rolls Up Sales By Item/save/day/fee Point Level Prior To Exporting To The Retail Merchandising System (rms). Does This Export Provide Visibility To Both Sales And Returns In This File?

Answer :

ReSA sends one file with  Transaction Heads, one for Sales and one for Returns. ReSA uses the item reputation to decide if the object become bought or again.

Question 38. What Is Automated Clearing House (ach)?

Answer :

ACH is a United States based totally banking community used to electronically switch price range. The National Automated Clearing House Association (NACHA) regulates this community and maintains the requirements.

Question 39. What Is The Ach Estimation Formula?

Answer :

The ACH application estimates the next day’s bank deposit by using averaging the preceding 4 actual bank deposits for that given day of the week (e.G. The estimate for Monday will take the average of the real bank deposit from the previous four Mondays). If the machine only has 3 weeks of information, it's going to use the average of the preceding three Mondays. If most effective two weeks of facts exists, it will use the common of the previous two Monday. If only one week facts exists, it'll use the financial institution deposit from the preceding Monday. If much less than one week of records exists, it's going to use the previous day’s deposit and if no records exists, no estimate might be created. 

The gadget also compares the previous day’s estimate for these days’s bank deposit in opposition to nowadays’s real financial institution deposit. It will upload the distinction to the common for the following day to create an Estimated Deposit Adjustment if essential.

Question forty. Why Does Resa Send Bank Deposit Estimates To The Ach?

Answer :

ReSA is estimating the following day’s bank deposit and sending this amount to the consolidating financial institution through the ACH network. This is used to hedge the coins this is to be obtained from the stores. 

If the store does not perform this characteristic, they do no longer want to run the batch software (saexpach.Computer). There isn't any impact to ReSA if this is not run.

Retail Management Interview Questions
Question forty one. What Is The Store Ach Maintenance Form Used For In Resa?

Answer :

This form is used to view the ACH information (Manual Deposit Adjustment, Estimated Deposit, Estimated Deposit Adjustment) for a specific shop. 

The retailer can also make a Manual Deposit Adjustment to the next day’s ACH Amount if they sense the real deposit will be specific than the estimated deposit for day after today. The Add button is used to permit the follow block to enter a Manual Deposit Adjustment for a shop/day (e.G. Christmas time when the expected sales are more than the common for the ultimate 4 weeks). This Manual Deposit Adjustment need to be made prior to the execution of the ACH program. 

The sum of the Manual Deposit Adjustment, Estimated Deposit and Estimated Deposit Adjustment produces the ACH Amount for the store/day. This is the amount as a way to be sent through the ACH community to the consolidating bank.

Question forty two. What Happens In Resa If The Cost Method Of Accounting Is Used?

Answer :

The cost of sales is not used in ReSA - most effective sales is captured. 

Cost of sales information will nonetheless be determined in the Retail Merchandising System (RMS), no longer in ReSA.

Chartered accountant Interview Questions
Question 43. How Can The Count Or Number Of Transactions For A Specific Transaction Type (e.G. Sale) Be Viewed In Resa

Answer :

The matter or quantity of transactions isn't always contained in the overall of sales or returns. This information may be utilized inside the Store Operations Workbench of the Retail Data Warehouse (RDW).

Question forty four. If The Flash Reports In Resa Compare Current Sales Against Last Year’s Sales, Where Is This Data Obtained If The Resa Purge Parameter Is Set To 30 Days?

Answer :

This information is saved inside the SA_FLASH_SALES desk. The SAPURGE.Laptop batch program deletes these data while they're 730 days old + the parameter defined within the ‘Number of Days Before Purge’.

In the SA_FLASH_SALES desk, there's a column named NET_SALES_SUSPENDED. This column refers back to the income that have been still in “droop mode” on the time of ultimate the Point of Sale (POS). These income aren't labeled as authentic sales, as there has been no very last exchange of goods and cash between the store and purchaser. These salesare not exported to the Retail Merchandising System (RMS) or Retail Data Warehouse (RDW).

Question forty five. If A Store Is Trickle Polled, Can The Flash Totals Report In Resa Still Be Generated During The Day Prior To Receiving The ‘d Close’ Record In Resa?

Answer :

Yes, however the system have to be set up to calculate totals previous to receiving the D CLOSE transaction. The batch agenda needs to be defined to run the totaling manner in the course of the day upon import of an RT LOG document.

Question 46. Is The Sapurge.Pc Program Of Resa Multi-threaded And Restart/recoverable?

Answer :

Yes, it is multi-threaded and restart/recoverable.

Question 47. When Using The Delete Store Day Functionality, Will The Store/day Record Be Deleted Or Just The Transactions For That Store/day?

Answer :

When deleting a Store/Day, it's far in reality the transaction information for the store/day which are deleted in preference to the shop/day file. SA_TRAN_HEAD.STATUS could be set to 'D' and these transactions will not be handy thru the Transaction Maintenance display.

Question 48. When Loading Retail Transaction Log (rtlog) Files, How Will This Affect The Tdup* File?

Answer :

When the ReSA System Option to test for reproduction/missing transactions is enabled, tdup* record is used to hold tune of the transaction numbers (tran_no) used. When a RTLOG report is uploaded then a tdup* report is created. It is created for a Store (i.E. Tdup.Dat). When a few new RTLOG report is uploaded for this keep then the tdup* document might be appended. Note that tdup* file is created for a Store no longer for a Store/Day. It is by no means deleted thru any batch. Depending on the Store's "Unique Tran.No. By" setup - Register or Store; tdup* file contains the Store/Day, Register and the Transaction number records. It guarantees that no replica transaction may be loaded.

Question forty nine. What Is The Meaning Of Fields Roll_up_level 1 , Roll_up_level 2 And Roll_up_level 3 In Resa Glcross Reference Screen 'saglcros.Fmb'?

Answer :

Total - Roll Ups :

Roll-americaallow a total to supply multiple values, it is equivalent to the part of the GROUP BY clause within the SQL SELECT announcement that combines any rows that could have duplicate values in the grouped through subject

For example :

SELECT rely/sum(Value to be Totaled)

FROM geographical regions

WHERE regulations + joins

GROUP BY roll ups

Question 50. What Are The Possible Roll_up Levels For The Total Defined On Register Level And Store Level Totals?

Answer :

In the Total Definition wizard > Roll Ups display

The Roll Ups display permits the person to define the parameter on the way to in reality count (or summed). It also permits the user to outline up to 3 parameters to group through. Only parameters which have previously been added to the overall definition can be both counted (summed) or grouped through.

If the whole is at the shop stage, which means the user best needs one fee according to shop, the system automatically assumes a roll as much as the shop/day level. If the whole was described to be on the cashier/sign up balancing stage, and the person wanted one total price according to cashier/sign in, the system might anticipate a roll up to cashier/register.

Question fifty one. Is The Gl Amount Equal To The Basic Level Amount Or Rolled Up Level Amount Or Some Other Amount?

Answer :

According to RMS Data Model, the table SA_FIF_GL_CROSS_REF is used to partner an Oracle account code with the unique varieties of totals that can be calculated through Sales Audit. Different account codes may be related to the equal overall type at one of a kind places and distinct ranges of rollup. And additionally the 3 roll u.S.In this table are the same as rollup stages of general. 

There is one more table FIF_GL_ACCT , which holds all the account related information, so as to be bridged across from the respective Financial Application.

Question fifty two. Should The V_total_totalname Table Be Used Instead For Sa_sys_value (for Calculated Totals) For Getting The Most Recent Value For A Totals On A Store/day?

Answer :

No, V_SA_TOTAL_VALUE view must be used to get the state-of-the-art Total Value.

Question 53. What Is The Difference Between V_sa_tran_item_net_rolled And V_sa_tran_item_net And When Would Each Be Applicable?

Answer :

The V_SA_TRAN_ITEM_NET_ROLLED gives the Retail charge of one Item after all the Discounts implemented to it. 
If one Item is having  discounts, the V_SA_TRAN_ITEM_NET_ROLLED view will display a unmarried line for that object.
Also V_SA_TRAN_ITEM_NET_ROLLED will have the total discount carried out to it. 
On the opposite hand V_SA_TRAN_ITEM_NET will show  one-of-a-kind traces every for one bargain.
Question 54. Can We Post Void Transactions In Resa (retail Sales Audit) By Changing The Value Of Transaction Type From 'sales' To ‘void’?

Answer :

No, if it's miles required to void a income transaction from the the front-quit, then this ought to be finished the usage of the post-void functionality in Transaction Detail display (trandetl.Fmb) and now not with the aid of converting the TRAN_TYPE for the transaction.

Question 55. Why Post Voided Transactions From Resa Forms Are Not Picked By Saexprms?

Answer :

When doing a Post Void on a transaction from ReSA paperwork and walking SAEXPRMS batch, the transaction will best be picked up if it's miles already exported. But if it is post voided earlier than export, it essentially manner it's far canceled and no data want to be despatched to RMS for this transaction.

Question fifty six. Why Is A Sales Audit Table (prefixed With Sa_) Used In Standard Rms (oracle Retail Merchandising System) Functionality As Currency Rounding In Price Management?

Answer :

The Currency Rounding functionality was evolved for ReSA and became prolonged to Pricing. Thus whilst it turned into determined to apply this capability to Pricing, we already have the ReSA rounding rules desk.

Question 57. Is The Currency-primarily based Rounding Rules Only Used For Resa?

Answer :

No, Price Rounding additionally uses Currency-primarily based rules.

Within the System Options dialogue there may be a discipline referred to as 'Pricing Rules for New Items'. This is represented inside the database as SYSTEM. OPTIONS.PRICING.RULE. This field determines which pricing rules ought to be used whilst growing gadgets and charge adjustments, promotions, and clearances within Retail Merchandising System (RMS). Valid values for this subject are 'R' for Rounding Rules or 'P' for Price Point. A price of 'R' suggests that the rounding policies, detailed with the aid of the person, will be used whilst creating an item. If the consumer chooses the pricing point guidelines, then the charge factor policies will be applied.

When creating a price change, merchandising or clearance we are able to determine how the charge "will appearance", by way of choosing one of the following Adjustment Types:

EI - Ends In
PP - Price Point
RO - Round
NO - None
If Round (RO) is selected, RMS will test for the existence of rounding policies for the foreign money or currency and us of a. If they exist, they will govern the rounding. If they do now not, normal arithmetic rounding may be implemented. If Round is the Adjustment Type selected, RMS will use rounding regulations primarily based at the foreign money chosen in System Options supplied that 'R'ounding is the value for the System_Options.Pricing_rule. 

If Price Point (PP) is the Adjustment Type chosen, and SYSTEM_OPTIONS.PRICING_RULE is same to Price Point, the Price Point regulations as setup via the user will follow. These regulations are defined within RMS and stored at the database stage. 

Default RMS rounding capability dictates that when applying a fee trade within the clearance, advertising or rate exchange bureaucracy, or throughout item setup, consequences within the price being rounded with two implied decimals (e.G. Authentic rate is 349, and with 10% off this is rounded to 314,10). Currently, RMS does not accommodate consumer defined rounding rules. Therefore, the default rounding functionality is used. However, with the improved use of overseas foreign money, there are numerous exclusive rounding regulations that can be used as an opportunity.

Changes within RMS and ReSA have been made to put in force foreign 

Question 58. In Currency Rounding Rules Detail Maintenance(sarruldt) Form, When Defining The First Range As 0 To zero.2600, Why Is It Not Possible To Use zero.2700 As The Lowest Ending Amount For The Next Range?

Answer :

After applying some computations, the resulting amount can also come up as having four decimals. If regulations with handiest 2 decimals are defined, then the four decimals might not be covered by way of any of the regulations. That is, Rule zero - 0.24 rounds to zero; 0.25 - zero.Seventy four rounds

to 0.50 and zero.75 - 1 rounds to at least one. Given 24.2455, the decimals zero.2455 does not belong inside any of the defined variety. The number of decimals for the Round Amount might be based totally on CURRENCIES.CURRENCY_RTL_DEC. For a forex defined as having 2 decimals, then it is going to be rounded to 2 decimals. Therefore, in the SCARLET.FMB, the LOW_ENDING_AMT and HIGH_ENDING_AMT (for the range) have to be entered as four decimals.

The forex rounding rule range can't overlap. Thus whilst the first range is zero - 0.2700; the following variety must start with zero.2701. If the primary variety is defined as zero - 0.2659; the subsequent variety will start at zero.2660

Question fifty nine. How Is Transaction Level Discount (i.E. Slab Discount) Handled In Rtlog File In Retail Sales Audit (resa)?

Answer :

If you have got a scenario at Point Of Sale (POS) wherein in you supply a reduction of one hundred at a Total Bill of a thousand. This discount does no longer practice to any item however is at a Bill stage.

Retail Merchandising System (RMS) does now not helps invoice/transaction stage discounts, RTLOG record will no longer have a transaction-stage discount (TDISC) file, so POS gadget should be despatched item-stage cut price. But that doesn't imply ReSA simplest handles item-stage discounts (IDISC). The slab reductions or bill/transaction degree reductions are in fact apportioned among all the gadgets in that invoice in proportion to their charges & gadgets sold.

If you have a state of affairs at POS wherein in you give a discount of one hundred at a Total Bill of 1000. And it has  objects priced otherwise then the transaction-degree discount may be divided among these  objects in accordance to their character charge & offered units :-

Item Price Quantity Discount

Item A 400 1 forty

Item B one hundred 6 60

Also for Slab discounts, there may be a discount or a pamphlet to describe this cut price based on slabs.

If there's a voucher or coupon involved then the Transaction statistics must have a further TTEND file to denote the discounts obtained with the aid of those coupons or vouchers for a particular transaction.

Question 60. If The 'keep Close Audit' Menu Shows The Users Home Store Automatically, Then Why Is It Not Visible In The 'transaction Find' Screen?

Answer :

While developing an worker thru Employee Maintenance Screen, you can assign multiple stores to the employee.

But handiest one shop can be selected as the Home Store of that worker. When this employee goes into Store Day Find display screen through 'Store Close Audit' menu, Retail Sales Audit (ReSA) mechanically queries the store/days the consumer ought to audit based totally on their worker kind (shop or headquarters) and assigned shops.

If a store employee is assigned a home shop, the Store Day Find window to start with presentations most effective statistics for that given save.

The person can refresh the display and select one of a kind standards to view statistics for both all assigned stores or all shops.

(The potential to view all shops is restrained by means of region security in Retail Merchandising System (RMS).)

The consumer can use Store Day Summary window to view transactions from a unmarried shop and day. This way the Transaction Find window works for a unmarried store. But the consumer desires to visit the screen through 'Store Close Audit' menu.

So, the Transaction Find Window thru Transaction renovation menu isn't limited to the users home keep. It is used to look for transactions across a couple of shops and/or days.

Question sixty one. Why Is The 'transaction Find' Window Through 'transaction Maintenance' Menu Not Restricted To The Users Home Store While The Store / Close Audit Screen Is?

Answer :

The Transaction Find Window through Transaction renovation menu is used to create new or view, edit transactions or create post void. While the store / near audit screen is used to audit days transactions.

Thus normally the shop / close audit screen by using default fetches save/day for the person's home save. But as I defined in advance, if the consumer has get admission to to different stores additionally, he or she will be able to get right of entry to transactions for those shops as properly.

Since the Transaction Find Window via Transaction Maintenance menu is used to create new or view, edit transactions or create post void, it does no longer robotically defaults to the consumer's home shop.

But this restrict to the users home keep can be done on both the displays if the consumer is constrained to his domestic store thru RMS safety alternative.

Question 62. There Are Five Totals Displayed On Miscellaneous Totals Window (samisctl). What Do They Signify?

Answer :

The Miscellaneous Totals window allows you to go into and keep the totals within the machine for a particular Store Day. This window permits you to enter your model of the entire. This window includes a list of the Total Categories and a corresponding list of the totals which might be contained in a selected Total Category.

Following is the list of totals displayed at the display screen:

POS Reported: This displays the price imported from an outside gadget such as POS.
System Calculated: This shows the cost calculated with the aid of Oracle Retail Sales Audit (ReSA) based on raw transaction records or existing totals.
Store Reported: This presentations the cost up to date via a Store Employee of either the POS said or System Calculated fee.
HQ Reported: This presentations the fee updated by using a Headquarter auditor of either the POS reported, System Calculated or Store Reported value.
Last Reported: This is the fee this is taken from one of the four totals in that order- HQ Reported, Store Reported, System Calculated or POS Reported which isn't NULL. If all the 4 totals are NULL, then Last Reported can be NULL.
Question 63. Is It Possible To Restrict The Ability To View All Stores By Location Security In Rms? Is It The Same Restriction For The 'transaction Find' Window Through 'transaction Maintenance' Menu ?

Answer :

Yes, if one person is given confined get entry to to simplest his or her home keep through RMS vicinity safety, he will be capable of access his domestic shop and nothing else. The same restrict holds for the Transaction Find Window thru Transaction

preservation menu. That is, if one consumer is given restrained get right of entry to to only his or her domestic save through RMS vicinity security, he will be able to access his home keep and not anything else in this screen also




CFG