IRISO (Internal Requisition Internal Sales Order)

Oracle IRISO Process

IRISO Stands for Internal Requisition Internal Sales Orders. IR ISO is used to transfer the material from one inventory organization or warehouse to another with in the same company. IR ISO tracks the material movement in the system.

Oracle IRISO process is designed only between 2 operating units.

Internal Requisitions can be raised to transfer goods between

1. Source and Destination inventory organizations in the Same Operating Unit.
2. Source and Destination inventory organizations Across Operating Units.

IRISO Process

IR ISO - Same Operating Unit
Oracle IRISO Process
IRISO Stands for Internal Requisition Internal Sales Orders. IR ISO is used to transfer the material from one inventory organization or warehouse to another with in the same company. IR ISO tracks the material movement in the system.

Oracle IRISO process is designed only between 2 operating units.

Internal Requisitions can be raised to transfer goods between

1. Source and Destination inventory organizations in the Same Operating Unit.
2. Source and Destination inventory organizations Across Operating Units.

IR ISO - Same Operating Unit

1. Create IR and associate Destination Inventory Org, Location and Subinventory
2. Approve IR.
3. Run Create ISO(Internal Sales Order) import process and Order Import Process
4. Internal Sales Order gets created.
5. Pick and Ship from the Source Inventory Organization.
6. Material will be available in the destination inventory.

IR ISO - Across Operating Units - OU1 & OU2

1. Create Internal Requisition in OU2(Destination OU)
2. Approve IR
3. Run Create ISO(Internal Sales Order) import process and Order Import Process
4. Internal Sales Order gets created in OU1.
5. Schedule Order and Issue demand in OU1.
6. Perform Pick Release and print picking documents.
7. Ship Confirm in OU1
8. Manual Receipt and Delivery of goods in OU2
9. Run Create Intercompany AR Invoices Concurrent Program.
10. Run Auto Invoice Master Program.
11. Run Create Intercompany AP invoices.
12. Run Payables import concurrent program.


--//IRISO QUERIES 

select *from oe_order_headers_all where creation_date like sysdate and order_source_id = 10 and order_number = 52;

--//order_source_id = 10 Represents Internal Orders.

select source_document_line_id from oe_order_lines_all where header_id = 26754334

select *from po_requisition_lines_all where requisition_line_id = 7246190

select *from po_requisition_headers_all where requisition_header_id = 7680038

Joins for Requisition and Order Management

1. OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_LINE_ID = po_requisition_lines_all.REQUISITION_LINE_ID
2. OE_ORDER_LINES_ALL.ORIG_SYS_DOCUMENT_REF   = po_requisition_HEADERs_all.SEGMENT1(Requisition Number)
3. OE_ORDER_HEADERS_ALL.ORIG_SYS_DOCUMENT_REF = po_requisition_HEADERs_all.SEGMENT1(Requisition number)

--//Internal Sales Order Query with all joins
SELECT porh.segment1,
porl.line_num,
pord.distribution_num,
ooh.order_number
sales_order,
ool.line_number so_line_num,
rsh.receipt_num,
rcv.transaction_type
FROM oe_order_headers_all ooh,
po_requisition_headers_all porh,
po_requisition_lines_all porl,
po_req_distributions_all pord,
oe_order_lines_all ool,
po_system_parameters_all posp,
rcv_shipment_headers rsh,
rcv_transactions rcv
WHERE ooh.order_source_id = posp.order_source_id
AND porh.org_id = posp.org_id
AND porh.requisition_header_id = ool.source_document_id
AND porl.requisition_line_id = ool.source_document_line_id
AND porh.requisition_header_id = porl.requisition_header_id
AND porl.requisition_line_id = pord.requisition_line_id
AND porl.requisition_line_id = rcv.requisition_line_id
AND pord.distribution_id = rcv.req_distribution_id
AND rcv.shipment_header_id = rsh.shipment_header_id

--//Simple Query for IRISO
select  distinct ooh.order_number,prh.segment1 from
oe_order_headers_all ooh
,oe_order_lines_all ool
,po_requisition_lines_all prl
,po_requisition_headers_all prh
where
ooh.header_id = ool.header_id
and ooh.order_source_id = 10
and prl.org_id = ool.org_id
and ool.source_document_line_id = prl.requisition_line_id
and prh.requisition_header_id = prl.requisition_header_id
and ooh.order_number = :l_order_number
and ooh.org_id = 7501;

--//IRISO With Delivery Details
select  distinct ooh.order_number,
prh.segment1 req_number,
ool.ordered_quantity ,
NVL(ool.shipping_quantity,0) shipping_qty,
ooh.flow_status_code Order_status,
ool.flow_status_code line_status
,NVL(wdd.delivered_quantity,0) delivered_qty
,NVL(wdd.shipped_quantity,0) shipped_qty
from
oe_order_headers_all ooh
,oe_order_lines_all ool
,po_requisition_lines_all prl
,po_requisition_headers_all prh
,wsh_delivery_details wdd
where
ooh.header_id = ool.header_id
and ooh.order_source_id = 10
and ooh.header_id = wdd.source_header_id
and ool.line_id = wdd.source_line_id
and prl.org_id = ool.org_id
and ool.source_document_line_id = prl.requisition_line_id
and prh.requisition_header_id = prl.requisition_header_id
and ooh.order_number = :l_order_number
and ooh.org_id = 7501;