PO退货报错－APP-PO-14142 rcv_receipts_eh.event-000: ORA-000

摘自：http://blog.sina.com.cn/s/blog_3edcf3ea0101i91k.html

APP-PO-14142 rcv_receipts_eh.event-000: ORA-000

  (2010-01-28 10:27:04)

解决办法如图在划圈位置选接收方式然后保存即可（路径为 Items>master Items)

以下为metalink的描述和解决办法

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 data found

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 data found
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 ones, therefore the Purchase Order level is the highest
level and Organization level is the lowest one.

The Receipt Routing Information Provided while Creating the Purchase Order
Takes precedence than the other two ways.

There is also a Profile Option :- RCV: Allow Routing Override whose value namely
Yes or No indicates whether the receiving routing assigned during requisition or
purchase order entry can be overridden at receipt time.

This profile is updatable at the site, application, and responsibility, levels.