PDOI Error : RECEIVING_ROUTING (VALUE= Standard Receipt) specified is invalid (Doc ID 2180615.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

Oracle Purchasing - Version 12.1 to 12.2.5 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

When attempting to run 'Import Standard Purchase Orders',
the following error occurs in PO Interface Errors table and PO is created also.

ERROR
ERROR_MESSAGE_NAME PO_PDOI_DERV_ERROR
COLUMN_NAME RECEIVING_ROUTING_ID
ERROR_MESSAGE "Error: Derivation Error: RECEIVING_ROUTING (VALUE= Standard Receipt) specified is invalid."

Also Purchase Order is being created in Incomplete status.

STEPS
The issue can be reproduced at will with the following steps:
1. Populate PO Interface table data.
2. Run 'Import Standard Purchase Orders'

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