Question 1. What Is Significance Of “home Store” Indicator In Resa? Explain In Detail?
If a store employee is assigned a home store in the Employee Maintenance form, the Store Day Find form will display only records for that given store when Edit/View is selected from the action box. To view all the stores assigned to the user in ReSA (the Employee Maintenance form), click the refresh button and select the Assigned Stores radio button.
Question 2. How To Populate “sa_export_options” Using Resa User Interface (ui) ?
sa_system_options is not updated from RESA UI but is populated at time of installation by running the script sa_system_required.sql
Question 3. How Can User Know Whether It Is A Single Or Multilevel Audit Scenario? Is There Any Indicator Or Value Exist For This?
This information is maintained on the Store Data window of the Store Maintenance form in the Retail Merchandising System (RMS). The multi-level audit settings for individual stores are stored on the ds_store_data table. Stores are defined as multi-level audit stores when the system_code field is ‘MLA’and the imp_exp field is ‘I’ for a specific store. If these settings are not defined for a store, then ReSA defines the store as a single level audit store. Single level audit would be defined if the user 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?
SAEXPGL exports totals to Oracle Financial Application general ledger for:
- Sales transactions
This export batch module works by first getting the store day. Then it finds the totals to export and verifies that individual totals contain no errors for either the store/day (if store/day is the unit-of-work defined by the user) or store/day/total (if store/day/total is the unit-of-work defined by the user). Next the module looks at the SA_FIF_ORA_CROSS_REF table to determine which Oracle account ID (Cost Center ID) it needs to export to. Determine if the selected store/day/total has been previously exported; if so, reverse the previous posting, and post the latest adjustments to the General Ledger (GL) staging table. Finally it moves the data to the Oracle staging GL_INTERFACE. (No RMS staging table is involved.)
Question 5. How To Find Out What Roles A User Have, And If Those Roles Have The Correct Privileges?
To verify whether a user was granted a privilege, or a role was granted a privilege, you can use the following (for this example, RMSDEV101A is used):
Check to see if the user was granted the system privilege directly:
SQL> desc dba_sys_privs
SQL> select * from dba_sys_privs where grantee = ‘RMSDEV101A’;
If the result for the above query does not show the system privileges granted for the user, check to see what roles the user was granted, and then check to see what privs has been granted to that role:
SQL> desc dba_role_privs
SQL> select * from dba_sys_privs where grantee = ‘DEVELOPER’;
Whenever you want to see what roles and system privileges a user has and what system privileges are assigned to specific roles, you should look at the dba_role_privs and dba_sys_privs views.
From a ReSA perspective a user should have the following privileges to create totals and views:
- Create any view
- Create any procedure
- Alter any procedure
- Drop any view
- Drop any procedure
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?
These are used for the Flash Sales reports – enabling the business to determine when a store has sufficient trading history. The date to determine comp. Status can be based on three factors: store open date, remodel date, or acquire date. These dates are held on the store table in the Retail Merchandising System (RMS).
Question 7. Does Only Point Of Sale (pos) Data Come Through Retail Sales Audit (resa)?
Stock Counts, Receipts, Transfers and Inventory Adjustments are not sent through ReSA. These types of transactions can either be supported by 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) can be loaded directly into RMS using upload files.
Main transactions processed by ReSA are the following:
- Post Voids
- Paid In / Paid Out
- No Sales
- Fuel Transactions (e.g. Tank Dips, Meter Readings, etc…)
NOTE: Not all POS systems support all of these transactions.
Question 8. What Does The ‘dclose’ Transaction Signify In Retail Sales Audit (resa)?
ReSA requires the ‘DCLOSE’ transaction in both multi-level and single level audit scenarios. This transaction indicates to ReSA that all Point of Sales (POS) transactions have been received. Once the ‘DCLOSE’ transaction is received, ReSA will not accept any more RTLOGs for the given store/day.
Question 9. What Happens When Retail Sales Audit (resa) Receives The ‘dclose’ Transaction In Both A Multi-level And Single Level Audit Scenario?
When the ‘D CLOSE’ record is received from the Point of Sale (POS) in a multi-level audit scenario, ReSA updates the Data Status to ‘Fully Loaded’. If errors are found, ReSA sets the Audit Status to ‘Store Errors Pending’. If no errors are found, ReSA sets the Audit Status to ‘Audited’ and Store Status will be Worksheet.
When the ‘D CLOSE’ record is received from the POS in single level audit scenario, ReSA updates the Data Status to ‘Fully Loaded’ and the Store Status to ‘Closed’. If errors are found, ReSA sets the Audit Status to ‘HQ Errors Pending’. If no errors are found, ReSA sets the Audit Status to ‘Audited’.
Question 10. How Does Retail Sales Audit (resa) Know That A Store Will Be Trickle Polled?
There is no setting in ReSA to define if a store will be trickle polled. The only requirement is to send a ‘DCLOSE’ transaction to ReSA at the end of the day. If a Retail Transaction Log (RTLOG) is loaded but does not contain the ‘DCLOSE’ transaction, the Data Status is updated to ‘Partially Loaded’. If the ‘DCLOSE’ transaction is received the Data Status is updated to ‘Fully Loaded’.
Question 11. The Sagetref.pc Program, In Retail Sales Audit (resa), Creates A “credit Card Mappings” File. What Is In This File?
Sagetref.pc read the sa_cc_val and writes to the credit card mappings file. This table is used to maintain information for credit card validation. This table holds the prefix range, credit card number length, and type of validation (modulus 10 or none) for a specific credit card.
This table is maintained by the DBA or IT Group. There are no front-end screens.
Question 12. Does Retail Sales Audit (resa) Have Its Own Sku/upc Tables That Are Populated By Sagetref.pc?
ReSA does not have its own SKU/UPC tables. Sagetref.pc creates a number of output files from different RMS tables such as ITEM_MASTER, VAR_UPC_EAN etc and the saimptlog.pc batch program reads the files to perform field level validation. Some examples of these output files are a list of all valid SKUs, UPCs, promotions, codes, tenders, etc…
Question 13. What Exactly Does The Saimptlogfin.pc Batch Program Do In Retail Sales Audit (resa)?
Saimptlogfin.pc creates a balance group entry (SA_BALANCE_GROUP table) for the store/day, cancels post voided transactions, updates the Data Status to ‘Fully Loaded’ if the ‘DCLOSE’ transaction is received (sets Store Status to ‘Closed’ if single level audit). It also removes missing transaction records that are now present due to loading data out of sequence.
Question 14. Does The Savouch.pc Program In Retail Sales Audit (resa) Perform Validation On Vouchers?
Yes, this program performs minimal validation (voucher amount is numeric). The validation does not check if a voucher has previously been redeemed. If this is necessary, a rule will need to be defined in ReSA to perform the validation.
Question 15. Can Sales And Returns Occur On The Same Transaction Record In Retail Sales Audit (resa)?
Yes, ReSA identifies a status at the item level (item_status field on the SA_TRAN_ITEM table).
The three statuses are Sale, Return and Void. A Sale or Return transaction can contain any variety of items with different statuses; however, ReSA identifies a Sale transaction as net money being paid into the till and a Return transaction as net money being paid out of the till. ReSA identifies an Exchange transaction when no money changes hands.
NOTE: The transaction type is held in SA_TRAN_HEAD while the individual transaction type is recorded in the SA_TRAN_ITEM table.
Question 16. 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?
Yes, this is only used to define the form the total will be displayed on, the Over/Short or the Miscellaneous Totals form.
Auditors use Over/Short Totals to perform store balancing (tender balance). In this screen there are 2 sections:
Accounted For – These totals represent what is physically counted in the till. (e.g. total cash on hand, total checks, etc…)
Accountable For – These represent what should be in 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), which can have no 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’?
If this is set to ‘Yes’, it indicates the total is expected from the Point of Sale (POS) such as 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 on either raw data or existing totals; therefore, the value will be displayed on the System Calculated column.
Question 18. On The Bottom Of Page 3 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?
The Display Group list box defines in what order the total will be displayed on the defined form in ReSA. This information is held on the sa_total_head table in the display_order field.
The Display Group Details button displays all other totals that are defined to be displayed on the same form, total category and share the same display group setting for the given total. If more than one total has the same display order, then they will be displayed alphabetically. This information is not held on one specific field, but rather queries multiple fields on the sa_total_head table.
Question 19. What Is The Difference Between A Total And An Audit Rule In Retail Sales Audit (resa)?
Totals in ReSA can either come from the Point of Sale (POS) or other external systems via the Retail Transaction Log (RTLOG). ReSA can also calculate the total itself based on raw transaction data or existing totals. Totals are used in performing store balancing (over/short), analysis within ReSA and exporting to existing transactions as well as totals. If a rule fails, the system generates an exception i.e; the retailer defines if the error can be overridden as well as what systems the error impacts. This system impact prevents a bottleneck in the export process by only prohibiting the export of the transaction or total to the systems defined in the system impact. Even if the transaction or total is in error, ReSA will still export it to other systems as long as they are not defined in the system impact 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)?
Table driven audits are created using the Rules Calculation Definition Wizard in ReSA while sub program driven audits are hard coded audits such as the validations included in saimptlog.pc (e.g. card number validation).
Question 21. What Is The “record Type” List Box Used For In The Rules Calculation Definition Wizard In Retail Sales Audit (resa)?
The selection in this field determines the parameters and realms that must be associated with the rule. For example, if Transaction Tender Level Error is selected as the record type then the system will automatically default the sa_tran_head and sa_tran_tender tables as the necessary realms.
This is a way of supporting the creation of rules, by defaulting the realms foraround this and therefore no new Record Types can be added 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?
In a multi-level environment, only the store employees can close the day – and this must be performed 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?
Worksheet – When a store is defined as a multi-level audit store (both store employees and HQ auditors will use ReSA), the store is loaded into ReSA in a Worksheet status. The store/day can be deleted in this status.
Fuel Closed – This status is only used for fuel stores that will be exporting to Oracle Site Fuels Management (SFM). Stores are loaded into ReSA in a Worksheet status; however, the audit cannot begin until the day is closed in SFM first. When this is done, ReSA updates the status to Fuel Closed. The store/day can be deleted in this status.
NOTE: SFM will send back a file signifying that the store transactions have been processed and reconciled. This will signify Fuel Closed – and enable the data to be worked on in ReSA.
Closed – In a multi-level audit scenario, the store employee must close the store day once all errors have been corrected or overridden. This updates the store status to Closed and makes the store/day available to the HQ auditor. In a single level audit scenario where only HQ auditors are using ReSA, the store is loaded into ReSA in a Closed status. The store/day cannot be deleted in this status
Question 24. What Is The Difference Between Accountable For And Accounted For Totals On The Over/short Form In Retail Sales Audit (resa)?
Accounted For:These totals represent what is physically counted in the till. (e.g. total cash on hand, total checks, etc…). These totals are expected from the Point of Sale (POS) or some other external system.
Accountable For:These totals represent what should be in the till (e.g. Sales, Returns, etc…). These totals can either come from the POS or ReSA can calculate these totals.
Question 25. When Are Vouchers Items And When Are They Tenders?
Vouchers are items when they are sold to a customer. Vouchers are tenders when they are redeemed by a customer for merchandise.
Question 26. What Is The Purpose Of The Item Summary And Tender Summary Forms In Resa?
The Item Summary form serves three purposes:
- It is used to search for all the transactions where the specific item exists for a given store/day.
- The u specific transaction and view the details on the Transaction Detail form.
- It is used to perform a mass item change for a specific item number to another valid item number for a given store/day.
If ReSA generates an invalid item number error, the retailer can create the specific item in the Retail Merchandising System (RMS) and use this form to re-validate the item number. Since the item now exists in RMS, ReSA will remove all invalid item number errors for the selected item for the given store/day.
The Tender Summary form is used to search for all the transactions where a specific tender type group was used for a given store/day.
Question 27. What Is Escheatment?
Escheatment is the process of forwarding monies of outstanding, non-expiring vouchers to the proper governing authorities after a defined period of time from the date of issuance.
Question 28. How Does A Retailer Turn This Functionality Off If They Do Not Practice Escheatment?
If a retailer does not want to use the escheatment functionality they will not check the Escheatment indicator on the System Options form. Since the retailer will not be escheating these monies to governing authorities, the retailer will claim these monies as income; therefore, they must define when these outstanding vouchers will be claimed as income on the Voucher Options window on the System Options form. The retailer still must run the saescheat.pc program in order to claim these 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?
In the United States, each state has different escheatment rules. We have created a level of hierarchy in ReSA for escheatment rules (Store, Issuer, Recipient and HQ). When defining each escheatable state or country, the retailer will indicate how many levels of the hierarchy will be checked.
The voucher must be beyond the escheatable number of days (SA_VOUCHER_OPTIONS.ESCHEAT_NO_DAYS). The program will check if a state or country exists for the first level of the hierarchy, the Store. If so, it will check if this state or country is defined in the Escheatment Options and whether or not the Store indicator is set for that partner. If a match is found, ReSA will escheat the voucher amount to the state or country of the Store.
If no match is found at the store level, the program will perform the same checks as outlined above through the entire escheatment hierarchy until a match is found. If no match is found, the retailer will claim the voucher as income.
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?
The Escheatment functionality in ReSA is driven by the hierarchy of Store, Issuer, Recipient, & HQ. When performing escheatment, ReSA checks if there is an address for the first level of the hierarchy, the Store. If so, it checks if the state or country is defined in the Escheatment table in ReSA. If the state or country exists on the table it then checks to see if the Store indicator for that state or country is set to yes. If so, ReSA escheats these monies to that state or country. If no state or country exists for the store, or one does but does not exist on the Escheatment table, or it does exist on the table but the Store indicator is set to no, then ReSA checks the next level, Issuer, and so on. If no matches are found after ReSA checks all four levels of the hierarchy, then the retailer claims the voucher as income.
- If claimed as revenue, this is a non-merchandise type of invoice.
- An entry in the partner table (escheatment authority be defined to indicate to whom the monies will be sent.
- If a voucher is redeemed after it has been escheated, it is the responsibility of the retailer to collect these monies from the government
- Only the outstanding voucher amount is escheated.
Question 31. Does The Sa Escheat.pc 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?
SA ESCHEAT.pc only creates a total and writes this to the SA_ESCHEAT_TOTAL table. The SAEXPIM.pc program reads from this table. This program is owned by ReIM.
If the retailer does not have ReIM, then a custom interface would need to be written to read the SA_ESCHEAT_TOTAL table to export the data into the retailer’s appropriate application
Question 32. If The Retailer Does Not Perform Escheatment, Can The Saescheat.pc Program In Resa Be Used To Claim These Outstanding Vouchers As Income?
Yes, the SAESCHEAT.pc program will support this function. If the retailer does not perform escheatment, they should not check the Escheatment Indicator on the System Options form. If this indicator is not set, the Escheatment button is disabled; however, the Vouch. Opt. button is still enabled. The retailer would click this button to open the Voucher Options window. In this window, the retailer will define in the first column when the voucher will be claimed as income (the number of days after issuance). In the second column, the retailer will define when the voucher will be purged from ReSA (the number of days after claiming the voucher as income). The retailer will define this criteria for each Tender Type ID assigned to the Tender Type Group of ‘Voucher’.
Question 33. Is There A Complete Standard Output Of Data For Archiving Data In Resa?
Transactions can be exported to Retail Data Warehouse (RDW) for reporting. Transactions can be stored online in ReSA for current usage or purged when they are no longer needed.
Question 34. What Triggers The System To Know Resa Can Start Exporting?
No special event in ReSA triggers the system to start exporting, rather the retailer defines when the export programs will run in the batch schedule. When these programs run (i.e. saexprms.pc, saexprdw.pc, saexpgl.pc, etc…), they check errors impacting that export exist for a store day. If not, then the data will be exported. The Retail Merchandising System (RMS) is the only system that ReSA will export some ‘clean’ transactions even if errors impacting RMS exist in other transactions. This is dependent on the Unit of Work setting in the System Options for ReSA. When set to Store, all RMS errors must be corrected or overridden for a store/day before any data is exported. When set to Transaction, only clean transactions are exported to RMS even when other RMS errors are outstanding. In later releases of ReSA 10.1.x, it can now export some ‘clean’ transactions to RDW (Retail Data Warehouse) just like how it is doing it for RMS.
Question 35. Does Resa Accept And Process Dsd (direct To Store Delivery) Transactions?
ReSA only supports the DSD scenario when a payment is made by the store to the vendor. ReSA requires that these payments be entered in the Point of Sale (POS) or other Retail Transaction Log (RTLOG) compatible systems as ‘Paid Out’ transactions.
Included in this Paid Out transaction are the following data:
- Amount paid
- Vendor ID
- Invoice Number
- Proof of Delivery Number
This information is loaded into ReSA and exported to Retail Invoice Matching (ReIM).
The retailer is also required to create an entry for the DSD in the Retail Merchandising System (RMS) using the Quick Order Entry screen. On this screen they will enter the vendor, invoice number or proof of delivery number, and indicate if the vendor store. RMS will export this transaction to ReIM as well. ReIM will match this RMS transaction with the ReSA transaction to verify a payment was made. This invoice will then be exported to the retailer’s AP financial system with a ‘Paid’ indicator.
NOTE: ReSA does not handle the actual receiving of the stock. This has to be done using 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?
If ReSA is on (system options.sales_audit_ind set to ‘Y’), some information is taken from the ReSA file rather that being looked up; however, quite a bit of validation is still performed. Value Added Tax (VAT) and currency information is not validated (on store and currencies). Merchandise hierarchy is not validated.
Question 37. According To The Operations Guide, The Saexprms.pc Program In Resa Rolls Up Sales By Item/store/day/price Point Level Prior To Exporting To The Retail Merchandising System (rms). Does This Export Provide Visibility To Both Sales And Returns In This File?
ReSA sends one file with two Transaction Heads, one for Sales and one for Returns. ReSA uses the item status to determine if the item was sold or returned.
Question 38. What Is Automated Clearing House (ach)?
ACH is a United States based banking network used to electronically transfer funds. The National Automated Clearing House Association (NACHA) regulates this network and maintains the standards.
Question 39. What Is The Ach Estimation Formula?
The ACH program estimates the following day’s bank deposit by averaging the previous four actual bank deposits for that given day of the week (e.g. the estimate for Monday will take the average of the actual bank deposit from the previous four Mondays). If the system only has three weeks of data, it will use the average of the previous three Mondays. If only two weeks of data exists, it will use the average of the previous two Monday. If only one week data exists, it will use the bank deposit from the previous Monday. If less than one week of data exists, it will use the previous day’s deposit and if no data exists, no estimate will be created.
The system also compares yesterday’s estimate for today’s bank deposit against today’s actual bank deposit. It will add the difference to the average for tomorrow to create an Estimated Deposit Adjustment if necessary.
Question 40. Why Does Resa Send Bank Deposit Estimates To The Ach?
ReSA is estimating the following day’s bank deposit and sending this amount to the consolidating bank via the ACH network. This is used to hedge the cash that is to be received from the stores.
If the retailer does not perform this function, they do not need to run the batch program (saexpach.pc). There is no impact to ReSA if this is not run.
Question 41. What Is The Store Ach Maintenance Form Used For In Resa?
This form is used to view the ACH data (Manual Deposit Adjustment, Estimated Deposit, Estimated Deposit Adjustment) for a specific store.
The retailer can also make a Manual Deposit Adjustment to the following day’s ACH Amount if they feel the actual deposit will be different than the estimated deposit for the following day. The Add button is used to enable the apply block to enter a Manual Deposit Adjustment for a store/day (e.g. Christmas time when the anticipated sales are greater than the average for the last four weeks). This Manual Deposit Adjustment must 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 that will be sent via the ACH network to the consolidating bank.
Question 42. What Happens In Resa If The Cost Method Of Accounting Is Used?
The cost of sales is not used in ReSA – only revenue is captured.
Cost of sales information will still be determined in the Retail Merchandising System (RMS), not in ReSA.
Question 43. How Can The Count Or Number Of Transactions For A Specific Transaction Type (e.g. Sale) Be Viewed In Resa
The count or number of transactions is not contained in the total of sales or returns. This information can be utilized in the Store Operations Workbench of the Retail Data Warehouse (RDW).
Question 44. 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?
This information is stored in the SA_FLASH_SALES table. The SAPURGE.pc batch program deletes these records when they are 730 days old + the parameter defined in the ‘Number of Days Before Purge’.
In the SA_FLASH_SALES table, there is a column named NET_SALES_SUSPENDED. This column refers to the sales that were still in “suspend mode” at the time of closing the Point of Sale (POS). These sales are not classified as true sales, as there has been no final exchange of goods and money between the retailer and customer. These salesare not exported to the Retail Merchandising System (RMS) or Retail Data Warehouse (RDW).
Question 45. 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?
Yes, but the system must be set up to calculate totals prior to receiving the D CLOSE transaction. The batch schedule needs to be defined to run the totaling procedure during the day upon import of an RT LOG file.
Question 46. Is The Sapurge.pc Program Of Resa Multi-threaded And Restart/recoverable?
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?
When deleting a Store/Day, it is actually the transaction records for the store/day that are deleted rather than the store/day record. SA_TRAN_HEAD.STATUS will be set to ‘D’ and these transactions will not be accessible through the Transaction Maintenance screen.
Question 48. When Loading Retail Transaction Log (rtlog) Files, How Will This Affect The Tdup* File?
When the ReSA System Option to check for duplicate/missing transactions is enabled, tdup* file is used to keep track of the transaction numbers (tran_no) used. When a RTLOG file is uploaded then a tdup* file is created. It is created for a Store (i.e. tdup.dat). When some new RTLOG file is uploaded for this store then the tdup* file will be appended. Note that tdup* file is created for a Store not for a Store/Day. It is never deleted through 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 information. It ensures that no duplicate transaction can be loaded.
Question 49. 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’?
Total – Roll Ups :
Roll-ups allow a total to produce multiple values, it is equivalent to the part of the GROUP BY clause in the SQL SELECT statement that combines any rows that would have duplicate values in the grouped by field
For example :
SELECT count/sum(Value to be Totaled)
WHERE restrictions + 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?
In the Total Definition wizard > Roll Ups screen
The Roll Ups screen allows the user to define the parameter that will actually be counted (or summed). It also allows the user to define up to three parameters to group by. Only parameters that have previously been added to the total definition can be either counted (summed) or grouped by.
If the total is at the store level, meaning the user only wants one value per store, the system automatically assumes a roll up to the store/day level. If the total was defined to be at the cashier/register balancing level, and the user wanted one total value per cashier/register, the system would assume a roll up to cashier/register.
Question 51. Is The Gl Amount Equal To The Basic Level Amount Or Rolled Up Level Amount Or Some Other Amount?
According to RMS Data Model, the table SA_FIF_GL_CROSS_REF is used to associate an Oracle account code with the different types of totals that can be calculated by Sales Audit. Different account codes can be associated with the same total type at different locations and different levels of rollup. And also the 3 roll ups in this table are the same as rollup levels of total.
There is one more table FIF_GL_ACCT , which holds all the account related information, which will be bridged across from the respective Financial Application.
Question 52. 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?
No, V_SA_TOTAL_VALUE view should be used to get the latest 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?
- The V_SA_TRAN_ITEM_NET_ROLLED gives the Retail price of one Item after all the Discounts applied to it.
- If one Item is having two discounts, the V_SA_TRAN_ITEM_NET_ROLLED view will show a single line for that item.
- Also V_SA_TRAN_ITEM_NET_ROLLED will have the total discount applied to it.
- On the other hand V_SA_TRAN_ITEM_NET will show two different lines each for one discount.
Question 54. Can We Post Void Transactions In Resa (retail Sales Audit) By Changing The Value Of Transaction Type From ‘sales’ To ‘void’?
No, if it is required to void a sales transaction from the front-end, then this should be done using the post-void functionality in Transaction Detail screen (trandetl.fmb) and not by changing the TRAN_TYPE for the transaction.
Question 55. Why Post Voided Transactions From Resa Forms Are Not Picked By Saexprms?
When doing a Post Void on a transaction from ReSA forms and running SAEXPRMS batch, the transaction will only be picked up if it is already exported. But if it is post voided before export, it basically means it is canceled and no data need to be sent to RMS for this transaction.
Question 56. Why Is A Sales Audit Table (prefixed With Sa_) Used In Standard Rms (oracle Retail Merchandising System) Functionality As Currency Rounding In Price Management?
The Currency Rounding functionality was developed for ReSA and was extended to Pricing. Thus when it was decided to apply this functionality to Pricing, we already have the ReSA rounding rules table.
Question 57. Is The Currency-based Rounding Rules Only Used For Resa?
No, Price Rounding also uses Currency-based rules.
Within the System Options dialogue there is a field called ‘Pricing Rules for New Items’. This is represented in the database as SYSTEM. OPTIONS.PRICING.RULE. This field determines which pricing rules should be used when creating items and price changes, promotions, and clearances within Retail Merchandising System (RMS). Valid values for this field are ‘R’ for Rounding Rules or ‘P’ for Price Point. A value of ‘R’ indicates that the rounding rules, specified by the user, will be used when creating an item. If the user chooses the pricing point rules, then the price point rules will be applied.
When creating a price change, promotion or clearance we can determine how the price “will look”, by choosing one of the following Adjustment Types:
- EI – Ends In
- PP – Price Point
- RO – Round
- NO – None
If Round (RO) is chosen, RMS will check for the existence of rounding rules for the currency or currency and country. If they exist, they will govern the rounding. If they do not, normal arithmetic rounding will be applied. If Round is the Adjustment Type chosen, RMS will use rounding rules based on the currency chosen in System Options provided 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 equal to Price Point, the Price Point rules as setup by the user will apply. These rules are defined within RMS and saved at the database level.
Default RMS rounding functionality dictates that when applying a price change in the clearance, promotion or price change forms, or during item setup, results in the price being rounded with two implied decimals (e.g. original price is 349, and with 10% off this is rounded to 314,10). Currently, RMS does not accommodate user defined rounding rules. Therefore, the default rounding functionality is used. However, with the increased use of foreign currency, there are several different rounding rules that may be used as an alternative.
Changes within RMS and ReSA have been made to implement foreign
Question 58. In Currency Rounding Rules Detail Maintenance(sarruldt) Form, When Defining The First Range As 0 To 0.2600, Why Is It Not Possible To Use 0.2700 As The Lowest Ending Amount For The Next Range?
After applying some computations, the resulting amount may come up as having 4 decimals. If rules with only 2 decimals are defined, then the 4 decimals won’t be covered by any of the rules. That is, Rule 0 – 0.24 rounds to 0; 0.25 – 0.74 rounds
to 0.50 and 0.75 – 1 rounds to 1. Given 24.2455, the decimals 0.2455 does not belong within any of the defined range. The number of decimals for the Round Amount will be based on CURRENCIES.CURRENCY_RTL_DEC. For a currency defined as having 2 decimals, then it will 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 4 decimals.
The currency rounding rule range cannot overlap. Thus when the 1st range is 0 – 0.2700; the next range should start with 0.2701. If the first range is defined as 0 – 0.2659; the next range will start at 0.2660
Question 59. How Is Transaction Level Discount (i.e. Slab Discount) Handled In Rtlog File In Retail Sales Audit (resa)?
If you have a scenario at Point Of Sale (POS) where in you give a discount of 100 at a Total Bill of 1000. This discount does not apply to any item but is at a Bill level.
Retail Merchandising System (RMS) does not supports bill/transaction level discounts, RTLOG file will not have a transaction-level discount (TDISC) record, so POS system should be sent item-level discount. But that does not mean ReSA only handles item-level discounts (IDISC). The slab discounts or bill/transaction level discounts are in fact apportioned amongst all the items in that bill in proportion to their prices & units sold.
If you have a scenario at POS where in you give a discount of 100 at a Total Bill of 1000. And it has two items priced differently then the transaction-level discount will be divided amongst these two items in accordance to their individual price & sold units :-
Item Price Quantity Discount
Item A 400 1 40
Item B 100 6 60
Also for Slab discounts, there may be a coupon or a pamphlet to describe this discount based on slabs.
If there is a voucher or coupon involved then the Transaction records should have an additional TTEND record to denote the discounts obtained by those coupons or vouchers for a particular transaction.
Question 60. If The ‘store Close Audit’ Menu Shows The Users Home Store Automatically, Then Why Is It Not Visible In The ‘transaction Find’ Screen?
While creating an employee through Employee Maintenance Screen, you can assign more than one stores to the employee.
But only one store can be selected as the Home Store of that employee. When this employee goes into Store Day Find screen through ‘Store Close Audit’ menu, Retail Sales Audit (ReSA) automatically queries the store/days the user must audit based on their employee type (store or headquarters) and assigned stores.
If a store employee is assigned a home store, the Store Day Find window initially displays only records for that given store.
The user can refresh the screen and select different criteria to view data for either all assigned stores or all stores.
(The ability to view all stores is restricted by location security in Retail Merchandising System (RMS).)
The user can use Store Day Summary window to view transactions from a single store and day. This way the Transaction Find window works for a single store. But the user needs to visit the screen through ‘Store Close Audit’ menu.
So, the Transaction Find Window through Transaction maintenance menu is not restricted to the users home store. It is used to search for transactions across multiple stores and/or days.
Question 61. Why Is The ‘transaction Find’ Window Through ‘transaction Maintenance’ Menu Not Restricted To The Users Home Store While The Store / Close Audit Screen Is?
The Transaction Find Window through Transaction maintenance menu is used to create new or view, edit transactions or create post void. While the store / close audit screen is used to audit days transactions.
Thus generally the store / close audit screen by default fetches store/day for the user’s home store. But as I described earlier, if the user has access to other stores also, he or she can access transactions for those stores as well.
Since the Transaction Find Window through Transaction Maintenance menu is used to create new or view, edit transactions or create post void, it does not automatically defaults to the user’s home store.
But this restriction to the users home store can be achieved on both the screens if the user is restricted to his home store through RMS security option.
Question 62. There Are Five Totals Displayed On Miscellaneous Totals Window (samisctl). What Do They Signify?
The Miscellaneous Totals window allows you to enter and maintain the totals in the system for a particular Store Day. This window allows you to enter your version of the total. This window contains a list of the Total Categories and a corresponding list of the totals that are contained in a selected Total Category.
Following is the list of totals displayed on the screen:
- POS Reported: This displays the value imported from an external system such as POS.
- System Calculated: This displays the value calculated by Oracle Retail Sales Audit (ReSA) based on raw transaction data or existing totals.
- Store Reported: This displays the value updated by a Store Employee of either the POS reported or System Calculated value.
- HQ Reported: This displays the value updated by a Headquarter auditor of either the POS reported, System Calculated or Store Reported value.
- Last Reported: This is the value that is taken from one of the 4 totals in that order- HQ Reported, Store Reported, System Calculated or POS Reported which is not NULL. If all the 4 totals are NULL, then Last Reported will 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 ?
Yes, if one user is given restricted access to only his or her home store through RMS location security, he will be able to access his home store and nothing else. The same restriction holds for the Transaction Find Window through Transaction
maintenance menu. That is, if one user is given restricted access to only his or her home store through RMS location security, he will be able to access his home store and nothing else on this screen also
Oracle 11g Interview Questions
Oracle 11g Tutorial
Accounts and Finance for Managers Interview Questions
Accounts and Finance for Managers Tutorial
Auditing Interview Questions
Retail Interview Questions
Retail Management Tutorial
Sales Interview Questions
Oracle 11g Interview Questions
Sales and marketing Interview Questions
Retail Management Interview Questions
Accounts and Finance for Managers Interview Questions
Chartered accountant Interview Questions
Oracle Forms And Reports Interview Questions
Auditing Interview Questions
Oracle Financials Interview Questions
Retail Interview Questions
Oracle Retail Merchandising System Interview Questions
Oracle Accounts Payable Interview Questions
Sales Interview Questions
Sales and marketing Interview Questions
Retail Management Interview Questions
Chartered accountant Interview Questions