Internal Requisition Missing In Receipts Form APP-PO-14094 Corrupted Mtl_Supply Req Instead of Shipment (Doc ID 1299474.1)

Last updated on JUNE 01, 2016

Applies to:

Oracle Inventory Management - Version 11.5.10.2 to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.
Form:RCVRCERC.FMB - Enter Receipts


Symptoms

When attempting to find an internal requisition shipment in the Receipts form the following error occurs:

APP-PO-14094: No records meet your search criteria


The issue can be reproduced at will with the following steps:
1. Navigate to Receiving / Receipts form
2. Search for the specific internal requisition
3. At this moment the above mentioned error is displayed


Rcv11i output (as per <Note 402245.1>) for the involved internal requisition shows:

1: PO_REQUISITION_HEADERS_ALL:

- REQUISITION_HEADER_ID = 216137
- SEGMENT1 = 11884
- TYPE_LOOKUP_CODE = INTERNAL
- TRANSFERRED_TO_OE_FLAG = Y
- ORG_ID =     107



2: PO_REQUISITION_LINES_ALL, contains some lines with:

- REQUISITION_HEADER_ID = 216137
- REQUISITION_LINE_ID = 755910 / 755913
- SOURCE_TYPE_CODE = INVENTORY
- SOURCE_ORGANIZATION_ID = 168
- DESTINATION_ORGANIZATION_ID = 8436
- ORG_ID = 107
 
- QUANTITY_DELIVERED = Null              
- QUANTITY_RECEIVED = Null   

  

4: OE_ORDER_LINES_ALL, all lines have:

- LINE_CATEGORY_CODE = ORDER                   
- SOURCE_TYPE_CODE = INTERNAL                   
- OPEN_FLAG = N                   
- BOOKED_FLAG = Y                   
- SHIPPING_INTERFACED_FLAG = Y                   
- ORDER_SOURCE_ID = 10                   
- FULFILLED_FLAG = Y       
- FLOW_STATUS_CODE = CLOSED



23: WSH_DELIVERY_DETAILS, all lines have:

- OE_INTERFACED_FLAG = Y                       
- INV_INTERFACED_FLAG = Y            
- RELEASED_STATUS = C (Shipped) 

                    

32: RCV_SHIPMENT_HEADERS:

- SHIPMENT_HEADER_ID =569682
- RECEIPT_SOURCE_CODE = INTERNAL ORDER
- SHIPMENT_NUM = 74388
- SHIP_TO_ORG_ID = 8436



33: RCV_SHIPMENT_LINES:

- SHIPMENT_HEADER_ID = 569682
- SHIPMENT_LINE_ID = 764904 / 764905 
- REQUISITION_LINE_ID = 755910 / 755913  
- QUANTITY_RECEIVED = 0
- SHIPMENT_LINE_STATUS_CODE = EXPECTED
- SOURCE_DOCUMENT_CODE = REQ
- DESTINATION_TYPE_CODE = INVENTORY
- TO_ORGANIZATION_ID = 8436
- COST_GROUP_ID = 1178   

       

35: MTL_SUPPLY:

- SUPPLY_TYPE_CODE = REQ                                                  
- SUPPLY_SOURCE_ID = 755910 / 755913 (ie REQUISITION_LINE_ID)
- REQ_LINE_ID = 755910 / 755913
- SHIPMENT_HEADER_ID = Null
- SHIPMENT_LINE_ID = Null
- COST_GROUP_ID = Null



HTMomse11i.sql output (as per <Note 133464.1>) shows that for WSH_DELIVERY_DETAILS (DET) all the lines have:

- INI = Y INVENTORY INTERFACED
- OMI =Y ORDER MANAGEMENT INTERFACED



WSH_NEW_DELIVERIES (DEL):                                   

- DELIVERY_ID = 74388
- DEL_NAME = 74388
- STATUS_CODE = CL  (Closed)

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