This post will cover brief overview of steps required to configure Oracle Inventory. There are some required, optional steps and for some steps you have to check some pre defined system default values that weather it suits your business needs or change them. Perform optional steps only if you are using that business functions. Later […]
A database link is a path through which a remote user in another database can connect to any other database. Once created the database link exists as an object in the user schema. Type of DB LinksThere are 3 types of DB links. They are as follows: 1. PRIVATE: When the DB links is created, […]
Oracle inventory main reporting tables.——————————————————————————– MTL_MATERIAL_TRANSACTIONS Base table for all transactions (etc RCV,Issuance,Sub Inv Transfer,Inter Org Transfer,Misl Transactions…). MTL_SYSTEM_ITEMS Table 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 […]
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 -> Segments Key Flex Field In flexfield title search for Item Categories. Item Categories 2. Enter new record in this case ORK Item Categories. Now click on […]
Optional step before defining inventory organization Define Location. 1. Now In Inventory responsibility navigate to Setup -> Organizations -> Organizations Enter organization name and type from pre defined list. In this case this organization is defined as Master Org. 2. To define a location navigate to Setup -> Organizations -> locations […]
Recent Comments