ITEM CATALOG
Item Catalog is a flex field , which is used to define descriptive elements for Items .
Use of Item catalog in Oracle Inventory is to Group items that share common characteristics. In order to define catalog, we can setup distinct catalog groups to partition the Item master. Each catalog group in turn has a set of unique characteristics called as Descriptive element that describe item belonging to the Group. Oracle Inventory provides item catalogs to help you quickly locate items based on key characteristics.
For Example: We can define a new catalog group called Two-Wheeler. We can assign descriptive elements of Engine capacity, power and color to the catalog group. In Master Item Screen create an item ‘ABC’ to the group Two-Wheeler. We can choose values for each of descriptive elements such as 150CC, 11 BHP and Black or 100CC, 85BHP and Yellow. Now we can refer to the item by both unique item number ‘ABC’ or by the Two-Wheeler catalog (150CC, 11 BHP, Black). This is the use of the Item catalog.
Example : We can define new catalog called TV .
We can assign descriptive elements of
· Screen Size
· Pixel Rate
· HDMI Port
· Type(LCD/LED)
So the we can refer the Item by Catalog or by Item Name .
The catalog’s are help full to search a item .
Define a Catalog Group
Navigation: Setup >> Items >> Catalog Groups (Responsibility : Inventory)
Image : 1
We added a new Catalog named Tv Catalog. Now Save the Form and click on details to add Detail Catalogs.
Image : 2
Select Descriptive Elements from the drop down and add the required Catalog descriptive fields.
The Required check box denotes that, the Descriptive Element is Mandatory to input value at the time of Item creation .
Save & Exit .
Create a new Item and Assign The Catalog Group
Create a new Item .
Responsibility : Inventory
Navigation : Items >> Master Items
Steps:
àGive the Name of the Item & its Description
àInventory Tab (Check Inventory Item , Stockable , Transactable )
Image: 3
àSave
àTools >> Catalog ( Click )
Image : 4
In this form we need to give the Catalog Group Name and the value of the Descriptive Elements. The check Box Description Default (Editable Field) is to add the values to the Items Description .Here we remove the check box for the Pixel Rate , so the value is not Reflected in the Description .
If we click on Update Description , then the Item Description will change .
Screen shot After clicking the Update Description .
Image : 5
àIn the Below Screen I removed the value for the Screen Size field & Click on Catalog Complete , so it is giving an error message . If we refer the previous screen where we created the Catalog , we define Screen Size as Required. So when we are trying to complete the catalog without giving any info on Screen Size field .
Image : 6
àSave the Item Catalog , Close it . Save the Master Item . Assign the Item to Member Organization
(Tools >> Organization Assignment)
Image: 7
Very good explanation.
ReplyDeleteDear Linga, Thanks a lot for the Post
ReplyDeleteGood Explanation.
ReplyDeleteitem_catalog_group column where we find that table(or) view
ReplyDeletevery nice
ReplyDeleteThank you very much..
ReplyDeleteVery good explanation and screen shot examples.
ReplyDeleteHAI THANKS FOR THE POST
ReplyDeleteAFTER ASSIGNING WHERE WE CAN USE IT
Thank you for this!
ReplyDelete