Payroll Errors

Document 1345874.1

Page 1 of 18

Troubleshooting Oracle Payroll Common Errors (Doc ID 1345874.1) In this Document Purpose Troubleshooting Steps References

APPLIES TO: Oracle Payroll - Version 11.5.10.2 and later Information in this document applies to any platform.

PURPOSE This note explains various issues and their solutions in Oracle Core Payroll.

TROUBLESHOOTING STEPS

Oracle Payroll ( Core Pay ) Seq Release

Symptom

when we try to delete a retro assignment in RetroPay Status page, following error is coming 1

11.5.10 and later "You cannot delete this assignment because it contains one or more elements that are system-created"

2

This is the delete assignments th Notifications Report

11.5.10 and later The user is calling hr_entry_api.get_link and pay_element_entry_api.create_element_entry from a workflow process following approval from a notification. The issue is that the person sending the notification may not be in the approver's security profile. They can approve the claim but when they call the APIs, they return no data as they use the secure view per_assignments_f not the base table to select data.

https://support.oracle.com/epmos/faces/DocumentDisplay?_adf.ctrl-state=912r99bj1_... 06/01/2015

Document 1345874.1

3

11.5.10 and later

Page 2 of 18

HR_ENTRY_API ends in error when using.

Review Oracle Integ can be found on MyO Responsibility that is 12.0/12.1

ERROR at line 1:

HR_ENTRY_API is callable API.

ORA-01403: no data found ORA-06512: at "APPS.HR_ENTRY_API", line 549

So this API cannot b

Because of this Orac the use of this API o

ORA-06512: at "APPS.HR_ENTRY_API", line 4266 ORA-06512: at line 55

When attempting to use The Bank Key Flexf hr_in_personal_pay_method_api.create_in_personal_pay_method, values from a Table the following error occurs:

4 11.5.10 and later

The view used for th needed the session_i

ERROR Error on line 0 DECLARE l_personal_payment_method_id NUMBER; l_external_account_id ORA-20001: FLEX-ID DOES NOT EXIST: ORA-06512: at "APPS.HR_PERSONAL_PAY_METHOD_API", line 1303 ORA-06512: at "APPS.HR_IN_PERSONAL_PAY_METHOD_API", line 114 ORA-06512: at line 9

5 R12.6 and later

Question 1: pay_element_entry_api.create_element_entry API Fails ORA-20001: Data Get_table_value Not Found

You are using the se pay_element_entry_ insert an API however fails on


Document 1345874.1

Page 3 of 18

fast formula which is defined function. Ho work properly?

Question 2:

Including the sysdate create element entrie manual entry with V you please sysdate help to archi

6

The following error is being raised when calling the api (application program

This error is being ra element entries that e

interface) pay_element_entry_api.update_element_entry:

system during the da updated

ERROR at line 1: ORA-20001: HR_7220_INVALID_PRIMARY_KEY: ORA-06512: at "APPS.PAY_ELEMENT_ENTRY_API", line 1233 ORA-06512: at line 23

What is the cause of the above error?


Document 1345874.1

Page 4 of 18

Why is the PAY_COST_ALLOCATION_API failing with the error below when the parameter value for p_proportion is set to '100'? 7

8

R12

ORA-20001: PAY_50983_INVALID_PROPORTION: ORA-06512: at "APPS.PAY_COST_ALLOCATION_API", line 721 ORA-06512: at line 13 Cannot view the balances after Payroll Run / Quickpay.

Data Install was

Error - APP-PAY-07276: Dynamic SQL for DB item failed : ORA-01403:no data found


Document 1345874.1

Page 5 of 18

Attach the Element Basic Salary with feeds as Assignment Fiscal Year to Date. Run the Payroll and check the balance value. Balance Dimension for Fiscal Yr Erroring (but working fine for tax year and Calender year) in International HRMS Setup

9

Error message :

APP-PAY-07276: Dynamic SQL for DB item failed : ORA01861: Literal does not match format string. In the Balances form after a payroll run. Seup Issue 10 11.5.10 and later We are trying to add a new classification to a seeded balance, how can we do this? Currently we receive the message: APP-PAY-06592: you cannot insert a row for system defined data


Document 1345874.1

Page 6 of 18

I can create a Information element but not an earnings element. ORA-01403: no data found On save of earnings element the following error is raised:

-------------------------------------------------------------FRM-40735: ON-INSERT trigger raised unhandled 11 12.1.1 and later exception ORA-01403. Trace shows : ffdict.non_dbi_used_in_formula 1 ffdict.non_dbi_used_in_formula 3 ffdict.validate_dbitem 5 ffdict.will_clash_with_context 1 insert_user_entity_main : missing route : INPUT_VALUE_ENTRY_LEVEL_OVERRIDE

12

11.5.10.2 and later

System will not allow set up of elements with dashes in the name. Trying to set up element with name CKOR SAR-SEP and receive error APP-PAY-07762.

Trying to create an element with the same name as another element which has been end dated and already exist in the system.

13

11.5.10.2 and later

Data Install was

- Create an element o with any payroll.

System throws an error : APP-PAY-06137 An element with the same name already exist - Process this elemen - End date the eleme the link.

- Try to create anoth name on Mar 2nd. E replicated 14 11.5.10.2 and later

You encounter this e


Document 1345874.1

Page 7 of 18

APP-PAY-06064: This element has been closed for entry (ELEMENT_NAME= ):

- Trying to enter element that is 'Close existing element - Trying to entry of element that

You have defined an element with an input value named OVERRIDE_AMOUNT of type monetary which has a Fast Formula of type 'Element Input Validation' attached to the The Fast Formula wh input to validate the entered value. message is:

If the amount entered is greater than 300 you wish to display an error message, otherwise accept the entered amount. Inputs are OVERRID IF OVERRIDE_AM However you receive the following error when attempting to use the Fast Formula and when it is attached to the element input: ( Formula_Status='e'

Formula_Message = of 300' APP-FF-33629: Unexpected end of "ENTRY_VALUE(T) 15 11.5.10.2 and later =:control.entry_value " line (trigger for OVERRIDE_AMOUNT)

) ELSE

Cause: A formula was invoked via Application Foundation. It was invoked using a #USR trigger step. One of the INPUT=, or UIDCOL=, or OUTPUT= lines appears to have been truncated. ( Formula_Status='s' Action: Please refer to your local support representative. formula_Message='A ) RETURN

This above coded

16 12.1.3 and later After upgrading to R12 (12.1.3) with HR 12.1.2 we get error compiling flexfield $SRS$.PYSGIA8B Can this be ignored?


Document 1345874.1

17

11.5.10.2 and later

Page 8 of 18

Refer to Note 12455 hrrbdeib.sql Fails wi Following error being encountered when running hrglobal? 06512 on table pay_input_valu note, the orphaned ro deleted.

ERROR at line 1:

A datafix for a simila Bug 5917962 HRRUNPRC.SQL

ORA-1403: no data found ORA-6512: at "APPS.HRDYNDBI", line 5403 ORA-6512: at line 43 APP-FF-33980: Internal error attempting to generate package If the following error stack occurs when compiling a Payroll Formula APP-FF-34004: Oracle Payroll FAILED APP-FF-33980: Internal error. A compilation error has been detected while attempting to generate package FFP51699_01010001 (or equivalent text string prefixed with FFP)

18

Formula


Document 1345874.1

How to resolve warning message APP-PAY-34859: The formula results for this processing rule have changed. The corresponding results may now be invalid. Check for the results.

19

20

Page 9 of 18

11.5.10.2 and later

After applying an HRMS family pack. 'FFP502_01010001' This error can and 'FFP503_01010001' are invalid. What needs to be done compilation was not the formula compilat to make these packages valid? was compiled using compilation code. Invalid Fast Formula Packages; FF_34999_WRAPPER_GEN_ERROR (Doc ID 394678.1)


Document 1345874.1

21

11.5.10.2 and later

Page 10 of 18

Need to query element links using one of the defined People Group segments. Getting error: APP-FND-01238 CANNOT SET VALUE FOR FIELD LINK.PEOPLE_GROUP_ID ERROR ON QUERY

How can this be done?


Document 1345874.1

Page 11 of 18

22

11.5.10.2 and later

APP-PAY-06398: This element is not mutually exclusive

This error message i attempted to save a n couldallow an emplo element multiple create an element lin your 'Semi another link for that Organization, the specific Organiza which the links exist the element twice. T create problems whe therefore, Oracle HR create both links.

23

11.5.10.2 and later

APP-PAY-07134: You cannot delete links which have entries within the deletion period.

You have attempted has entries within the selected.

24

11.5.10.2 and later

APP-PAY-07016: Your changes will affect element entries. Do you want to continue

11.5.10.2 and later

The following error is raised when it is attempted to open the Batch Element Entry (BEE) form.

25


Document 1345874.1

Page 12 of 18

Navigate: Mass Information Exchange > Batch Element Entry "APP-PER-449106: This functionality is currently not available. This is because the data associated with this functionality is currently being upgraded"

26

When creating a BEE Batch to load comp time award hours for selected employees for Fiscal Year begin, the system is throwing the following error on every employee in thebatch.

"Employee is not eligible for this element entry at the effective date"

We checked the following : 1) if there exists a proper element link for all employees present in the batch. 2) if the element is EFFECTIVE as on the date on which you want to create the BEE.


Document 1345874.1

Page 13 of 18

and they were perfect.

Why is the following error being raised when trying to validate a Batch Element Entry (BEE) batch?

This error is raised w

-The BEE Batch has to 'Change Existing E 'Cannot update as more than one entry for this element exists at the effective date' 27

11.5.10.2 and later

-there are multiple en payroll period where is being transferred.

Since the system can element entries in th

should be updated w in the batch then the raised. 28

R 12.1.2

New invalids after 12.1.2 upgrade

Invalid ********


Document 1345874.1

Page 14 of 18

SQL> select object_name,object_type,status,owner from dba_objects where object_name='PERCONTACTRELATIONSH_3135U_DYT';

OBJECT_NAME OBJECT_TYPE STATUS OWNER ------------------------------ ------------------- ------- -------PERCONTACTRELATIONSH_3135U_DYT TRIGGER INVALID APPS

SQL> select name,created from v$database;

NAME CREATED --------- -----------------DWWFNI 22-DEC-10

SQL> alter trigger APPS.PERCONTACTRELATIONSH_3135U_DYT compile;

Warning: Trigger altered with compilation errors. SQL> sho errors Errors for TRIGGER APPS.PERCONTACTRELATIONSH_3135U_DYT: LINE/COL ERROR -------- ---------------------------------------------------------------48/3 PL/SQL: Statement ignored 48/23 PLS-00302: component 'PER_CONTACT_RELATIONSHIPS_ARU' must be


Document 1345874.1

Page 15 of 18

declared How to stop the following error from occurring when applying a patch.

ORA-01026: multiple buffers of size > 4000 in the bind list 29

11.5.10.2 and later This occurs for on seed data files with extension .ldt. Generally, the error is seen

Dumping LDT file into FND_SEED_STAGE_ENTITY ERRORS: HR_6882_HRPROC_ASSERT at LOCATION pyjavaco:1 APP-PAY-06882: Assertion failure detected at location pyjavaco:1. When attempting to run the "CHEQUE_WRITER_GEN module: Cheque Writer (generic)" the following errors can occur: Signal 11 Assertion failure detected at location pyjavaco:

30

11.5.10.2 and later

or general problem not being able to open the XML output

The above errors RUN_XDO & PRIN in table PAY_ACTIO 31

11.5.10.2 and later

After applying HR_PF.K.RUP4 (Patch 7666111), when accessing the BEE Spreadsheet Inte

The BEE Spreadsheet Interface does not get opened and you are not able to upload batches using it. How do you avoid this error?


Document 1345874.1

Page 16 of 18

1) The client wishes to amend the BACS Limit

The system will not allow this change as pre payments exist from an interim run done Is there any way round this so that the account name can be amended for the main payroll run ?

Error: APP-PAY-06226: Pre-payments exist for this payment method.

32

11.5.10.2 and later

2) Is it possible to work round this problem by deleting the prepayments via Payroll Process Results

to enable the BACS Limit change required?

Why do I receive the error:

33

11.5.10.2 and later

The operation resulte a payroll (i.e. to chan point on the assignm

This is only allowed payment methods fo valid for the new pay

APP-PAY-6844: this operation invalidates personal payment In this case, one or m methods does not ha methods for the assignment is valid for the new p


Document 1345874.1

Page 17 of 18

REFERENCES

NOTE:124555.1 - HRGLOBAL.DRV hrrbdeib.sql Fails: ORA-01403: no data found ORA-06512: at APPS.HRDYNDBI NOTE:211422.1 - Oracle Payroll 'Fast Formula' Frequently Asked Questions (FAQ) NOTE:422607.1 - How to Delete the Orphaned Rows in Table PAY_INPUT_VALUES_F Which Causes The Hrglobal To Fail? BUG:9545005 - HRMSR12: FWD PORT OF 9019163


Document 1345874.1

Page 18 of 18

BUG:10120645 - FRM-40735 ERROR ON INSERT TRIGGER WHEN ADDING A NEW CONTACT BUG:5353762 - ERROR WHEN APPLYIN HRMS-K ROLLUP-1 PATCH BUG:5917962 - HRGLOBAL FAILS WITH HRRUNPRC.SQL BUG:6892796 - RETRO (ENHANCED)- RETRO STATUS WINDOW DOES NOT ALLOW STATUS CHANGES BUG:9019163 - APP-FND-01238 CANNOT SET VALUE FOR FIELD LINK.PEOPLE_GROUP_ID ERROR ON QUERY


Payroll Errors

Recommend Documents