Orphan Records in Element Time Information(HXT_ADD_ELEM_INFO_F)

(Doc ID 2394124.1)

Last updated on MAY 02, 2018

Applies to:

Oracle Payroll - Version 12.1 and later
Oracle Fusion Time and Labor - Version 11.1.8.0.0 and later
Information in this document applies to any platform.
This note provides a brief overview of .

Symptoms

Problem Statement:

When deleting Element from Element Description form, associated record in hxt_add_elem_info_f does not get deleted.

The orphan record cannot be deleted from "Element Time Information" as it cannot be queried in the form.

 

 

Steps to Reproduce:

The issue can be reproduced at will with the following steps:

  1.  Login as HRMS Responsibility
  2.  Go to Element Description form
     (N) Total Compensation > Basic > Element Description
  3.  Search for the element and delete (purge).

 

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