PNIMPCAD:Import Locations and Space Allocation From Interface Tables Error EMP_ASSIGN_END_DATE Is NULL (Doc ID 1390669.1)

Last updated on JULY 12, 2016

Applies to:

Oracle Property Manager - Version 12.1.1 and later
Information in this document applies to any platform.
PNIMPCAD module: Import Locations and Space Allocation From Interface Tables

***Checked for relevance 21-Oct-2013***

Symptoms


When attempting to import Space Assignments from Interface Table
with assignment records in interface table (PN_EMP_SPACE_ASSIGN_ITF)
having NULL EMP_ASSIGN_END_DATE

the following error occurs.

ERROR
-----------------------
PNIMPCAD error emp_assign_end_date is null

Log file also show below error :
You cannot assign space to this location for the dates entered because the location is either not active or not assignable for these dates. Please select different dates.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1- Run request : PNIMPCAD module: Import Locations and Space Allocation From Interface Tables

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