Flexfields in Order Entry/Shipping

Depending on your system's setup, Oracle Order Entry/Shipping may use some or all of the following key flexfields provided by other Oracle products. Order Entry/Shipping also provides the Pricing Attributes descriptive flexfield to capture information specific to product pricing.

Key Flexfields
1. Accounting (Oracle General Ledger): Defining your Accounting key flexfield is part of setting up your sets of books.
2. Item Catalogs (Oracle Inventory): If you make entries for items in a standard industry catalog or if you want to group items according to certain descriptive elements, you need to configure this flexfield. Even if you do not use item cataloguing, you must enable at least one segment of this flexfield and compile it before you define your items.
3. Item Categories (Oracle Inventory): You must set up this flexfield before you define items because all items must be assigned to categories.
4. Sales Orders (Oracle Inventory):Use the Sales Orders key flexfield to differentiate sales order transactions that Order Entry/Shipping interfaces to Oracle Inventory. You must define this flexfield before placing demand or reservations in Order Entry/Shipping. The profile option OE: Source Code defaults the source code you use in the third flexfield segment.
5. Sales Tax Location (Oracle Receivables): Use this flexfield to charge your customers for tax based on their shipping addresses.
6. Stock Locators (Oracle Inventory): If you want to track items by a specific aisle or row, use this key flexfield to capture additional information about inventory stock locators. If you use this flexfield, you must set the OE: Inventory Stock Location profile option.
7. System Items (Oracle Inventory): Before you define items, set up this flexfield in order to record and report item information. The OE: Item Flexfield profile option needs to be set.
8. Territory (Oracle Receivables): The Territory flexfield can be associated with salespeople, invoices, and customer site addresses. Use it to record and report territory information.

Descriptive Flexfields
1. Pricing Attributes (Oracle Order Entry/Shipping): Pricing attributes modify an item's price without requiring that you create a new item. For example, you sell computer software and the price of the software is different depending on the number of users. You define a pricing attribute called 'Number Of Users'. When you enter an order line, the Pricing Attributes flexfield opens a window to capture the number of users. Oracle Order Entry/Shipping uses this information along with the item and unit of measure to derive the item list price.
The Pricing Attributes descriptive flexfield contains 15 user-definable flexfield segments to be used as pricing attributes. Once defined, the attributes can be used in the lines block of the Sales Orders window, the Line Options window, the Shipment Schedules window, the lines block of the Price Lists window, and the Item Groups window in Oracle Order Entry/Shipping; and in the Services and Renew Service windows in Oracle Service.
2. Delivery Line (Oracle Order Entry/Shipping): The Delivery Line descriptive flexfield, which is available on the Ship Confirm Delivery Special menu, displays a window that you create in which you can define additional delivery line information. The Delivery Line descriptive flexfield contains 20 user-definable flexfield segments to be used as delivery line attributes.
3. Industry Information (Oracle Release Management): If your system includes Oracle Release Management, you can use this flexfield to record industry-specific data for an order line.


Ben said...

Thanks for more in depth explanation of flexfields.

Order taking services

Sridevi Koduru said...
This comment has been removed by the author.
Sridevi Koduru said...

Sridevi Koduru (Senior Oracle Apps Trainer
LinkedIn profile -
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, OAF, SQL, PL/SQL, D2K at | +91 - 9581017828.

Erptree Oracle said...

Excellent Blog very imperative good content, this article is useful to beginners and real time Employees. Oracle R12 Financials Training in Hyderabad