IR-ISO cycle Techno Functional Overview

One of the cycles being setup and used in the business is the Internal Requisition and Internal Sales Order Cycle commonly known as IR-ISO Cycle.

The complete setup of the system needs to be done when doing the IR-ISO cycle . below we are highlighting some of the basic Setups to be done for an IR-ISO cycle, then we will give a brief overview of the Steps occurring in the IR-ISO Sycle
1. Item Setup : The items we wish to be ordered for IR-ISO need to have the Internal Order and Internal Order Enabled Flag checked for the Transaction , Item Validation and Item Master Warehouse
2.Shipping Networks need to be setup  between the Shipping and the Receiving Warehouse

3. The customer Setup should be completed : The customer for whom the internal Order is created the SHIP TO site must be setup with the Internal Location and Internal Warehouse of of the Shipping Warehouse

4. Purchasing Option Setup need to be updated with the Internal Order Type

Once the Setup is completed  we can perform the IR-ISO cycle

1. Create the Internal Requisition and save It
      > Entry is made in the table po_requistion_headers and po_requisition_lines table , Current Status          of the the Requisition is Incomplete
2. Approve the Requisition
     > The Requisition is now Approved
3. Run the Standard Oracle Program "Create Internal Order"
     > This program creates the Sales Order from the Internal Requisition , the program picks up the             information of the Requisition and Populates the information in the Order in the Order Interface         table oe_headers_iface and oe_lines_iface
4. Run the Program "Order Import"
    > This Program will complete the Order Import and Sales Order will be available in Oracle
5. Query the Sales Order using requisition information and Complete the Order cycle
   > From back end the column : source_document_line_id of oe_order_lines table will be have the po_requisition line id
6. Once the Order is picked and Ship the Internal Requisition is now eligible for receiving
7. Perform the Requisition receiving
   > Information comes in the Table : rcv_shipment_headers , rcv_shipment_lines, rcv_transactions

This is the total flow of information in IR-ISO and overview of the basic tables affected