Scribd
Upload
43 views2 pages

New DBI Termination

The document addresses an error encountered in Oracle Fusion Global Payroll when running Quickpay for a terminated employee, specifically a 'too many rows returned' error related to the formula SA_GET_HR_DATA. The issue arises from termination DBIs returning multiple values due to the employee's conversion from pending worker status. The solution involves replacing the problematic DBIs with ones that filter based on the employee's work relationship to ensure only the correct data is returned.

Uploaded by

enjoyin.mousa.coast
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
43 views2 pages

New DBI Termination

The document addresses an error encountered in Oracle Fusion Global Payroll when running Quickpay for a terminated employee, specifically a 'too many rows returned' error related to the formula SA_GET_HR_DATA. The issue arises from termination DBIs returning multiple values due to the employee's conversion from pending worker status. The solution involves replacing the problematic DBIs with ones that filter based on the employee's work relationship to ensure only the correct data is returned.

Uploaded by

enjoyin.mousa.coast
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

Document 2950467.1 https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=1...

Last Login: July 18, 2025 5:33 PM AST Switch to My Oracle Cloud Support Mohamed (Available) (0) Contact Us Help

Dashboard Knowledge Service Requests Patches & Updates Powered by AI. Do not input sensitive data

Give Feedback...
Copyright (c) 2025, Oracle. All rights reserved. Oracle Confidential.

Fusion Payroll SA Legislation: Formula SA_GET_HR_DATA, Line 267, Too Many Rows Returned Error (Doc ID To Bottom
2950467.1)

In this Document Was this document helpful?

Symptoms Yes
No
Cause
Solution
Document Details
References

Type:
PROBLEM
Status:
PUBLISHED
Last Major
21-May-2023
APPLIES TO: Update:
02-Oct-2023
Last Update:

Oracle Fusion Global Payroll Cloud Service - Version 11.13.23.01.0 and later
Information in this document applies to any platform.
Related Products
Oracle Fusion Global Payroll
SYMPTOMS Cloud Service

On : 11.13.23.01.0 version, Global Payroll


Information Centers

When attempting to run Quickpay for a terminate employee the following error occurs. Information Center: Fusion
Human Capital Management –
United Kingdom [2090342.2]
ERROR
----------------------- Information Center: Fusion
Error was encountered when processing payroll relationship 12345 Global Payroll [2661318.2]
AFDICT_APP_PREFIX-PAY-1635252: The {ELEM_NAME element couldn't be successfully processed. (ETNAME=IN End Of Service
Provision)
Document References
AFDICT_APP_PREFIX-PAY-1635399: An error occurred during formula execution. (ORACLE_ERROR_TEXT=) No References available for this
(FORMULA_ERROR_TEXT=Formula SA_GET_HR_DATA, line 267, too many rows returned. (3=PAY_INTERNAL_LOG_WRITE)) document.
message text = An error occurred during formula execution. (ORACLE_ERROR_TEXT=)
(FORMULA_ERROR_TEXT=Formula SA_GET_HR_DATA, line 267, too many rows returned. (3=PAY_INTERNAL_LOG_WRITE))
Recently Viewed

Fusion Payroll SA Legislation:


Formula SA_GET_HR_DATA,
STEPS Line 267, Too Many Rows
Returned Error [2950467.1]
-----------------------
The issue can be reproduced at will with the following steps: Fusion HCM Data Loader:
Error for Worker.dat "The
1. Run Quickpay.
corresponding date effective
2. Error occurs. record in the
{PARENTNAME} for date
{DATE}, action {ACTION},
and effective sequence
{SEQ} is missing for the
{CHILDNAME}
CAUSE (PER-1531696)" [2149175.1]
Fusion Worker HDL Error:
You must enter a
This person has been converted as employee from pending worker and later the work relationship has been terminated.
combination with 11 total
number of segments
Termination DBIs used in End of Service custom fast formula return multiple values, one for employee work relationship and [2942868.1]
another one for pending worker, passed to the seeded fast formula SA_GET_HR_DATA as PER_PER_TERMINATION% DBIs don't
Fusion Global Payroll :
have filter based on employee work relationship. Due this, error occurs. Manage Personal Payment
Method - Bank Details
Effective End Date Issue
[2462459.1]
SOLUTION
Fusion Global HR: Resolving
Error The employment terms
Replace in End of Service custom fast formula the termination DBIs that are returning multiple values with other ones based on number already exists. Enter
employee work relationship, which will check the Person Type and return only the correct data for the Employee. a unique employment terms
number (PER-1530364)
[2638480.1]
Old DBi New DBI
Show More
PER_PER_TERMINATION_TYPE PER_EMP_TERMINATION_TYPE
PER_PER_TERMINATION_REASON_CODE PER_EMP_TERMINATION_REASON_CODE
PER_PER_TERMINATION_ACTION_CODE PER_EMP_TERMINATION_ACTION_CODE
PER_PER_TERMINATION_DATE PER_EMP_TERMINATION_DATE

1 of 2 7/21/2025, 11:54 PM
Document 2950467.1 https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=1...

REFERENCES

Didn't find what you are looking for? Ask in Community...

Related
Products

• Oracle Cloud > Oracle Software Cloud > Oracle Human Capital Management Cloud > Oracle Fusion Global Payroll Cloud Service > SA - Saudi Arabia Legislation > SA - Other

Keywords
EMPLOYEE; END OF SERVICE; FAST FORMULA; FORMULA; PAYROLL; PENDING; RELATIONSHIP; SAUDI ARABIA LOCALIZATION; TERMINATE EMPLOYEE; TERMINATION; TOO MANY
ROWS; WORK RELATIONSHIP
Errors
PAY-1635252; PAY-1635399

Back to Top
Copyright (c) 2025, Oracle. All rights reserved. Legal Notices and Terms of Use Privacy Statement

2 of 2 7/21/2025, 11:54 PM

You might also like