Oracle EBS OM
文章平均质量分 80
田攀
tian.pan@qq.com
展开
-
Delivery Lines Splitting
分拆Delivery的情况有很多种,有因为包装要求的主动分拆,还有因为延迟发货的被动分拆1.延迟发货(backorder)的被动分拆库存数量不足,Delivery会被分拆,有货部分先发,没货部分会被backorder,等有货了再发。下图就是因为库存数量不足引起的分拆,订单需要120的数量,但库存中只有100的数量,这样就会分拆成两行,第一行发运单数量为100,第二行为20原创 2012-05-08 11:50:26 · 2335 阅读 · 0 评论 -
Using the this API wsh_deliveries_pub.Delivery_Action to ship confirm for the delvery
CREATE OR REPLACE procedure cc_shippingasl_return_status VARCHAR2(2000);l_msg_count NUMBER;--l_msg_data VARCHAR2(1000);pp_init_msg_list VARCHAR2(10) := FND_api.G_FALSE;pp_return_values VARCHAR2原创 2012-12-06 18:48:56 · 7007 阅读 · 0 评论 -
Interface Trip Stop - SRS
In Oracle Shipping, Interface Trip Stop (ITS) will be trigger at the time of Shipping confirm if check box “Defer Interface” is not check.Navigation:Order Management > Shipping > Interface > Run > Req原创 2013-03-01 10:49:38 · 7624 阅读 · 0 评论 -
OM:Over-ship Tolerance
订单(Order Management)流程,发运数量(Shipped Qty)可以超过实际的订单请求数量(Requested Qty),最终会以发运数量为准。在订单的Shipping页签,设定"Over-ship Tolerance",这个值是一个百分比,是指可以超发多少比例的数量(这个字段如果隐藏,可从Folder中显示出来)超发的数量/订单请求数量不能大于Over-ship Toleranc原创 2013-03-29 17:29:31 · 3357 阅读 · 0 评论 -
Creating a Customer at the time of creating a Sales Order
Profile:OM: Add Customer允许可以在定义销售订单时,快速添加一个新的客户None:表示不允许使用快速添加客户功能。All:表示既可以添加新客户,也可以为已经存在的客户添加地址及联系人。Address and Contact Only:仅能为已经存在的客户添加地址及联系人原创 2013-03-25 15:22:00 · 2485 阅读 · 0 评论 -
MTL_SALES_ORDERS
Once Sales Order get booked, There will be record go into mtl_sales_orders.Unlike account numbers which are stored as flexfields in GL_CODE_COMBINATIONS, or purchase orders which are stored in PO_HEAD原创 2013-02-06 16:41:50 · 4601 阅读 · 0 评论 -
Order Management Useful Scripts
Listed some useful queries scripts for Oracle Order Management Flow.(For Order Management Detailed Flow, You may check my previous post: Oracle EBS订单的流程(Order->AR): http://blog.csdn.net/pan_tian/artic原创 2013-04-08 12:26:31 · 16990 阅读 · 0 评论 -
Internal Sales Order (ISO) Process Flow
本文介绍下内部销售订单Internal Sales Order(ISO)在Oracle EBS中的流程,内部销售订单和组织间转移(Inter-Organization Transfer,IOT)的作用是类似的,都是用于在库存组织间实现物料转移。只是使用的场景不尽相同,Inter-Organization Transfer(IOT),一般适用于,操作者同时具有来源组织和目标组织物料控制的权利,那么直原创 2013-04-27 00:36:52 · 7591 阅读 · 0 评论 -
Sales Order Related Scripts
--Line Ids Associated With This Order NumberSELECT LIN.LINE_ID LINE_ID, TO_CHAR(LIN.line_number) || DECODE(LIN.shipment_number, NULL, NULL, '.' || TO_CHAR(LIN.shipment_number)) || DECODE(LIN.optio原创 2013-05-08 16:32:29 · 7749 阅读 · 0 评论 -
SAMPLE SCRIPT TO CREATE SALES ORDER USING OE_ORDER_PUB.PROCESS_ORDER
Use Of Oe_Order_Pub.Process_Order To Create Sale OrderProcess Order API is a PL/SQL packaged procedure which can be used to manipulate the sales order data by performing Insert, update or delete opera原创 2012-12-06 18:35:56 · 10130 阅读 · 0 评论 -
Oracle EBS Advanced Pricing Tables
TablesQP_LIST_HEADERS_BQP_LIST_HEADERS_B stores the header information for all lists. List types can be, for example, Price Lists, Discount Lists or Promotions.QP_LIST_LINESQP_LIST_LINES stores all li原创 2012-11-20 18:14:03 · 9214 阅读 · 0 评论 -
Oracle Back to Back Process Flow
什么是Back to Back Order?简单的说,B2B是我们从供应商那拿货,然后收到货后,再发运给客户。.B2B FlowB2B的例子1.Item的定义Item Should be customer Orderable and PurchasableIt should be ATO(Assemble to Order) marked in OM原创 2012-07-27 15:33:10 · 6127 阅读 · 0 评论 -
Dropship的流程
做的一个Dropship流程的实录(包括流程期间遇到问题的解决)What are the advantages of Drop Shipment Orders?These are the benefits:No inventory is requiredReduced order fulfillment processing costsReduced flow timesEli原创 2012-04-06 15:52:50 · 10460 阅读 · 1 评论 -
使用脚本关闭订单头
订单的关闭是自动的,在所有行工作流结束(Close或者Cancel)后0.5天,订单头也将在Workflow Background Process的推动下关闭。还有另外一种说法:you can wait until month-end and the “Order Flow – Generic” workflow will close it for you.所以造成了很多时候订单行已经关闭原创 2012-06-27 17:34:58 · 4374 阅读 · 0 评论 -
[Script]Backordered Problematic delivery detail
脚本用于Backorder有问题Delivery Detail(比如关联的Move Order丢失...),可以backorder Delivery后,再重新Pick Release;如果不想要这个订单了,可以Backorder后,Cancel销售订单,并通过NOTE:1322105.1来删除多余的Reservation。UPDATE wsh_delivery_assignments原创 2012-06-27 17:44:23 · 2779 阅读 · 0 评论 -
Pick Release 代码流程图
OM模块的Pick Release用的比较多,里边涉及的分支比较多,总结了一下方便查阅For pdf version,you can download via "Pick Release Process_v3.pdf"转载请注明出处:http://blog.csdn.net/pan_tian/article/details/7527908======EOF======原创 2012-05-02 14:18:12 · 3552 阅读 · 0 评论 -
OM System Parameter: Reservation Time Fence
OM System Parameter: Reservation Time FencePath:Order Management > Setup > System Parameters > Values > "OM System Parameters" FormAbout parameter "Reservation Time Fence",It means "Time(in days原创 2012-07-13 16:54:01 · 4202 阅读 · 0 评论 -
Picking Release Parameter
Picking Release Parameter"Auto Allocate"Path:OM > Shipping > Setup > Shipping Parameter > Pick Release tab >Parameter "Auto Allocate"If check this,while perform "Launch Pick Release" in shippi原创 2012-07-13 17:27:40 · 2266 阅读 · 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 Transactio原创 2012-06-27 16:23:33 · 9106 阅读 · 1 评论 -
Back to Back vs Drop Shipment
两个流程很类似,都要创建PR和PO给供应商,主要区别在于谁来发货。B2B是我们从供应商那拿货,然后收到货后,再运送给客户;Dropship表示销售是从我们这里发出,但是是由供应商直接给客户发货,我们分别和客户,供应商开应收,应付发票。(关于Dropship的流程,可以参见我的另外一篇文章:Dropship的流程Difference between b原创 2012-07-27 15:38:56 · 6329 阅读 · 0 评论 -
Oracle EBS订单的流程(Order->AR)
基本流程创建订单路径:Order Management > Orders,Returns > Sales Orders填写订单头信息,客户,订单类型,销售人员填写订单体信息,输入物料,数量...然后Book Order,订单Book之后,你会发现订单头的Status的状态变成了“Booked”,订单行的状态为"Awaiting Shipping",记录下来你的订单号,后边的每一步都需要这个订单号。原创 2012-06-26 18:34:45 · 48150 阅读 · 7 评论