Oracle Inventory Management - Version: 11.5.9 to 12.0.0 This problem can occur on any platform. FORM.:RCVRCERC.FMB - Enter Receipts GUI
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
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.
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.