My Oracle Support Banner

Orphan Records in Element Time Information(HXT_ADD_ELEM_INFO_F) (Doc ID 2394124.1)

Last updated on DECEMBER 11, 2023

Applies to:

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


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).





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

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