1. Implementing Order Management
  2. Overview of Using Flexfields to Integrate Order Management with Oracle Applications

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 use REST API to send each value that an extensible flexfield contains to an upstream source system or to a downstream fulfillment system.

    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 REST API or a specific set of web services. For details, see Use REST API and Web Services 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 your own data to a 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.

Related Topics