APP-PO-14142 rcv_receipts_eh.event-000: ORA-000
(2010-01-28 10:27:04)解决办法如图在划圈位置选接收方式然后保存即可(路径为 Items>master Items)
Applies to:
Oracle Inventory Management - Version: 11.5.9 to 12.0.0
This problem can occur on any platform.
FORM:RCVRCERC.FMB - Enter Receipts GUI
Symptoms
Searching Receipt Fails with APP-PO-14142: rcv_receipts_eh.event-000 ORA-1403: no da
In R12 the error may be:
APP-PO-14142: rcv_receipts_eh.event-000: ORA-0000: normal, succesful completion
Cause: A SQL error has occurred in rcv_receipts_eh.event. The SQL error is ORA-0000: normal,
successful completion
Steps to reproduce:
1 Navigate to Receiving>Receipts
2 Enter PO number, PO line and press Find
3 Receive the following error: APP-PO-14142: rcv_receipts_eh.event-000 ORA-1403: no da
4 Trace shows, the following statement returns 0 rows :
SELECT ROUTING_NAME
FROM
RCV_ROUTING_HEADERS WHERE ROUTING_HEADER_ID = :b1
Cause
The Routing could not be set up correctly for the PO.
Use the following scripts to find out if the routing is not setup for the PO:
select po_header_id,
from po_headers_all where segment1 = 'PO#'; Insert the problem PO number
select po_line_id, line_num
from po_lines_all
where po_header_id = 'value returned from above';
select line_location_id, receiving_routing_id
from po_line_locations_all
where po_header_id = value returned from #1 and po_line_id = value returned
from #2
select routing_name, description
from rcv_routing_headers
where routing_header_id = insert value returned for receiving_routing_id from #3
If the last query does not return any rows then the Routing has not been set up correctly.
Solution
Check the routing for the PO.The Receipt Routing can be set at 5 places:
1) While Creating the Purchase Orders. At shipment level.
2) Item Definition Level.
3) At the Supplier Definition level.
4) Shipping Networks During Inventory Setup.
5) At the Organizational Level. Receipt Options.
Every level overrides the following on
level and Organization level is the lowest on
The Receipt Routing Information Provided while Creating the Purchase Order
Takes precedence than the other two ways.
There is also a Pro
Yes or No indicates whether the receiving routing assigned during requisition or
purchase order entry can be overridden at receipt time.
This pro