Batch Error

In Scope

Technical: BATCH_ERROR | ID: OR-PRC-BATCH_ERROR-BATCH_ERROR

Stores one row each error that occurs during the running of the Oracle Retail batch programs. The information written to this table is used to report on what type of...

See how this object fits into Pricing & Promotions

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: BATCH_ERROR

Field Definitions(5)

Rules & Considerations(14)

validation

constraint

Sample Load Data(4)

_scenario	PROGRAMR	ERR_DATER	ERR_TYPER	FUNCTIONR	ERR_MSG	ERR_CODE	ERR_DATA	TABLE_NAME
Example values from field definitions	SAMPLE	2026-01-01	S	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE
default	Batch Error-002-ALT	2026-01-03	B	Batch Error-002-ALT	Batch Error-002-ALT	ALT-BATCH_ERRO-002	Batch Error-002-ALT	Batch Error Secondary
default	Batch Error-003-EDGE	2026-01-05	B	Batch Error-003-EDGE	Batch Error-003-EDGE	EDGE-BATCH_ERRO-003	Batch Error-003-EDGE	Batch Error Core

Example values from field definitions

PROGRAMR: SAMPLE
ERR_DATER: 2026-01-01
ERR_TYPER: S
FUNCTIONR: SAMPLE
ERR_MSG: SAMPLE
ERR_CODE: SAMPLE
ERR_DATA: SAMPLE
TABLE_NAME: SAMPLE

default

PROGRAMR: Batch Error-002-ALT
ERR_DATER: 2026-01-03
ERR_TYPER: B
FUNCTIONR: Batch Error-002-ALT
ERR_MSG: Batch Error-002-ALT
ERR_CODE: ALT-BATCH_ERRO-002
ERR_DATA: Batch Error-002-ALT
TABLE_NAME: Batch Error Secondary