Overview of Using Flexfields to Integrate Order Management with Oracle Applications

Use a flexfield to integrate Order Management with Oracle Receivables, Oracle Shipping, Oracle Receiving, or Oracle Procurement.

Guidelines

Consider these guidelines.

  • You can send each value that an extensible flexfield uses to an upstream source system or to a downstream fulfillment system. You can use a web service, such as Order Information Service, to send the value.

    Oracle Receivables comes predefined with a separate entity for each descriptive flexfield. You don't have to use separate entities for descriptive flexfields in Shipping, Receiving or Procurement because their predefined entities already have the descriptive flexfields you need.

  • You make attributes available in the main entity.

  • You must make sure your set up only references attributes that each application supports. For a list of attributes, see Entities and Attributes That You Can Use When You Integrate Order Management with Other Oracle Applications.

  • You must reference the database code that identifies each attribute, such as Attribute1 or Attributedate2. You must not use the implemented names to reference the attributes.

  • If you reference a descriptive flexfield according to context, then you must make sure your set up populates AttributeCategory. If you use a global segment, then it isn't necessary to populate AttributeCategory.

  • If your flexfield is on a fulfillment line, then use only one context for each entity. Your set up must not attempt to process two different contexts at the same time. For example, if you need to process two attributes, then add two segments to the same context. Add segment x and segment y to context A. Don't add segment x to context A and segment y to context B.

Automatically Map Extensible Flexfield

Each interaction uses a service data object (SDO). You must use a specific set of web services. For details, see Web Services That You Can Use to Integrate Order Management.

You can use the Copy-of feature in XLST (Extensible Stylesheet Language Transformations) instead of doing this work manually. This feature dynamically maps the input extensible flexfields to the Order Management entities and maps the extensible flexfield entity in Order Management to the SDO or modified node.

Here's where you can use this feature in Order Management.

  • Sales order integration

  • Template tasks

  • Fulfillment tasks

You must manually map other task types.

Import and Export

You can use REST API to import flexfield data. To get some examples, see Guidelines for Setting Up Extensible Flexfields in Order Management.

You can also use a flexfield to send custom data to your downstream fulfillment system. For an example, go to Technical Reference for Order Management (Doc ID 2051639.1), download the Payloads and Files attachment, then see the Other section in the attachment.