Oracle Apps Key Flex Field (a) KFF

As the name explains in Oracle KFF is a field which is flexible to be structured as per the requirement of the Business.One has to know well abt the KFF before building the system. KFF is a critical setup and many of them are irreversible.There are totally 38 KFF available acroos all Modules.

Key points to be noted in the KFF are as follows

Which application doesit belong to?

How many structure allowed?

Possibility of Dynamic insert

To be More clear about the Basic KFF for a functional consultant, lets move into some of the specific KFF and its application.

Application: Inventory

1) System Item flexfield
2) Item Categories
3) Item Catalogs
4) Sales Orders
5) Stock Locators
5) Account Aliases

Application: General Ledger

1) Accounting Flexfield
2) GL Ledger Flexfield ---> This is a additional KFF in R12
3) Reporting Attributes:Accountin

Application: Assets

1) Asset Key Flexfield
2) Category Flexfield
3) Location Flexfield

Application: Human Resources

1) Competence Flexfield
2) Grade Flexfield
3) Job Flexfield
4) Position Flexfield

Application: Payroll

1) Cost Allocation Flexfield
2) People Group Flexfield


Hint For INV implementation: System Item KFF is a critical thing to be taken care and the number of segment will decide the entire Item transaction across all modules.
Adviceable is to restrict the number of Segment inSystem Item KFF

Attribute Determines the Item

Defining a Item is not just naming a physical or logical object, but inturn assigning various properties to it.In oracle its termed as Attributes, the attibute is the one which determines the nature of a Item.So every consultant should now the significance of the item, item category and organization assignment.Let me share the key attributes in each functional areas for now.

Main

1. Primary Unit of Measure
2. User Item Type
3. Item Status
4. Conversions

Inventory

1. Inventory Item
2. Stockable
3. Transactable
4. Revision Control
5. Reservable
6. Check Material Shortage
7. Lot Expiration (Shelf Life) Control
8. Shelf Life Days
9. Lot Control
10. Starting Lot Prefix
11. Starting Lot Number
12. Cycle Count Enabled
13. Negative Measurement Error
14. Positive Measurement Error
15. Serial Generation
16. Starting Serial Prefix
17. Starting Serial Number
18. Locator Control
19. Restrict Subinventories
20. Restrict Locators

Bills of Material

1. BOM Allowed
2. BOM Item Type
3. Base Model
4. Engineering Item (Oracle Engineering only)
5. Effectivity Control

Costing

1. Costing Enabled
2. Inventory Asset Value
3. Include in Rollup
4. Cost of Goods Sold Account
5. Standard Lot Size

Purchasing

1. Purchased
2. Purchasable
3. Use Approved Supplier
4. Allow Description Update
5. RFQ Required
6. Outside Processing Item
7. Outside Processing Unit Type
8. Taxable
9. Receipt Required (Three-Way Invoice Matching)
10. Inspection Required (Four-Way Invoice Matching)
11. Default Buyer
12. Unit of Issue
13. Receipt Close Tolerance
14. Invoice Close Tolerance
15. UN Number
16. Hazard Class
17. List Price
18. Market Price
19. Price Tolerance
20. Rounding Factor
21. Encumbrance Account
22. Expense Account
23. Asset Category

Receiving

1. Receipt Date Action
2. Receipt Days Early
3. Receipt Days Late
4. Overreceipt Quantity Control Action
5. Overreceipt Quantity Control Tolerance
6. Allow Substitute Receipts
7. Allow Unordered Receipts
8. Allow Express Transactions
9. Receipt Routing
10. Enforce Ship-To

Physical Attributes

1. Weight Unit of Measure
2. Unit Weight
3. Volume Unit of Measure
4. Unit Volume
5. Container
6. Vehicle
7. Container Type
8. Internal Volume
9. Maximum Load Weight
10. Minimum Fill Percentage
11. Collateral Item
12. OM Indivisible

General Planning

1. Inventory Planning Method
2. Planner
3. Make or Buy
4. Min-Max Minimum Quantity
5. Min-Max Maximum Quantity
6. Minimum Order Quantity
7. Maximum Order Quantity
8. Order Cost
9. Carrying Cost Percent
10. Source Type (Replenishment)
11. Source Organization
12. Source Subinventory
13. Safety Stock Method
14. Safety Stock Bucket Days
15. Safety Stock Percent
16. Fixed Order Quantity
17. Fixed Days Supply
18. Fixed Lot Multiplier

MPS/MRP Planning

1. Planning Method
2. Forecast Control
3. Exception Set
4. Pegging
5. Shrinkage Rate
6. Round Order Quantities
7. Acceptable Early Days
8. Repetitive Planning
9. Overrun Percentage
10. Acceptable Rate Increase
11. Acceptable Rate Decrease
12. Calculate ATP
13. Reduce MPS
14. Planning Time Fence
15. Planning Time Fence Days
16. Demand Time Fence
17. Demand Time Fence Days
18. Release Time Fence
19. Release Time Fence Days

Lead Times

1. Preprocessing
2. Processing
3. Postprocessing
4. Fixed
5. Variable
6. Cumulative Manufacturing
7. Cumulative Total
8. Lead Time Lot Size

Work in Process

1. Build in WIP
2. Supply Type
3. Supply Subinventory
4. Supply Locator
5. Overcompletion Tolerance Type
6. Overcompletion Tolerance Value
Order Management
1. Customer Ordered
2. Customer Orders Enabled
3. Shippable
4. Internal Ordered
5. Internal Orders Enabled
6. OE Transactable
7. Pick Components
8. Assemble to Order
9. ATP Components
10. Ship Model Complete
11. Check ATP
12. ATP Rule
13. Picking Rule
14. Default Shipping Organization
15. Returnable
16. RMA Inspection Required
17. Over Shipment Tolerance
18. Under Shipment Tolerance
19. Over Return Tolerance
20. Under Return Tolerance

Invoicing

1. Invoiceable Item
2. Invoice Enabled
3. Accounting Rule
4. Invoicing Rule
5. Tax Code
6. Sales Account
7. Payment Terms

Service

1. Support Service
2. Warranty
3. Coverage
4. Service Duration
5. Billing Type
6. Serviceable Product
7. Service Starting Delay