ODI Mapping WMS_IMPORT_PO Fails With Error ODI-17511 (Doc ID 1493999.1)

Last updated on AUGUST 21, 2016

Applies to:

Oracle Warehouse Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Materials Management

ODI Mapping WMS_IMPORT_PO fails with No value for WMS_V_CHECK_PO

Created a PO and approved the same in 11i instance. While importing the PO from 11i to R12 DWMS instance for our POC, getting the below error ODI-17511: No value to be set to variable 'WMS_DISTRIBUTED_DEPLOYMENT.WMS_V_CHECK_PO'.

This happens after the step 47 - WMS_UPDATE_WMS_DOC_SYNC_WORK_TBL_Y-WMS_UPDATE_PO_HEADERS_ARCHIVE_ALL_I. Now the record in the PO_HEADERS_ARCHIVE is updated to I and not rolled back. The PO import program is getting submitted no matter the record is inserted into the interface table on DWMS R12 instance.

ERROR
-----------------------
ODI-17511: No value to be set to variable 'WMS_DISTRIBUTED_DEPLOYMENT.WMS_V_CHECK_PO.

STEPS
-----------------------
Create a PO and approve. Execute the ODI WMS_IMPORT_PO map. the process will error out after the step 47 with the following error ODI-17511: No value to be set to variable 'WMS_DISTRIBUTED_DEPLOYMENT.WMS_V_CHECK_PO'. No matter whether there is an error, PO import program is also submitted..

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