IM Ap Stage Header Error

In Scope

Technical: IM_AP_STAGE_HEAD_ERROR | ID: OR-IM-IM_AP_STAGE_HEAD_ERROR-IM_AP_STAGE_HEADER_ERROR

Invoice Matching AP staging headers for supplier invoice documents posted to Oracle Financials, including supplier, vendor site, currency, and exchange-rate details that failed posting and were retained for error handling.

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_AP_STAGE_HEAD_ERROR

Field Definitions(5)

Sample Load Data(4)

_scenario	DOC_IDR	SEQ_NORPK	VENDORR	INVC_TYPE_LOOKUP_CODER	AMOUNT	DEAL_ID	DSD_IND	DOC_DATE	LOCATION	LOC_NAME	LOC_TYPE	ORDER_NO	ORG_UNIT	SEGMENT1	SEGMENT2	SEGMENT3	SEGMENT4	SEGMENT5	SEGMENT6	SEGMENT7	SEGMENT8	SEGMENT9	DEAL_TYPE	FISCAL_ID	SEGMENT10	SEGMENT11	SEGMENT12	SEGMENT13	SEGMENT14	SEGMENT15	SEGMENT16	SEGMENT17	SEGMENT18	SEGMENT19	SEGMENT20	BEST_TERMS	MATCH_DATE	POSTING_ID	DOC_SEQ_NUM	LEGAL_ENTITY	REFERENCE_ID	RTV_ORDER_NO	APPROVAL_DATE	CURRENCY_CODE	EXCHANGE_RATE	DEAL_DETAIL_ID	DOC_SEQ_PREFIX	INVOICE_NUMBER	ORACLE_SITE_ID	BEST_TERMS_DATE	CONSIGNMENT_IND	ODI_SESSION_NUM	SET_OF_BOOKS_ID	CREATE_DATE_TIME	CUSTOM_DOC_REF_1	CUSTOM_DOC_REF_2	CUSTOM_DOC_REF_3	CUSTOM_DOC_REF_4	THIRD_PARTY_PAYEE	ATTACHMENT_EXT_URL	EXCHANGE_RATE_TYPE	ADDITIONAL_ORDER_NOS	INVOICE_RECEIVED_DATE
Example values from field definitions	1	1	SAMPLE	SAMPLE	1.0000	1	S	2026-01-01	1	SAMPLE	S	1	1	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	S	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	2026-01-01	1	1	SAMPLE	SAMPLE	1	2026-01-01	SAM	1.0000000000	1	SAMPLE	SAMPLE	1	2026-01-01	S	1	1	2026-01-01	SAMPLE	SAMPLE	SAMPLE	SAMPLE	1	SAMPLE	SAMPLE	SAMPLE	2026-01-01
default	1000000003	4	IM Ap Stag	ALT-IM_AP-002	12.5000	1000000003	I	2026-01-03	3	IM Ap Stage Head Error Secondary	I	4	3	IM Ap Stage Head Error-00	IM Ap Stage Head Error-00	IM Ap Stage Head Error-00	IM Ap Stage Head Error-00	IM Ap Stage Head Error-00	IM Ap Stage Head Error-00	IM Ap Stage Head Error-00	IM Ap Stage Head Error-00	IM Ap Stage Head Error-00	I	ALT-IM_AP-002	IM Ap Stage Head Error-00	IM Ap Stage Head Error-00	IM Ap Stage Head Error-00	IM Ap Stage Head Error-00	IM Ap Stage Head Error-00	IM Ap Stage Head Error-00	IM Ap Stage Head Error-00	IM Ap Stage Head Error-00	IM Ap Stage Head Error-00	IM Ap Stage Head Error-00	IM Ap Stage Head Error-00	IM Ap Stage Hea	2026-01-03	1000000003	4	IM Ap Stage Head Error-002-ALT	ALT-IM_AP-002	4	2026-01-03	ALT	12.5000000000	1000000003	IM Ap Stage Head Error-002-ALT	IM Ap Stage Head Error-002-ALT	1000000003	2026-01-03	I	4	1000000003	2026-01-03	IM Ap Stage Head Error-002-ALT	IM Ap Stage Head Error-002-ALT	IM Ap Stage Head Error-002-ALT	IM Ap Stage Head Error-002-ALT	3	IM Ap Stage Head Error-002-ALT	IM Ap Stage Head Error-002-ALT	IM Ap Stage Head Error-002-ALT	2026-01-03
default	1000000005	6	IM Ap Stag	EDGE-IM_AP-003	14.0000	1000000005	I	2026-01-05	5	IM Ap Stage Head Error Core	I	6	5	IM Ap Stage Head Error-00	IM Ap Stage Head Error-00	IM Ap Stage Head Error-00	IM Ap Stage Head Error-00	IM Ap Stage Head Error-00	IM Ap Stage Head Error-00	IM Ap Stage Head Error-00	IM Ap Stage Head Error-00	IM Ap Stage Head Error-00	I	EDGE-IM_AP-003	IM Ap Stage Head Error-00	IM Ap Stage Head Error-00	IM Ap Stage Head Error-00	IM Ap Stage Head Error-00	IM Ap Stage Head Error-00	IM Ap Stage Head Error-00	IM Ap Stage Head Error-00	IM Ap Stage Head Error-00	IM Ap Stage Head Error-00	IM Ap Stage Head Error-00	IM Ap Stage Head Error-00	IM Ap Stage Hea	2026-01-05	1000000005	6	IM Ap Stage Head Error-003-EDGE	—	6	2026-01-05	EDG	14.0000000000	1000000005	IM Ap Stage Head Error-003-EDGE	IM Ap Stage Head Error-003-EDGE	1000000005	2026-01-05	I	6	1000000005	2026-01-05	IM Ap Stage Head Error-003-EDGE	IM Ap Stage Head Error-003-EDGE	IM Ap Stage Head Error-003-EDGE	IM Ap Stage Head Error-003-EDGE	5	IM Ap Stage Head Error-003-EDGE	IM Ap Stage Head Error-003-EDG	IM Ap Stage Head Error-003-EDGE	2026-01-05

Example values from field definitions

DOC_IDR: 1
SEQ_NORPK: 1
VENDORR: SAMPLE
INVC_TYPE_LOOKUP_CODER: SAMPLE
AMOUNT: 1.0000
DEAL_ID: 1
DSD_IND: S
DOC_DATE: 2026-01-01
LOCATION: 1
LOC_NAME: SAMPLE
LOC_TYPE: S
ORDER_NO: 1
ORG_UNIT: 1
SEGMENT1: SAMPLE
SEGMENT2: SAMPLE
SEGMENT3: SAMPLE
SEGMENT4: SAMPLE
SEGMENT5: SAMPLE
SEGMENT6: SAMPLE
SEGMENT7: SAMPLE
SEGMENT8: SAMPLE
SEGMENT9: SAMPLE
DEAL_TYPE: S
FISCAL_ID: SAMPLE
SEGMENT10: SAMPLE
SEGMENT11: SAMPLE
SEGMENT12: SAMPLE
SEGMENT13: SAMPLE
SEGMENT14: SAMPLE
SEGMENT15: SAMPLE
SEGMENT16: SAMPLE
SEGMENT17: SAMPLE
SEGMENT18: SAMPLE
SEGMENT19: SAMPLE
SEGMENT20: SAMPLE
BEST_TERMS: SAMPLE
MATCH_DATE: 2026-01-01
POSTING_ID: 1
DOC_SEQ_NUM: 1
LEGAL_ENTITY: SAMPLE
REFERENCE_ID: SAMPLE
RTV_ORDER_NO: 1
APPROVAL_DATE: 2026-01-01
CURRENCY_CODE: SAM
EXCHANGE_RATE: 1.0000000000
DEAL_DETAIL_ID: 1
DOC_SEQ_PREFIX: SAMPLE
INVOICE_NUMBER: SAMPLE
ORACLE_SITE_ID: 1
BEST_TERMS_DATE: 2026-01-01
CONSIGNMENT_IND: S
ODI_SESSION_NUM: 1
SET_OF_BOOKS_ID: 1
CREATE_DATE_TIME: 2026-01-01
CUSTOM_DOC_REF_1: SAMPLE
CUSTOM_DOC_REF_2: SAMPLE
CUSTOM_DOC_REF_3: SAMPLE
CUSTOM_DOC_REF_4: SAMPLE
THIRD_PARTY_PAYEE: 1
ATTACHMENT_EXT_URL: SAMPLE
EXCHANGE_RATE_TYPE: SAMPLE
ADDITIONAL_ORDER_NOS: SAMPLE
INVOICE_RECEIVED_DATE: 2026-01-01

default

DOC_IDR: 1000000003
SEQ_NORPK: 4
VENDORR: IM Ap Stag
INVC_TYPE_LOOKUP_CODER: ALT-IM_AP-002
AMOUNT: 12.5000
DEAL_ID: 1000000003
DSD_IND: I
DOC_DATE: 2026-01-03
LOCATION: 3
LOC_NAME: IM Ap Stage Head Error Secondary
LOC_TYPE: I
ORDER_NO: 4
ORG_UNIT: 3
SEGMENT1: IM Ap Stage Head Error-00
SEGMENT2: IM Ap Stage Head Error-00
SEGMENT3: IM Ap Stage Head Error-00
SEGMENT4: IM Ap Stage Head Error-00
SEGMENT5: IM Ap Stage Head Error-00
SEGMENT6: IM Ap Stage Head Error-00
SEGMENT7: IM Ap Stage Head Error-00
SEGMENT8: IM Ap Stage Head Error-00
SEGMENT9: IM Ap Stage Head Error-00
DEAL_TYPE: I
FISCAL_ID: ALT-IM_AP-002
SEGMENT10: IM Ap Stage Head Error-00
SEGMENT11: IM Ap Stage Head Error-00
SEGMENT12: IM Ap Stage Head Error-00
SEGMENT13: IM Ap Stage Head Error-00
SEGMENT14: IM Ap Stage Head Error-00
SEGMENT15: IM Ap Stage Head Error-00
SEGMENT16: IM Ap Stage Head Error-00
SEGMENT17: IM Ap Stage Head Error-00
SEGMENT18: IM Ap Stage Head Error-00
SEGMENT19: IM Ap Stage Head Error-00
SEGMENT20: IM Ap Stage Head Error-00
BEST_TERMS: IM Ap Stage Hea
MATCH_DATE: 2026-01-03
POSTING_ID: 1000000003
DOC_SEQ_NUM: 4
LEGAL_ENTITY: IM Ap Stage Head Error-002-ALT
REFERENCE_ID: ALT-IM_AP-002
RTV_ORDER_NO: 4
APPROVAL_DATE: 2026-01-03
CURRENCY_CODE: ALT
EXCHANGE_RATE: 12.5000000000
DEAL_DETAIL_ID: 1000000003
DOC_SEQ_PREFIX: IM Ap Stage Head Error-002-ALT
INVOICE_NUMBER: IM Ap Stage Head Error-002-ALT
ORACLE_SITE_ID: 1000000003
BEST_TERMS_DATE: 2026-01-03
CONSIGNMENT_IND: I
ODI_SESSION_NUM: 4
SET_OF_BOOKS_ID: 1000000003
CREATE_DATE_TIME: 2026-01-03
CUSTOM_DOC_REF_1: IM Ap Stage Head Error-002-ALT
CUSTOM_DOC_REF_2: IM Ap Stage Head Error-002-ALT
CUSTOM_DOC_REF_3: IM Ap Stage Head Error-002-ALT
CUSTOM_DOC_REF_4: IM Ap Stage Head Error-002-ALT
THIRD_PARTY_PAYEE: 3
ATTACHMENT_EXT_URL: IM Ap Stage Head Error-002-ALT
EXCHANGE_RATE_TYPE: IM Ap Stage Head Error-002-ALT
ADDITIONAL_ORDER_NOS: IM Ap Stage Head Error-002-ALT
INVOICE_RECEIVED_DATE: 2026-01-03

default

DOC_IDR: 1000000005
SEQ_NORPK: 6
VENDORR: IM Ap Stag
INVC_TYPE_LOOKUP_CODER: EDGE-IM_AP-003
AMOUNT: 14.0000
DEAL_ID: 1000000005
DSD_IND: I
DOC_DATE: 2026-01-05
LOCATION: 5
LOC_NAME: IM Ap Stage Head Error Core
LOC_TYPE: I
ORDER_NO: 6
ORG_UNIT: 5
SEGMENT1: IM Ap Stage Head Error-00
SEGMENT2: IM Ap Stage Head Error-00
SEGMENT3: IM Ap Stage Head Error-00
SEGMENT4: IM Ap Stage Head Error-00
SEGMENT5: IM Ap Stage Head Error-00
SEGMENT6: IM Ap Stage Head Error-00
SEGMENT7: IM Ap Stage Head Error-00
SEGMENT8: IM Ap Stage Head Error-00
SEGMENT9: IM Ap Stage Head Error-00
DEAL_TYPE: I
FISCAL_ID: EDGE-IM_AP-003
SEGMENT10: IM Ap Stage Head Error-00
SEGMENT11: IM Ap Stage Head Error-00
SEGMENT12: IM Ap Stage Head Error-00
SEGMENT13: IM Ap Stage Head Error-00
SEGMENT14: IM Ap Stage Head Error-00
SEGMENT15: IM Ap Stage Head Error-00
SEGMENT16: IM Ap Stage Head Error-00
SEGMENT17: IM Ap Stage Head Error-00
SEGMENT18: IM Ap Stage Head Error-00
SEGMENT19: IM Ap Stage Head Error-00
SEGMENT20: IM Ap Stage Head Error-00
BEST_TERMS: IM Ap Stage Hea
MATCH_DATE: 2026-01-05
POSTING_ID: 1000000005
DOC_SEQ_NUM: 6
LEGAL_ENTITY: IM Ap Stage Head Error-003-EDGE
REFERENCE_ID: —
RTV_ORDER_NO: 6
APPROVAL_DATE: 2026-01-05
CURRENCY_CODE: EDG
EXCHANGE_RATE: 14.0000000000
DEAL_DETAIL_ID: 1000000005
DOC_SEQ_PREFIX: IM Ap Stage Head Error-003-EDGE
INVOICE_NUMBER: IM Ap Stage Head Error-003-EDGE
ORACLE_SITE_ID: 1000000005
BEST_TERMS_DATE: 2026-01-05
CONSIGNMENT_IND: I
ODI_SESSION_NUM: 6
SET_OF_BOOKS_ID: 1000000005
CREATE_DATE_TIME: 2026-01-05
CUSTOM_DOC_REF_1: IM Ap Stage Head Error-003-EDGE
CUSTOM_DOC_REF_2: IM Ap Stage Head Error-003-EDGE
CUSTOM_DOC_REF_3: IM Ap Stage Head Error-003-EDGE
CUSTOM_DOC_REF_4: IM Ap Stage Head Error-003-EDGE
THIRD_PARTY_PAYEE: 5
ATTACHMENT_EXT_URL: IM Ap Stage Head Error-003-EDGE
EXCHANGE_RATE_TYPE: IM Ap Stage Head Error-003-EDG
ADDITIONAL_ORDER_NOS: IM Ap Stage Head Error-003-EDGE
INVOICE_RECEIVED_DATE: 2026-01-05

Rule Validation Summary

Source Rule Count: 72
Governed Rule Count: 66

All objects