Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

Patch 17180979 causes APPS.AP_RETRO_PRICING_PKG invalid

edited Jun 26, 2018 11:08AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 1 commentAnswered ✓

Hi,
Apps 12.1.3

Applied patch Patch 17180979
and package
Patch 17180979 causes

The following error occurs when customer recompile the AP_RETRO_PRICING_PKG:

    SQL> alter package AP_RETRO_PRICING_PKG compile body;
   
    Warning: Package Body altered with compilation errors.
   
    SQL> show errors
    Errors for PACKAGE BODY AP_RETRO_PRICING_PKG:
   
    LINE/COL ERROR
    -------- -------------------------------------------------------------
    7686/9   PL/SQL: SQL Statement ignored
    7692/22  PL/SQL: ORA-00907: missing right parenthesis

Versions of files in AP_RETRO_PRICING_PKG
/* $Header: apretros.pls 120.7.12010000.2 2012/11/26 08:38:29 sbonala ship $ */

/* $Header: apretrob.pls 120.29.12010000.23 2013/01/11 15:46:51 nbshaik ship $ */

Is there a fix in 10g for this package?

Regards!

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center