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 11.5.10.2 and later
Information in this document applies to any platform.

Goal

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,
(SELECT
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 =
pay_in_utils.get_element_link_id(assgn.assignment_id,sysdate,types.element_type_
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(OAException.java(Compiled
Code))
at oracle.apps.fnd.framework.OAException.wrapperException

 

Solution

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