My Oracle Support Banner

Complex PO Closed For Receiving Allows Work Confirmations To Be Created But Errors In Receiving RCV_ASN_SHIPMT_NOT_OPEN (Doc ID 1933061.1)

Last updated on JANUARY 12, 2018

Applies to:

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

Symptoms

If a complex PO is manually closed and a user tries to create a Work Confirmation against it, there are no pay items for selection.
If the same PO is closed for receiving, pay items are available and Work Confirmations can be submittied; however, they error in the RCV_TRANSACTIONS_INTERFACE table.

ERROR
-----------------------
select column_name, error_message, error_message_name, table_name from po_interface_errors;

COLUMN_NAME                 DOCUMENT_SHIPMENT_LINE_NUM
ERROR_MESSAGE              Error: PO Shipment (NUMBER = 1) is not open.                   
ERROR_MESSAGE_NAME     RCV_ASN_SHIPMT_NOT_OPEN 
TABLE_NAME                     RCV_TRANSACTIONS_INTERFACE


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Make a Complex PO closed for receiving
2. Select the Create Work Confirmation action
3. Enter the desired Work Confirmation details and submit for approval.
4. Once the Receiving Transaction Processor has run, the Work Confirmation status changes to Error.
5. The transaction is stuck in the RCV_TRANSACTIONS_INTERFACE

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
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.