Package Body CSM_PARTY_DOWNLOAD_PVT Invalid After Applying Recommended Patch Collection 2 (19030202) (Doc ID 1984441.1)

Last updated on MARCH 04, 2015

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Patch Application Issues

When applying Recommended Patch Collection 2 (19030202), package body APPS.CSM_PARTY_DOWNLOAD_PVT is invalid.
In looking at the error, the code is referencing table hz_party_relationships in 2 different locations in the code.

 /* $Header: csmpprob.pls 120.3.12010000.2 2014/09/03 10:45:19 ravir ship $ */

In looking at the database, table hz_party_relationships is in the AR schema. However, there is no synonym in the APPS schema that resolves the reference to this unqualified table in csmpprob.pls.

ERROR
-----------------------
Here are the errors:
  LINE POSITION TEXT
---------- ---------- --------------------------
  151 8 PL/SQL: ORA-00942: table or view does not exist
  150 1 PL/SQL: SQL Statement ignored
  539 8 PL/SQL: ORA-00942: table or view does not exist
  538 1 PL/SQL: SQL Statement ignored

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