Author Archives: All Oracle Apps

Order to Cash Cycle

Create Generic Sales Order

Navigate to Orders, Returns > Sales Orders and make sure the following information is entered. Now we can Notice that some of these fields (in addition to others), get defaulted based on  the Defaulting Rules setup.


Make sure the Ship To/Bill To Locations are defaulted in.
Order Type : Mixed
Price List : Corporate
Salesperson : No Sales Credit
and in Others tab
Payment Terms : N30
Warehouse : M1.

Go to the Line Items tab, and enter the following information as shown in the screen shot:

In the Pricing tab, notice that the Price List Corporate has defaulted from the Header, and that the List Price 100 is the price you set up in the price list. The Unit Selling Price is the same as the List Price in this example, but it will show a different value if there is a discount or surcharge applied to the list price. For example, if you apply a 10% discount modifier, the List Price will be 100 and the Selling Price will be 90. We can apply line price adjustments through the Actions Button which shows as an LOV. The modifier details like rate of adjustment,  adjusted amount and extended price will appear.


In the Shipping tab, notice that the Warehouse is M1. This is the warehouse from which the item will be shipped out to the customer.


Save the Order.
Now increase the on hand Quantity of the Item in M1 inventory Org by doing a Miscellaneous Transaction of Receipt type.

Change the Organization to M1 and Navigate to Transactions –> Miscellaneous Transaction



Once the Record is saved we can find a Material Transaction Entry is created as well and can be seen from Transactions –> Material Transaction. Pass the Item Number as the Parameter and Click on Find to view the transaction.


A transaction Entry would be found for the Miscellaneous Transaction Created.


Now navigate to the Sales Order and Query for the Order we have Created which is 66429.


Now Click on the button ‘Book Order’ in the header or lines.

Once the Order is Booked we should see a note saying Order has been booked. Notice the status of the order header has changed from Entered to ‘Booked’, and the status of the line (check the Status field in the Main tab of the lines) has changed from Entered to ‘Awaiting Shipping’.

Once the Order is Booked a soft reservation is created and records are inserted into MTL_DEMAND, MTL_RESERVATIONS, OE_ORDER_LINES_ALL, OE_ORDER_HEADERS_ALL.

Once the Order is Booked we can see the Order Status Changed to Booked and Line Status Changed to Awaiting Shipping.



At this is the point that a ‘delivery detail’ will be created in Shipping that is associated with this order line. As an optional step, you can check the following.
Navigate to Shipping > Transactions
Enter your order number and click on Find
In the Lines/LPNs tab, you should find the delivery detail with
Line Status = Ready to Release and Next Step = Pick Release, which we will do next.

You can get more information on the table/API details in the Scripts API/Interfaces Section.






Assign item to Price List

Assign item to and existing Price List

Before adding the Item to the price list make sure the following Profile Options are set as below:

Change the Responsibility to System Administrator and Navigate to Profile –> System Profile and Search for QP: Source System Code


The QP: Source System Code at user level should be set to Oracle Pricing as the Oracle Pricing Manager or Equivalent Responsibility can modify the existing Price List.

Navigate to Profile –> System Profile and Search for QP: Pricing Transaction Entity. We can very well use the Search criteria for Modifying from the Profile Options Form.


QP: Pricing Transaction Entity should be set to Order Fulfillment.

Navigate to Profile –> System Profile and Search for QP: Security Control


QP: Security Control at site level should be OFF so that user can change the Price list or add the item to the existing Price List.

1. Navigate to Oracle Pricing Manager, Vision Operations à Price Lists > Price List Setup. You could create a new price list, but in this testflow, we will assign your item to an existing price list ‘Corporate’.
Query the price list ‘Corporate’.

2. Move the cursor to the List Lines section, and add a new line using Ctrl + Down Arrow on your keyboard, or by going to File > New. Enter the following information :
Product Context : Item
Product Attribute : Item Number
Product Value : AOAOTC1
Value : 100
The rest of the required fields should default in.

Let us add our item AOAOTC1 to existing price list Corporate and add a valid Price to the item.


Let us enter the Price as 100.

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.