My Oracle Support Banner

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

Last updated on AUGUST 09, 2018

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

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.