Category Archives: INV

Issuing Miscellaneous Receipt

Create stock for item using Miscellaneous Receipt

Navigate to Inventory > Transactions > Miscellaneous Transaction, and enter the following information:
Type : Miscellaneous receipt
Click on the Transaction Lines button


Save the Record after entering the Quantity:



Check the On Hand Quantity by Navigating to Inventory –> On-hand, Availability –> On-hand Quantity :


Check the Availability:


Inventory Organization Overview

Inventory Organization Overview

Let us see the basic structure of the definition of an inventory organization by looking at the data already defined in the Vision database.
Note: Do not change any data we see below.
Change the Responsibility to Inventory and Navigate to Setup –> Organizations –> Organizations.

Query by the name ‘Seattle Manufacturing’. This is the organization (organization code M1) we commonly use in the Vision Database to create Inventory transactions, including shipment of sales orders. Notice the entry ‘Inventory Organization’ under Organization Classifications. Place the cursor on that row, and click on the button Others.


Select ‘Accounting Information’ from the list.

  • Place cursor anywhere in the Accounting Information field to see details.
  • Notice this is where the organization is associated with its ‘Set of Books, Legal Entity and Operating Unit’.
  • The concept of Operating Unit will often come up, so it is good to know where this relationship is defined, ie. which Operating Unit the Inventory Organization (warehouse) belongs to.
  • Close the Accounting Information window and Additional Organization Information screen.



Place the cursor on the classification Inventory Organization again, click on the Others button and select ‘Inventory Information’ from the list.

  • Notice this is where the Inventory organization parameters are defined.
  • This screen can also be accessed directly from Inventory > Setup > Organizations > Parameters.
  • Notice this is where the organization code ‘M1’ is specified, and the Item Master Organization is specified as ‘Vision Operations’ (V1). This sets the relationship for Seattle Manufacturing (child org) and Vision Operations (master org).



As an optional step, you can query the organization ‘Vision Operations’ and check that it is classified as both a Legal Entity and Operating Unit as well as an Inventory Organization. If you check the Inventory Organization Parameters for ‘Vision Operations’ you will notice that the organization code is defined as ‘V1’. The master org is itself.

As another optional step, you can go to Edit > Preferences > Profiles, and run a query with the profile name ‘MO:%’. You will see the value for the profile option ‘MO: Operating Unit’ being ‘Vision Operations’. This is the Operating unit in which the OM transactions are created when logged into the responsibility used in this testflow (for R11i).

Reference: oracle metalink


Create Purchasable Item


Create a New Item used in Order to Cash Flow

Create an item that will be entered in the sales order.

Change the Responsibility to Inventory and Navigate to Items –> Master Items:

When Prompted select the Organization as V1 or M1 which is the Master Organization. Even when M1 is selected which is an inventory Org V1 would be displayed for creating the Item in the Master Org. We want to create the item in M1 and the ship the item from M1.

Enter a name for the Item and Description as shown below.


Go to Tools –> Copy From.
Select the Template ‘Purchased Item’.
Click on ‘Apply’ and then click on ‘Done’.



The seeded template ‘Purchased Item’ will assign the necessary item attributes to go through this basic OM testflow. For example, check some of the following item attributes that you did not need to set manually because they were assigned from the template.

Got to Inventory tab and we can see Inventory Item, Stockable, Transactable, Reservable flags are checked.
Go to Order Management tabĀ  (click on the arrow to the right of all the tabs) and can see
Customer Ordered, Customer Orders Enabled, Shippable, OE Transactable flags are enabled Automatically by selecting the Template.

So far defined the item in the Item Master Organization, V1. Next, go to Tools > Organization Assignment. Alternatively, click on the 3rd tab on the left side of the screen as circled in red in the below screenshot.

This is where you will find a list of organizations (child organizations) that have V1 as their master organization. M1 shows at the top if we have selected M1 while changing the Organization while creating the Master Item. The item attributes defined in V1 can be assigned to the child organizations by checking the Assigned box.


We can use the Assign All button to Assign the Items to all the Inventory Organizations. Check the Assigned box as shown above for the organization M1. Items needs to be enabled in the organizations in which they will be transacted.

Use the below SQL to Check the Details:

Finding the organization code of the organization_id’s from Inventory parameters using below SQL:

The item attributes can be changed at each individual child organization level by clicking on the Org Attributes button in the screenshot above, or by going to Inventory > Items > Organization Items. Note, however, that this depends on whether the item attribute is controlled at the master org level or the child org level, which is defined in Inventory > Setup > Items > Attribute Controls.