Retail Invoice Matching (MOSC)

MOSC Banner

Unable to retrieve rows from database. SELECT IM_SYSTEM_OPTIONS.

edited Jan 29, 2014 2:54AM in Retail Invoice Matching (MOSC) 5 commentsAnswered
 Hello everyone,

i am facing the login issue in REIM 13.2.6. i am getting this below error in the log.

2014-01-28 13:01:40,274 ERROR [[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] com.retek.reim.merch.utils.ReIMException - com.retek.reim.merch.utils.ReIMException: Unable to retrieve rows from database. SELECT IM_SYSTEM_OPTIONS.DEBIT_MEMO_SEND_DAYS,IM_SYSTEM_OPTIONS.CLOSE_OPEN_RECEIPT_DAYS,IM_SYSTEM_OPTIONS.COST_RESOLUTION_DUE_DAYS,IM_SYSTEM_OPTIONS.QTY_RESOLUTION_DUE_DAYS,IM_SYSTEM_OPTIONS.DOC_HIST_DAYS,IM_SYSTEM_OPTIONS.DEBIT_MEMO_PREFIX_COST,IM_SYSTEM_OPTIONS.DEBIT_MEMO_PREFIX_QTY,IM_SYSTEM_OPTIONS.DEBIT_MEMO_PREFIX_TAX,IM_SYSTEM_OPTIONS.CREDIT_MEMO_PREFIX_COST,IM_SYSTEM_OPTIONS.CREDIT_MEMO_PREFIX_QTY,IM_SYSTEM_OPTIONS.CREDIT_NOTE_REQ_PREFIX_COST,IM_SYSTEM_OPTIONS.CREDIT_NOTE_REQ_PREFIX_QTY,IM_SYSTEM_OPTIONS.CREDIT_NOTE_REQ_PREFIX_TAX,IM_SYSTEM_OPTIONS.POST_DATED_DOC_DAYS,IM_SYSTEM_OPTIONS.MAX_TOLERANCE_PCT,IM_SYSTEM_OPTIONS.DAYS_BEFORE_DUE_DATE,IM_SYSTEM_OPTIONS.DEFAULT_PAY_NOW_TERMS,IM_SYSTEM_OPTIONS.CALC_TOLERANCE_IND,IM_SYSTEM_OPTIONS.CALC_TOLERANCE,IM_SYSTEM_OPTIONS.TAX_VALIDATION_TYPE,IM_SYSTEM_OPTIONS.TAX_DOCUMENT_CREATION_LVL,IM_SYSTEM_OPTIONS.DEFAULT_TAX_HEADER,IM_SYSTEM_OPTIONS.TAX_RESOLUTION_DUE_DAYS, IM_SYSTEM_OPTIONS.VPN_ITEM_LOOKUP, IM_SYSTEM_OPTIONS.DFLT_CBC_REASON_CODE, IM_SYSTEM_OPTIONS.DFLT_CBQ_REASON_CODE, IM_SYSTEM_OPTIONS.DFLT_CMC_REASON_CODE, IM_SYSTEM_OPTIONS.DFLT_CMQ_REASON_CODE, IM_SYSTEM_OPTIONS.MATCH_USING_REF_3, IM_SYSTEM_OPTIONS.MATCH_USING_REF_4, IM_SYSTEM_OPTIONS.RECEIPT_WRITE_OFF_DAYS, IM_SYSTEM_OPTIONS.TAX_VALIDATION_SRC, IM_SYSTEM_OPTIONS.NUM_TAX_ALLOW,IM_SYSTEM_OPTIONS.POST_BASED_ON_DOC_HEADER, IM_SYSTEM_OPTIONS.PRORATE_ACROSS_TAX_CODES  FROM IM_SYSTEM_OPTIONS WHERE 1=1  

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center