Oracle EBS薪酬模块员工分录出现两条相同工资项，无法删除终止

zackchen

Oracle EBS薪酬模块员工分录出现两条相同工资项，无法删除终止，工资项的设置是不允许多个项的，分录中的两条记录的ELEMENT_ENTRY_ID是相同的，删除或终止时报如下错误
APP-PAY-06153：系统错误：步进2处的程序 hr_entry_api.delete_element_entry
原因：在步进2，程序 hr_entry_api.delete_element_entry导致错误。

有遇到上述问题的朋友或知道如何解决这个问题的朋友请帮忙解答一些，谢谢啦

o5591673

你是不是可以直接用 hr_entry_api.delete_element_entry 这个API在后台删除呢？

zackchen

o5591673 发表于 2011/8/16 13:35
你是不是可以直接用 hr_entry_api.delete_element_entry 这个API在后台删除呢？

因为不了解删除或终止时都调用过哪些程序，如果直接调用报错的存储过程，不知道会不会出现什么不可预知的问题，所以不敢贸然调用存储过程删除，除非是个高手，了解这段代码，呵呵。毕竟是用户生产环境。而且直接调用存储过程会报同样错误，除非直接删除表中的数据。

blueworm

在 Metalink 查詢  APP-PAY-06153   hr_entry_api.delete_element_entry ，找到兩篇資料給你參考

APP-PAY-06153 When Trying To Enter Final Process Date For Terminated Employee [ID 1209323.1]
		Modified 04-MAR-2011     Type PROBLEM     Status MODERATED

In this Document
[size=-1]  Symptoms
  Cause
  Solution
  References

---

[size=-1]This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

Applies to: Oracle Human Resources - Version: 11.5.10.2 and later   [Release: 11.5.10 and later ]
Information in this document applies to any platform.

SymptomsWhen attempting to enter the 'Final Process' date for a terminated employee, the following error occurs.

ERROR
-----------------------
APP-PAY-06513: System Error: Procedure hr_entry_api.delete_element_entry at Step 2
Cause: The procedure hr_entry_api.delete_element_entry has created an error at Step 2.
Action: Contact your System Administrator quoting the procedure hr_entry_api.delete_element_entry
             at Step 2.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log in to the Applications.
2. Choose an HRMS responsibility, e.g. 'US Super HRMS Manager'.
3. Navigate to 'People-> Enter and Maintain'.
4. Query the terminated employee.
5. Click on 'Others-> End Employment'.
6. Enter a date for the field 'Final Process'.
7. Save the changes.

CauseThe cause of the issue is that there are records in table pay_element_entries_f for the same element
entry that have the same start or end dates.

The following SQL queries can determine if this is the case.

select element_entry_id,effective_start_date,count(*)
from pay_element_entries_f
where assignment_id in <assignment_ids of the terminated employee separated by comma>
group by element_entry_id,effective_start_date
having count(*)>1;

select element_entry_id,effective_end_date,count(*)
from pay_element_entries_f
where assignment_id in <assignment_ids of the terminated employee separated by comma>
group by element_entry_id,effective_end_date
having count(*)>1;

SolutionContact Oracle Support to request for a datafix.

ReferencesBUG:9757779 - APP-PAY-06153 STEP 2 ERROR WHEN ENTERING A FINAL PROCESS DATE FOR AN EX-EMPLOYEE

Related Products Oracle E-Business Suite > Human Capital Management > Human Resources > Oracle Human Resources Errors PAY-6153; PAY-6513

Cannot Delete Salary Proposal Record [ID 334975.1]
		Modified 31-JAN-2011     Type PROBLEM     Status PUBLISHED

In this Document
[size=-1]  Symptoms
  Cause
  Solution
  References

---

Applies to: Oracle Human Resources - Version: 11.5.9 to 11.5.10.2 - Release: 11.5 to 11.5
Information in this document applies to any platform.
***Checked for relevance on 31-Jan-2011***
SymptomsThis employee in question has two assignments and both have related 'Salary Proposal' records.
The problem is we are unable to delete the latest Salary Proposal record relating to the Primary Assignment.
Instead it gives the following message.
APP-PAY-06153 System Error: Procedure hr_entry_api.delete_element_entry Step 2.

Navigation:
Assignment > Salary and try to delete the salary proposal record.

This has been worked before but it does not work for this particular employee.
CauseThere are overlapping element entries for the primary assignment's salary proposal.

The data shows the following element entries for the primary assignment_id.

Effective           Effective          Asg.    Element     Element    Element          Element   Creator            Entry
Start Date        End Date          Id       Entry ID     Link ID   Name              Type ID Type                Type
-----------------------------------------------------------------------------------------------------------------------
14-Feb-2005   10-Sep-2005  82479  45528       61          Regular Wages  155        Element Entry  Salary Proposal
14-Feb-2005   31-Dec-4712  82479  100734     65         VERTEX           204        Element Entry  Salary Proposal
01-Jul-2005     10-Sep-2005  82479  100734     65         VERTEX           204        Element Entry  Salary Proposal
11-Sep-2005   31-Dec-4712  82479  45528       61         Regular Wages   155        Element Entry  Salary Proposal
Solution
The Vertex element entries are causing the overlapping salary proposal issue.  The script that is usually run to correct Vertex tax element entries can also be run to correct Vertex salary proposal element entries.  The script is deltax.sql, and it will delete all Vertex entries.  Once this is run, a correction to the employee's location will rebuild the tax records.
Deltax.sql can be obtained by contacting Oracle Support.
References

Related Products Oracle E-Business Suite > Human Capital Management > Human Resources > Oracle Human Resources Keywords ELEMENT ENTRY; VERTEX; PRIMARY ASSIGNMENT Errors PAY-6153

zackchen

blueworm 发表于 2011/8/17 09:21
在 Metalink 查詢  APP-PAY-06153   hr_entry_api.delete_element_entry ，找到兩篇資料給你參考

谢谢这位兄弟帮我查的资料，我这里的情况和你提供资料的第一种情况比较相像，但是不同的地方是资料里说这个人的重复分录的起始时间和结束时间相同，而我的环境中起始时间不同一个是6月1日，一个是7月1日，但是结束时间都是4712-12-31，资料中也没有说明怎么解决，找Oracle估计黄花菜都凉了，呵呵，不过还是谢谢这位兄弟

blueworm

你先把這個 Element 、Element Link 及 Element Entry 的畫面貼上來看看

zackchen

blueworm 发表于 2011/8/17 14:11
你先把這個 Element 、Element Link 及 Element Entry 的畫面貼上來看看

贴图太麻烦了，还得找个地方上传图片，呵呵，现在问题解决，不过不是什么好办法，直接改了hr.pay_element_entries_f这个表的effective_end_date，让重复的记录时间连接上了，现在做操作还没出现什么后遗症。通过查last_updated_by发现是一个人事管理员不知道做了什么操作，改了那条分录，导致他的effective_end_date变成了 4712-12-31。现在也重现不了了。

shaychen

过来打个招呼 {:soso_e113:}

码砖头的人

我也曾经遇到过pay_element_entries_f这个表的effective_end_date错误问题，导致无法进行终止雇佣的问题。按理来说前台操作不应该出现这类问题，偏偏就出现了，可能这个算是一个bug吧。