OSP Requisition Interface Fails With Please Enter a Valid Deliver to Location (Doc ID 2186031.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Work in Process - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

Problem Statement
Requisition is not generating for the OSP item with following error.
Record is stuck in the PO_REQUISITIONS_INTERFACE_ALL. We have checked the error in the 'PO_INTERFACE_ERRORS' table and it was stuck with the error message Please enter a valid Deliver to Location.

It seems due to incorrect deliver to location was populated in requisition interface table from WIP JOB.

Error
COLUMN_NAME : DELIVER_TO_LOCATION_ID
ERROR_MESSAGE : Please enter a valid Deliver to Location.

Steps to Reproduce

  1. Create OSP JOB
  2. Release and move to OSP operation
  3. Created the record on PO_REQUISITIONS_INTERFACE_ALL but then it is not imported successfully by Requisition Import program.

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