My Oracle Support Banner

Error APP-PO-14094 or FRM-40212 RCVRCERC Is Raised When Attempting to Receipt Internal Requisition Due to Lost Link Between IR/ISO (Doc ID 1593853.1)

Last updated on JANUARY 28, 2020

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 the Expected Receipts RCVRCERC form as the following error occurs:


ERROR

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

 
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 = XXX

Sales Orders form shows ISO is closed.
It has one line for Qty 50.
 
2) Purchasing responsibility
Navigate to Receiving / Receipts RCVRCERC form
Find Expected Receipts form
Search for
 - Source Type = Internal
 - Requisition = XXX

Get error APP-PO-14094


3) Navigate to Receiving Transactions Summary form
Search for
 - Source Type = Internal
 - Requisition = XXX

Get FRM-40212: Invalid value for field REQ_NUM.


4) Output of the Receiving Data Collection Script from Doc ID 402245.1 shows the internal requisition has the following:
TRANSFERRED_TO_OE_FLAG Y

> po_requisition_headers_all
REQUISITION_HEADER_ID XXXXX
SEGMENT1 XXX
TYPE_LOOKUP_CODE INTERNAL
TRANSFERRED_TO_OE_FLAG Y
ORG_ID XXXX

> po_requisition_lines_all
REQUISITION_LINE_ID XXXXX
QUANTITY 50
SOURCE_TYPE_CODE INVENTORY
ITEM_ID XXXX
QUANTITY_DELIVERED 0
SOURCE_ORGANIZATION_ID XXX
DESTINATION_ORGANIZATION_ID XXXX
QUANTITY_RECEIVED

Inventory Sourced Lines: Sales Orders
> oe_order_lines_all table has no records !!

Output of following sql returns no rows:



> mtl_supply
SUPPLY_TYPE_CODE REQ
SUPPLY_SOURCE_ID XXXXX
REQ_HEADER_ID XXXXX
REQ_LINE_ID XXXXX
ITEM_ID XXXX
QUANTITY 50
FROM_ORGANIZATION_ID XXX
TO_ORGANIZATION_ID XXXX
 

5) Output of Sales Order Analyzer (<Document:2038363.1>) also does not show a link to an Internal Requisition(IR), but delivery is shipped.

> WSH_DELIVERY_DETAILS
DELIVERY DETAIL_ID XXXXX
RELEASE STATUS C=Shipped
INI Y
OMI Y   
ITEM_ID XXXX
SOURCE REQ_QTY 50
SHIPPED QTY 50 

> MTL_MATERIAL_TRANSACTIONS
SO Issue transaction for quantity -50.
 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.