OM Step related to its interface!! [message #235212] |
Fri, 04 May 2007 06:24 |
orappnewbie
Messages: 20 Registered: May 2007
|
Junior Member |
|
|
Hi All,
I need your help in OM cycle and its related Interface.
I know basic OM cycle.
Order Entry->Booking->Pick release->Shipping->Invoice
I know that for order entry & booking can be done by Order Import. I am not sure about other steps.
If any body has a script for all the interface steps and who can share the info i will be great full....
thanks in advance
|
|
|
Re: OM Step related to its interface!! [message #235282 is a reply to message #235212] |
Fri, 04 May 2007 13:08 |
prashant_pathak
Messages: 263 Registered: February 2006 Location: California,US
|
Senior Member |
|
|
Hi,
Following is the detail flow....i can come up with this much detail hope other member might point out if i am missing some thing
Order Cylce:
1)Enter Order
2)Book Order
3)Shipping Transaction :- Query with Order Number
4)Launch Pick Release for the Order
5)Release to Ware House , Move Order created and ready for Transact Move order
6)Inventory->Move Order->Transact Move Order, Query for your move order and allocate the material
so pick release and pick confirmation will be completed
7)material will be take based on FIFO of picking order in Subinventory
8)Shipping Transaction form:- Auto-Create Delivery
9)Shipping Transaction form:- Ship Confirm the delivery :-
Un check set delivery In-Transit and Close Trip
10)Delivery will confirmed
11)Shipping Transaction form:- Path By Stop :- will have Awaiting Pickup and Awaiting Drop Off
12)Shipping Transaction form:- Path By Stop:- Update Status to Close of Pickup - Status will picked
13)Interface Trip Stop will be executed and which will
remove the reservation and decreament the inventory
14)Shipping Transaction form:- Delivery and Trip will be in in-Transit status
15)Shipping Transaction form:- Path By Stop:-
Update Status to Close Drop Off - Status will be Dropped Off
16)Order Line Will be Close and Invoice detail will be interfaced to AR
So following are the interface/API based on above flow
Order Import
Pick release
Trip
Stop
Delivery
Delivery Details
Hope This Helps
Regards
Prashant Pathak
|
|
|
|
Re: OM Step related to its interface!! [message #235474 is a reply to message #235464] |
Sun, 06 May 2007 11:41 |
Daren_Ganga
Messages: 1 Registered: May 2007 Location: dfasd
|
Junior Member |
|
|
Pick release is the process where the Sales Orders brings the materials into stage Area.
For example think the following scenario. You had went to an Medical shop and ordered some medicines.
The Seller brings the medicines and keeps them on his desk
( A temporary area before you actually pack and deliver)
Ship Confirm is the process where you bring the material from the Staging Area and you place it in the Sales order.
It means the goods/Items are ready to ship for an Sales Order.
Coming to the Technical Discussions..Concentrate on the 2 Flags
OM_INTERFACED_FLAG AND INV_INTERFACED_FLAG which would give the total process.
-Ganga
|
|
|
Re: OM Step related to its interface!! [message #235751 is a reply to message #235474] |
Mon, 07 May 2007 19:05 |
orappnewbie
Messages: 20 Registered: May 2007
|
Junior Member |
|
|
thanks
can any one please verify following order interface insert for booking order? am i having all neccessary columns?
insert into oe_headers_iface_all
(order_source_id
orig_sys_document_ref
order_type_id
price_list_id
salesrep_id
created_by
creation_date
last_updated_by
last_update_date
operation_code
invoice_rule_id
payment_term_id
sold_to_org_id
sold_from_org_id
customer_name
booked_flag)
insert into oe_lines_iface_all
(order_source_id
orig_sys_document_ref
orig_sys_line_ref
orig_sys_shipment_ref
inventory_item
request_date
delivery_lead_time
ordered_quantity
order_quantity_uom
pricing_quantity
pricing_quantity_uom
sold_to_org_id
sold_from_org_id
invoice_to_org_id
invoice_rule_id
payment_term_id
created_by
creation_date
last_updated_by
last_update_date
)
|
|
|
Re: OM Step related to its interface!! [message #235993 is a reply to message #235751] |
Tue, 08 May 2007 11:36 |
prashant_pathak
Messages: 263 Registered: February 2006 Location: California,US
|
Senior Member |
|
|
Hi,
following min column for booking an order
Header
insert into oe_headers_iface_all
(
order_source_id,
orig_sys_document_ref,
order_type_id,
price_list_id,
created_by,
creation_date,
last_updated_by,
last_update_date,
sold_from_org_id,
sold_to_org_id,
invoice_to_org_id,
ship_to_org_id,
operation_code,
booked_flag
)
Line
insert into oe_lines_iface_all
(
order_source_id,
orig_sys_document_ref,
orig_sys_line_ref,
orig_sys_shipment_ref,
inventory_item,
request_date,
promise_date,
delivery_lead_time,
ordered_quantity,
order_quantity_uom,
created_by,
creation_date,
last_updated_by,
last_update_date,
operation_code,
payment_term_id,
unit_list_price,
pricing_quantity,
pricing_quantity_uom,
salesrep_id,
ship_from_org_id,
ship_to_org_id,
accouting_rule_id,
tax_exempt_flag
)
it could be less this column but i just tried with this column and it booked the order....
Regards
Prashant Pathak
|
|
|
|
Re: OM Step related to its interface!! [message #247063 is a reply to message #235212] |
Sat, 23 June 2007 07:29 |
ramesha.smiley
Messages: 19 Registered: August 2006 Location: Chennai
|
Junior Member |
|
|
hi Prashant,
I've got a component which is i need to develop an interface for ship confirm. SHIP CONFIRM INTERFACE.
I knew the order flow and infact i went thru this thread and it clearly shows the flows. i went thru the trm for shipping.
the base tables which needs to be populated are,
wsh_new_deliveries
wsh_delivery_details
i created staging table , wrapper and populated firstly the wsh_del_details_interface. then i did the same process and populated the wsh_new_del_interface, with the status code as either 'OP','CL','CO'. ofcourse, u know wat these lookup codes mean.
perhaps, i thought 'import delivery lines' available in shipping was the open interface available for importing delivery lines. Although the data doesn't want to be hit the base table. i dont know where i'm goin wrong. OR else do ive to take the order entry base tables into account while ship confirming.
please suggest me, coz im desperate.
another thing is, i'd also like to know when will the 'Inventory interface' and the 'Order Management Interface' programs run.
thanx
ramesh
|
|
|
|
|
Re: OM Step related to its interface!! [message #247086 is a reply to message #247083] |
Sat, 23 June 2007 14:45 |
prashant_pathak
Messages: 263 Registered: February 2006 Location: California,US
|
Senior Member |
|
|
see there are two things...
1)
order are being created by order import and than you want to move that order further by ship confirm and Auto Invoice automatically
2) there is no orders in the system just deliveries coming from External system ( all though this is bit wiered).
so here you have to load the data for delivery and run API
Let me know which one fits your case
Regards
Prashant Pathak
|
|
|
|
Re: OM Step related to its interface!! [message #317176 is a reply to message #247355] |
Tue, 29 April 2008 16:44 |
shree_z
Messages: 75 Registered: February 2008
|
Member |
|
|
Hi,
Does anyone have any thoughts regarding the above scenario?
Infact I am also stuck in the same scenario where our company deals with a third party which takes care of all the shipping, physically and ship confirms in their own custom application.
My need also is to develop an interface which can load all the data ,from the shipping info sent by the third party , into our Oracle ERP.
One suggestion so far from our business side is to run the Oracle Shipping execution Public APIs as a request set..
Any other thoughts welcome, what exactly could be the step I must follow, in this situation
Thanks in advance.
|
|
|