Receiving Forms: FRM-40212 Invalid Value For Field PO_NUM When Searching By PO Number (Doc ID 1247924.1)

Last updated on JUNE 01, 2016

Applies to:

Oracle Inventory Management - Version 11.5.2 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.
Form:RCVRCERC.FMB - Enter Receipts
Form:RCVTXERT.FMB - Enter Receiving Transactions


Symptoms

When attempting to search specific Purchase Order on Enter receipts or Enter Receiving Transactions form the following error occurs:

FRM-40212: Invalid value for field PO_NUM.

 
Steps
The issue can be reproduced at will with the following steps:
1) Receiving  / Receipts
2) Type the PO Number and press Find Button
3) Get error message 

When searching on Enter Receiving Transactions form by receipt_num some records are retrieved.

Trace shows the instruction that returns no record from RCVRCERC form is the following

SELECT ph.segment1 , ph.po_header_id, ph.type_lookup_code, ph.displayed_field
type, ph.vendor_name, ph.vendor_id, ph.full_name, 'Vendor' , ph.org_id,
MO_GLOBAL.get_ou_name (ph.org_id) operating_unit
FROM
po_pos_val_v ph WHERE (SEGMENT1 LIKE :1) AND ( exists ( SELECT 'Valid PO
Shipments' FROM po_line_locations poll WHERE ph.po_header_id =
poll.po_header_id AND nvl(poll.approved_flag,'N') = 'Y' AND
nvl(poll.cancel_flag,'N') = 'N' AND poll.shipment_type in ('STANDARD',
'BLANKET','SCHEDULED') AND poll.ship_to_organization_id = :2 ) AND rownum >=
1 AND ph.org_id = nvl(:3,ph.org_id) ) ORDER BY decode(rtrim(ph.segment1,
'0123456789'),null,null,ph.segment1), decode(rtrim(ph.segment1,'0123456789')
,null,to_number(ph.segment1),null)

No records can be found in po_pos_val_v for the purchase order

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