Tuesday, 19 March 2013

REIM ISSUES : Invoice matching system options is not defined. Please contact your system administrator.

ERROR IN REIM 13.2.4 :
==================

com.retek.reim.merch.utils.ReIMException: Invoice matching system options is not defined. Please contact your system administrator.
        at com.retek.reim.services.ReIMSystemOptionsService.select(ReIMSystemOptionsService.java:34)
        at com.retek.reim.ui.login.LoginAction.doForward(LoginAction.java:82)
        at com.retek.reim.ui.login.LoginAction.perform(LoginAction.java:60)
        at org.apache.struts.action.Action.execute(Action.java:420)
        at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
        at com.retek.merch.utils.CustomRequestProcessor.processActionPerform(CustomRequestProcessor.java:23)
        at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
        at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
        at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
2013-03-06 17:36:24,579 ERROR [[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] com.retek.reim.ui.login.LoginAction -
com.retek.reim.merch.utils.ReIMException: Could not complete login.
        at com.retek.reim.ui.login.LoginAction.perform(LoginAction.java:62)
        at org.apache.struts.action.Action.execute(Action.java:420)
        at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
        at com.retek.merch.utils.CustomRequestProcessor.processActionPerform(CustomRequestProcessor.java:23)
        at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
        at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
        at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
-

CAUSES :
========

This error is due to absence of data in IM_SYSTEM_OPTIONS table.

when the time of installing RMS application you have uncheck the inesrt demo data option for REIM. due to that, this issue is occuring.


solution :
======

conn RMS13/RMS13

insert into im_system_options (DEBIT_MEMO_SEND_DAYS,CLOSE_OPEN_RECEIPT_DAYS,COST_RESOLUTION_DUE_DAYS,QTY_RESOLUTION_DUE_DAYS,DOC_HIST_DAYS,DEBIT_MEMO_PREFIX_COST,DEBIT_MEMO_PREFIX_QTY,DEBIT_MEMO_PREFIX_TAX,CREDIT_MEMO_PREFIX_COST,CREDIT_MEMO_PREFIX_QTY,CREDIT_NOTE_REQ_PREFIX_COST,CREDIT_NOTE_REQ_PREFIX_QTY,CREDIT_NOTE_REQ_PREFIX_TAX,POST_DATED_DOC_DAYS,MAX_TOLERANCE_PCT,DAYS_BEFORE_DUE_DATE,DEFAULT_PAY_NOW_TERMS,CALC_TOLERANCE,TAX_VALIDATION_TYPE,TAX_DOCUMENT_CREATION_LVL,DEFAULT_TAX_HEADER,TAX_RESOLUTION_DUE_DAYS,CALC_TOLERANCE_IND,VPN_ITEM_LOOKUP,RECEIPT_WRITE_OFF_DAYS,DFLT_CBC_REASON_CODE,DFLT_CBQ_REASON_CODE,DFLT_CMC_REASON_CODE,DFLT_CMQ_REASON_CODE,MATCH_USING_REF_3,MATCH_USING_REF_4,NUM_TAX_ALLOW,TAX_VALIDATION_SRC,BALANCING_TOLERANCE,POST_BASED_ON_DOC_HEADER) values ('1','90','3','2','20','DMC','DMQ','DMT','CMC','CMQ','CNC','CNQ','CNT','10','100','3','163','10','RECON','ITEM','N','0','P','Y','0','','','','','Y','Y','N','RMS13','1','N');

commit;
-


NOW TRY LOGIN IN REIM APPLICATION.


Migration of extract and pump process from 11g to 19c in golden gate

 In this example, we are going to migrated golden gate from 11g to 19c. As part of migration, we need to perform the below steps. Step 1: Pr...