|
| |
| |
| |
|
Statistics |
| Unique Visitors: 0 |
| Total Unique Visitors: 95442 |
| Visitors Out: 588 |
| Total Visitors Out: 1240 |
|
|
|
| |
|
|
| |
|
| How to Define Oracle Inventory Organization |
| 2011-10-05 06:51:00 |
Optional stepbefore defining inventory organizationDefine Location.1. Now In Inventoryresponsibility navigate to Setup ->Organizations -> OrganizationsEnterorganization name and type from pre defined list.In this casethis organization is defined as Master Org.2. To define alocation navigate to Setup ->Organizations -> locationsThere are twooptions for scope Global and LocalGlobal: Ifglobal selected then this location will be available for all modules.After enteringname and description move to address details tab.3. Choose youraddress style as address styles are defined according to your country. Enter remainingdetails and save you work. 4. Now select location ORK Locations in organization definition form. ...
|
| |
|
| How to Define Setup Item Categories of Oracle inventory |
| 2011-09-29 05:10:00 |
After defining System item flexfield next step to do is to define Item categories flexfield .1. Go to Inventory responsibility and open Key Fleffield Flexfield -> Key -> SegmetnsKey Flex FieldIn flexfield title search for Item Categories.Item Categories2. Enter new record in this case ORK Item Categories. Now click on segments to enter segments summary.3. You can define any number of segments according to your business requirement here is this example we will define three segments.4. Enter first segment as Super Category. assign column and value set to this segment.5. Repeatedly do above step for both next segments.Column indicates the database fields that will hold entered value for specific segment. Now enter your desired item seg...
|
| |
|
| How to Setup Oracle Inventory - Required Steps Part 2 |
| 2011-09-28 02:22:00 |
Step-11. Define unit of measure classes. All items having similar characteristics fall under same UOM class like Kilogram or Length.Step-12. Define Sub inventories.Sub inventory groups inventory logically or physically, at least one sub inventory must be assigned to each organization.Step-13. Define Item attribute controls.Attributes are detail information about items.Each attribute is maintained at master level or organization level.If an attribute is defined as master level then it can only be updated at item master level and attributes maintained at item/organization level can only be updated at this level only.Step-13. Define Categories.Categories are defined to manage items having same characteristics.Step-14. Define Category Set and default Category Set.Sets ...
|
| |
|
| How to Define Cost Type In Oracle Inventory |
| 2010-10-15 01:07:00 |
Cost type is required while we define any new organization.Some cost types which are already defined are Average and Frozen.Steps to Define.Choose inventory responsibility and navigate to form.Setup -> Costs -> Cost TypesOn Cost Type WindowDefault cost type is basically used for items where any specific type is not defined.Date to inactivate cost is used to inactive your cost at specific date except for average and frozen cost type because frozen and average cost cannot by inactivate.If multi org is checked then this type is available for all organization but not its costs.If unchecked then this type is only available for organization which created it.If allow update is checked then this cost type can be updated by available average cost update processes.If for this type you wan...
|
| |
|
| Configuring Work Day calendar in oracle Inventory |
| 2010-10-09 12:12:00 |
If you want to predict needs of your material or to plan material requirement then you can configure workday calendar for this.Work day calendar provide lot of flexibility in terms of shifts, pattern for working days also you can configure exceptions.Following are Configuration Steps.1. Go to work day calendar.Setup>Organizations>CalendarsOn Workday Calendar Window.You can choose weekly calendar, monthly or periodic calendar type.Like 4/4/5 is two four-week periods followed by one five week period and 5/4/4 is vice versa.For twelve months in a year use calendar months. 13 Periods is thirteen for week period’s year wise.Start date and end date are very important in configuring work day calendar.As your organization standard on and off days wi...
|
| |
|
| How to configure System Items Flexfield |
| 2010-10-07 05:22:00 |
1. First define value set for item flexfield segments.Go to inventory responsibility and navigate to value set.Setup -> Flexfield->Validation->Sets2. Define Value Set for Item Section.Choices: List Type, Enter format validation of your own choice, validation type.3. Define Value Set for Sub Section.Sub Section Value Set is dependent on item section.To configure select dependent validation type and click on Edit Information.4. Define Value Set For Serial No.Serial No is also dependent on item section.5. Now value set for Condition Code and future segment.Ok we are done with first part of creating value se...
|
| |
|
| Oracle Supply Chain all APIS |
| 2010-10-05 01:25:00 |
1.EGO_ITEM_PUB.Assign_Item_To_OrgThis API provide functionality to assign one/more items to an organization(s)How to Assign Item Using Assign_item_to_org 2. Item Creation and Updation Public API.EGO_ITEM_PUB.Process_item(s)3. Category Code Creation Public API. This API provides functionality to create a category. INV_ITEM_CATEGORY_PUB.Create_Category 4. Item Category Assignment Public API EGO_ITEM_PUB.Process_Item_Cat_Assignment 5. Item Catalog Descriptive Element Public API. EGO_ITEM_PUB.Process_item_descr_elements6. Item Revision Creation and Updation Public API. EGO_ITEM_PUB.Process_Item_Revision 7. Implement Item Pending Changes Public API. This API provides functionality to implement pending changes (phase and/or status) for an item/item revision. EGO_ITEM_PUB.Implement_Item_Pend...
|
| |
|
| Oracle APPS Supply Chain tables ERD - PART-2 |
| 2010-09-06 02:11:00 |
RCV_TRANSACTIONSYou can get data of all receiving transactions in this table.Important columnsTRANSACTION_TYPE like DELIVER,REJECT,ACCEPT,CORRECT,RETURN TO RECEIVINGTRANSFER, RETURN TO VENDOR, RECEIVE.Also you can directly connect to shipment and purchase order tables for rcv_transactionsBy SHIPMENT_HEADER_ID and PO_HEADER_ID.PO_HEADERS_ALLGet purchase order header level information from this table.Important ColumnsTYPE_LOOKUP_CODE indicates purchase order type like RFQ, STANDARD.PO_LINES_ALLGet purchase order live level information from this table.Important columnsITEM_ID join with table MTL_SYSTEM_ITEMS column ITEM_ID to get item all information.PO_VENDORSGet vendor level information from this table.Important columnsPO_VENDOR_SITES_ALLGet vendor sites information from this ta...
|
| |
|
| Oracle APPS Supply Chain Tables ERD PART-1 |
| 2010-09-02 23:47:00 |
Oracle inventory main reporting tables.--------------------------------------------------------------------------------MTL_MATERIAL_TRANSACTIONSBase table for all transactions (etc RCV,Issuance,Sub Inv Transfer,Inter Org Transfer,Misl Transactions...).MTL_SYSTEM_ITEMSTable contains all System items organization wise. It is Base table for items.This table holds the definitions for inventory items, engineering items, and purchasing items. The flexfield code is MSTK. The primary key for an item is the INVENTORY_ITEM_ID and the ORGANIZATION_ID. The same item could be defined in more than one organization. Each row represents an item in an organization. MTL_SYSTEM_ITEMS_TLTable contains translated description of each master item.The primary key is INVENTORY_ITEM_ID, ORGANIZATION_ID and LANGUAGE...
|
| |
|
| |
 |
