My Oracle Support Banner

Payrolling of Benefits Archive is Throwing ORA-01403: no data found error When Custom BIK Element is Processed (Doc ID 2784540.1)

Last updated on JUNE 15, 2021

Applies to:

Oracle HRMS (UK) - Version 12.1 HRMS RUP13 to 12.2 HRMS RUP15 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

Payrolling of Benefits in Kind Archive is firing the below error when a custom BIK (Benefits in Kind) element is used

The below error is seen in the Benefits in Kind Archive log file :

 

HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-20001: An error encountered was - ORA-20001:
ORA-06512: at "APPS.PAY_ARCHIVE", line 1234
ORA-06512: at line 3

SQL_NO 1108
TABLE_NAME pay_archive.process_employee
APP-PAY-06881: Error ORA-20001: An error encountered was - ORA-20001:
ORA-06512: at "APPS.PAY_ARCHIVE", line 1234
ORA-06512: at line 3
 has occurred in table pay_archive.process_employee at location 1108

Cause: an oracle error has occurred. The failure was reported on table pay_archive.process_employee at location 1108 with the error text ORA-20001: An error encountered was - ORA-20001:
ORA-06512: at "APPS.PAY_ARCHIVE", line 1234
ORA-06512: at line 3

Exception:100 - ORA-01403: no data found
An error encountered was - ORA-20001:



STEPS

  1. Using UK HRMS Responsibility, create a BIK (benefits in kind) element and do the setup as per Payrolling of Benefits in Kind Technical Brief 14 ((Oracle Payroll UK Localization Payrolling of Benefits in Kind Changes April 2017 (Doc ID 2219594.1)
  2. Assign the element to one of the employees' element entries (People > Enter and Maintain > Assignment > Entries
  3. Run a quickpay in (People > Enter and Maintain > Assignment > Quickpay)
  4. Navigate to Process and Reports, Submit request
  5. Run Payrolling of Benefits in Kind Archive and notice the above error

Changes

Created custom Benefits in Kind element, new setup

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


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