More Set Up Details for Extensible Flexfields

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

Set Up Extensible 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 extensible 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 Overview of Using Extensible Flexfields 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.

Extensible Flexfields That You Can Publish

You can publish only the extensible 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
FulfillLineDetails	DOO_FULFILL_LINE_DTLS_ADD_INFO
LotSerialNumber	DOO_LOT_SERIAL_NUM_ADD_INFO

The Category Hierarchy and Preconfigured Context Values aren't available for these extensible flexfields.

Masking 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, the user enters 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 Transform Source Orders.

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