, , ,

List of Key Flexfields in Oracle 11i Applications

There are 34 KFF’s available in Oracle 11i. They are as follows
S.No.
Flex Field
Owning Application
Maximum Segments
1
AHL Operation
Advanced Service Online
15
2
AHL Route
Advanced Service Online
15
3
Asset Key Flexfield
Assets
10
4
Category Flexfield
Assets
7
5
Location Flexfield
Assets
7
6
Group Asset
CRL Financials Assets
7
7
Super Group
CRL Financials Assets
7
8
Management Flexfield
Financials Intelligence
9
Accounting Flexfield
General Ledger
30
10
Reporting Attributes: Accounting
General Ledger
11
CAGR Flexfield
Human Resources
20
12
Competence Flexfield
Human Resources
30
13
Grade Flexfield
Human Resources
30
14
Item Contexts Key Flex
Human Resources
30
15
Job Flexfield
Human Resources
30
16
Personal Analysis Flexfield
Human Resources
30
17
Position Flexfield
Human Resources
30
18
Soft Coded Key Flexfield
Human Resources
30
19
Account Aliases
Inventory
20
20
Item Catalogs
Inventory
20
21
Item Categories
Inventory
20
22
ORACLE_SERVICE_ITEM_FLEXFIELD
Inventory
20
23
Sales Orders
Inventory
20
24
Stock Locators
Inventory
20
25
System Items
Inventory
20
26
Bank Details Key Flexfield
Payroll
30
27
Cost Allocation Flexfield
Payroll
30
28
People Group Flexfield
Payroll
30
29
PSB Position Flexfield
Public Sector Budgeting
30
30
ARTA-Receipt Prof Ident
Receivables
15
31
Sales Tax Location Flexfield
Receivables
10
32
Territory Flexfield
Receivables
20
33
Oracle Service Item Flexfield
Service
20
34
Training Resources
Training Administration
20
, , ,

Dual UoM in Oracle R12

Lets take a case Food industry:

FG Foods Ltd. sell variety of Chicken which can have different weight. The superior quality of a chicken weighs to 4 Pound (on an average) but the deviation can be ±10%. This chicken is purchased on number basis and later it is sold on Number (Each) basis as well as on weight (Pound-Lbs) basis. So here Chicken is getting transacted based on two UOM and FG Foods want to track Qty on both UoM basis.
To satisfy this requirement we need to define an item which can be tracked on two UoM, define converser rate between these UoMs.

Item Definition:
UoM Conversion:
Also define Inter-class conversion that too item specific.
1 Unit = 4 Pound

Transactions:
Lets look at the transaction below, 100 Lbs comes to 25 chickens (as per tolerance), but if it goes beyond the tolerance then Oracle will not accept it.


In this case, based on tolerance defined it will accept values for secondary UoM ±2.5 (10% of 25).
So in below transactions one line is on –ve tolerance and other is on +ve tolerance.

On-hand and Availability:

Miscellaneous Issue:
Lets try doing issue transaction based on only Secondary UoM (Each). Oracle will automatically calculate quantity in other UoM based on the conversion rate.


On-hand Qty:
In above transaction, even though we did not give value in Lbs, Oracle deducted one chicken and 4 Pounds (refer the conversion).
51-1   = 50 Each
200-4 = 196 Lbs


Price List View:
Oracle accepts different price values for different UoM as shown below, and you can sell the product on any UoM.


Sales Order Lines 68097 :
Lets sell this product based on different UoM..
Oracle will pull the price based on UoM you mentioned on the Order line, also it asks to feed the secondary qty as well. But remember the final transaction will happen based on UoM added on Order line and then other qty will be calculated.


Now Process the Order: Book > Pick Release > Pick Confirm > Ship Confirm.

Observe the above shipping transactions,
Line 1.1: even though its showing Secondary Req Qty as 12 actual Secondary Shipped Qty is 11.5 (as per the conversion), as 46Lbs of chicken comes to 11.5 (46/4)
Line 1.2: Here we did not give qty in Lbs, so oracle calculated it based on conversion and populated.
At the end of this transaction the final On-Hand shall as below:
50 – (11.5+12) =  26.5
196 – (46+48)  = 102