Search over 500+ Posts

Oct 7, 2009

Oracle R12 Internal Requisition and Internal Sales Order Process Flow.

In this blog I will explain the Process flow and Setup required to create Oracle Order Management Internal Sales order (ISO) from Internal requisition (IR)

What is internal sales order
A request within your company for goods or services. An internal sales order originates
from an employee or from another process as a requisition, such as inventory or
manufacturing, and becomes an internal sales order when the information is transferred
from Purchasing to Order Management. Also known as internal requisition or purchase
requisition.

Oracle Purchasing uses Order Import to transfer requisitions for internally sourced
products to Order Management. Once imported, the internal sales orders are processed
similar to regular sales orders.

Note: You can create requisitions (with same number) in two different operating units.

You can partially or fully cancel the line quantities on internal sales orders.
You can make the following attribute changes after an internal sales order has been generated:
Update Scheduled Shipment Date
Decrement order line quantity
Note: If you cancel an internal sales order, order line, or backordered order line that is linked to an internal requisition, manually cancel the internal requisition. The order cancelProcessing issues a reminder.

Test Case –
Item – IR Item004
Assign to Inventory Org M1 and M2
Create Requisition with Destination Org M1 and Source Org M2.Create Internal Sales Order in M2

1# Create Item IR Item4 , with “Purchased Item” as template , in Oracle Inventory Management.


2# Mark Item as Internal Order Enabled.


3# Assign Item to M1 and M2 Inventory Orgs.


4# Define Cost for Item Navigation >Costs >Item Costs







5# Update the cost
Navigation
     Costs
        Update Standard Costs
             Update Cost







6# Set the Internal Order Setup at Customer Ship To Site in Oracle Order Management.





7# Define Shipping Network setup Between M2 and M2 in Oracle Shipping.
Inventory > Setup > Organization > shipping Network





8# Define Purchasing Option Setup for Internal Sales Order and define
Internal requisition Order Type
Internal requisition Order Source.
in Oracle Purchasing Module



9#Create & Approve Requisition in Oracle Purchasing


Save and Approve Requisition.


10#submit “Create Internal Order” Concurrent program in Oracle Purchasing.


11#Submit Order Import




Query for Sales Order based on requisition Number.


12# Progress the Sales Order from Awaiting Shipping to Close.

23 comments:

  1. Hi ,

    Its a very useful post.thanks
    I have one doubt.In step 6, the second screen shot..i am not able to locate it... can u please help

    ReplyDelete
  2. This comment has been removed by the author.

    ReplyDelete
  3. It is in Customer setup.Please go to customer , under General Purpose tab

    ReplyDelete
  4. I want to change quantity after importing data from Internal Requisition. I have noticed that if "Status" flag has value "entered" then i am able to change sales order line quantity but by default "status" is "booked" and not allow to change the quantity value

    ReplyDelete
  5. Hi Michelle

    Please note that if you are in R12 and has latest patch set , you should be able to change the Quantity on a book Internal Order .
    Please note that you still need to disable the Processing Constraint
    Update Ordered Quantity
    Please refer my Post
    http://eoracleapps.blogspot.com/2010/02/internal-requisition-and-internal-sales.html

    ReplyDelete
  6. Dear,

    According to my business, I had been setup Processing Constraint - Slip Order Line, will its generate error ?

    ReplyDelete
  7. Hi! Harry

    Purpose of Processing Constraint is to add additional validation conditions or enforce some rules.you have stated that you are planning to add PC ( Slip Order Line), I am not sure what exactly it do , so it is difficulty to comment. Give me some additional details and I may able to assist you .

    Thanks

    ReplyDelete
  8. This is very good!

    Regards,
    Sandip Jadhav
    http://oracleprasan.blogspot.com

    ReplyDelete
  9. Hi,
    This is really very helpful explanation covering att pre-requisit set up and process cycle.

    Please assist me with my query, is it possible to do return of internal sales order in R12?

    Warm Regards,
    Abhigyan Visen

    ReplyDelete
  10. I am not sure if RMA for Internal Sales Order is possible . You can try for reverse IR and then ISO.

    What exactly is your requirement.

    Regards
    e

    ReplyDelete
  11. Hi, Its a nice post. Will ISO create Invoice?

    ReplyDelete
  12. no , ISO don't create Invoice in AR.

    Hope that helps

    ReplyDelete
  13. is RMA performed in ISO? if so how

    ReplyDelete
  14. I don't think RMA is possible in case of ISO...What exactly is your requirement...

    ReplyDelete
  15. Once ISO is closed, Should the IR also be closed or will IR get closed

    ReplyDelete
  16. how to reverse IR and then ISO

    ReplyDelete
  17. could you please provide me the screnn shots to reverse the IR

    ReplyDelete
  18. Once ISO is closed IR will closed too.

    ReplyDelete
  19. Hi:
    I'm having issue with the price default on the Internal requisition.$0 price is getting defaulted on the IR item lines. The environment is OPM enabled organization. Any advise in this regard? OPM costing is enabled, item is costed and cost type is standard cost and the cost of the item is active in the current period. If you know the solution then please advise.

    Best Regards,
    Prashanthi Chennupati.

    ReplyDelete
  20. Hi:

    I'm having issue with the price default on the Internal requisition.$0 price is getting defaulted on the IR item lines. The environment is OPM enabled organization. Any advise in this regard? OPM costing is enabled, item is costed and cost type is standard cost and the cost of the item is active in the current period. If you know the solution then please advise.

    Best Regards,
    Prashanthi Chennupati.

    ReplyDelete
  21. I am not sure about integration between Pricing and Requisition , but will try to find out some information...

    ReplyDelete
  22. Very helpful.

    Thanks alot.

    Arsalan

    ReplyDelete
  23. Very good document.

    Thanks.

    ReplyDelete