Cannot Find PO Receipt to Deliver or Accept On RCVTXERT Form APP-PO-14094: No Records / Missing RCV_SHIPMENT_LINES (RSL) (Doc ID 1981848.1)

Last updated on AUGUST 02, 2016

Applies to:

Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Find for some PO receipts receiving transactions cannot be done as when attempting to find the receipts on Enter Receiving Transactions form the following error occurs


Steps
The issue can be reproduced at will with the following steps:
Navigate to Receiving transactions  form RCVTXERT form
Search for Receipt Number 201589
Get error

What has been checked

A) RCV11i output shows apparently data corruption of missing RSL line
1: po_headers_all
PO_HEADER_ID 403231
SEGMENT1 2015100048
ORG_ID 84

3: po_line_locations_all
ITEM_ID 230601
LINE_LOCATION_ID 477381
PO_HEADER_ID 403231
PO_LINE_ID 482464
QUANTITY 35000
QUANTITY_RECEIVED 18000
SHIP_TO_ORGANIZATION_ID 90

4: po_distributions_all
QUANTITY_ORDERED 35000
QUANTITY_DELIVERED 0

11: rcv_shipment_headers
No records (or it can be found via sql)

12: rcv_shipment_lines
No records

13: rcv_transactions
TRANSACTION_ID 597291
TRANSACTION_TYPE RECEIVE
QUANTITY 18000
SHIPMENT_HEADER_ID 367837
SHIPMENT_LINE_ID 416790
SOURCE_DOCUMENT_CODE PO
DESTINATION_TYPE_CODE RECEIVING
PO_HEADER_ID 403231
PO_LINE_ID 482464
PO_LINE_LOCATION_ID 477381

14: mtl_supply
SUPPLY_TYPE_CODE RECEIVING
SUPPLY_SOURCE_ID 597291
PO_HEADER_ID 403231
PO_LINE_ID 482464
PO_LINE_LOCATION_ID 477381
SHIPMENT_HEADER_ID 367837
SHIPMENT_LINE_ID 416790
RCV_TRANSACTION_ID 597291
ITEM_ID 230601
QUANTITY 18000
UNIT_OF_MEASURE KG
TO_ORGANIZATION_ID 90

15: rcv_supply
Similar RECEIVING record

17: rcv_transactions_interface
No records


B) The following scripts have been run
1 . Select * from  rcv_shipment_headers where SHIPMENT_HEADER_ID =367837 ;
SHIPMENT_HEADER_ID 367837
RECEIPT_SOURCE_CODE VENDOR
RECEIPT_NUM 201589
SHIP_TO_ORG_ID 90
-so the record exists in RSH
**there may not be a record in the RSH table either.

2. Select * from rcv_shipment_lines where SHIPMENT_HEADER_ID =367837 ;
no rows selected.

3. Select * from rcv_shipment_lines where  SHIPMENT_LINE_ID = 416790;
no rows selected.

4. IDENT_MISSING_RSH_FOR_ASN_ASBN.sql and IDENT_MISSING_RSH_FROM_RSL.sql from <Note 371105.1>,
no rows selected.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms