, , , , , ,

Item Category Flexfield Structures

You can define multiple segment structures for the Item Categories Flexfield. Each segment structure may have its own display prompts and fields.
When you install or upgrade Oracle Inventory or Oracle Purchasing, Oracle provides two category flexfield structures by default: Item Categories and PO Item Category.
Each segment structure can display prompts and fields that apply specifically to a particular naming convention. For example, you might want one of your category sets to use two segments for the names of categories. Another item grouping scheme might use just one segment for the names of categories. You choose a flexfield structure for every category set and category that you define.

1. Lets create an item category as Procut Information with three segment:  Product Line – Product Name – Brand Name
Product Line – Electronics, Machine, FMG
Product Name – Mobile, TV, Bus Engine, Soap, Biscuit
Brand Name – LG, Samsung, Cummins, Britania
 
2. Define all the value sets as shown below.

3. Define the item category flex field.

4. Filling up the value set of the stucture product information

 
/by
, , , , ,

Item Categories

Categories are logical groupings of items that have similar characteristics. A category set is a distinct category grouping scheme and consists of categories.
Each category grouping scheme can use different terminology for its categories, as well as different naming structures based on number of segments. You can define multiple structures for your Item Categories flexfield. You can configure each flexfield structure by using as many segments and any level of value set validation that you need.

When inventory is installed, a default category must be assigned to each of the following functional areas: Inventory, Purchasing, Order Entry, Costing, Engineering, and Planning. When an item is enabled for a functional area, it is assigned the default category set.  You cannot delete the items default category set assignment.  Default categories are required so that each functional area has at least one category set that contains all items in that functional area.   For the functional areas, optionally, you can have a unique category set; for example, you may set up a unique category set for Purchasing.  It is also possible to have one category set defined to be the default category set for all functional areas.  The complete set up of item categories is done in below 5 steps in sequence.
/by
, , , , ,

Oracle Inventory Flexfields

Oracle Inventory provides the following flexfields:
  1. System Items
  2. Item Catalogs
  3. Item Categories
  4. Stock Locators
  5. Account Aliases
  6. Sales Orders
Depending on your system’s setup, Inventory may also use some or all of the following
flexfields provided by other Oracle products:
     
  • Accounting (Oracle General Ledger)
  • Sales Tax Location (Oracle Receivables)
  • Territory (Oracle Receivables)
1. System Items
You can use the System Items Flexfield (also called the Item Flexfield) for recording and reporting your item information. You must design and configure your Item Flexfield before you can start defining items.
All Oracle Applications products that reference items share the Item Flexfield and support multiple-segment implementations. However, this flexfield supports only one structure.
You must set up your OE: Item Flexfield profile option to specify the Item Flexfield structure that you will use for your Oracle applications.
Users can also set up the OE: Item Flexfield Entry Method profile option to specify your preferred method of entry for this flexfield.
You can optionally use the item flexfield to default item information for invoice, debit memo, and credit memo lines or you can enter your own line information.
2. Item Catalogs
This key flexfield supports only one structure.
3. Item Categories
You must design and configure your Item Categories Flexfield before you can start defining items since all items must be assigned to categories. You can define multiple structures for your Item Categories Flexfield, each structure corresponding to a different category grouping scheme. You can then associate these structures with the categories and category sets you define.
4. Stock Locators
You can use the Stock Locators Flexfield to capture more information about stock locators in inventory. If you do not have Oracle Inventory installed, or none of your items have locator control, it is not necessary to set up this flexfield.
If you keep track of specific locators such as aisle, row, bin indicators for your items, you need to configure your Stock Locators Flexfield and implement locator control in your organization.
This key flexfield supports only one structure.
 
5. Account Aliases
This key flexfield supports only one structure.
 
6. Sales Order
The Sales Order Flexfield is a key flexfield used by Oracle Inventory to uniquely identify sales order transactions Oracle Order Management interfaces to Oracle Inventory.
Your Sales Order Flexfield should be defined as Order Number, Order Type, and Order Source. This combination guarantees each transaction to Inventory is unique. You must define this flexfield before placing demand or making reservations in Oracle Order Management.
You must set up the OM: Source Code profile option to determine the source code you will use in for the third segment of this flexfield to guarantee that each transaction is unique. (Oracle Inventory defaults the value of the OM: Source Code profile option to ‘ORDER MANAGEMENT’.)
For your value sets, you must use Dynamic Inserts. The Validation Type should be None. Value Required should be Yes to improve performance of concurrent programs. The value set must be alphanumeric. The value set maximum size must be 40.
You should set the Required field to Yes in the Validation Information region when enabling the flexfield segments. Setting this field to Yes, improves performance when updating existing demand or reservations by guaranteeing that Oracle Order Management always supplies a value.
Set Right-justify Zero-fill Numbers to No so sales order numbers are not padded with zeros.

Oracle Inventory defines a unique ID for each order in MTL_SALES_ORDERS based on this flexfield. The Inventory unique ID, as opposed to the Order Management unique ID, is used throughout Oracle Manufacturing applications.

/by
, , , , ,

Implementation of Inventory

/by
, , , , ,

Organization in R12

Define the following organizaions as per the requirement of business
i. Business group
ii. Legal Entity
iii. Operating Units
iv. Organization
External organizations (for example, tax offices, insurance carriers, disability organizations, benefit carriers, or recruitment agencies)
Internal organizations (for example, departments, sections or cost centers)
Creating an Organization
1. Enter a name for your organization in the Name field. A check is performed to see if organizations with the same name already exist.
All Oracle applications you install share the information entered in the Organization window. Therefore organization names must be unique within a business group, and business group names must be unique across your applications network.
You can create two organizations with the same name in different business groups but this can cause confusion later, if the HR: Cross business group profile option is set to Yes and you decide to share certain information across all business groups. If you decide to create two organizations with the same name, be sure that this will not cause you problems in the future.
2. Optionally, select an organization type in the Type field.
Organization types do not classify your organization, you use them for reporting purposes only. The type may identify the function an organization performs, such as Administration or Service, or the level of each organization in your enterprise, such as Division, Department or Cost Center.
3. Enter a start date in the From field. This should be early enough to include any historical information you need to enter.
Note: You cannot assign an employee to an organization before the start date of the organization.
4. Enter a location, if one exists. You can also enter an internal address to add more details such as floor or office number.
If you are using Oracle Payroll in the US, every organization to which employees can have assignments, including business groups, must have on record a location with a complete address. This is because the system uses the location of the organization of the employee’s primary assignment to determine employee work locations for tax purposes. This does not apply to GREs, because the assignment to a GRE exists in addition to the assignment to an organization.
For Dutch users only, if you are setting up external organizations for a tax office, a social insurance provider or a private health insurance provider, you must enter the postal address and contact details using the NL_POSTAL_ADDRESS Location EIT.
Note: If you are an Oracle Inventory user, then you must not assign a location to more than one organization classified as an Inventory Organization.
5. Enter internal or external in the Internal or External field. You cannot assign people to an external organization.
Examples of external organizations that may require entry are disability organizations, benefits carriers, insurance carriers, organizations that employees name as beneficiaries of certain employee benefits, and organizations that are recipients of third party payments from employees’ pay.
 
 
Inventory : Setup -> Organizations -> Organization
 
Enter Organization Classifications & Additional Information
1. Business Group
Business Group Information.
Budget Value Defaults.
Work Day Information.
Benefits Defaults.
PTO Balance Type.
Recruitment Information.
Payslip Information.
Self Service Preference Information.
2. Attaching Set of Books to Legal Entity
 
3. Attaching Set of Books & Legal Entity to Operating Unit
4. Attaching Operating Unit to organization
/by