Routing Process in Oracle

       
When a purchase order is created and sent to the supplier, on receiving the delivery for the PO       receiving of  the goods needs to be performed. This process is governed by the receiving/routing process in Oracle which is defined the different Routing Processes.

There are 3 types of Routing Mechanisms available in Oracle

1. Direct Delivery

2.Standard Routing

3.Inspected Routing

       The routing Mechanism to be followed depends on the routing mechanism defined in Oracle. the Routing mechanism to be used when receiving the goods can be defined at item level, supplier level or when doing the Warehouse setup

Routing Setup at Item Master

Routing method definition at Warehouse Setup

Routing Method defined at supplier level

In case the routing mechanism is defined at all the levels, oracle follows the below precedence to determine

which method to apply. Item --> Supplier --> Warehouse setup ie if the routing rule is defined at item master it is picked up else check at supplier level and lastly warehouse setup.

1. Direct Delivery

It is a single step receiving process, the goods are directly delivered to the specified location in the warehouse

Steps:

1. PO is created and sent across to the supplier.
2. On receiving the receipt information from the supplier the user created the receipt in the system , Navigation : Purchasing --> Receiving --> Receipts, search for the expected receipt. Enter the required shipping details and save the transaction
3. When the Receiving Transaction Processor Runs, the goods will be received in the system and the user can see the on-hand being increased by the units received.

On the technical front, In Direct delivery only the DELIVER transaction gets created in the table rcv_transactions, there is nor RECEIVE transaction being created.

2. Standard Routing

It is a 2 step receiving process

1. Po is Created and sent across to the supplier
2. On receiving the receipt information from the supplier the user created the receipt in the system , Navigation : Purchasing --> Receiving --> Receipts, search for the expected receipt. Enter the required shipping details and save the transaction
3. The receipt is created in the system
4. When the physical delivery of goods is received at the warehouse then the user performs the actual receiving of the goods which causes the onhand to increase.

When the receipt is first created in the system and the Receiving Transaction Processor is run the RECEIVE transaction in created in the system. this transaction signifies that the business has received the shipping details from the suppliers hence an expected receipt is created in the system

On receiving the actual goods at the warehouse , receiving of the goods is done against the receipt. When the Receiving Transaction Processor is run in the system, a DELIVER transaction is created in the system which signifies the actual receipt of goods in the Warehouse.

In standard routing, 2 entries are made in the table rcv_transactions, the first is made when the receipt is created in the system --> this transaction causes the creation of the RECEIVE transaction. When the actual receipt of goods are performed against the receipt the DELIVER transaction is created.

In case the user wishes to perform the INSPECTION action too he can do it but this step is entirely optional, In case inspection is performed entry will be made in the table rcv_transactions for INSPECTION as well.

3. Inspected Routing

It is a 3 step receiving process

1. Po is Created and sent across to the supplier
2. On receiving the receipt information from the supplier the user created the receipt in the system , Navigation : Purchasing --> Receiving --> Receipts, search for the expected receipt. Enter the required shipping details and save the transaction
3. The receipt is created in the system
4. When the physical delivery of goods is received at the warehouse then the user performs the task of Inspection. The user inspects the goods to check if it is as per the business requirements
5. If the inspection is successful the user will perform the Receiving of the goods in the system causing the onhand to increase.

When the receipt is first created in the system and the Receiving Transaction Processor is run the RECEIVE transaction in created in the system. this transaction signifies that the business has received the shipping details from the suppliers hence an expected receipt is created in the system

On receiving the actual goods at the warehouse ,Inspection of the goods is done at the warehouse, In case the inspection is successful an ACCEPT transaction is created in the system, After successful inspection of the goods receiving of the goods is done against the receipt. When the Receiving Transaction Processor is run in the system, a DELIVER transaction is created in the system which signifies the actual receipt of goods in the Warehouse.

In case the step of Inspection fails i.e in case the shipped goods do not match the business criteria then the user will Reject the received goods. In case of rejection a REJECT transaction is created and a entry for the same is made in the table rcv_transactions

In Inspected routing, 3 entries are made in the table rcv_transactions, the first is made when the receipt is created in the system --> this transaction causes the creation of the RECEIVE transaction. On successful inspection of the goods ACCEPT transaction is created .When the actual receipt of goods are performed against the receipt the DELIVER transaction is created.

In case the inspection fails then the below transactions get created in the table rcv_transactions,  the first is made when the receipt is created in the system --> this transaction causes the creation of the RECEIVE transaction. When inspection of the goods fail then REJECT transaction is created .