Package Body CSM_PARTY_DOWNLOAD_PVT Invalid After Applying Recommended Patch Collection 2 (19030202)
(Doc ID 1984441.1)
Last updated on OCTOBER 13, 2022
Applies to:
Oracle Receivables - Version 12.1.3 and laterInformation 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
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 |
| References |