Not Able to Apply For Leave From Employee Self Service, Errors: ORA-20001: THE BUSINESS GROUP SPECIFIED IS INVALID (Doc ID 1632861.1)

Last updated on JANUARY 06, 2016

Applies to:

Oracle Self-Service Human Resources - Version 12.1 HRMS RUP5 and later
Information in this document applies to any platform.

Symptoms

On PRODUCTION,  12.1 HRMS RUP5

When trying to access absence function from employee self-service, get below error :

oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException:
JBO-27122: SQL error during statement preparation. Statement: SELECT
NVL(paa.date_start,paa.date_projected_start) start_date
,NVL(paa.date_end,paa.date_projected_end) end_date
,paattl.name absence_type
,paat.absence_attendance_type_id absence_attendance_type_id
,fcl.meaning absence_category
,paat.absence_category absence_category_code
,paa.absence_hours
,(SELECT meaning from hr_lookups where 'A' = lookup_code(+) and
'LEAVE_STATUS' = lookup_type(+))
approval_status
, 'A' approval_status_code
,decode(paa.date_start,null,
(SELECT meaning from fnd_lookup_values
where lookup_type ='ABSENCE_STATUS' and
lookup_code ='PLANNED'
and language = userenv('LANG')),
(SELECT meaning from fnd_lookup_values
where lookup_type ='
...

## Detail 0 ##
java.sql.SQLException:
ORA-20001: The business group specified is invalid Cause: You have specified an incorrect business group identifier or name.

Action: Correct the business group value or call your local support representative.
ORA-06512:
at "APPS.HR_UTILITY", line 939ORA-06512:
at "APPS.HR_API", line 1411


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

1. Login >>Click on seeded Employee Self Service
2. Click on Absence Management>> Error is received



Additional Information



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