My Oracle Support Banner

Change Personal Information Approved But Got Stuck In The Transaction Console As Pending (Doc ID 2540300.1)

Last updated on JANUARY 22, 2020

Applies to:

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

Symptoms

On : 11.13.19.01.0 version, Global Human Resources

ACTUAL BEHAVIOR
---------------
Though Change Personal Information is approved, it still got stuck in the transaction console as pending

EXPECTED BEHAVIOR
-----------------------
Expect to see the changed data

Composite Instance logs shows the following errors:

Failed to post data to database during "Insert": SQL Statement "INSERT INTO PER_CONTACT_RELSHIPS_F(CONTACT_RELATIONSHIP_ID,EFFECTIVE_START_DAT......................
ORA-01400: cannot insert NULL into ("FUSION"."PER_CONTACT_RELSHIPS_F"."CONTACT_TYPE")


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go to Tools > Transaction Console and see that Change Person Information transaction for employee XXX showing in Pending state

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.