Fusion Global HR: 'Cannot insert null' Error While Creating Global Temporary Assignment (Doc ID 1638335.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Fusion Global Human Resources - Version 11.1.8.0.0 and later
Oracle Fusion Global Human Resources Cloud Service - Version 11.1.8.0.0 and later
Information in this document applies to any platform.

Symptoms

On Oracle Fusion Applications, release 8,

Customer is receiving an error while creating Global Temporary Assignment as below :


Error
------
'Cannot insert null into PER_ASSIGNMENT_EXTRA_INFO_M.EFFECTIVE_END_DATE'.



Steps to replicate:
------------------------
  1. Select action as ‘global temporary assignment’
  2. Select the applicable status for primary assignment:
  3. Enter assignment details for the temporary assignment
  4.Submit the transaction. Error message is displayed in the workflow notification



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