IM Posting Status

In Scope

Technical: IM_POSTING_STATUS | ID: OR-IM-IM_POSTING_STATUS-IM_POSTING_STATUS

Stores invoice matching data for IM posting status in Oracle Retail Invoice Matching. Used to support operational processing, integration, and reporting within the Oracle Retail application landscape.

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_POSTING_STATUS

Field Definitions(5)

Rules & Considerations(14)

validation

constraint

Sample Load Data(4)

_scenario	POSTING_IDRPK	STATUS	END_DATE	CREATED_BY	HAS_ERRORS	START_DATE	DESCRIPTION	CREATION_DATE	LAST_UPDATED_BY	LAST_UPDATE_DATE	OBJECT_VERSION_ID
Example values from field definitions	1	S	2026-01-01	SAMPLE	S	2026-01-01	SAMPLE	2026-01-01	SAMPLE	2026-01-01	1
default	1000000003	N	2026-01-03	APP_USER_ID	N	2026-01-03	IM Posting Status-002-ALT	2026-01-03	APP_USER_ID	2026-01-03	1000000003
default	1000000005	N	2026-01-05	USERENV	N	2026-01-05	—	2026-01-05	USERENV	2026-01-05	1000000005

Example values from field definitions

POSTING_IDRPK: 1
STATUS: S
END_DATE: 2026-01-01
CREATED_BY: SAMPLE
HAS_ERRORS: S
START_DATE: 2026-01-01
DESCRIPTION: SAMPLE
CREATION_DATE: 2026-01-01
LAST_UPDATED_BY: SAMPLE
LAST_UPDATE_DATE: 2026-01-01
OBJECT_VERSION_ID: 1

default

POSTING_IDRPK: 1000000003
STATUS: N
END_DATE: 2026-01-03
CREATED_BY: APP_USER_ID
HAS_ERRORS: N
START_DATE: 2026-01-03
DESCRIPTION: IM Posting Status-002-ALT
CREATION_DATE: 2026-01-03
LAST_UPDATED_BY: APP_USER_ID
LAST_UPDATE_DATE: 2026-01-03
OBJECT_VERSION_ID: 1000000003