Can Not Receipt Internal Requisition APP-PO-14094 or FRM-40212 RCVRCERC Lost Link IR / ISO (Doc ID 1593853.1)

Last updated on JULY 19, 2016

Applies to:

Oracle Inventory Management - Version 12.1.1 to 12.1.3 [Release 12.1]
Oracle Order Management - Version 12.1.1 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

Internal Sales Order ISO has line status closed and shipping interfaced.

However, when attempting to find the Internal Requisition to receive, it is not available in Expected Receipts RCVRCERC form as the following error occurs:

 
Steps
The issue can be reproduced at will with the following steps:

1) Order Management Responsibility
Order Organizer / Search Results
Find Orders/Quotes
Search for Requisition Number = 771

Sales Orders form shows Internal Sales Order ISO #126 is closed.
It has one line for Qty 50 / Ordered Item FP-SY-056
 
2) Purchasing responsibility
Navigate to Receiving / Receipts RCVRCERC form
Find Expected Receipts form
Search for
 . Source Type = Internal
 . Requisition = 771

Get error APP-PO-14094

3) Navigate to Receiving Transactions Summary form
Search for
 . Source Type = Internal
 . Requisition = 771

Get FRM-40212: Invalid value for field REQ_NUM.

4) Output of the Receiving Data Collection Script from <Note 402245.1> shows the internal requisition has
TRANSFERRED_TO_OE_FLAG Y
but does not seem linked to internal sales order line!
In Mtl_supply there is still REQ supply!

1: po_requisition_headers_all
REQUISITION_HEADER_ID 34890
SEGMENT1 771
TYPE_LOOKUP_CODE INTERNAL
TRANSFERRED_TO_OE_FLAG Y
ORG_ID 1139

2: po_requisition_lines_all
REQUISITION_LINE_ID 62307
QUANTITY 50
SOURCE_TYPE_CODE INVENTORY
ITEM_ID 4480
QUANTITY_DELIVERED 0
SOURCE_ORGANIZATION_ID 140
DESTINATION_ORGANIZATION_ID 1180
QUANTITY_RECEIVED

Inventory Sourced Lines: Sales Orders
4: oe_order_lines_all
No records !!

( Output of following sql returns no rows:
select sol.*
 from oe_order_lines_all sol ,
      po_requisition_lines_all rql ,
      po_requisition_headers_all rqh
where sol.source_document_type_id = 10
  and sol.source_document_line_id = rql.requisition_line_id
  and rql.requisition_header_id = rqh.requisition_header_id
  and rql.source_type_code = 'INVENTORY'
  and rqh.segment1 = '771'
  and rqh.org_id = 1139
)

23: mtl_supply
SUPPLY_TYPE_CODE REQ
SUPPLY_SOURCE_ID 62307
REQ_HEADER_ID 34890
REQ_LINE_ID 62307
ITEM_ID 4480
QUANTITY 50
FROM_ORGANIZATION_ID 140
TO_ORGANIZATION_ID 1180
 

5) Output of HTMOMSE Sales Order Diagnostic Script from <Note 133464.1> also does not show a link to internal requisition but shows delivery is shipped

WSH_DELIVERY_DETAILS
DELIVERY DETAIL_ID 43150
RELEASE STATUS C=Shipped
INI Y
OMI Y   
ITEM_ID 4480
ITEM FP-SY-056
SOURCE REQ_QTY 50
SHIPPED QTY 50 

In MTL_MATERIAL_TRANSACTIONS table there is SO Issue transaction for quantity -50.
 

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