Search Results ozf_resale_batch_line_maps_all

Overview

OZF_RESALE_BATCH_LINE_MAPS_ALL is a Trade Management (OZF) transactional table within the Oracle E-Business Suite 12.1.1 and 12.2.2 data model. Its documented purpose is to store the mappings between a resale batch header and the individual resale order lines that were submitted together with that batch. In effect, it functions as a resolution table that links one batch record to one or more resale lines, enabling downstream processing, reconciliation, and reporting of batch submissions at line-level granularity.

From a heuristic Data Vault modeling perspective, the FK structure supplied in the ETRM metadata suggests this object is best classified as a link table. It carries no descriptive payload columns beyond the standard who-columns and a small set of descriptive flexfield attributes, and its principal identity is a surrogate key resolving the relationship between two business entities. The "ALL" suffix denotes an org-striped table; the presence of ORG_ID alongside SECURITY_GROUP_ID indicates that multi-org and multi-tenant access controls are applied at row level.

Key Information Stored

RESALE_BATCH_LINE_MAP_ID — Surrogate primary key. It is the single column of the OZF_RESALE_BATCH_LINE_MAPS_PK constraint and is also defined as the unique index OZF_RESALE_LINE_MAPS_ALL_U1, making it the documented business-key candidate.
RESALE_BATCH_ID — Foreign key referencing OZF_RESALE_BATCHES_ALL. Identifies the batch header to which the line belongs.
RESALE_LINE_ID — Foreign key referencing OZF_RESALE_LINES_ALL. Identifies the resale order line mapped to the batch.
ORG_ID — Operating unit identifier supporting multi-org partitioning of the mapping rows.
SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, used for data security and access isolation.
OBJECT_VERSION_NUMBER — Optimistic locking column used by the Trade Management framework to detect concurrent updates.
CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — Standard audit columns recording who created and last modified the mapping and when.
REQUEST_ID, PROGRAM_ID, PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE — Concurrent program context columns that capture the batch process which inserted or refreshed the mapping.
LAST_UPDATE_LOGIN — Login of the user performing the most recent update.
CREATED_FROM — Indicates the source mechanism (for example, a given process or UI path) that created the mapping record.
ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — Descriptive flexfield columns reserved for customer-specific extensions.

Common Use Cases and Queries

The most frequent use of this table is to answer the question "which resale lines were included in a given batch?" and its converse "which batch processed a given resale line?". A typical reporting query joins the mapping to both parents:

Batch-to-line explosion: SELECT m.RESALE_BATCH_ID, m.RESALE_LINE_ID FROM OZF_RESALE_BATCH_LINE_MAPS_ALL m WHERE m.RESALE_BATCH_ID = :batch_id.
Line-to-batch lookup: filter on RESALE_LINE_ID to determine the governing batch, useful when reconciling resale accruals or claims back to a submission run.
Financial reconciliation: joining to OZF_RESALE_LINES_ALL and the batch header to compare expected versus submitted line amounts per operating unit, filtered on ORG_ID.
Audit and troubleshooting: filtering on REQUEST_ID or PROGRAM_ID to trace which concurrent program created or refreshed a mapping set, and reviewing CREATED_BY / LAST_UPDATED_BY for change history.
Data security verification: joining to FND_SECURITY_GROUPS via SECURITY_GROUP_ID to confirm rows are visible only to authorized responsibility or security profiles.

Related Objects

OZF_RESALE_BATCHES_ALL — Parent batch header table; joined on RESALE_BATCH_ID = OZF_RESALE_BATCHES_ALL.RESALE_BATCH_ID.
OZF_RESALE_LINES_ALL — Parent resale line table; joined on RESALE_LINE_ID = OZF_RESALE_LINES_ALL.RESALE_LINE_ID.
FND_SECURITY_GROUPS — Referenced by SECURITY_GROUP_ID for row-level security.
OZF_RESALE_BATCH_LINE_MAPS_PK — Primary key constraint on RESALE_BATCH_LINE_MAP_ID.
OZF_RESALE_LINE_MAPS_ALL_U1 — Unique index supporting the surrogate key.

Table: OZF_RESALE_BATCH_LINE_MAPS_ALL 12.2.2
owner:OZF, object_type:TABLE, fnd_design_data:OZF.OZF_RESALE_BATCH_LINE_MAPS_ALL, object_name:OZF_RESALE_BATCH_LINE_MAPS_ALL, status:VALID, product: OZF - Trade Management , description: This table contains the mappings between the batch header and the resale order lines that were submitted along with that batch , implementation_dba_data: OZF.OZF_RESALE_BATCH_LINE_MAPS_ALL ,
Table: OZF_RESALE_BATCH_LINE_MAPS_ALL 12.1.1
owner:OZF, object_type:TABLE, fnd_design_data:OZF.OZF_RESALE_BATCH_LINE_MAPS_ALL, object_name:OZF_RESALE_BATCH_LINE_MAPS_ALL, status:VALID, product: OZF - Trade Management , description: This table contains the mappings between the batch header and the resale order lines that were submitted along with that batch , implementation_dba_data: OZF.OZF_RESALE_BATCH_LINE_MAPS_ALL ,
SYNONYM: APPS.OZF_RESALE_BATCH_LINE_MAPS_ALL 12.1.1
owner:APPS, object_type:SYNONYM, object_name:OZF_RESALE_BATCH_LINE_MAPS_ALL, status:VALID,
VIEW: OZF.OZF_RESALE_BATCH_LINE_MAPS_AL# 12.2.2
VIEW: OZF.OZF_RESALE_BATCH_LINE_MAPS_AL# 12.2.2
owner:OZF, object_type:VIEW, object_name:OZF_RESALE_BATCH_LINE_MAPS_AL#, status:VALID,
TABLE: OZF.OZF_RESALE_BATCH_LINE_MAPS_ALL 12.1.1
owner:OZF, object_type:TABLE, fnd_design_data:OZF.OZF_RESALE_BATCH_LINE_MAPS_ALL, object_name:OZF_RESALE_BATCH_LINE_MAPS_ALL, status:VALID,
APPS.OZF_RESALE_BATCH_LINE_MAPS_PKG SQL Statements 12.1.1
Table: OZF_RESALE_LINES_ALL 12.1.1
owner:OZF, object_type:TABLE, fnd_design_data:OZF.OZF_RESALE_LINES_ALL, object_name:OZF_RESALE_LINES_ALL, status:VALID, product: OZF - Trade Management , description: Chargeback Lines information , implementation_dba_data: OZF.OZF_RESALE_LINES_ALL ,
Table: OZF_RESALE_BATCHES_ALL 12.1.1
owner:OZF, object_type:TABLE, fnd_design_data:OZF.OZF_RESALE_BATCHES_ALL, object_name:OZF_RESALE_BATCHES_ALL, status:VALID, product: OZF - Trade Management , description: This table stores the batches for Resale , implementation_dba_data: OZF.OZF_RESALE_BATCHES_ALL ,
APPS.OZF_RESALE_BATCH_LINE_MAPS_PKG SQL Statements 12.2.2
Table: OZF_RESALE_LINES_ALL 12.2.2
owner:OZF, object_type:TABLE, fnd_design_data:OZF.OZF_RESALE_LINES_ALL, object_name:OZF_RESALE_LINES_ALL, status:VALID, product: OZF - Trade Management , description: Chargeback Lines information , implementation_dba_data: OZF.OZF_RESALE_LINES_ALL ,
Table: OZF_RESALE_BATCHES_ALL 12.2.2
owner:OZF, object_type:TABLE, fnd_design_data:OZF.OZF_RESALE_BATCHES_ALL, object_name:OZF_RESALE_BATCHES_ALL, status:VALID, product: OZF - Trade Management , description: This table stores the batches for Resale , implementation_dba_data: OZF.OZF_RESALE_BATCHES_ALL ,
SYNONYM: APPS.OZF_RESALE_BATCH_LINE_MAPS 12.1.1
owner:APPS, object_type:SYNONYM, object_name:OZF_RESALE_BATCH_LINE_MAPS, status:VALID,
SYNONYM: APPS.OZF_RESALE_BATCH_LINE_MAPS_ALL 12.2.2
owner:APPS, object_type:SYNONYM, object_name:OZF_RESALE_BATCH_LINE_MAPS_ALL, status:VALID,
PACKAGE BODY: APPS.OZF_RESALE_BATCH_LINE_MAPS_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OZF_RESALE_BATCH_LINE_MAPS_PKG, status:VALID,
PACKAGE BODY: APPS.OZF_RESALE_BATCH_LINE_MAPS_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OZF_RESALE_BATCH_LINE_MAPS_PKG, status:VALID,
TABLE: OZF.OZF_RESALE_BATCH_LINE_MAPS_ALL 12.2.2
owner:OZF, object_type:TABLE, fnd_design_data:OZF.OZF_RESALE_BATCH_LINE_MAPS_ALL, object_name:OZF_RESALE_BATCH_LINE_MAPS_ALL, status:VALID,
PACKAGE BODY: APPS.OZF_RESALE_PUB 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OZF_RESALE_PUB, status:VALID,
PACKAGE BODY: APPS.OZF_QP_QUAL_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OZF_QP_QUAL_PVT, status:VALID,
PACKAGE BODY: APPS.OZF_TP_ACCRUAL_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OZF_TP_ACCRUAL_PVT, status:VALID,
12.1.1 DBA Data 12.1.1
12.1.1 DBA Data 12.1.1
12.1.1 FND Design Data 12.1.1
PACKAGE BODY: APPS.OZF_TP_ACCRUAL_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OZF_TP_ACCRUAL_PVT, status:VALID,
APPS.OZF_RESALE_PUB SQL Statements 12.2.2
12.2.2 FND Design Data 12.2.2
12.2.2 DBA Data 12.2.2
PACKAGE BODY: APPS.OZF_RESALE_BATCH_LINE_MAPS_PKG 12.1.1
PACKAGE BODY: APPS.OZF_RESALE_BATCH_LINE_MAPS_PKG 12.2.2
12.2.2 DBA Data 12.2.2
PACKAGE BODY: APPS.OZF_RESALE_COMMON_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OZF_RESALE_COMMON_PVT, status:VALID,
12.1.1 DBA Data 12.1.1
12.2.2 DBA Data 12.2.2
APPS.OZF_QP_QUAL_PVT SQL Statements 12.2.2
APPS.OZF_TP_ACCRUAL_PVT SQL Statements 12.1.1
APPS.OZF_QP_QUAL_PVT dependencies on OZF_RESALE_BATCH_LINE_MAPS_ALL 12.2.2
APPS.OZF_TP_ACCRUAL_PVT dependencies on OZF_RESALE_BATCH_LINE_MAPS_ALL 12.2.2
APPS.OZF_RESALE_BATCH_LINE_MAPS_PKG dependencies on OZF_RESALE_BATCH_LINE_MAPS_ALL 12.1.1
APPS.OZF_RESALE_BATCH_LINE_MAPS_PKG dependencies on OZF_RESALE_BATCH_LINE_MAPS_ALL 12.2.2
APPS.OZF_TP_ACCRUAL_PVT dependencies on OZF_RESALE_BATCH_LINE_MAPS_ALL 12.1.1
APPS.OZF_RESALE_COMMON_PVT dependencies on OZF_RESALE_BATCH_LINE_MAPS_ALL 12.2.2
APPS.OZF_RESALE_PUB dependencies on OZF_RESALE_BATCH_LINE_MAPS_ALL 12.2.2
APPS.OZF_TP_ACCRUAL_PVT SQL Statements 12.2.2
APPS.OZF_RESALE_COMMON_PVT dependencies on OZF_RESALE_BATCH_LINE_MAPS 12.2.2
APPS.OZF_TP_ACCRUAL_PVT dependencies on OZF_RESALE_LINES_ALL 12.1.1
APPS.OZF_RESALE_PUB dependencies on OZF_RESALE_LINES_ALL 12.2.2
APPS.OZF_TP_ACCRUAL_PVT dependencies on OZF_RESALE_LINES_ALL 12.2.2
APPS.OZF_TP_ACCRUAL_PVT dependencies on OZF_RESALE_HEADERS_ALL 12.1.1
APPS.OZF_TP_ACCRUAL_PVT dependencies on OZF_RESALE_HEADERS_ALL 12.2.2
APPS.OZF_TP_ACCRUAL_PVT dependencies on OZF_RESALE_HEADERS 12.2.2