Oracle Ebs-sql (MRP-7): Large data query to check the cause of error in MRP program Operation 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-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