Internal Order Process Notes

In Internal Order Process, there are some note you need to know:

1-After run "Order Import Request", Sales Order had been created:

• The Sales Order Type being chosen from Purchasing Options (Navigation: PO > Setup > Organizations > Purchasing Option).
• The Sales Order line Schedule Ship Date is coming from the Internal Requisition Need-By Date.
• The Unit selling price gets passed from the Internal Requisition or item cost from the source organization.
• Sales Order lines are always created with Calculate Price Flag as 'N'. You can forcefully changes the Calculate Price Flag to 'P'.
  

2-After do the Ship Confirm for the Sales Order. You change to Purchasing Super User for receive the quantity that is delivered on the Internal Requisition but can not find Receiving Transaction. This error may occurs when default SubInventory is not defined in the destination Org. To fix this error do the following steps:

• Query the Item in the Item Master, Move to the Receiving Tab and enter a Default Receiving Subinventory in the lower-right corner.
• Then, navigate to INV > Transactions > Transaction Open Interface, find the Item Error
• Select the record in error, choose 'Submit' checkbox and save.
• Finally, run the 'Inventory interface transaction manager' for process the record using the new default SubInventory.

OracleValues Team

Drop Ship SO Cycle in Oracle Order Management (Part 1/5)

1)What is “Drop Ship” ?

Drop Ship is a method of product delivery which the vendor accepts payment for an order, but the buyer receives the product(s) directly from the manufacturer. In a drop shipping arrangement, the vendor will be a middleman between the manufacturer and the buyer. The profit in this transaction is come from difference between the wholesale and retail price of the items sold.

2)Drop Ship in Oracle Order Management

Order Management  allows you to create Drop Ship SO which means you can receive orders for products that do not have in your inventory and you have a vendor provide the products directly to your customer.

3)Flow of  Drop Ship Sales Order

  (1). Create SO

  (2). Book SO

  (3). Progress SO

  (4). Release Purchase Order (Purchase Release concurrent)

  (5). Import Requisition / Auto create Purchase Order (Purchasing response)

  (6). Receive the material against purchase order

  (7). Invoice creation in AP

  (8). Invoice creation in AR

  (9). Complete line and Close Order

4)Benefit of Drop Shipment Order

Drop shipping is very useful for smaller retail shops, internet-only storefronts and those who primarily use catalogs for sales. A representative product may be displayed on the store's shelves or pictured in its catalog, but the actual product purchased may be sitting in a factory 1000 miles away. The following are some benefit of this method:

 + Do not need inventory

 + Reduce flow times

 + Elimination of losses on non-sellable products.

 + Reduced shipping to customer

 + No need packing and shipping costs.

 + Vary your product to customers.

OracleValues Team

How to using Dual UOM in Oracle Order Management R12

Some case business, we purchase items in 1st UOM and need to receive/issue them in a 2nd UOM. In this post, we explain how to setup Item use dual UOM (Unit of Measure) for create Sales Order in Oracle Order Management (Oracle R12):
 1) Create new Item
   - Navigate to Inventory > Item > Master Item

    - Note that Defaulting is set to "Default"

 2) Define conversion between 1st UOM and 2nd UOM of this Item
  - Navigate to Inventory > Setup > UOM > Conversion

 
 3) Create Sales Order
  - Navigate to Order Management > Order, Organizer > SO

  - Because we set Defaulting value to "Default" in step 1, so when we input the Quantity, its auto calculate the Second Quantity use the UOM conversion defined in step 2. If you want to change default quantity value, enter and choose "No" when the message appear.

OracleValues Team

Can not import Internal Requisition to Oracle Order Management

When working with Internal Order Process, I had met the following error:
1-Create Internal Requisition and Approve it.
2-Run "Create Internal Order" concurrent request
3-Run "Order Import" concurrent request in Oracle Order Management module.
4-Use Order Organizer  to find Internal Sales Order that created, but can not found.

I had do step by step below to track and fix this issue:

a)Check the data of Internal Requisition in interface table, I use these SQL:

SELECT orig_sys_document_ref
FROM oe_headers_iface_all
WHERE order_source_id = 10
AND orig_sys_document_ref IN( SELECT requisition_header_id
   FROM po_requisition_headers_all
   WHERE segment1= '&IR_num');

SELECT orig_sys_document_ref
FROM oe_lines_iface_all
WHERE order_source_id = 10
AND orig_sys_document_ref IN( SELECT requisition_header_id
  FROM po_requisition_headers_all
  WHERE segment1= '&IR_num');

After run those SQL, the result is no row, so there is no date on interface table

b)I run the following SQL to check the Internal Requisition already import to Sales Order or not?

SELECT 'Exists in OM main'
FROM oe_order_headers_all
WHERE order_source_id =10
and source_document_id in ( SELECT requisition_header_id
  FROM po_requisition_headers_all
  WHERE segment1= '&IR_num');

SELECT porh.segment1 purchase_req, ooh.order_number sales_order,
ool.line_number so_line_no, porl.line_num pur_req_line_no
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
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 ooh.org_id = posp.org_id
AND ool.header_id = ooh.header_id
AND ool.orig_sys_line_ref not like '%OE_ORDER_LINES_ALL%'
AND ool.source_document_line_id is not null
AND porh.segment1 = '&IR_num';

Its still no record, that mean this Internal Requisition has not been imported and not in interface table yet.

c)I don't know why this internal requisition can not import but the transfer flag is set to 'Y'. I tried to update this Flag and run process again (Recommend do this in Test Instance first):

UPDATE po_requisition_headers_all

SET transferred_to_oe_flag = 'N'
WHERE requisition_header_id = '&req_header_id';

Run the 'Create Internal Orders' again.
Run the 'Order Import Process' then check the Sales Order had been created.

OracleValues Team

Can not enter Item in Price List

That is my experience, first-time I setup new Ledger, new Operating Unit, new Inventory Organizations, new Items. After that, I had been test my setup: create Purchase Order, do Receipt of Purchase Order, create Miscellaneous Issue transaction,... everything work fines. But when I test with Oracle Order Management module, I had a problem with create Price List, I can not create Price List with Item, can not enter Item in OM Price List.
After check all again, I found that I had lost one step: setup system profile "QP:Item Validation Organization":

• Navigate to System Administrator > Profile > System

• Query on QP%Item% then select Master Org for this profile value. 

• Save, complete step

 Sometime, we can not enter value for this profile option. We can fix this error by setting the Profile options "HR: Business Group"

OracleValues Team