Sunday, October 24, 2010

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

Friday, October 22, 2010

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

Thursday, October 14, 2010

Internal Order Process Step by Step

After complete setup for Internal Order Process on Oracle EBS R12, We can walk through the following test flow: 


Step 1 - V1 Purchasing - Creating the Requisition
Navigation: V1 PO> Requisitions > Requisitions
  • In the Type Field - Enter Type to Internal Requisition
  • Click into the Lines Region on the Item field then Enter Item OVT_Internal_Order1 with Quantity 500
  • In the Destination Inventory Organization: Seattle Manufacturing
  • In the Location field: M1- Seattle Mfg
  • Approve the Requisition
Step 2 - V1 Purchasing - Submit the 'Create Internal Orders' process
Navigation: V1 PO > Reports/Run

  • Single Request - execute the request - 'Create Internal Orders'
This process is responsible for inserting data into the Oracle Order Management interface Tables.  One of the fields that is inserted is the location_id - and because Order Management uses Customers rather than locations  - this is why it is mandatory to assign the Internal Location to the Customer.  The location that is passed from purchasing  is correlated to a customer so as to allow the  Order Import to run successfully.


Step 3 - VS Order Management - Import the Internal Sales Order
Responsibility: Order Management Super User

Navigation:
OM > Orders, Returns > Import Orders > Order Import Request
  • Enter the parameters: Choosing Source Internal and Order Reference is the Requisition Number had been created before.
  • Submit the request and confirm it completes with success
Navigation: OM> Orders, Returns > Order Organizer
  • Enter Source Type is Internal then enter the requisition number
  • Choose Find and the Sales Order is presented - which confirms the order was imported
  • The corrections form should be used to confirm if any errors have occurred during the import if the sales order is not found

Step 4 - D1 Shipping - Execute Pick Release against the Sales Order
Navigation: OM > Shipping > Release Sales Order

  • Move to Inventory tab - and choose the source inventory organization
  • Enter the Internal Sales Order number - and adjust the ship dates to include the ship date on the order line
  • Move to the Shipping Tab - choose Yes for Autocreate Delivery and Auto Pick Confirm 
Choosing these settings will conduct the move order transaction automatically.
  • Choose Concurrent and Confirm the Pick Release process has completed with success
The pick release process is responsible for moving the quantity from the sub-inventory (selected during the miscellaneous transaction earlier) for the Source Organization - to the Staging sub-inventory.

Step 5 - D1 Shipping - Confirm Shipment of the goods
Navigation: OM > Shipping > Transaction

  • Enter the Internal Sales Order in the field 'From Order Number'
  • Choose Find and then move to the Delivery Tab
  • Next choose Ship Confirm from the actions and then the GO Button
Step 6 - M1 Inventory - Receive the goods
Responsibility: Purchasing Super User

Navigation: Receiving > Receiving Transactions Summary
  • Choose the Destination Inventory Organization
  • Change the source to Internal and enter the Item Number - choose transactions - and Click find 

Step 7 - D1 Inventory - Create Intercompany AR Invoice
Responsibility: Inventory
Navigation: Reports/Run

  • Single Request - execute the request - 'Create Intercompany AR Invoice' 
  • Run AutoInvoice in AR Vision Singapore(AR > Interfaces > AutoInvoice) if you had not setup it run automatically.
Step 8 - M1 Inventory - Create Intercompany AP Invoice
Responsibility: Inventory
Navigation: Reports/Run
  • Single Request - execute the request - 'Create Intercompany AP Invoice' 
  • Run the request - 'Payable Open Interface Import'.
This completes the steps for the internal order flow.

OracleValues Team