My Oracle Support Banner

'ORA-20001: HR_6153_ALL_PROCEDURE_FAIL: N, PROCEDURE' Error on Benefits Confirmation and Summary Report Email (Doc ID 1940948.1)

Last updated on AUGUST 19, 2020

Applies to:

Oracle Advanced Benefits - Version 12.1 HRMS RUP7 and later
Information in this document applies to any platform.


The following error occurs after submitting the "Benefits Confirmation And Summary Report Email" concurrent request:


Exception while getting output from BENSMEM Concurrent Program java.sql.SQLException: ORA-20001: HR_6153_ALL_PROCEDURE_FAIL: N, PROCEDURE, BECNCREP - ben_conc_reports.process, N, STEP, check business rules ...
ORA-06512: at "APPS.FND_MESSAGE", line 509
ORA-06512: at "APPS.BEN_CONC_REPORTS", line 1646
ORA-06512: at line 1

Exception in closing the connectionjava.lang.NullPointerException
Exception occured in sending email
Start of log messages from FND_FILE
System Error: Procedure BECNCREP - ben_conc_reports.process at Step check business rules ...

Cause: The procedure BECNCREP - ben_conc_reports.process has created an error at Step check business rules ....

Action: Contact your system administrator quoting the procedure BECNCREP - ben_conc_reports.process and Step check business rules ....

Steps to Reproduce:
The issue can be reproduced at will with the following steps:

1. Go to responsibility US Super HRMS Manager.

2. Navigate to Processes and Reports > Submit Processes and Reports > Single Request.

3. Select Request Name "Benefits Confirmation And Summary Report Email" and submit.


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

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