|
|
仔細研究了一下AutoCreate Final Assembly Orders的日志
我發現參數ORDER_NUMBER好象錯了，怎么由12030800094變成了2147483647
而且我用他的sql將其中的參數置換后是能查詢出我所要的結果，難道是系統BUG！
+---------------------------------------------------------------------------+
Work in Process: Version : 11.5.0 - Development
Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.
WICDOL module: AutoCreate Final Assembly Orders
+---------------------------------------------------------------------------+
Current system time is 12-DEC-2008 15:27:44
+---------------------------------------------------------------------------+
Page Length = 59, Page Width = 132
===================================================================
Debug Mode : Enabled
Output to Terminal : No
Argument Method : Database Fetch
Trace Mode : Disabled
===================================================================
Argument 1 (ORDER_NUMBER) = 12030800094
Argument 2 (DUMMY_FIELD) =
Argument 3 (OFFSET_DAYS) = 1
Argument 4 (LOAD_TYPE) = 3
Argument 5 (STATUS_TYPE) = 1
Argument 6 (ORG_ID) = 117
Argument 7 (CLASS_CODE) = 量產
Argument 8 (FAILED_REQ_ID) = -1
Argument 9 (ORDER_LINE_ID) =
Argument 10 (BATCH_ID) =
===================================================================
Dbg:Connected to DB
ALmost there.
BATCH STR = .
Dbg rg_id = 117
Dbgffset_days = 1.000000
Dbg:load_type = 3
Dbg:class_code = 量產
Dbg:status_type = 1
Dbg:failed_req_id = -1
Dbgrder_number = 2147483647
Dbgrder_line_id = -1
Dbgrg_id = 117
Dbgffset_days = 1.000000
Dbg:load_type = 3
Dbg:class_code = 量產
Dbg:status_type = 1
Dbg:failed_req_id = -1
Dbgrder_number = 2147483647
Dbgrder_line_id = -1
Dbg:all_success_rec = 1
Dbg: OM Installed: Enter get_order_lines.
Dbg: Exited get_order_lines with status 1
Dbg: wei_group_id = -1
Dbg: Orders Loaded = 0
Dbg:Exiting Filter Order Lines w/success
Dbg:Exiting Sales Order Loader w/success
***** End Of Report - AutoCreate Final Assembly Orders *****
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
get_order_lines: Begin Get Order Lines.
get_order_lines: Organization ID: 117
get_order_lines: Offset: 1
get_order_lines: Load Type: 3
get_order_lines: Class Code: 量產
get_order_lines: Status Type: 1
get_order_lines: Order Number: 2147483647
get_order_lines: Line ID: -1
select /*+ ordered index (WAS WF_ITEM_ACTIVITY_STATUSES_PK) */
oel.line_id line_id,
oel.ship_from_org_id ship_from_org_id,
oel.header_id header_id,
nvl(oel.org_id, -1) org_id
from oe_order_lines_all OEL,
wf_item_activity_statuses WAS,
wf_process_activities WPA,
mtl_system_items MSI
where oel.inventory_item_id = msi.inventory_item_id
and oel.ship_from_org_id = msi.organization_id
and msi.bom_item_type = 4
and oel.open_flag = 'Y'
and oel.ato_line_id is not null
and (oel.item_type_code = 'CONFIG' or
(oel.ato_line_id = oel.line_id and oel.item_type_code = 'STANDARD'))
and nvl(oel.cancelled_flag, 'N') = 'N'
and oel.booked_flag = 'Y'
and oel.schedule_status_code = 'SCHEDULED'
and oel.ordered_quantity > 0
and msi.replenish_to_order_flag = 'Y'
and msi.build_in_wip_flag = 'Y'
and msi.pick_components_flag = 'N'
and was.item_type = 'OEOL'
and was.activity_status = 'NOTIFIED'
and was.item_type = wpa.activity_item_type
and was.process_activity = wpa.instance_id
and wpa.activity_name in
('EXECUTECONCPROGAFAS', 'CREATE_SUPPLY_ORDER_ELIGIBLE', 'SHIP_LINE')
and ((wpa.activity_name = 'EXECUTECONCPROGAFAS' and oel.program_id = -99) OR
(wpa.activity_name <> 'EXECUTECONCPROGAFAS' and
nvl(oel.program_id, 0) <> -99))
and not exists
(select '1'
from bom_operational_routings bor
where bor.assembly_item_id = oel.inventory_item_id
and bor.organization_id = oel.ship_from_org_id
and bor.alternate_routing_designator is NULL
and nvl(bor.cfm_routing_flag, 2) = 1)
and was.item_key = to_char(oel.line_id)
and oel.header_id in
(select oeh.header_id
from oe_order_headers_all oeh
where oeh.order_number = :l_order_number)
and oel.ship_from_org_id = :l_org_id
and (oel.item_type_code = 'CONFIG' or
(oel.item_type_code in ('STANDARD', 'OPTION') and
oel.ato_line_id = oel.line_id))
and SYSDATE >=
(select CAL.CALENDAR_DATE
from bom_calendar_dates cal, mtl_parameters mp
where mp.organization_id = oel.ship_from_org_id
and cal.calendar_code = mp.calendar_code
and cal.exception_set_id = mp.calendar_exception_set_id
and cal.seq_num =
(select cal2.prior_seq_num - nvl( _offset_days, 0) -
(ceil(nvl(msi.fixed_lead_time, 0) +
nvl(msi.variable_lead_time, 0) *
(INV_CONVERT.inv_um_convert(oel.inventory_item_id,
5,
oel.ordered_quantity,
oel.order_quantity_uom,
msi.primary_uom_code,
null,
null) -
CTO_WIP_WRAPPER.GET_RESERVED_QTY(oel.line_id))))
from bom_calendar_dates cal2
where cal2.calendar_code = mp.calendar_code
and cal2.exception_set_id = mp.calendar_exception_set_id
and cal2.calendar_date = trunc(oel.schedule_ship_date)))
order by oel.org_id, oel.line_id
drive_mark = 13
Opened. System Time : 12-DEC-2008 15:27:45
get_order_lines: MOperating Unit :109
get_order_lines: ****************************************
get_order_lines: Number of Order Lines Selected: 0
get_order_lines: Number of Rows on Hold: 0
get_order_lines: Number of Rows not Departure Planned: 0
get_order_lines: Number of Rows in error: 0
get_order_lines: Number of Order Lines Inserted: 0
get_order_lines: WIP Group ID: -1
get_order_lines: ****************************************
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
Executing request completion options...
+------------- 1) PRINT -------------+
Printing output file.
Request ID : 2473300
Number of copies : 0
Printer : noprint
+--------------------------------------+
Finished executing request completion options.
+---------------------------------------------------------------------------+
Concurrent request completed successfully
Current system time is 12-DEC-2008 15:27:46
+---------------------------------------------------------------------------+
[ 本帖最后由 fly-in-the-sky 于 2008-12-12 16:30 编辑 ] |
|
楼主: fly-in-the-sky
IP卡
狗仔卡
楼主
显身卡
发表于 2008-12-12 21:49
