INVENTORY CREATION PROCESS IN ORACLE APPS

TO CREATE A  NEW ITEM IN INVENTORY MODULE:

METHODE:1

==========

1.      Login USER NAME and PASSWORD in Oracle Applications R12

2.      Choose Inventory, Vision Operations(USA)

3.      In this Responsibility  to select Items------> Master Items

4.      After select  Items display given window

5.      Here we Enter Item Name in Item tab and Enter description in Description tab . Save Record

6.      You want to see item what you entered  that is stored in given Base Table as  Column Name SEGMENT1

7.      MTL_SYSTEM_ITEMS_B  it is a Base table for Inventory here system generated a  ITEM ID With column Name INVENTORY_ITEM_ID  automatically.

8.      select * from MTL_SYSTEM_ITEMS_B WHERE SEGMENT1 LIKE '%LENOVO%'

select * from MTL_SYSTEM_ITEMS_B WHERE INVENTORY_ITEM_ID='219955'

Now we created Item only not transfer to Modules. It means not stock and not transferable, not see in modules.

Next we want to enable this process so in Master Items tab Click on Inventory tab than we look like given bellow tab. In this tab we observed Check Boxes like Inventory Item, stockable, Transactable, Revision Control(D), Reservable(G), Check Material shortage.

Here uncheck Boxes is represent in back end table as Flag Column can we see in MTL_SYSTEM_ITEMS_B table we shown us as ‘N’.

 After check the boxes than shows those ‘Y’.

9.      In bellow tab if check Inventory tab automatically checked stackable,Transactable Boxes.

10.  In above tab if you want  show the only stackable not  transactable than just uncheck the transactable Check Box. Here not possible to uncheck Inventory Item  check Box

11.  Now  SAVE  the tab.

12.  Next Open Bills Of Material tab click on BOM(Bills of material) and SAVE tab.

13.  Next Open Purchasing Tab click on Purchased, Purchasable and Allow Description Update tab Finally SAVE  it.

14.  Next Open Order Management click on check Boxes  Customer Ordered, customer Orders Enabled, shippable, Internal Ordered, Internal Orders Enabled, OE Transactable.

15.   SAVE tab.

16.  Next click on Invoicing tab Enable check boxes Invoiceable Item ,Invoice Enabled.

17.  If we want to Publish/Un publish the item than choose Web Option Tab.

METHODE:2

1.      Create an Item  with name and description.

2.      Now click Tools on Menu bar select Copy From…

3.      After shown bellow tab here we can find Finished Good  it is created Oracle People.

4.      Now  click on apply button Next click Done.

5.      After see what you want to required to enabled the check boxes like method 1.

6.      Here Inventory, Purchasing, Bills of materials, Order management, Invoicing, web Options.

HOW TO ASSIGN A ITEM  INTO MULTIPLE ORAGANIZATIONS:

1.      After creating Item we want to assign the item into Multiple Organization than simply  click on Tools  in Menu Bar select Organization assignment.

2.      After selecting Organization assignment display the given window here select which Organization you want assign the item/ you want assign the Item to all Organization than just click on ASSIGN ALL Button. But in bellow tab I select  vision Germany org .now my Item is displaying two Organizations.

3.      Next  SAVE.

4.      We can see all above details in MTL_SYSTEM_ITEMS_B backend Table.