AGILE PLM TO FUSION CLOUD PLM MAPPING

    Agile PLM to Fusion Data Mapping — Object by Object

    The mapping is where an Agile programme is won or lost. Class by class, attribute by attribute, object by object — how the Agile record is expressed in the Fusion Cloud PLM object model, and what to do with the parts that have no natural home.

    7
    Object families mapped
    3
    FBDI templates
    Versioned
    Every rule
    Signed off
    Before build

    Mapping the Agile object model onto Fusion

    Agile and Fusion Cloud PLM both manage product records, but they do not model them identically. The mapping is a design deliverable, agreed and signed before anything is built, not a set of assumptions embedded in a script.

    Items map by class. Agile subclasses, including the ones added over the years, resolve to Fusion item classes and catalog assignments. Lifecycle phases map to item statuses and lifecycle phases; the two vocabularies rarely align one to one, so the crosswalk is explicit and versioned rather than inferred.

    Attributes split three ways. Standard Agile attributes with a direct Fusion equivalent map straight across. Page Two and Page Three fields, which carry business-critical data under generic names in most long-lived instances, are resolved to their actual meaning first and then mapped to standard attributes or to extensible and descriptive flexfields. Anything with no sensible target is defaulted or archived, and that decision is recorded either way.

    Structures, AML and changes each map onto their own Fusion interface. The item FBDI template carries the latest released revision with its attributes, flexfields, AML and attachments; the structure template carries components, substitutes and reference designators; the change order template replays completed changes to rebuild revision history and redlines.

    The mapping deliverable

    1
    Class and lifecycle crosswalk
    Agile subclasses to Fusion item classes and catalogs, lifecycle phases to statuses, with every value accounted for.
    2
    Attribute map
    Every populated Agile attribute with its target: standard field, extensible flexfield, descriptive flexfield, default or archive.
    3
    Object-to-interface map
    Which Agile object lands in which Fusion interface, and in which load stage.
    4
    Value crosswalks
    Unit of measure, code sets and lookups translated through governed tables rather than inline logic.

    The six mappings that cause the most trouble

    Where Agile programmes consistently lose time, and what the design has to settle.

    🗂️

    Custom subclasses

    Subclasses accumulated over a decade may carry data the standard object model does not describe. Each needs a target class decision, not a default.

    🔣

    Page Two and Page Three

    Flex fields named Text01 through Text30 holding business-critical values. The mapping cannot start until someone says what each one means.

    🆔

    Item numbering

    Renumbering, padding or prefixing must apply consistently to structures, AML, changes and attachments, not just the item master.

    🏭

    Manufacturer identity

    Variant spellings consolidated to one governed record before AML is rebuilt, or the AML counts will never reconcile.

    📅

    Effectivity

    Revisions cannot carry overlapping effectivity ranges in the target, so overlaps in the source are resolved during transformation.

    📎

    Attachment identity

    The same drawing on several revisions needs distinct document identity in the target, or later revisions silently overwrite earlier ones.

    How the mapping gets built

    Evidence first, decisions second, build third.

    1

    Profile the source — Weeks 1–2

    Which classes exist, which attributes are populated, on what proportion of records and with what value distribution. Unused fields drop out of scope immediately.

    2

    Establish target configuration — Weeks 2–4

    The Fusion item classes, catalogs, statuses and flexfields available to map into, which depends on how the target has been configured.

    3

    Draft the crosswalks — Weeks 3–6

    Class, lifecycle, UOM and code-set translations drafted with every source value accounted for, including the ones that appear twice.

    4

    Resolve the exceptions — Weeks 5–8

    Attributes with no natural target settled in working sessions with engineering and quality, and the decision recorded per attribute.

    5

    Sign off and version — Weeks 7–9

    The mapping signed and versioned. From that point changes are tracked, so cycle three runs known rules rather than adjusted ones.

    How each Agile object family is expressed in Fusion

    The mapping document is organised by object family rather than by table, because that is how the target consumes the data and how the business reviews it.

    Each family below has its own target interface, its own dependency position in the load order, and its own reconciliation check afterwards.

    1
    Item and class
    Agile subclass to Fusion item class and catalog assignment, with the class determining which attributes and flexfields are even available.
    2
    Lifecycle and status
    Agile lifecycle phases to Fusion item statuses and lifecycle phases through an explicit crosswalk, since the vocabularies differ.
    3
    Attributes
    Standard attributes mapped directly; the rest routed to extensible or descriptive flexfields, defaulted, or archived by recorded decision.
    4
    Structure
    Components with quantity and effectivity, plus substitutes and reference designators, each landing on its own interface.
    5
    Manufacturer and AML
    Manufacturer parts created first as their own records, then AML entries linking them to the item revision.
    6
    Change and redline
    Completed changes carrying a record type per affected row, which is how history, additions, deletions and replacements are distinguished.

    Three ways teams handle mapping

    Only one of them survives the third rehearsal.

    📒

    Mapping in a spreadsheet

    Fine as a design artefact, dangerous as the source of truth. The build drifts from it and nobody notices which version is live.

    💻

    Mapping embedded in scripts

    The rules exist only as code, so a business question about what happens to a field needs a developer to answer it.

    🗃️

    Versioned mapping rules

    One governed definition driving the build, readable by the business, versioned so every cycle is reproducible.

    Frequently asked questions

    How do Agile PLM items map to Oracle Fusion Cloud PLM?+

    By class, then by attribute. Agile subclasses resolve to Fusion item classes and catalog assignments, with custom subclasses given an explicit target rather than a default. Lifecycle phases map to Fusion item statuses and lifecycle phases through a crosswalk, because the two vocabularies rarely align one to one. Standard attributes with a direct equivalent map straight across; the remainder go to extensible or descriptive flexfields, or are defaulted or archived by explicit decision.

    What happens to Page Two and Page Three attributes?+

    They get resolved before they get mapped. Profiling reports which flex fields are populated, on which classes, at what fill rate and with what value distribution, which narrows the question considerably. Engineering and quality then say what each surviving field actually means, since names like Text07 do not. Each is then mapped to a standard Fusion attribute where one fits, to an extensible or descriptive flexfield where it does not, or explicitly archived rather than migrated.

    Does every Agile object have a Fusion equivalent?+

    No, and any mapping exercise that assumes so will fail in the build. Oracle documents import paths for items, revisions, manufacturer parts, AML, structures with components, substitutes and reference designators, attachments and change orders, and that set covers the core of a product record. Objects outside it, and custom classes or relationship types specific to your instance, are handled case by case, and some are better archived than forced into a target structure that does not fit them.

    How are bills of material mapped?+

    Structure entities map to the Fusion structure interfaces: components with quantities and effectivity, substitutes, and reference designators. Depth is not the constraint; sequencing is. Because every component is itself a revision-controlled item, components must exist at the correct revision before the parent structure referencing them can load, so the mapping carries the load-order dependency alongside the field mapping.

    How are units of measure and code values translated?+

    Through governed crosswalk tables rather than inline conditional logic. Each source value is listed, given a target value, and signed off, with unmapped values raised as exceptions rather than silently passed through or defaulted. Holding them as data means a business user can review the translation without reading code, and means the same input produces the same output in every cycle.

    When is the mapping frozen?+

    At sign-off, usually around week eight or nine, and freezing it is what makes the later cycles meaningful. After that point changes are tracked as versioned amendments rather than made in place, so when rehearsal three produces a different result from rehearsal two you can tell whether the cause was a data change or a rule change. Without that discipline the cycles stop being comparable and reconciliation loses its value.

    Need an Agile to Fusion mapping you can sign?

    We will profile your Agile configuration, draft the class, lifecycle and attribute crosswalks against your target configuration, and hand you a mapping document your engineering and quality teams can approve.