Use Descriptive Flexfields in Your Integration
Apply these guidelines when you use a descriptive flexfield to integrate Order Management with another Oracle application.
Understand How You Use a Descriptive Flexfield
Note
-
To integrate Purchasing, Shipping, or Receiving, select a predefined source, such as PurchaseRequestSource. Order Management provides predefined descriptive flexfields that you can use. You don't need to create one.
-
Select a predefined entity, such as PurchaseRequestLine.
-
Add the attributes that you must integrate with your fulfillment system.
-
Add the AttributeCategory attribute. This attribute contains the value of the context code, such as ItemPriceForSupplier, of the descriptive flexfield.
-
If your descriptive flexfield uses a context sensitive segment.
-
Provide a value.
-
Reference an attribute in a view object or add an expression.
-
You typically add an expression.
-
If you add a string in your expression, then enclose it with double quotation marks ( " " ).
-
Reference the Attribute in the View Object
Note
-
A view object, such as FulfillLineVO, contains attributes, such as FulfillLineId.
-
VO is an abbreviation for view object.
-
The value you chose for the View Object attribute determines the values you can select for the attribute View Object Attribute.
Use a Descriptive Flexfield When You Integrate With Accounts Receivable
Note
-
Use a predefined entity for accounts receivable, such as TransactionInterfaceHeaderDff, which is a descriptive flexfield that stores details about the receivables transaction header. Examine the entities that are available on the Entities tab to identify the one you need.
-
Add these attributes. They're all required.
-
FulfillLineId
-
NameSpace
-
XsiType
-
_FLEX_Context
You must add these attributes for each context entity that you define for a descriptive flexfield.
-
-
Add the descriptive flexfield attributes that you must send to accounts receivable, such as GlobalSegment1_Custom.
Note
-
You can map an interface line of type Line.
-
You can't map an interface line of type Discount, Charge, or Freight.
-
You can use only one context for each descriptive flexfield.
-
To avoid an SQL exception, make sure the web service you use to send fulfillment lines from Receivables to Order Management includes no more than 10,000 fulfillment lines in each invoice response.
If you must map an attribute from the order header, extensible flexfield, or fulfillment line detail, then you must use an integration algorithm. Order Management uses this hierarchy.
Order header
Fulfillment line
Fulfillment line details
Other Oracle applications might not organize these objects into a hierarchy. Instead, they might represent them in a single object named ARLine. ARLine also includes descriptive flexfields, so it can represent the same data that the fulfillment line represents. If you must copy attributes from the fulfillment line to ARLine, then you require an integration algorithm only if you must implement conditional logic.
Specify the Source
Note
-
Click the Sources tab.
-
Query the Source for InvoiceSources.
-
Query the Entity for your entity, such as TransactionInterfaceHeaderDff.
-
Add your custom attributes. Create an expression for each of them.
-
Enter a value for NameSpace and _FLEX_Context from the XML file.
-
Enter a value for XSiType from the XSD file.
For example:
Attribute |
Expression |
---|---|
GlobalSegment1_Custom |
As an option, add an expression. For example:
Note that this example is a concatenation. Here's the pseudocode.
|
NameSpace |
Enter the value from the XML file you downloaded for your flexfield archive. For example:
|
XsiType |
Enter the value from your XSD file. For example:
|
_FLEX_Context |
Enter the value of the context code from the XML file you downloaded for your flexfield archive. This example uses GlobalSegment1, so you can leave
_FLEX_Context empty. If you didn't include a global segment in this example,
you would enter |
Specify the Service
Note
-
Click the Services tab.
-
Query the Service for InvoiceService.
-
Query the Entity for your entity, such as TransactionInterfaceHeaderDff.
-
Add your custom attributes. Create an alias for each one. The alias is the name of the service. Get it from your XML file.
Attribute
Alias
GlobalSegment1_Custom
_AR_5FRRRF_5FDFF_5FRCT_5FGlobal_2D1
Order Management uses this value when it creates the payload to create the task.
If you prefer to send this value in your integration algorithm, then you add it to the algorithm instead.
-
Add the predefined attributes. It isn't necessary to define the alias for predefined attributes.
- Integrate Order Management with Accounts Receivable
- Use a Service Mapping to Integrate Order Management with Other Oracle Applications
- Use Descriptive Flexfields to Integrate Order Management with Oracle Applications
- Overview of Integrating Order Management with Other Oracle Applications
- Create a Sandbox So You Can Edit Service Mappings