Package CSP_PARTS_REQUIREMENT Is Invalid When APPS Schema Is Not Used

(Doc ID 2344041.1)

Last updated on DECEMBER 29, 2017

Applies to:

Oracle Spares Management - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.5 version, Patch Application Issues

After applying Patch 26922549 Package CSP_PARTS_REQUIREMENT is invalid.

This patch provided these file versions:
CSP_PARTS_REQUIREMENT          cspvprqs.pls 120.9.12020000.7
CSP_PARTS_REQUIREMENT          cspvprqb.pls 120.19.12020000.20

ERROR
-----------------------
Errors for PACKAGE BODY CSP_PARTS_REQUIREMENT:

[Error] PLS-00201 (5122: 34): PLS-00201: identifier 'APPS.CSF_RESOURCE_PUB' must be declared
[Error] PLS-00320 (5149: 64): PLS-00320: the declaration of the type of this expression is incomplete or malformed
[Error] PLS-00320 (5156: 11): PLS-00320: the declaration of the type of this expression is incomplete or malformed
[Error] PLS-00201 (5223: 30): PLS-00201: identifier 'APPS.CSP_PART_SEARCH_PVT' must be declared
[Error] PLS-00201 (5224: 30): PLS-00201: identifier 'APPS.CSP_PART_SEARCH_PVT' must be declared
[Error] PLS-00320 (5293: 5): PLS-00320: the declaration of the type of this expression is incomplete or malformed
[


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Applied Patch 26922549

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