My Oracle Support Banner

Fusion Global Payroll: Quick Pay Error Formula CA_SALES_TAX_CALC, line 266, too many rows returned. (3=PER_PER_PERSON_ADD_USAGE_REGION3 (Doc ID 2905693.1)

Last updated on JANUARY 03, 2023

Applies to:

Oracle Fusion Global Payroll Cloud Service - Version 11.13.22.10.0 and later
Oracle Fusion Global Payroll - Version 11.12.1.0.0 and later
Information in this document applies to any platform.

Symptoms

Error while running Quick Pay,

ERROR
-----------------------

HR_51118_HRPROC_ERR_OCC_ON_ASG
ASGNO 41XXXX
AFDICT_APP_PREFIX-PAY-1635156: Error was encountered when processing payroll relationship 41XXXX.
HR_51119_HRPROC_ERR_OCC_ON_ET
ETNAME ADD ER Sales Tax Calculator
AFDICT_APP_PREFIX-PAY-1635252: An error occurred when processing element {ELEM_NAME. (ETNAME=ADD ER Sales Tax Calculator)
HR_51120_HRPROC_ERR_OCC_ON_FML
FMLANAME ADD ER_SALES_TAX_CALC
AFDICT_APP_PREFIX-PAY-1635031: An error occurred when processing formula ADD ER_SALES_TAX_CALC.
HR_6867_HRPROC_FMLA_ORA_ERR
ORACLE_ERROR_TEXT
FORMULA_ERROR_TEXT Formula CA_SALES_TAX_CALC, line 266, too many rows returned.
(3=PER_PER_PERSON_ADD_USAGE_REGION3)
AFDICT_APP_PREFIX-PAY-1635399: An error occurred during formula execution. (ORACLE_ERROR_TEXT=) (FORMULA_ERROR_TEXT=Formula CA_SALES_TAX_CALC, line 266, too many rows returned. (3=PER_PER_PERSON_ADD_USAGE_REGION3))
Formula CA_SALES_TAX_CALC, line 266, too many rows returned. (3=PER_PER_PERSON_A
DD_USAGE_REGION3)




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run Quick Pay
2. Receive an Error



Cause

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
Symptoms
Cause
Solution


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