My Oracle Support Banner

GST : ORA-06508: PL/SQL: could not find program unit being called: "APPS.JAI_TAX_PERIOD_ENDING_PKG" (Doc ID 2340122.1)

Last updated on NOVEMBER 10, 2023

Applies to:

Oracle Financials for India - Version 12.2.7 to 12.2.7 [Release 12.2]
Information in this document applies to any platform.

Symptoms


ACTUAL BEHAVIOR
---------------
On Running India - Period Ending Process , the concurrent is failing with Error.

Error Message from India - Period Ending Process log file
----------------------------------------------------------------
Cause: FDPSTP failed due to ORA-04063: package body "APPS.JAI_TAX_PERIOD_ENDING_PKG" has errors
ORA-06508: PL/SQL: could not find program unit being called: "APPS.JAI_TAX_PERIOD_ENDING_PKG"
ORA-06512: at line 1

Error Message On Recompiling Package
---------------------------------------------
JAI_TAX_PERIOD_ENDING_PKG PACKAGE BODY PL/SQL: ORA-00904: "AP_UTILITIES_PKG"."GET_REVERSAL_GL_DATE": invalid identifier
JAI_TAX_PERIOD_ENDING_PKG PACKAGE BODY PL/SQL: SQL Statement ignored
JAI_TAX_PERIOD_ENDING_PKG PACKAGE BODY PLS-00306: wrong number or types of arguments in call to 'GET_REVERSAL_GL_DATE'


EXPECTED BEHAVIOR
-----------------------
Package "JAI_TAX_PERIOD_ENDING_PKG" is expected to be valid and on running India - Period Ending Process should be completed without error.

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
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.