My Oracle Support Banner

GST: Error 'OFFSET_TAX_TYPE_ID must be declared' on compilation of JAI_SETTLEMENT_PKG (Doc ID 2612235.1)

Last updated on NOVEMBER 20, 2019

Applies to:

Oracle Financials for India - Version 12.1 and later
Information in this document applies to any platform.

Symptoms

Getting below error upon compilation of JAI_SETTLEMENT_PKG

ERROR
-----------------------
3223/3   PL/SQL: SQL Statement ignored
3248/17  PLS-00302: component 'OFFSET_TAX_TYPE_ID' must be declared
3248/17  PL/SQL: ORA-00984: column not allowed here
4218/3   PL/SQL: Statement ignored
4218/19  PLS-00302: component 'TAX_TYPE_ID' must be declared
4219/3   PL/SQL: Statement ignored
4219/19  PLS-00302: component 'OFFSET_TAX_TYPE_ID' must be declared
4454/2   PL/SQL: Statement ignored
4454/20  PLS-00302: component 'TAX_TYPE_ID' must be declared
4455/2   PL/SQL: Statement ignored
4455/20  PLS-00302: component 'OFFSET_TAX_TYPE_ID' must be declared


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot use the settlement functionality

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution


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