两个很妖的问题折磨

昨天12多才回去,一直被两个很妖的问题迷惑,记录下来,纪念一下[@more@]

第一个,挑库请求, 本来在开发环境没有问题,可是换到培训环境,竟然在刚开始的时候 OE_PICK_BATCH_ALL里面没有数据. 后来查来查去,关键集中在:

SELECT oh.header_id, ol.line_id, ol.inventory_item_id,
ol.pricing_quantity, oh.ORDER_NUMBER
FROM oe_order_headers_all oh,
oe_order_lines_all ol,
fnd_lookup_values lv,
wsh_delivery_line_status_v wdl,
ra_salesreps_all raa,
ra_terms_b rt,
xx_order_headers_all toh,
hz_cust_accounts hca
WHERE oh.header_id = ol.header_id
-- and oh.ORDER_NUMBER='234'
AND oh.attribute1 = 'Y'
--AND ol.flow_status_code = 'AWAITING_SHIPPING'
AND oh.org_id = 101
AND lv.lookup_type = 'SHIP_METHOD'
AND oh.shipping_method_code = lv.lookup_code
AND lv.LANGUAGE = 'ZHS'
AND wdl.source_code = 'OE'
AND NVL (oh.attribute15, 'N') != 'Y'
AND wdl.source_line_id = ol.line_id
AND wdl.pick_status = 'R'
AND raa.salesrep_id = oh.salesrep_id
AND raa.NAME = NVL ('', raa.NAME)
AND oh.freight_carrier_code =
NVL ('', oh.freight_carrier_code)
AND rt.term_id = oh.payment_term_id
AND rt.prepayment_flag =
DECODE ('',
'Y', 'N',
'N', 'Y',
rt.prepayment_flag
)
AND oh.order_number = toh.order_number(+)
AND toh.city(+) = NVL ('', toh.city(+))
AND toh.city(+) <> ''
AND hca.cust_account_id = oh.sold_to_org_id
AND hca.account_number >=
NVL ('', hca.account_number)
AND hca.account_number <=
NVL ('', hca.account_number)
AND oh.order_number >= NVL ('', oh.order_number)
AND oh.order_number <= NVL ('', oh.order_number)
AND lv.meaning = 'EMS'

这里好像找不到数据,可是今天上午的时候,我查来查去竟然正常了,我什么都没有修改!!!可能是打了补丁

一个补丁 patch: 4363740

挑库不成功原因检查 :
1.订单行状态 awaiting shipping 等待发运
2.attribute1 , attribute15
3.波次属性设置发运方法
4.订单BOOKED

第二个,货签连接里面, 我更改了UPATE_GOODS_NUMBER 这个procedure , 结果硬是没有结果, 我有点怀疑代码改来改去,可能有漏洞.我就在很多地方加了message , 结果依然不会执行, 后来发现我可能编译FORM 路径不对,检查过没有错. 再去干脆删除FMX , 结果还是可以进去,原来FORM 路径被识别到了/FND下面, 我靠.原来是这个,需要换菜单或重新注册FORM . 原因是DBA 克隆的时候没有处理好路径.害死人了

现在还是这个奇怪的路径

/train/trainappl/fnd/11.5.0/forms/ZHS/XXOEGOODSLABEL.fmx

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/226700/viewspace-916655/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/226700/viewspace-916655/