Price Management - Oracle Documentation
Contents
1. Modif BdD 0035_rpm_mbc_lov_values Description technique Column competitive_mbc should not be required on rpm_mbc_attribute Conditions de fonctionnement Market Basket Code 0036_rpm_promo_comp_ detail Performance mods index changes on RPM_PROMO_COMP RPM_PRICE_CHANGE and RPM_CLEARANCE Performance Fixes 0037_rpm_clearance Performance mods index changes on RPM_PROMO_COMP RPM_PRICE_CHANGE and RPM_CLEARANCE Performance Fixes 0038_rpm_price_change Performance mods index changes on RPM_PROMO_COMP RPM_PRICE_CHANGE and RPM_CLEARANCE Performance Fixes 0039_rpm_temp_item_loc Add new fields Dept Class and Subclass to RPM_TEMP_ITEM_ LOC table Added Dept Class Subclass fields 0040_rpm_worksheet_ workspace Performance index on rpm_worksheet_workspace Performance Fixes 0041_rpm_system_options_ def Change the datatype of RPM_SYSTEM_OPTIONS_DEF DEF_ MAINT_MARGIN_METHOD from a NUMBER 1 to a VARCHAR2 1 Maintain Margin Strategy and Auto Approve 0042_rpm_worksheet_ workspace Performance partition rpm_worksheet_workspace by dept 32 hash partitions and 1 local index on worksheet_status_id Performance Fixes 0043_rpm_worksheet_data Performance partition rpm_worksheet_data by dept 32 hash partitions and 1 local index on worksheet_status_id Performance Fixes 0044_rpm_pricing_ Add column STATE to Promotion cons2. Retek Price Management 11 0 3 Notes de mise a jour Si ge social Retek Inc Retek on the Mall 950 Nicollet Mall Minneapolis MN 55403 Etats Unis 888 61 RETEK appel gratuit aux Etats Unis Standard 1 612 587 5000 Fax 1 612 587 5100 Si ge europ en Retek 110 Wigmore Street London WIU 3RW Royaume Uni Standard 44 0 20 7563 4600 Informations commerciales 44 0 20 7563 46 46 Fax 44 0 20 7563 46 10 Le logiciel d crit dans la pr sente documentation fait l objet d un accord de licence et son utilisation est soumise au respect des dispositions de cet accord Les informations qu il comprend sont confidentielles Retek Inc Aucune partie de cette documentation ne peut tre reproduite ou transmise sous quelque forme ou par quelque moyen que ce soit sans l autorisation crite expresse de Retek Inc Retek on the Mall 950 Nicollet Mall Minneapolis MN 55403 USA La notification de copyrights ne peut tre supprim e sans l accord de Retek Inc Les informations contenues dans ce document sont susceptibles d tre modifi es sans pr avis Retek propose la documentation relative ses produits en lecture seule afin d assurer l int grit de son contenu Le Support client le Retek ne peut prendre en charge les documentations modifi es sans l autorisation de Retek La fonctionnalit d crite dans le pr sent document s applique cette version comme indiqu par la page de ti
3. Consultez le manuel d installation pour savoir quels scripts de conversion ex cuter Amelioration des performances Les performances de certaines zones fonctionnelles de RPM ont t test es et am lior es Voici la liste de ces zones Programme batch d extraction de marchandises Programme batch d ex cution des prix Interface utilisateur Statut Brouillon IU IU D tails du brouillon Boite de dialogue Modification de prix Boite de dialogue Promotions Boite de dialogue Soldes Suppositions Le RPM d pend de Retek Security Manager RSM RSM doit tre install avant l installation du RPM Pour obtenir des informations compl mentaires reportez vous aux guides d installation de RPM et RSM Le de majoration promotionnel affich au niveau de l en t te dans la bo te de dialogue des promotions est le de majoration appliqu a toutes les promotions simples pour les articles de la promotion Ce de majoration est calcul a partir des PV normaux des articles a la date de d but de la promotion sauf si la promotion est appliqu e au PV de solde auquel cas ce dernier est utilis comme PV de base pour le calcul Retek Price Management e Pour l installation une conversion minimum et des scripts de donn es seed sont n cessaires Ceci permet de garantir la compatibilit compl te de cette version avec les donn es existantes Consultez le manuel d installation pour de plus amples informations sur ces scripts
4. anomalie 10000 RPM supports the ability to define promotions at a level of the merchandise hierarchy department class or subclass at the store or zone This ability allows retailers to define common promotions such as 20 off Cordless Power tools or 25 off Bath Towels If the combination of items and locations in the hierarchy promotion exceeds 50 000 records the application fails because it cannot process a promotion of this size For example if the promotion was defined at a department level for a given zone but the item location combinations exceeds 50 000 the user would need to set up separate promotion components at the class or subclass level where the 50 000 record value will not be exceeded These components must be approved separately for the system to manage the volume A business process should be put in place to manage the creation of hierarchy promotions to ensure that they do not exceed the 50 000 record threshold 10001 When the task engine is not cleanly stopped it fails to successfully launch when restarted The SYS_PROC is currently used to prevent multiple copies of the task engine from running against the same installation of RPM Normally the task engine cleans up entries on this table as part of its shutdown process These entries are not cleaned up if the task engine is not cleanly terminated for example the process is sent a 9 termination KILL signal When the task engine is restarted it reports th
5. Remarque Toute donn e RMS utilis e dans RPM ne doit pas tre supprim e du RMS e La table RPM MBC_LOV_VALUES ne poss de aucune interface utilisateur associ e Les valeurs de cette table doivent par cons quent tre ins r es au moment de l installation et g r es par un administrateur de base de donn es DBA Consultez le manuel d installation pour de plus amples informations sur cette table e RPM_BATCH_CONTROL est une table g r e par l administrateur de base de donn es Consultez le manuel d utilisation de RPM pour de plus amples informations WAS Modification de la base de donn es Remarque RPM et RIBforRPM ne peuvent pas tre install s sur le m me serveur Modif BdD Description technique Conditions de fonctionnement 0001_rpm_area_diff_comp Add new table RPM_AREA_ DIFF_COMP Area Differentials and Competitor Strategies 0002_rpm_area_diff_ref_comp Add new table RPM_AREA_ DIFF_REF COMP Area Differentials and Competitor Strategies 0003_rpm_area_diff Add column comp_store to RPM_AREA_ DIFF Area Differentials and Competitor Strategies 0004_rpm_dept_ aggregation Add columns cost_chg_highlight_days pend_cost_chg_highlight_ days pend_cost_chg_window_days retail_chg_highlight_days to table RPM_DEPT_AGGREGATION Cost and Price Change Visibility 0005_rpm_system_options Add column dynamic_area_diff_ind to RPM_SYSTEM_OPTIONS Area Differentials an
6. a price change for a new item not linked yet with locations An item is created and retails are defined by zones After the item is approved in RMS the user wants to modify the retail for one of its zones Data displayed regarding the cost and margin is inconsistent RQST00000069923 DEFECT000395221 Transaction rollback errors occur when the system performs asynchronous processing For example the issue arises when the user approves a price change and the asynch flag in system options is set to true 17
7. inconsistencies when applying a sort to the Maintain DEFECT000394444 zone group screen When applying a numeric sort on the zones within a zone group the locations assigned to each zone do not display properly For example a user applied a numeric sort on the zone container When choosing a zone and displaying locations it displays the incorrect locations for the zone The locations displayed are not in the highlighted zone If the user does not sort the zones the locations are displayed correctly RQST00000068054 The values in the pricing worksheet for sales margin and sales margin DEFECT000394379 percentage are not being calculated correctly Based on documentation sales margin amount is the following This field will hold the projected margin for a given period of time for items in the worksheet based on smoothed average sales and either basis or proposed retail less cost The calculation will mirror the Sales Amount calculation except that the Pricing Cost on the effective date will be subtracted from the basis or proposed retail before multiplying that value by the smoothed average sales amount Problemes connus Probl mes connus internes LQ Remarque le num ro d anomalie interne de Retek dans le tableau ci dessous est indiqu pour r f rence Notez que ce num ro n est pas li au service d assistance client le de Retek Notes de mise a jour Num ro d anomalie interne Retek Description de l
8. 08 location After click on Apply an error message appears to indicate items which are not linked to the zone or the location where the clearance will take place Clearances are made by entire dept seasons and the user cannot create a clearance for each association item loc The same fact occurs for promotion and price change RQST00000066303 On Create Price Change Create Clearance or Create Promotions DEFECT000378148 dialogs the user must click twice on the Select button to select items and display them on the item selection window 13 Retek Price Management ROCS Description des demandes d intervention RQST00000067 135 Price Change There is an inconsistency between the action and the DEFECT000393236 error message No Change Type has been specified to a new price change Clicking on Apply the following error message appears Change Amount single Unit Retail or Multi Unit Retail is required RQST00000066718 Impossible to select Executed Price Change or Clearance The user DEFECT000393025 cannot select the status Executed Price Changes via the Price Change Search window RQST00000068473 When you are on itemchildrendiff and click on Retail by zone the DEFECT000394657 lines are not displayed in the correct order The zone 1 should be displayed then the zone 2 and so on This issue appears when you open Retail by zone from item master and is confusing for users RQST00000068784 There are data
9. ORKSHEET DATA and Margin RPM_WORKSHEET WORKSPACE 0016_rpm_strategy_maint_ Add table Maintain Margin margin RPM_STRATEGY_MAINT_MARGIN Strategy and Auto Approve 0017_rpm_maint_margin_ err_dtl Update column price_change_display_id on RPM_MAINT_MARGIN_ERR_DTL to be varchar2 15 Maintain Margin Strategy and Auto Approve 0018_rpm_worksheet_ status Add column price_strategy_type to RPM_WORKSHEET_STATUS Area Differentials and Competitor Strategies 0019_rpm_area_diff_comp Add column area_diff_mbc_id to RPM_AREA_DIFF_COMP Area Differentials and Competitor Strategies Retek Price Management Modif BdD 0020_rpm_area_temp_ item_loc Description technique Create GLOBAL TEMPORARY TABLE RPM_AREA TEMP_ ITEM LOC Conditions de fonctionnement Area Differentials and Competitor Strategies 0021_rpm_worksheet_ status Add column maint_margin_ind to RPM_WORKSHEET STATUS Maintain Margin Strategy and Auto Approve 0022_rpm_mbc_lov_value Add column type to RPM_MBC_LOV_VALUES Market Basket Code 0023_rpm_clearance Performance index on rpm_clearance Performance Fixes 0024_rpm_price_change Performance indexes on 6 RPM tables Performance Fixes 0025_rpm_future_retail Performance mods for rpm_future_retail add 3 columns partition by dept and new indexes Performance Fixes 0026_rpm_pricing_ constraint Rename the pric
10. actif Les clients Retek ayant sign un contrat de maintenance peuvent contacter un repr sentant du support client le conform ment aux termes du contrat et ce de l une des mani res suivantes M thode de contact Contact E mail support retek com Internet ROCS rocs retek com Site Web client de Retek pour la mise jour et la consultation des probl mes T lephone 1 612 587 5800 Il existe galement dans certains pays des num ros d appel gratuits Australie 1 800 555 923 AU Telstra ou 1 800 000 562 AU Optus France 0800 90 91 66 Hong Kong 800 96 4262 Cor e 00 308 13 1342 Royaume Uni 0800 917 2863 Etats Unis 1 800 61 RETEK ou 800 617 3835 Courrier Retek Customer Support Retek on the Mall 950 Nicollet Mall Minneapolis MN 55403 Etats Unis Lorsque vous contactez le Support client le veuillez fournir e La version du produit et le nom du programme module e Une description fonctionnelle et technique du probl me notamment les r percussions commerciales e Les instructions tape par tape de la reconstitution e Le message d erreur exact re u e Des captures d cran de chaque action entreprise Notes de mise a jour Pr sentation Vous trouverez dans ce document les informations relatives aux am liorations fonctionnelles et techniques qui ont t apport es Retek Price Management RPM depuis la derni re version Vous trouverez galement les anomalies de l ancienne version qui ont t corr
11. at another task engine is already running Workaround Manually delete all rows from the SYS_PROC table before starting the task engine up after an abnormal termination 10002 There is a classloader problem with Java Web Start applications using Java 1 4 1 See the following link for a description of the bug http bugs sun com bugdatabase view_bug do bug_id 4665132 On rare occasions this bug results in odd visual behavior in the RPM application Retek has identified the following symptoms e Clicking on a task in the task pad results in an empty Error dialog box e Empty task pad e Dialog boxes are only large enough to show the three window manipulation buttons minimize return to previous resize and close e All Dialog boxes display with no text If such symptoms occur close and re launch the application Sometimes the bug makes it impossible to close the application normally so the user must force it to close by right clicking the application s tab in the Windows task bar and selecting close 15 Retek Price Management Num ro d anomalie interne Retek Description de l anomalie 10003 If there are any errors returned by RMS package calls the user sees a message window that states Stale Object Refresh and proceed This message window appears because the actual message returned by RMS is overridden by a StaleObjectStateException which gets thrown by Hibernate because
12. combination already existed on a deal as a detail of an existing deal component prior to that item location combination s being approved on the promotion component the item location combination is added to that deal again as a part of a new deal component If this scenario occurs the item location combination exists on multiple deal components of the same deal When sales are processed for the item location that exists on multiple components of a deal this processing results in the recording of deal income multiple times for the same sale Currently the markup and margin percent fields are using an incorrect formula for retails that include VAT This issue causes the markup and margin percent fields to display a percent that incorrectly strips the VAT rate off 12 Notes de mise a jour Anomalies corrig es externes ROCS Description des demandes d intervention RQST00000065615 Fatal exception when create a vendor funded deal in RMS type DEFECT000377748 vendor funded markdown Select component type and then add item locations items added at company level locations added at chain level RQST00000066311 The System Defaults View screen fields are not editable Looking at DEFECT000378146 the screenshot you can see that three fields are enabled and can be edited RQST00000067202 Select a department in the Zone Retail Definition List It is impossible DEFECT000393249 to sel
13. d Competitor Strategies 0006_rpm_worksheet_ status Add columns area_diff_prim_ind area_diff_prim_ws_id currency division div_name group_name group_no price_change_currency sales_change_amount sales_cost_currency sales_currency sales_ex_vat_currency to table RPM_WORKSHEET WORKSPACE Maintain Margin Strategy and Auto Approve Notes de mise a jour Modif BdD 0007_rpm_worksheet_data Description technique Add columns maint_margin_cost maint_margin_retail maint_margin_zl_cost maint_margin_zl_retail past_cost_chg_date past_price_chg_date pend_cost_chg_cost pend_cost_chg_date pend_zl_cost_chg_cost to table RPM_WORKSHEET WORKSPACE Conditions de fonctionnement Sales Change Amount 0009_rpm_maint_margin_ err Add new table RPM_MAINT_MARGIN_ERR Maintain Margin Strategy and Auto Approve 0010_rpm_maint_margin_ err_dtl Add new table RPM_MAINT_MARGIN_ERR_DTL Maintain Margin Strategy and Auto Approve 0011_rpm_pricing_ Add new table Promotion constraint RPM_PRICING_CONSTRAINT Constraint 0012_rpm_area_diff_mbc Add new table Market Basket RPM_AREA_ DIFF_MBC Code Maintain Margin 0013_rpm_area_diff_comp Add columns area_diff_mbc_id and Market Basket mkt_basket_code to table Code Maintain RPM_AREA_ DIFF_COMP Margin 0014_rpm_worksheet_data Add columns comp_mkt_basket_code Market Basket and margin_mkt_basket_code to tables Code Maintain RPM_W
14. d tables RPM_PRICE_ WORKSPACE and RPM_PRICE_WORKSPACE_DETAIL Table additions and changes for Performance and Paging Sorting Filt ering in Price Changes and Clearances 0056_rpm_price_ workspace_seq Creating Sequence RPM_PRICE_WORKSPACE_SEQ and Creating Sequence RPM_PRICE_WRKSPC_DTL_ID_ SEQ Table additions and changes for Performance and Paging Sorting Filt ering in Price Changes and Clearances Notes de mise a jour Modif BdD 0057_rpm_price_ workspace_detail Description technique Add new column detail_type to the RPM_PRICE_WORKSPACE_DETAIL table Conditions de fonctionnement Table additions and changes for Performance and Paging Sorting Filt ering in Price Changes and Clearances 0058_rpm_price_ workspace Update PARENT_DISPLAY_ID to be Varchar2 and LOCATION_DESCRIPTION to be Varchar2 30 on RPM_PRICE_ WORKSPACE table Table additions and changes for Performance and Paging Sorting Filt ering in Price Changes and Clearances 0059_rpm_column_length Column expansion for internationalization Column Expansion for Internationalization 0059_rpm_promo_comp_ simple New performance index on RPM_PROMO_COMP_SIMPLE Performance Fixes 0060_rpm_promo_comp_ threshold New performance index on RPM_PROMO_COMP_THRESHOLD Performance Fixes 0061_rpm_conflict_check_ request New table RPM_CONFLICT_CHECK_ REQUEST Table additions and c
15. e a t modifi e de fa on afficher l affectation des concurrents principaux et des concurrents de r f rence aux zones secondaires Deux nouvelles colonnes Division et Groupe ont t ajout es l cran Statut Brouillon Ces nouvelles colonnes permettent l utilisateur de trier et de filtrer lorsque le statut est brouillon ce qui lui permet d afficher les totaux d un niveau donn de la hi rarchie des marchandises Retek Price Management e Un nouveau type de strat gie appel e G rer la marge a t ajout e 4 RPM Cette nouvelle strat gie permet aux d taillants de recevoir des propositions de modification de PV bas es sur les modifications de PA en attente La strat gie de gestion de la marge r cup re toutes les modifications de PA d une hi rarchie zone marchandises sp cifi e de fa on prospective et g n re les modifications de PV propos es L utilisateur doit choisir l une des deux options suivantes le PV propos est bas sur la marge actuelle la marge du code de panier est associ e l article L utilisateur peut aussi sp cifier comment appliquer l augmentation ou la baisse du PV Cette modification peut se faire par pourcentage du PA ou par montant exact ajout au PA ou soustrait Par exemple si le PA augmente de 10 le PV augmente de 10 si le PA augmente de 1 00 le PV augmente de 1 00 Une fonction suppl mentaire ajout e au brouillon permet d approuver automati
16. ect a department ID writing the part of the ID or the part of the name department with the keypad and it is impossible to go down or up with the scroll if there are approximately 4500 5000 departments in the list RQST00000066300 The user must select a zone or location before specify the Change DEFECT000392792 Type and Change Amount RQST00000067038 When a promotion had been created the calendar proposes an end date DEFECT000393172 respecting the Price Change processing days but not the constraint that end date must be greater than action date The promotion is not linked to an event An end date prior to the start date is specified clicking on Add Component the following message appears Error message Start date if linked with an event the promotion date range must have a start date and end date and must be contained within the event range RQST00000066721 Fatal Exception saving code maintenance The following error DEFECT000393110 message appears when the code of the Code Maintenance is too long Code This field has too many characters Maximum 10 A Fatal Exception occurs when there is a space in the code RQST00000066380 Create a Clearance Inefficiency tabbing navigation When a tab DEFECT000393111 occurs it does not allow the user to fill the next field The user must click with the mouse in this next field RQST00000066733 An error message occurs when applying an item is not linked to the DEFECT0003931
17. essfully process if there are any link codes items brought into the worksheet There is currently an issue with all character fields in RPM Validation for character fields does not take into account that certain French characters actually take up the space of two characters on the database Therefore validation of these fields pass on the user interface UT side but Oracle is unable to save them to the database because they may exceed the size specified for the field For example if there is a field on the UI database that can hold ten characters and the user types in a value ten characters long including two French characters that actually take up the space of two characters on the database the UI counts ten characters and the validation passes but the database counts the value as twelve characters and is not able to insert the value on the database For promotion components with vendor funding each time an item location detail of the component is approved the items and locations are added to the vendor funded deals associated with the promotion component For each approval action a new deal component is added to the associated vendor funded deals These new deal components include the items and locations contained in the details that were approved Depending on the information already contained in the deal this design results in the same item location combinations existing on multiple components of the same deal If an item location
18. hanges to handle Asynchronous processing 0062_RPM_FUTURE_ RETAIL Performance local indexes on rpm_future_retail on clearance_id and price_change_id Performance Fixes 0063_rpm_conflict_check_ result 0064_rpm_conflict_ check_request_seq Create new table RPM_CONFLICT_CHECK_RESULT and sequence RPM_CONFLICT_CHECK_RQST_ SEQ Rename RPM_CONFLICT_CHECK_RQST_ SEQ to RPM_CONFLICT_CHECK_REQUEST _SEQ Table additions and changes to handle Asynchronous processing Table additions and changes to handle Asynchronous processing 0065_rpm_confict_check_ rqst_prpt Create new table RPM_CONFLICT_CHECK_RQST_ PRPT Table additions and changes to handle Asynchronous processing Retek Price Management Modif BdD 0066_rpm_future_retail Description technique New performance indexes on RPM_FUTURE_RETAIL Conditions de fonctionnement Performance Fixes 0067_rpm_conflict_check_req _ rp_seq Create new sequence RPM_CONFLICT_CHECK_REQ_ GRP _SEQ Table additions and changes to handle Asynchronous processing 0067_rpm_conflict_check_ req_grp_seq Create new Sequence RPM_CONFLICT_CHECK_REQ_GRP _SEQ Table additions and changes to handle Asynchronous processing 0068_rpm_worksheet_data Performance index on RPM_WORKSHEET_DATA global index Performance Fixes 0069_rpm_column_lengths Column expansion for Column Expansion internatio
19. ig es Prise en charge des produits Retek Cette version de RPM est compatible avec les produits Retek suivants RMS 11 0 3 y compris Retek Sales Audit Retek Allocation 11 0 2 RIB 11 1 RSL 11 1 RDW 11 0 SIM ISO 11 0 0 1 RETL 11 2 2 Retek Navigator 11 0 1 RSM 11 1 1 Am liorations fonctionnelles RPM peut dor navant utiliser des brouillons de zone secondaire avant que le brouillon de zone principale soit approuv dans la bo te de dialogue Brouillon Le syst me met dynamiquement jour dans la zone secondaire les modifications apport es au brouillon dans la zone principale Cette m thode fonctionne comme un sc nario de simulation puisque les modifications de prix ne sont pas v ritablement cr es dans la bo te de dialogue Brouillon tant que l utilisateur n approuve pas un brouillon Cette nouvelle fonctionnalit zones secondaires modifiables et mises jour imm diatement en fonction des modifications des zones principales n est disponible que dans les bo tes de dialogue Statut Brouillon et D tails du brouillon Par ailleurs les comparaisons de tarification concurrentielle sont pr sent dispos es en couches au dessus des r gles de tarification de diff rentiel de zone pour les zones secondaires Le prix de diff rentiel de zone sert de guide et le PV concurrent peut ajuster le prix de la proposition de diff rentiel qui est bas sur des r gles donn es La bo te de dialogue des diff rentiels de zon
20. ing_constriant_id column to pricing_constraint_id Promotion Constraint 0027_rpm_system_ options_def Add column maint_margin_method to RPM_SYSTEM_ OPTIONS DEF Maintain Margin Strategy and Auto Approve 0028_rpm_system_ options_def Rename column maint_margin_method to def_maint_margin_method on table RPM_SYSTEM_ OPTIONS DEF Maintain Margin Strategy and Auto Approve 0029_rpm_worksheet_data Add columns maint_margin_retail_uom and maint_margin_zl_retail_uom to RPM_WORKSHEET DATA Maintain Margin Strategy and Auto Approve 0030_rpm_worksheet_ workspace Add columns maint_margin_retail_uom and maint_margin_zl_retail_uom to RPM_WORKSHEET WORKSPACE Maintain Margin Strategy and Auto Approve 0031_rpm_link_code_ attribute Creating Foreign Key on RPM_LINK_CODE_ATTRIBUTE and Create Sequence RPM_LINK_CODE_ATTRIBUTE_ SEQ Updates to Link Code functionality to handle removal or item_zone_price 0032_rpm_mbc_attribute Create Sequence RPM_MBC_ATTRIBUTE_SEQ Market Basket Code 0033_rpm_worksheet_data Added columns maint_margin_retail_std and maint_margin_zl_retail_std to rpm worksheet_data workspace Maintain Margin Strategy and Auto Approve 0034_rpm_worksheet_ workspace Added columns maint_margin_retail_std and maint_margin_zl_retail_std to rpm worksheet_data workspace Maintain Margin Strategy and Auto Approve Notes de mise a jour
21. nalization for Internationalization 0070_rpm_worksheet_data Add column parent_diff_4_type_desc to Bug Fixes RPM_WORKSHEET DATA 0071_rpm_worksheet_ Add column parent_diff_4_type_desc to Bug Fixes workspace RPM_WORKSHEET WORKSPACE 0072_rpm_system_options_ Remove column Bug Fixes def def_lead_item_calc_type from RPM_SYSTEM_OPTIONS_DEF 0073_rpm_sequences Alter sequences RPM_PRICE_WORKSPACE_SEQ and RPM_PRICE_WRKSPC_DTL_ID_SE Q to set the maxvalue parameter to 999999 Table additions and changes for Performance and Paging Sorting Filt ering in Price Changes and Clearances 0074_rpm_promo Performance fixes add index on RPM_PROMO END_DATE Performance Fixes 0075_rpom_con_check_err Create table RPM_CON_CHECK_ERR Table additions and changes to handle Asynchronous processing 0076_rpm_con_check_err_ detail Create table RPM_CON_CHECK_ ERR DETAIL Table additions and changes to handle Asynchronous processing Notes de mise a jour Modif BdD 0077_rpm_con_check_err Description technique Add column error_date to table RPM_CON_CHECK_ERR Conditions de fonctionnement Table additions and changes to handle Asynchronous processing 0078_rpm_con_check_err Update column ref_display_id to VARCHAR 15 NOT NULL and ref_secondary_display_id to VARCHAR 15 NOT NULL on table RPM_CON_CHECK_ERR Table additions and changes to handle Asynchronous proces
22. out e aux crans Statut Brouillon et D tails du brouillon Cette nouvelle colonne contient le montant de la modification des ventes Ce montant est la diff rence entre le nouveau PV de l article et le PV de base la date d application multipli e par les ventes projet es d une semaine e Le brouillon de tarification comporte de nouvelles colonnes qui donnent davantage d informations l utilisateur sur les v nements susceptibles d affecter les d cisions de tarification La visibilit des modifications de PA pass es et futures et des modifications de prix pass es est ainsi am lior e Notes de mise a jour Ameliorations techniques Les codes utilis dans les tableaux RPM pour repr senter les types de site ont t am lior s Dans la liste de tableaux suivante le type de magasin correspond un 0 et le type d entrep t au chiffre 1 RPM_LOCATION_MOVE RPM_ZONE_LOCATION RPM_FUTURE_RETAIL RPM_WOR KSHEET_DATA RPM_WORKSHEET_STATUS RPM_WORKSHEET_WORKSPACE Auparavant des probl mes surgissaient lorsque ces tableaux fusionnaient avec d autres tableaux contenant des donn es qui repr sentaient le type de zone par exemple type magasin 0 type zone 1 type entrep t 2 Pour r soudre le probl me les codes ont t stabilis s dans la totalit de l application 0 magasin 1 zone et 2 entrep t Il a fallu pour cela convertir les donn es de la liste de tableaux ci dessus
23. quement les PV propos s Cette fonction concerne les strat gies de gestion de marge dans lesquelles les enregistrements n ont subi aucune modification la fin de la p riode d analyse e RPM int gre galement une nouvelle fonctionnalit qui permet d associer deux types de codes de panier diff rents march concurrentiel et march de marge une combinaison article zone Les codes de panier du march concurrentiel sont utilis s conjointement avec les strat gies concurrentielles et les codes de panier de march de marge sont utilis s conjointement avec les strat gies de marge et de gestion de la marge e Une autre fonctionnalit permet pr sent de pr venir les utilisateurs de RPM si ils cr ent une modification de prix lors d une p riode nombre de jours d finie pour le lancement d une promotion approuv e ils cr ent une promotion lors d une p riode nombre de jours d finie pour la date d application d une modification de prix approuv e e L avertissement n emp che pas l utilisateur de cr er la modification de prix ou la promotion Dans la bo te de dialogue des modifications de prix une nouvelle fonctionnalit propose une date d application pour la modification de prix si celle ci ne respecte pas une contrainte promotionnelle Le nombre de jours est d termin par la nouvelle variable de contrainte promotionnelle stock e au niveau sous famille site e Une nouvelle colonne a galement t aj
24. sing 0079_rpm_con_check_err_ detail Update column ref_display_id to VARCHAR 15 NOT NULL and Table additions and changes to handle ref_secondary_display_id to Asynchronous VARCHAR 15 NOT NULL on table processing RPM_CON_CHECK_ERR 0080_rpm_rpice_change Add column ignore_constraints to Promotion RPM_PRICE CHANGE Constraint 0081_rpm_promo_comp_ Add column ignore_constraints to Promotion detail RPM_PROMO_COMP_DETAIL Constraint 0082_rpm_price_workspace Add column ignore_constraints to Promotion RPM_PRICE_ WORKSPACE Constraint 0083_rpm_item_dif Update rpm_item_diff view definition to Bug Fixes use instead of lt in the first union 0084_rpm_system_options Add columns price_clr_bckgrnd_cnflct_ind promo_bckgrnd_cnflct_ind wrksht_bckgrnd_cnflct_ind to RPM_SYSTEM_OPTIONS Table additions and changes to handle Asynchronous processing 0085_rpm_system_options Removed column background_conflict_ind from RPM_SYSTEM_OPTIONS Table additions and changes to handle Asynchronous processing 0086_rpm_price_workspace Add column zone_display_id to RPM_PRICE_WORKSPACE Table additions and changes for Performance and Paging Sorting Filt ering in Price Changes and Clearances 11 Retek Price Management Anomalies corrig es de la version RPM 11 0 2 Anomalies corrig es internes Description de l anomalie The merchandise extract is currently unable to succ
25. the data is out of sync The message returned by Hibernate is misleading because it informs users that they can resubmit their request at a later time when there is actually a legitimate problem with the package call The package error is written to a log file but only if the log level is set to DEBUG To change log levels the file log4j xml must be edited This file is found in a jar file at the following link lt WEBSPHERE_HOME gt AppServer installedA pps lt INSTANCE NAME gt rpm1 1 ear platform server jar The log4j xml file must be extracted from platform server jar It must then be modified and re jarred into platform server jar When the application is restarted through the Websphere admin console the log levels change Notes de mise a jour Problemes connus externes ROCS Description des demandes d intervention RQST00000069653 DEFECT000395054 Posupld is supposed to handle 0 unit_cost The error is returned by merch_retail_api_sql non_range_item_retail which validates if the I_unit_cost is 0 and raises error if it is However it is inconsistent with how the I_unit_cost is later on used in calculate_non_ranged_retail which seems to allow the I_unit_cost to be 0 and accordingly sets the O_selling_retail to 0 The validation that restricts I_unit_cost 0 should be removed from merch_retail_api_sql non_range_item_retail RQST000000686 14 Inconsistency of the cost and margin displayed in the apply bloc of
26. traint RPM_PRICING_CONSTRAINT Constraint 0045_rpm_dept_ Performance make Performance Fixes aggregation rpm_dept_aggregation_il a unique index 0046_rpm_system_ options_def Add column def_wksht_promo_const_ind to RPM_SYSTEM_OPTIONS_DEF Promotion Constraint Retek Price Management Modif BdD 0047_rpm_item_loc Description technique Drop view RPM_ITEM_LOC Conditions de fonctionnement Remove RPM_ITEM_ LOC view 0048_rpm_batch_control Add column thread_luw_count to RPM_BATCH_CONTROL Performance Fixes 0049_rpm_worksheet_ Add CONSTRAINT_BOOLEAN and Promotion workspace IGNORE_CONSTRAINT_BOOLEAN Constraint to rpm_worksheet_data and rpm_worksheet_workspace 0050_rpm_worksheet_data Add CONSTRAINT_BOOLEAN and Promotion IGNORE_CONSTRAINT_BOOLEAN Constraint to rpm_worksheet_data and rpm_worksheet_workspace 005 1_rpm_worksheet_data Remove column mkt_basket_code from RPM_WORKSHEET DATA and RPM_WORKSHEET WORKSPACE Performance Fixes 0052_rpm_worksheet_ status Remove column price_strategy_type from rpm_worksheet_status Performance Fixes 0053_rpm_worksheet_ status add column constraint_ind to RPM_WORKSHEET_STATUS CONS TRAINT_IND Promotion Constraint 0054_rpm_system_options Add column background_conflict_ind to RPM_SYSTEM_OPTIONS Table additions and changes to handle Asynchronous processing 0055_rpm_price workspace_details Ad
27. tre et aucune autre version du logiciel y compris et sans limitation les versions ult rieures du m me composant logiciel La fonctionnalit d crite dans le pr sent document peut tre modifi e dans les versions ult rieures du logiciel et Retek se r serve le droit d apporter ces modifications sa discr tion absolue Retek Price Management est une marque commerciale de Retek Inc Retek et le logo Retek sont des marques d pos es de Retek Inc Ce travail non publi est prot g par un accord de confidentialit le secret commercial le droit d auteur et d autres lois Dans l ventualit d une publication la mention suivante doit figurer 2005 Retek Inc Tous droits r serv s Tous les noms des autres produits mentionn s sont des marques commerciales ou des marques d pos es par leurs propri taires respectifs et doivent tre trait es comme telles Imprim aux Etats Unis d Am rique Retek Price Management Support clientele Horaires du Support client le Le Support client le est accessible 24 heures sur 24 7 jours sur 7 et 365 jours par an par e mail t l phone ou Internet En fonction de l option d assistance choisie par le client Standard Plus ou Premium la p riode de disponibilit de certains services peut tre limit e Les questions de gravit 1 Critiques sont trait es 7 jours sur 7 24 heures sur 24 jusqu leur r solution pour tous les clients b n ficiant de l entretien
Download Pdf Manuals
Related Search