My Oracle Support Banner

California State Periodic Wage Listing (SPWL) Errors Error At Step 10 In PAY_US_SPWL action_creation-ORA-01403: No Data Found (Doc ID 2725001.1)

Last updated on NOVEMBER 02, 2020

Applies to:

Oracle HRMS (US) - Version 12.1 HRMS RUP13 and later
Information in this document applies to any platform.

Symptoms

When attempting to submit the Concurrent Program under > Submit Process and Reports > Single Request > State Periodic Wage Listing (Enhanced) for the State of California.

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

p_context_name  : TAX_UNIT_ID
p_context_value : 61
pay_balance_pkg.set_context                                             10
p_context_name  : JURISDICTION_CODE
p_context_value : 05-000-0000
pay_balance_pkg.load_defbal_cache                                       30
pay_balance_pkg.get_latest_action_id. set per cache:1234 assact:
pay_balance_pkg.get_value - DATE MODE                                   1
def_bal_id = 2081
Assign_id  = 1234
V_date     = 24-SEP-20
Entering pay_core_utils.do_transaction
Transaction is SAVEPOINT bal_date_mode
Determine calling procedure
Try utl_call_stack approach
Calling name using utl_call_stack approach :
PAY_BALANCE_PKG.GET_VALUE_LOCK_INTERNAL
No Restrictions
Directly perform required transaction SAVEPOINT bal_date_mode
Leaving pay_core_utils.do_transaction
pay_balance_pkg.get_value                                               10
Entering pay_core_utils.do_transaction
Transaction is rollback to bal_date_mode
Determine calling procedure
Try utl_call_stack approach
Calling name using utl_call_stack approach :
PAY_BALANCE_PKG.GET_VALUE_LOCK_INTERNAL
No Restrictions
Directly perform required transaction rollback to bal_date_mode
Leaving pay_core_utils.do_transaction
Error at step 10 in PAY_US_SPWLaction_creation-ORA-01403: no data found
pay_payroll_actions_bru                                                 10
pay_payroll_actions_bru                                                 30
-------------------------------------------------------------------------




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Submit the Concurrent Program for the State Periodic Detail Report (SPWL)
2. No records processed, all assignments unprocessed
3. Observe the SPWL does not run to completion ends in error


Changes

 

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
Changes
Cause
Solution
References


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