首页 > 代码库 > Oracle EBS-SQL (MRP-7):检查MRP计划运行报错原因之超大数据查询2.sql
Oracle EBS-SQL (MRP-7):检查MRP计划运行报错原因之超大数据查询2.sql
The following scripts can be used to check for huge line numbers:
-- PO Requisitions
select * from PO_REQUISITION_LINES_ALL where LINE_NUM > 1000000000;
-- PO Lines
select * from PO_LINES_ALL where LINE_NUM > 1000000000;
-- Receiving Supply
SELECT * FROM PO_RCV_SUPPLY_VIEW WHERE LINE_NUM > 1000000000;
-- Requisition Supply
SELECT * FROM PO_REQ_SUPPLY_VIEW WHERE LINE_NUM > 1000000000;
-- PO Supply
SELECT * FROM PO_PO_SUPPLY_VIEW WHERE LINE_NUM > 1000000000;
-- Intransit Shipment Supply
SELECT * FROM PO_SHIP_SUPPLY_VIEW WHERE SHIPMENT_LINE_NUM > 1000000000;
-- Intransit Receiving Supply
SELECT * FROM PO_SHIP_RCV_SUPPLY_VIEW WHERE SHIPMENT_LINE_NUM > 1000000000;
--
-- Receiving Supply
SELECT * FROM PO_RCV_SUPPLY_VIEW WHERE LINE_NUM > 1000000000;
-- Requisition Supply
SELECT * FROM PO_REQ_SUPPLY_VIEW WHERE LINE_NUM > 1000000000;
-- PO Supply
SELECT * FROM PO_PO_SUPPLY_VIEW WHERE LINE_NUM > 1000000000;
-- Intransit Shipment Supply
SELECT * FROM PO_SHIP_SUPPLY_VIEW WHERE SHIPMENT_LINE_NUM > 1000000000;
-- Intransit Receiving Supply
SELECT * FROM PO_SHIP_RCV_SUPPLY_VIEW WHERE SHIPMENT_LINE_NUM > 1000000000;
Refer to below view when running MRP with check "Net Purchase" in
plan option.
( PO_RCV_SUPPLY_VIEW, PO_REQ_SUPPLY_VIEW, PO_PO_SUPPLY_VIEW,PO_SHIP_SUPPLY_VIEW, PO_SHIP_RCV_SUPPLY_VIEW )
SELECT * FROM MRP_PO_SUPPLY_VIEW WHERE SUPPLY_LINE_NUM > 1000000000