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

Last updated on MAY 01, 2017

Applies to:

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

Symptoms

On 12.1 HRMS RUP7 version Oracle Advanced Benefits,

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

ORA-20001: HR_6153_ALL_PROCEDURE_FAIL: N, PROCEDURE, BECNCREP

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.



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms