Skip to main content

Oracle Item catalog

Item 
Catalog



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 commoncharacteristics. 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 onCatalog 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)

Comments

Popular posts from this blog

General Ledger FAQ

1.  What responsibility should I use when doing the set up for General Ledger? Use a seeded responsibility like 'Oracle General Ledger Super User'. You may also need to use the System Administrator responsibility. 2.  What are the pre-requisites required to define a new calendar? According to your business needs you need to decide the calendar type required i.e. monthly, weekly or biweekly, the number of periods, adjusting periods and the maximum number of periods within a fiscal year. 3. What are the pre-requisites required to define a new Ledger? Define a Calendar, Chart of Accounts and enable the functional Currency  and convention of subledger accounting method. 4. Why must I check the calendar definition before assigning to a Ledger? The calendar definition cannot be changed once it is assigned to a set of books so it is very important to check that the calendar definition is suitable to the specific business needs, has been d

Difference Between MTS, ATO, MTO ,PTO ,CTO and ETO.

 Make-to-stock (MTS) In MTS environments, products are created before receipt of a customer order. Customer orders are then filled from existing stock, and then those stocks are replenished through production orders. MTS environments have the advantage of decoupling manufacturing processes from customer orders. Theoretically, this enables customer orders to be filled immediately from readily available stock. It also allows the manufacturer to organize production in ways that minimize costly changeovers and other disruptions. However, there are risks associated with placing finished goods into inventory without having a firm customer order or an established need. These risks tend to limit MTS environments to simple, low-variety, or commodity products whose demand can be forecasted readily.  Assemble-to-order (ATO) In ATO environments, products are assembled from components after the receipt of a customer order. The key components in the assembly or finishing process are pla

Accounting entries in Oracle Purchasing and Payables

This document gives in detail different accounts used and the accounting impact of various transactions that take place in Oracle Purchasing and Oracle Payables. Both Standard costing and Average costing methods are considered. The accounts are Oracle Applications specific and might differ from the conventional accounting names. Examples are given wherever required for better understanding of the concept. The sources of these accounts are given. PURCHASING:  Receiving – For Accrual Process for perpetual Accruals Receipts for inventory purchases are always accrued upon receipt. And also use perpetual accruals for expense purchases you want to record uninvoiced purchase liabilities immediately upon the receipt of the expense goods. Receiving Account (Receiving Account) To record the current balance of the material in receiving and inspection. Where to define in Apps: Define Organization                                          Define Receiving Options