More Set Up Details for Extensible Flexfields

Get more details about how to create extensible flexfields in Oracle Order Management.

Set Up Flexfields When You Use Oracle Analytics Publisher

If you use Oracle Analytics Publisher, then make sure you do these steps when you set up your flexfield. For assistance, contact Oracle Support.

1. Run the Publish Extensible Flexfield Attributes scheduled process.

2. On the Manage Extensible Flexfield page, click Actions > Refresh and Deploy Offline.

3. Deploy your extensible flexfield. For details, see Use Extensible Flexfields to Add Your Attributes in Order Management.

4. Download the flexfield archive.

   • On the Manage Extensible Flexfield page, click Actions > Download Flexfield Archive.

   • Wait for the dialog to display 100%, then click Download.

   • In the Opening dialog, click OK.

   • Save the file to a folder of your choice.

   • Unzip the file.

5. Reset the Financial Analytics container.

Flexfields That You Can Publish

You can publish only the flexfield attributes that come predefined with Order Management and that are part of the predefined extensible categories.

Entity	Predefined Category
Headers	DOO_HEADERS_ADD_INFO
Lines	DOO_LINES_ADD_INFO
FulfillLines	DOO_FULFILL_LINES_ADD_INFO
Payments	DOO_PAYMENTS_ADD_INFO
PriceAdjustments	DOO_PRICE_ADJUSTMENTS_ADD_INFO
SalesCredits	DOO_SALES_CREDITS_ADD_INFO
OrchestrationTaskActivity	DOO_ACTIVITIES_ADD_INFO
LotSerialNumber	DOO_LOT_SERIAL_NUM_ADD_INFO

You can't use the Category Hierarchy or Preconfigured Context Values with an extensible flexfield.

Mask Your Data

Assume you need to display your own postal code on the order header, the postal code has seven digits, and you need to use an extensible flexfield to do it because these postal codes aren't part of Order Management's predefined data. The data contains sensitive information, so you also want to use asterisks to mask the value except for the last two characters. For example, you enter 5674577, and you want to mask that value to *****77.

Note that you can't mask data in a value set in Order Management, but we can still meet the rest of your requirement. Here's how:

1. Go to the Setup and Maintenance work area, then go to the task:
   • Offering: Order Management
   • Functional Area: Orders
   • Task: Manage SCM Common Value Sets
2. On the Manage SCM Common Value Sets page, click Actions > Create, then set the values.

   Attribute	Value
   Value Set Code	My Postal Codes
   Module	Common
   Validation Type	Format Only
   Value Data Type	Character
   Value Subtype	Text
   Maximum Length	7

   Setup varies for different types of value sets. For details, see Set Attribute Values Before You Convert Source Orders.

3. Create an extensible flexfield, then set the Value Set attribute on your flexfield segment to My Postal Codes. For details, see Use Extensible Flexfields to Add Your Attributes in Order Management.