My Oracle Support Banner

Package CSP_PARTS_REQUIREMENT Is Invalid When APPS Schema Is Not Used (Doc ID 2344041.1)

Last updated on FEBRUARY 25, 2019

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

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.