RPM Pc Search Merch Tbl

In Scope

Technical: RPM_PC_SEARCH_MERCH_TBL | ID: OR-RPCS-RPM_PC_SEARCH_MERCH_TBL

this is a global tempoprary table that is used to reflect the obj_dept_class_subclass_tbl that will be used by some pl/sql packages search utlity to avoid nested object casting.

See how this object fits into Pricing & Promotions

Review the broader sequencing and dependencies for this domain

Migration Details

Complexity
Medium
Stage
Stage 2
Cutover Wave
Dependency Level

Dependencies

No dependencies

Target Structure

Load API
Table
Target Objects
RPM_PC_SEARCH_MERCH_TBL

Implementation Considerations

Use Cases

Initial load, rehearsal loads, cutover

Sequencing

Load during Master Data to establish foundational reference data before dependent setup or transactional loads. Load once prerequisite cross-domain reference data is available so RPM_PC_SEARCH_MERCH_TBL can be established cleanly. Sequence this object with its pricing & promotions peers so RPCS processing can consume it without synthetic defaults. (Inferred from vendor object description, current scope dependencies, and Oracle Retail RPCS documentation.)

Cutover

Load during Stage 2 / .

Data Governance

Requires business ownership and source-to-target crosswalk governance.

Field Definitions (4)

Typical Source Systems

ERPLegacy

Notes

Load during Master Data to establish foundational reference data before dependent setup or transactional loads. Load once prerequisite cross-domain reference data is available so RPM_PC_SEARCH_MERCH_TBL can be established cleanly. Sequence this object with its pricing & promotions peers so RPCS processing can consume it without synthetic defaults. (Inferred from vendor object description, current scope dependencies, and Oracle Retail RPCS documentation.)