Invalid Reference JA_IN_REGIMES In Value Set Attached To Segment Tax Type (Doc ID 2102001.1)

Last updated on JANUARY 04, 2022

Applies to:

Symptoms

ISSUE CLARIFICATION
===============
On Applications upgraded from 11i to R12.2.4
When attempting to , the following error occurs.

-- Error
========

1) APP-FND-00798: Invalid reference JA_IN_REGIMES in value set attached to segment Tax Type.
2) Test of value set JA_IN_TAX_TYPES failed with following error message :
ORA-00942: table or view does not exist
select tax_type_code VALUE , tax_type_name DESCRIPTION , tax_type_id from jai_tax_types where rownum=1


-- Expected Behaviour
==============
Value set Should complete normal

-- Steps
=======
The issue can be reproduced at will with the following steps.

1.There is problem with value set JA_IN_TAX_TYPES.

It is currently used in a descriptive flexfield segment as a value set and on compilation of the same, we are getting below error-

2. APP-FND-00798: Invalid reference JA_IN_REGIMES in value set attached to segment Tax Type.

-- Business Impact
==============
The issue has the following business impact:
Due to this issue, users cannot proceed with the value set in question

Cause

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