IM Financials Stage Error

In Scope

Technical: IM_FINANCIALS_STAGE_ERROR | ID: OR-IM-IM_FINANCIALS_STAGE_ERROR-IM_FINANCIALS_STAGE_ERROR

Staging table used to load, validate, and track inbound invoice matching data for Oracle Retail Invoice Matching before it is processed into core operational tables. It typically supports interface status,...

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

Object Type: dictionary

Target Structure

Load Approach: Table
Target Objects: IM_FINANCIALS_STAGE_ERROR

Field Definitions(5)

Rules & Considerations(42)

constraint

validation

Sample Load Data(4)

_scenario	SEQ_NORPK	AMOUNT	DOC_ID	VENDOR	DOC_DATE	ORDER_NO	CREATE_ID	SEGMENT_1	SEGMENT_2	SEGMENT_3	SEGMENT_4	SEGMENT_5	SEGMENT_6	SEGMENT_7	SEGMENT_8	SEGMENT_9	TRAN_CODE	BEST_TERMS	RECEIPT_ID	SEGMENT_10	SEGMENT_11	SEGMENT_12	SEGMENT_13	SEGMENT_14	SEGMENT_15	SEGMENT_16	SEGMENT_17	SEGMENT_18	SEGMENT_19	SEGMENT_20	ERR_MESSAGE	VENDOR_TYPE	PRE_PAID_IND	RECEIPT_DATE	CURRENCY_CODE	BEST_TERMS_DATE	CREATE_DATETIME	SET_OF_BOOKS_ID	DEBIT_CREDIT_IND	MANUALLY_PAID_IND	SUPPORT_ERR_MESSAGE
Example values from field definitions	1	1.0000	1	SAMPLE	2026-01-01	1	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	1	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	S	2026-01-01	SAM	2026-01-01	2026-01-01	1	SAMPLE	S	SAMPLE
default	4	12.5000	1000000003	IM Financi	2026-01-03	4	MDM_USER	IM Financials Stage Error	IM Financials Stage Error	IM Financials Stage Error	IM Financials Stage Error	IM Financials Stage Error	IM Financials Stage Error	IM Financials Stage Error	IM Financials Stage Error	IM Financials Stage Error	unr	IM Financials S	1000000003	IM Financials Stage Error	IM Financials Stage Error	IM Financials Stage Error	IM Financials Stage Error	IM Financials Stage Error	IM Financials Stage Error	IM Financials Stage Error	IM Financials Stage Error	IM Financials Stage Error	IM Financials Stage Error	IM Financials Stage Error	IM Financials Stage Error-002-ALT	IM Fin	I	2026-01-03	ALT	2026-01-03	2026-01-03	1000000003	IM Fin	I	IM Financials Stage Error-002-ALT
default	6	14.0000	1000000005	IM Financi	2026-01-05	6	BATCH_USER	IM Financials Stage Error	IM Financials Stage Error	IM Financials Stage Error	IM Financials Stage Error	IM Financials Stage Error	IM Financials Stage Error	IM Financials Stage Error	IM Financials Stage Error	IM Financials Stage Error	vwt	IM Financials S	1000000005	IM Financials Stage Error	IM Financials Stage Error	IM Financials Stage Error	IM Financials Stage Error	IM Financials Stage Error	IM Financials Stage Error	IM Financials Stage Error	IM Financials Stage Error	IM Financials Stage Error	IM Financials Stage Error	IM Financials Stage Error	IM Financials Stage Error-003-EDGE	IM Fin	I	2026-01-05	EDG	2026-01-05	2026-01-05	1000000005	IM Fin	I	IM Financials Stage Error-003-EDGE

Example values from field definitions

SEQ_NORPK: 1
AMOUNT: 1.0000
DOC_ID: 1
VENDOR: SAMPLE
DOC_DATE: 2026-01-01
ORDER_NO: 1
CREATE_ID: SAMPLE
SEGMENT_1: SAMPLE
SEGMENT_2: SAMPLE
SEGMENT_3: SAMPLE
SEGMENT_4: SAMPLE
SEGMENT_5: SAMPLE
SEGMENT_6: SAMPLE
SEGMENT_7: SAMPLE
SEGMENT_8: SAMPLE
SEGMENT_9: SAMPLE
TRAN_CODE: SAMPLE
BEST_TERMS: SAMPLE
RECEIPT_ID: 1
SEGMENT_10: SAMPLE
SEGMENT_11: SAMPLE
SEGMENT_12: SAMPLE
SEGMENT_13: SAMPLE
SEGMENT_14: SAMPLE
SEGMENT_15: SAMPLE
SEGMENT_16: SAMPLE
SEGMENT_17: SAMPLE
SEGMENT_18: SAMPLE
SEGMENT_19: SAMPLE
SEGMENT_20: SAMPLE
ERR_MESSAGE: SAMPLE
VENDOR_TYPE: SAMPLE
PRE_PAID_IND: S
RECEIPT_DATE: 2026-01-01
CURRENCY_CODE: SAM
BEST_TERMS_DATE: 2026-01-01
CREATE_DATETIME: 2026-01-01
SET_OF_BOOKS_ID: 1
DEBIT_CREDIT_IND: SAMPLE
MANUALLY_PAID_IND: S
SUPPORT_ERR_MESSAGE: SAMPLE

default

SEQ_NORPK: 4
AMOUNT: 12.5000
DOC_ID: 1000000003
VENDOR: IM Financi
DOC_DATE: 2026-01-03
ORDER_NO: 4
CREATE_ID: MDM_USER
SEGMENT_1: IM Financials Stage Error
SEGMENT_2: IM Financials Stage Error
SEGMENT_3: IM Financials Stage Error
SEGMENT_4: IM Financials Stage Error
SEGMENT_5: IM Financials Stage Error
SEGMENT_6: IM Financials Stage Error
SEGMENT_7: IM Financials Stage Error
SEGMENT_8: IM Financials Stage Error
SEGMENT_9: IM Financials Stage Error
TRAN_CODE: unr
BEST_TERMS: IM Financials S
RECEIPT_ID: 1000000003
SEGMENT_10: IM Financials Stage Error
SEGMENT_11: IM Financials Stage Error
SEGMENT_12: IM Financials Stage Error
SEGMENT_13: IM Financials Stage Error
SEGMENT_14: IM Financials Stage Error
SEGMENT_15: IM Financials Stage Error
SEGMENT_16: IM Financials Stage Error
SEGMENT_17: IM Financials Stage Error
SEGMENT_18: IM Financials Stage Error
SEGMENT_19: IM Financials Stage Error
SEGMENT_20: IM Financials Stage Error
ERR_MESSAGE: IM Financials Stage Error-002-ALT
VENDOR_TYPE: IM Fin
PRE_PAID_IND: I
RECEIPT_DATE: 2026-01-03
CURRENCY_CODE: ALT
BEST_TERMS_DATE: 2026-01-03
CREATE_DATETIME: 2026-01-03
SET_OF_BOOKS_ID: 1000000003
DEBIT_CREDIT_IND: IM Fin
MANUALLY_PAID_IND: I
SUPPORT_ERR_MESSAGE: IM Financials Stage Error-002-ALT