Monday, October 3, 2011

Searching Receipt Fails with APP-PO-14142: rcv_receipts_eh.event-000 ORA-1403

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem: Searching Receipt Fails with APP-PO-14142: rcv_receipts_eh.event-000 ORA-1403


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.

References:

Searching Receipt Fails with APP-PO-14142: rcv_receipts_eh.event-000 ORA-1403 [ID 267010.1]


Get Oracle Certifications for all Exams
Free Online Exams.com

No comments: