Application Integration on Oracle Cloud Ed 6 — Lesson 2: Mappings, Lookups, Routing, Enrichment, and Data Quality

Technical Scope

• schemas and mapper expressions
• lookups, value maps, and enrichment
• routes, switches, loops, and scopes
• canonical data, validation, and schema evolution

Instructor Demonstration

Demonstrate schemas and mapper expressions inside an order-to-fulfillment integration that must survive schema changes, endpoint failures, and business rejection, then capture the exact configuration, command, transaction, report, or code evidence that proves the result.

Applied Workshop

Implement a controlled workshop covering lookups, value maps, and enrichment and routes, switches, loops, and scopes, then test a failure or exception involving canonical data, validation, and schema evolution.

1. Confirm environment, identity, data, dependencies, and expected result.
2. Complete the product-specific implementation or analysis.
3. Capture commands, configuration, output, logs, transactions, or reports.
4. Explain the operational, security, performance, or business trade-off.

Validation Standard

The Mappings, Lookups, Routing, Enrichment, and Data Quality result must be reproducible, traceable to approved inputs, and consistent with the expected Oracle product behavior.

• The intended target and ownership are verified.
• The result is supported by reproducible evidence.
• Security, performance, reliability, and support impact are reviewed.
• Unexpected behavior is investigated before acceptance.

Failure Analysis

Diagnose issues in schemas and mapper expressions, lookups, value maps, and enrichment, routes, switches, loops, and scopes, or canonical data, validation, and schema evolution without making an unverified production change.

Learners isolate the smallest proven cause, apply a reversible correction, rerun validation, and record the preventive action.