随笔分类 -  Oracle EBS OM

[Script]Backordered Problematic delivery detail
摘要:脚本用于Backorder有问题Delivery Detail(比如关联的Move Order丢失...),可以backorder Delivery后,再重新Pick Release;如果不想要这个订单了,可以Backorder后,Cancel销售订单,并通过NOTE:1322105.1来删除多余的Reservation。UPDATE wsh_delivery_assignments SET delivery_id = NULL, parent_delivery_detail_id = NULL, last_updated_by ... 阅读全文

posted @ 2012-06-27 17:44 h2内存数据库 阅读(316) 评论(0) 推荐(0) 编辑

使用脚本关闭订单头
摘要:订单的关闭是自动的,在所有行工作流结束(Close或者Cancel)后0.5天,订单头也将在Workflow Background Process的推动下关闭。还有另外一种说法:you can wait until month-end and the “Order Flow – Generic” workflow will close it for you.所以造成了很多时候订单行已经关闭了,但订单头还是处于Booked状态,这个时候如果你想Close订单头,你可以手动运行Workflow Background Process来关闭订单,也可以使用脚本来close Order Header.脚 阅读全文

posted @ 2012-06-27 17:34 h2内存数据库 阅读(247) 评论(0) 推荐(0) 编辑

Order&Shipping Transactions Status Summary
摘要:Order&Shipping Transactions Status SummaryStepOrder Header StatusOrder Line StatusOrder Flow Workflow Status (Order Header)Line Flow Workflow Status (Order Line)Shipping Transaction Status(RELEASED_STATUS in WDD)1. Enter an OrderEnteredEnteredBook Order ManualEnter – Line N/A2. Book the Order... 阅读全文

posted @ 2012-06-27 16:23 h2内存数据库 阅读(273) 评论(0) 推荐(0) 编辑

导航