IM System Options
In ScopeTechnical: IM_SYSTEM_OPTIONS | ID: OR-IM-IM_SYSTEM_OPTIONS-IM_SYSTEM_OPTIONS
Stores configuration settings and processing options for IM system options in Oracle Retail Invoice Matching. These values control system behavior, integration settings, validation rules, or runtime defaults used by invoice...
See how this object fits into Invoice Matching
Review the broader sequencing and dependencies for this domain
Migration Details
- Complexity
- Medium
- Sequencing
- Stage 2
- Typical Sources
- ERPLegacy
Classification
- Information Type
- Configuration
- Object Type
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- IM_SYSTEM_OPTIONS
Field Definitions(5)
Rules & Considerations(177)
validation
constraint
Sample Load Data(4)
| _scenario | DOC_HIST_DAYSR | DEBIT_MEMO_SEND_DAYSR | DEBIT_MEMO_PREFIX_QTYR | DEBIT_MEMO_PREFIX_COSTR | CLOSE_OPEN_RECEIPT_DAYSR | DFLT_SOB | DFLT_DEPT | CREATED_BY | DFLT_CLASS | CREATION_DATE | NUM_TAX_ALLOW | OBIEE_ENABLED | CALC_TOLERANCE | CNT_TOMOR_CRIT | CNT_TOMOR_WARN | CNT_TOTAL_CRIT | CNT_TOTAL_WARN | LUW_AUTO_MATCH | S9T_PURGE_DAYS | ALLOWANCE_MATCH | DFLT_HEADER_TAX | GL_MAX_SEGMENTS | LAST_UPDATED_BY | LUW_FDG_EXTRACT | DOC_QTY_DECIMALS | LAST_UPDATE_DATE | LUW_EDI_INJECTOR | BATCH_DATE_FORMAT | CNT_PAST_DUE_CRIT | CNT_PAST_DUE_WARN | MAX_TOLERANCE_PCT | OBJECT_VERSION_ID | CALC_TOLERANCE_IND | CNT_2DAYS_OUT_CRIT | CNT_2DAYS_OUT_WARN | CNT_3DAYS_OUT_CRIT | CNT_3DAYS_OUT_WARN | POST_ON_DOC_HEADER | TOTAL_QTY_REQUIRED | USE_SUFFIX_ON_DOCS | BALANCING_TOLERANCE | DOCUMENT_SEARCH_MAX | EDI_DATA_PURGE_DAYS | POST_DATED_DOC_DAYS | RESOLUTION_DUE_DAYS | TAX_VALIDATION_TYPE | DAYS_BEFORE_DUE_DATE | DEAL_DOCS_PURGE_DAYS | DFLT_QTY_OVERBILL_RC | WS_FIN_ACC_VALID_URL | WS_FIN_DRILL_FWD_URL | DEBIT_MEMO_PREFIX_TAX | DFLT_COST_OVERBILL_RC | DFLT_QTY_UNDERBILL_RC | WS_FIN_ACC_VALID_CRED | WS_FIN_DRILL_FWD_CRED | BATCH_STATUS_HIST_DAYS | CALC_EXCHANGE_RATE_VAR | CREDIT_MEMO_PREFIX_QTY | DFLT_COST_UNDERBILL_RC | DFLT_PAY_NOW_TERMS_RTV | DOCUMENTATION_SUMM_IND | RECEIPT_WRITE_OFF_DAYS | STATUS_DATA_PURGE_DAYS | BATCH_THREAD_TIMEOUT_MS | CREDIT_MEMO_PREFIX_COST | DEBIT_MEMO_PREFIX_ALLOW | DFLT_NON_MERCH_LOCATION | TAX_RESOLUTION_DUE_DAYS | THIRD_PARTY_PAYEE_ALLOW | CREDIT_MEMO_PREFIX_ALLOW | DFLT_PAY_NOW_TERMS_DEALS | MATCH_INQUIRY_SEARCH_MAX | PRORATE_ACROSS_TAX_CODES | DELAY_LN_MTCH_UNTL_ROUTE_ | INJECTOR_STAGED_HIST_DAYS | POST_INTRA_REGION_TAX_IND | TAX_DOCUMENT_CREATION_LVL | CREDIT_NOTE_REQ_PREFIX_QTY | CREDIT_NOTE_REQ_PREFIX_TAX | ALWAYS_USE_PO_EXCHANGE_RATE | CREDIT_NOTE_REQ_PREFIX_COST | EXCL_PRFX_ON_EXTL_SRCD_DOCS | EXTERNAL_ACCOUNT_VALIDATION | CREDIT_NOTE_REQ_PREFIX_ALLOW | INCL_DOC_DATE_FOR_DUPL_CHECK | INCL_DOC_YEAR_FOR_DUPL_CHECK | DELAY_LN_MTCH_UNTL_ROUTE_DATE | USE_INV_RCV_DT_TO_CALC_DUE_DT |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | SAMPLE | SAMPLE | 1 | 1 | 1 | SAMPLE | 1 | 2026-01-01 | S | S | 1.0000 | 1 | 1 | 1 | 1 | 1 | 1 | S | S | 1 | SAMPLE | 1 | 1 | 2026-01-01 | 1 | SAMPLE | 1 | 1 | 1.0000 | 1 | S | 1 | 1 | 1 | 1 | S | S | S | 1.0000 | 1 | 1 | 1 | 1 | SAMPL | 1 | 1 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | S | S | 1 | S | SAMPLE | SAMPLE | SAMPLE | S | 1 | 1 | 1 | SAMPLE | SAMPLE | 1 | 1 | S | SAMPLE | SAMPLE | 1 | S | 2026-01-01 | 1 | S | SAMPLE | SAMPLE | SAMPLE | S | SAMPLE | S | S | SAMPLE | S | S | S | S |
| default | non | non | IM System Options-002-ALT | IM System Options-002-ALT | non | 3 | 1003 | APP_USER_ID | 1103 | 2026-01-03 | S | N | 12.5000 | 3 | 3 | 3 | 3 | 3 | 3 | N | I | 3 | APP_USER_ID | 3 | 3 | 2026-01-03 | 3 | yyyyMMddHHmmss | 3 | 3 | 12.5000 | 1000000003 | A | 3 | 3 | 3 | 3 | N | N | N | 1.0000 | 3 | 3 | 3 | 3 | RECON | 3 | 3 | IM System Options-00 | IM System Options-002-ALT | IM System Options-002-ALT | IM System Options-002-ALT | IM System Options-00 | IM System Options-00 | I | I | — | N | IM System Options-002-ALT | IM System Options-00 | IM System Optio | N | 3 | 3 | 3 | IM System Options-002-ALT | DMA | 3 | non | N | CMA | IM System Optio | 3 | N | Y | — | N | ITEM | IM System Options-002-ALT | IM System Options-002-ALT | Y | IM System Options-002-ALT | N | N | CNA | N | N | — | N |
| default | non | non | IM System Options-003-EDGE | IM System Options-003-EDGE | non | 5 | 1005 | USERENV | 1105 | 2026-01-05 | S | N | 14.0000 | 5 | 5 | 5 | 5 | 5 | 5 | N | I | 5 | USERENV | 5 | 5 | 2026-01-05 | 5 | yyyyMMddHHmmss | 5 | 5 | 14.0000 | 1000000005 | A | 5 | 5 | 5 | 5 | N | N | N | 1.0000 | 5 | 5 | 5 | 5 | RECON | 5 | 5 | IM System Options-00 | IM System Options-003-EDGE | IM System Options-003-EDGE | IM System Options-003-EDGE | IM System Options-00 | IM System Options-00 | I | I | — | N | IM System Options-003-EDGE | IM System Options-00 | IM System Optio | N | 5 | 5 | 5 | IM System Options-003-EDGE | DMA | 5 | non | N | CMA | IM System Optio | 5 | N | Y | — | N | ITEM | IM System Options-003-EDGE | IM System Options-003-EDGE | Y | IM System Options-003-EDGE | N | N | CNA | N | N | — | N |
Example values from field definitions
- DOC_HIST_DAYSR
- 1
- DEBIT_MEMO_SEND_DAYSR
- 1
- DEBIT_MEMO_PREFIX_QTYR
- SAMPLE
- DEBIT_MEMO_PREFIX_COSTR
- SAMPLE
- CLOSE_OPEN_RECEIPT_DAYSR
- 1
- DFLT_SOB
- 1
- DFLT_DEPT
- 1
- CREATED_BY
- SAMPLE
- DFLT_CLASS
- 1
- CREATION_DATE
- 2026-01-01
- NUM_TAX_ALLOW
- S
- OBIEE_ENABLED
- S
- CALC_TOLERANCE
- 1.0000
- CNT_TOMOR_CRIT
- 1
- CNT_TOMOR_WARN
- 1
- CNT_TOTAL_CRIT
- 1
- CNT_TOTAL_WARN
- 1
- LUW_AUTO_MATCH
- 1
- S9T_PURGE_DAYS
- 1
- ALLOWANCE_MATCH
- S
- DFLT_HEADER_TAX
- S
- GL_MAX_SEGMENTS
- 1
- LAST_UPDATED_BY
- SAMPLE
- LUW_FDG_EXTRACT
- 1
- DOC_QTY_DECIMALS
- 1
- LAST_UPDATE_DATE
- 2026-01-01
- LUW_EDI_INJECTOR
- 1
- BATCH_DATE_FORMAT
- SAMPLE
- CNT_PAST_DUE_CRIT
- 1
- CNT_PAST_DUE_WARN
- 1
- MAX_TOLERANCE_PCT
- 1.0000
- OBJECT_VERSION_ID
- 1
- CALC_TOLERANCE_IND
- S
- CNT_2DAYS_OUT_CRIT
- 1
- CNT_2DAYS_OUT_WARN
- 1
- CNT_3DAYS_OUT_CRIT
- 1
- CNT_3DAYS_OUT_WARN
- 1
- POST_ON_DOC_HEADER
- S
- TOTAL_QTY_REQUIRED
- S
- USE_SUFFIX_ON_DOCS
- S
- BALANCING_TOLERANCE
- 1.0000
- DOCUMENT_SEARCH_MAX
- 1
- EDI_DATA_PURGE_DAYS
- 1
- POST_DATED_DOC_DAYS
- 1
- RESOLUTION_DUE_DAYS
- 1
- TAX_VALIDATION_TYPE
- SAMPL
- DAYS_BEFORE_DUE_DATE
- 1
- DEAL_DOCS_PURGE_DAYS
- 1
- DFLT_QTY_OVERBILL_RC
- SAMPLE
- WS_FIN_ACC_VALID_URL
- SAMPLE
- WS_FIN_DRILL_FWD_URL
- SAMPLE
- DEBIT_MEMO_PREFIX_TAX
- SAMPLE
- DFLT_COST_OVERBILL_RC
- SAMPLE
- DFLT_QTY_UNDERBILL_RC
- SAMPLE
- WS_FIN_ACC_VALID_CRED
- S
- WS_FIN_DRILL_FWD_CRED
- S
- BATCH_STATUS_HIST_DAYS
- 1
- CALC_EXCHANGE_RATE_VAR
- S
- CREDIT_MEMO_PREFIX_QTY
- SAMPLE
- DFLT_COST_UNDERBILL_RC
- SAMPLE
- DFLT_PAY_NOW_TERMS_RTV
- SAMPLE
- DOCUMENTATION_SUMM_IND
- S
- RECEIPT_WRITE_OFF_DAYS
- 1
- STATUS_DATA_PURGE_DAYS
- 1
- BATCH_THREAD_TIMEOUT_MS
- 1
- CREDIT_MEMO_PREFIX_COST
- SAMPLE
- DEBIT_MEMO_PREFIX_ALLOW
- SAMPLE
- DFLT_NON_MERCH_LOCATION
- 1
- TAX_RESOLUTION_DUE_DAYS
- 1
- THIRD_PARTY_PAYEE_ALLOW
- S
- CREDIT_MEMO_PREFIX_ALLOW
- SAMPLE
- DFLT_PAY_NOW_TERMS_DEALS
- SAMPLE
- MATCH_INQUIRY_SEARCH_MAX
- 1
- PRORATE_ACROSS_TAX_CODES
- S
- DELAY_LN_MTCH_UNTL_ROUTE_
- 2026-01-01
- INJECTOR_STAGED_HIST_DAYS
- 1
- POST_INTRA_REGION_TAX_IND
- S
- TAX_DOCUMENT_CREATION_LVL
- SAMPLE
- CREDIT_NOTE_REQ_PREFIX_QTY
- SAMPLE
- CREDIT_NOTE_REQ_PREFIX_TAX
- SAMPLE
- ALWAYS_USE_PO_EXCHANGE_RATE
- S
- CREDIT_NOTE_REQ_PREFIX_COST
- SAMPLE
- EXCL_PRFX_ON_EXTL_SRCD_DOCS
- S
- EXTERNAL_ACCOUNT_VALIDATION
- S
- CREDIT_NOTE_REQ_PREFIX_ALLOW
- SAMPLE
- INCL_DOC_DATE_FOR_DUPL_CHECK
- S
- INCL_DOC_YEAR_FOR_DUPL_CHECK
- S
- DELAY_LN_MTCH_UNTL_ROUTE_DATE
- S
- USE_INV_RCV_DT_TO_CALC_DUE_DT
- S
default
- DOC_HIST_DAYSR
- non
- DEBIT_MEMO_SEND_DAYSR
- non
- DEBIT_MEMO_PREFIX_QTYR
- IM System Options-002-ALT
- DEBIT_MEMO_PREFIX_COSTR
- IM System Options-002-ALT
- CLOSE_OPEN_RECEIPT_DAYSR
- non
- DFLT_SOB
- 3
- DFLT_DEPT
- 1003
- CREATED_BY
- APP_USER_ID
- DFLT_CLASS
- 1103
- CREATION_DATE
- 2026-01-03
- NUM_TAX_ALLOW
- S
- OBIEE_ENABLED
- N
- CALC_TOLERANCE
- 12.5000
- CNT_TOMOR_CRIT
- 3
- CNT_TOMOR_WARN
- 3
- CNT_TOTAL_CRIT
- 3
- CNT_TOTAL_WARN
- 3
- LUW_AUTO_MATCH
- 3
- S9T_PURGE_DAYS
- 3
- ALLOWANCE_MATCH
- N
- DFLT_HEADER_TAX
- I
- GL_MAX_SEGMENTS
- 3
- LAST_UPDATED_BY
- APP_USER_ID
- LUW_FDG_EXTRACT
- 3
- DOC_QTY_DECIMALS
- 3
- LAST_UPDATE_DATE
- 2026-01-03
- LUW_EDI_INJECTOR
- 3
- BATCH_DATE_FORMAT
- yyyyMMddHHmmss
- CNT_PAST_DUE_CRIT
- 3
- CNT_PAST_DUE_WARN
- 3
- MAX_TOLERANCE_PCT
- 12.5000
- OBJECT_VERSION_ID
- 1000000003
- CALC_TOLERANCE_IND
- A
- CNT_2DAYS_OUT_CRIT
- 3
- CNT_2DAYS_OUT_WARN
- 3
- CNT_3DAYS_OUT_CRIT
- 3
- CNT_3DAYS_OUT_WARN
- 3
- POST_ON_DOC_HEADER
- N
- TOTAL_QTY_REQUIRED
- N
- USE_SUFFIX_ON_DOCS
- N
- BALANCING_TOLERANCE
- 1.0000
- DOCUMENT_SEARCH_MAX
- 3
- EDI_DATA_PURGE_DAYS
- 3
- POST_DATED_DOC_DAYS
- 3
- RESOLUTION_DUE_DAYS
- 3
- TAX_VALIDATION_TYPE
- RECON
- DAYS_BEFORE_DUE_DATE
- 3
- DEAL_DOCS_PURGE_DAYS
- 3
- DFLT_QTY_OVERBILL_RC
- IM System Options-00
- WS_FIN_ACC_VALID_URL
- IM System Options-002-ALT
- WS_FIN_DRILL_FWD_URL
- IM System Options-002-ALT
- DEBIT_MEMO_PREFIX_TAX
- IM System Options-002-ALT
- DFLT_COST_OVERBILL_RC
- IM System Options-00
- DFLT_QTY_UNDERBILL_RC
- IM System Options-00
- WS_FIN_ACC_VALID_CRED
- I
- WS_FIN_DRILL_FWD_CRED
- I
- BATCH_STATUS_HIST_DAYS
- —
- CALC_EXCHANGE_RATE_VAR
- N
- CREDIT_MEMO_PREFIX_QTY
- IM System Options-002-ALT
- DFLT_COST_UNDERBILL_RC
- IM System Options-00
- DFLT_PAY_NOW_TERMS_RTV
- IM System Optio
- DOCUMENTATION_SUMM_IND
- N
- RECEIPT_WRITE_OFF_DAYS
- 3
- STATUS_DATA_PURGE_DAYS
- 3
- BATCH_THREAD_TIMEOUT_MS
- 3
- CREDIT_MEMO_PREFIX_COST
- IM System Options-002-ALT
- DEBIT_MEMO_PREFIX_ALLOW
- DMA
- DFLT_NON_MERCH_LOCATION
- 3
- TAX_RESOLUTION_DUE_DAYS
- non
- THIRD_PARTY_PAYEE_ALLOW
- N
- CREDIT_MEMO_PREFIX_ALLOW
- CMA
- DFLT_PAY_NOW_TERMS_DEALS
- IM System Optio
- MATCH_INQUIRY_SEARCH_MAX
- 3
- PRORATE_ACROSS_TAX_CODES
- N
- DELAY_LN_MTCH_UNTL_ROUTE_
- Y
- INJECTOR_STAGED_HIST_DAYS
- —
- POST_INTRA_REGION_TAX_IND
- N
- TAX_DOCUMENT_CREATION_LVL
- ITEM
- CREDIT_NOTE_REQ_PREFIX_QTY
- IM System Options-002-ALT
- CREDIT_NOTE_REQ_PREFIX_TAX
- IM System Options-002-ALT
- ALWAYS_USE_PO_EXCHANGE_RATE
- Y
- CREDIT_NOTE_REQ_PREFIX_COST
- IM System Options-002-ALT
- EXCL_PRFX_ON_EXTL_SRCD_DOCS
- N
- EXTERNAL_ACCOUNT_VALIDATION
- N
- CREDIT_NOTE_REQ_PREFIX_ALLOW
- CNA
- INCL_DOC_DATE_FOR_DUPL_CHECK
- N
- INCL_DOC_YEAR_FOR_DUPL_CHECK
- N
- DELAY_LN_MTCH_UNTL_ROUTE_DATE
- —
- USE_INV_RCV_DT_TO_CALC_DUE_DT
- N
default
- DOC_HIST_DAYSR
- non
- DEBIT_MEMO_SEND_DAYSR
- non
- DEBIT_MEMO_PREFIX_QTYR
- IM System Options-003-EDGE
- DEBIT_MEMO_PREFIX_COSTR
- IM System Options-003-EDGE
- CLOSE_OPEN_RECEIPT_DAYSR
- non
- DFLT_SOB
- 5
- DFLT_DEPT
- 1005
- CREATED_BY
- USERENV
- DFLT_CLASS
- 1105
- CREATION_DATE
- 2026-01-05
- NUM_TAX_ALLOW
- S
- OBIEE_ENABLED
- N
- CALC_TOLERANCE
- 14.0000
- CNT_TOMOR_CRIT
- 5
- CNT_TOMOR_WARN
- 5
- CNT_TOTAL_CRIT
- 5
- CNT_TOTAL_WARN
- 5
- LUW_AUTO_MATCH
- 5
- S9T_PURGE_DAYS
- 5
- ALLOWANCE_MATCH
- N
- DFLT_HEADER_TAX
- I
- GL_MAX_SEGMENTS
- 5
- LAST_UPDATED_BY
- USERENV
- LUW_FDG_EXTRACT
- 5
- DOC_QTY_DECIMALS
- 5
- LAST_UPDATE_DATE
- 2026-01-05
- LUW_EDI_INJECTOR
- 5
- BATCH_DATE_FORMAT
- yyyyMMddHHmmss
- CNT_PAST_DUE_CRIT
- 5
- CNT_PAST_DUE_WARN
- 5
- MAX_TOLERANCE_PCT
- 14.0000
- OBJECT_VERSION_ID
- 1000000005
- CALC_TOLERANCE_IND
- A
- CNT_2DAYS_OUT_CRIT
- 5
- CNT_2DAYS_OUT_WARN
- 5
- CNT_3DAYS_OUT_CRIT
- 5
- CNT_3DAYS_OUT_WARN
- 5
- POST_ON_DOC_HEADER
- N
- TOTAL_QTY_REQUIRED
- N
- USE_SUFFIX_ON_DOCS
- N
- BALANCING_TOLERANCE
- 1.0000
- DOCUMENT_SEARCH_MAX
- 5
- EDI_DATA_PURGE_DAYS
- 5
- POST_DATED_DOC_DAYS
- 5
- RESOLUTION_DUE_DAYS
- 5
- TAX_VALIDATION_TYPE
- RECON
- DAYS_BEFORE_DUE_DATE
- 5
- DEAL_DOCS_PURGE_DAYS
- 5
- DFLT_QTY_OVERBILL_RC
- IM System Options-00
- WS_FIN_ACC_VALID_URL
- IM System Options-003-EDGE
- WS_FIN_DRILL_FWD_URL
- IM System Options-003-EDGE
- DEBIT_MEMO_PREFIX_TAX
- IM System Options-003-EDGE
- DFLT_COST_OVERBILL_RC
- IM System Options-00
- DFLT_QTY_UNDERBILL_RC
- IM System Options-00
- WS_FIN_ACC_VALID_CRED
- I
- WS_FIN_DRILL_FWD_CRED
- I
- BATCH_STATUS_HIST_DAYS
- —
- CALC_EXCHANGE_RATE_VAR
- N
- CREDIT_MEMO_PREFIX_QTY
- IM System Options-003-EDGE
- DFLT_COST_UNDERBILL_RC
- IM System Options-00
- DFLT_PAY_NOW_TERMS_RTV
- IM System Optio
- DOCUMENTATION_SUMM_IND
- N
- RECEIPT_WRITE_OFF_DAYS
- 5
- STATUS_DATA_PURGE_DAYS
- 5
- BATCH_THREAD_TIMEOUT_MS
- 5
- CREDIT_MEMO_PREFIX_COST
- IM System Options-003-EDGE
- DEBIT_MEMO_PREFIX_ALLOW
- DMA
- DFLT_NON_MERCH_LOCATION
- 5
- TAX_RESOLUTION_DUE_DAYS
- non
- THIRD_PARTY_PAYEE_ALLOW
- N
- CREDIT_MEMO_PREFIX_ALLOW
- CMA
- DFLT_PAY_NOW_TERMS_DEALS
- IM System Optio
- MATCH_INQUIRY_SEARCH_MAX
- 5
- PRORATE_ACROSS_TAX_CODES
- N
- DELAY_LN_MTCH_UNTL_ROUTE_
- Y
- INJECTOR_STAGED_HIST_DAYS
- —
- POST_INTRA_REGION_TAX_IND
- N
- TAX_DOCUMENT_CREATION_LVL
- ITEM
- CREDIT_NOTE_REQ_PREFIX_QTY
- IM System Options-003-EDGE
- CREDIT_NOTE_REQ_PREFIX_TAX
- IM System Options-003-EDGE
- ALWAYS_USE_PO_EXCHANGE_RATE
- Y
- CREDIT_NOTE_REQ_PREFIX_COST
- IM System Options-003-EDGE
- EXCL_PRFX_ON_EXTL_SRCD_DOCS
- N
- EXTERNAL_ACCOUNT_VALIDATION
- N
- CREDIT_NOTE_REQ_PREFIX_ALLOW
- CNA
- INCL_DOC_DATE_FOR_DUPL_CHECK
- N
- INCL_DOC_YEAR_FOR_DUPL_CHECK
- N
- DELAY_LN_MTCH_UNTL_ROUTE_DATE
- —
- USE_INV_RCV_DT_TO_CALC_DUE_DT
- N
Rule Validation Summary
- Source Rule Count
- 249
- Governed Rule Count
- 177