IM Document Header Comments

In Scope

Technical: IM_DOC_HEAD_COMMENTS | ID: OR-IM-IM_DOC_HEAD_COMMENTS-IM_DOCUMENT_HEADER_COMMENTS

Stores free-text comments or annotations associated with IM doc head comments in Oracle Retail Invoice Matching. Used to retain supporting context for review, approval, investigation, or downstream display.

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_DOC_HEAD_COMMENTS

Field Definitions(5)

Rules & Considerations(19)

validation

constraint

Sample Load Data(4)

_scenario	TEXTR	COMMENT_IDRPK	CREATED_BYR	COMMENT_TYPER	CREATION_DATER	DOC_ID	LAST_UPDATED_BY	LAST_UPDATE_DATE	OBJECT_VERSION_ID
Example values from field definitions	SAMPLE	1	SAMPLE	SAMPLE	2026-01-01	1	SAMPLE	2026-01-01	1
default	IM Doc Head Comments-002-ALT	1000000003	APP_USER_ID	IM Doc	2026-01-03	1000000003	APP_USER_ID	2026-01-03	1000000003
default	IM Doc Head Comments-003-EDGE	1000000005	USERENV	IM Doc	2026-01-05	1000000005	USERENV	2026-01-05	1000000005

Example values from field definitions

TEXTR: SAMPLE
COMMENT_IDRPK: 1
CREATED_BYR: SAMPLE
COMMENT_TYPER: SAMPLE
CREATION_DATER: 2026-01-01
DOC_ID: 1
LAST_UPDATED_BY: SAMPLE
LAST_UPDATE_DATE: 2026-01-01
OBJECT_VERSION_ID: 1

default

TEXTR: IM Doc Head Comments-002-ALT
COMMENT_IDRPK: 1000000003
CREATED_BYR: APP_USER_ID
COMMENT_TYPER: IM Doc
CREATION_DATER: 2026-01-03
DOC_ID: 1000000003
LAST_UPDATED_BY: APP_USER_ID
LAST_UPDATE_DATE: 2026-01-03
OBJECT_VERSION_ID: 1000000003