Spin Off SR 3-13045419311: Invalid Objects After Upgrade (JAI_OM_RMA_PKG) (Doc ID 2192199.1)

Last updated on OCTOBER 12, 2016

Applies to:

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

Symptoms

On : 12.2.4 version, Install and Patching Issues

 Invalid objects after upgrade (JAI_OM_RMA_PKG)
This one created for JAI_OM_RMA_PKG (Oracle Financials for India)

ERROR
-----------------------
SQL> alter package JAI_OM_RMA_PKG compile body;

Warning: Package Body altered with compilation errors.

SQL> show errors
Errors for PACKAGE BODY JAI_OM_RMA_PKG:

LINE/COL ERROR
-------- -----------------------------------------------------------------
4/11 PLS-00323: subprogram or cursor 'DEFAULT_TAXES_ONTO_LINE' is
  declared in a package specification and must be defined in the
  package body




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
recently upgraded our EBS environment from 12.1.3 to 12.2.4. the Object JAI_OM_RMA_PKG became invalid state and doesn't get compile.

SQL> alter package JAI_OM_RMA_PKG compile body;

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

Cause

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