ORA-28239: No Key Provided for HR HelpDesk Full Synch Messages Process (PERSON_FULL_SYNCH) (Doc ID 1508087.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Human Resources - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Core HR - General

HR HelpDesk Full Synch Messages (PERSON_FULL_SYNCH) is failing with below error.


ERROR
-----------------------
ORA-28239: no key provided

+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+

Error in Person Initial Load Extraction: -28239

Error Msg: ORA-28239: no key provided
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+
 
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.UK Super HRMS Manager>
2.Open the View > Requests
3.Run the HR HelpDesk Full Synch Messages Process, for the PERSON_FULL_SYNCH
4.Verify that the process completes in warning with the above error
5.Message in the Log File.The Output file is not created

BUSINESS IMPACT
-----------------------
The issue has the following business impact:Unable to implement HelpDesk integration.

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