Unable to submit Tax Declaration using India Employee Self Service

(Doc ID 377469.1)

Last updated on JULY 14, 2016

Applies to:

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


When you try to submit Tax declaration in Employee Self Service we are getting the following error message :

Navigation : Goto India Employee Self Service > Tax Declaration

Error :

You have encountered an unexpected error. Please contact the System Administrator for assistance.
Click here for exception details.

Exception Details.

oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122:
SQL error during statement preparation. Statement: SELECT meaning
, to_number(pay_in_tax_declaration.get_planned_value( det.assignment_id,
det.value, det.element_entry_id, det.input_value_id)) planned
, det.value actual
, 'N' ChangeInd
FROM hr_lookups lookup,
pay_in_utils.get_ee_value(entries.element_entry_id,inputs.name,sysdate) value
, inputs.name name
, entries.element_entry_id element_entry_id
, inputs.input_value_id input_value_id
, assgn.assignment_id
FROM per_all_assignments_f assgn
, pay_element_types_f types
, pay_element_entries_f entries
, pay_input_values_f inputs
WHERE assgn.person_id = :1
AND (types.processing_type = 'R' OR assgn.payroll_id IS NOT NULL)
AND types.element_name = 'House Rent Information'
AND entries.element_type_id = types.element_type_id
AND entries.element_link_id =
AND entries.assignment_id = assgn.assignment_id
AND inputs.element_type_id = types.element_type_id
AND sysdate BETWEEN assgn.effective_start_date
AND assgn.effective_end_date
AND sysdate BETWEEN types.effective_start_date
AND types.effective_end_date
AND sysdate BETWEEN entries.effective_start_date
AND entries.effective_end_date
AND sysdate BETWEEN inputs.effective_start_date
AND inputs.effective_end_date
) det
WHERE lookup.lookup_type = 'IN_CALENDAR_MONTH'
AND upper(substr(lookup.meaning, 0, 3)) = det.name(+)
order by lookup.lookup_code
at oracle.apps.fnd.framework.OAException.wrapperException



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