Package CSP_PART_SEARCH_PVT is Invalid After Applying CSP Patch 25312554

(Doc ID 2301631.1)

Last updated on AUGUST 30, 2017

Applies to:

Oracle Depot Repair - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

On 12.1.3 - Logistics Management

After applying the following patches, the below error occurs:

  . Patch 25554109:R12.CS.B - 12.1.3:BUG FIXES FOR CS:MAR'17 RUP
  . Patch 25242797:R12.CSD.B - ORACLE DEPOT REPAIR RECOMMENDED PATCH COLLECTION (16-FEB-17)
  . Patch 25312554:R12.CSP.B - INTERNAL SALES ORDER CREATED FROM PR HAS INCORRECT AMOUNT

ERROR
------------
The PACKAGE body APPS.CSP_PART_SEARCH_PVT did not compile successfully.
 
Warning: Package Body altered with compilation errors.
Errors for PACKAGE BODY APPS.CSP_PART_SEARCH_PVT:
 
LINE/COL ERROR
-------- -----------------------------------------------------------------
2331/7   PL/SQL: SQL Statement ignored
2342/14  PL/SQL: ORA-00904: "CCDT"."CALENDAR_ID": invalid identifier
2407/9   PL/SQL: Statement ignored
2407/12  PLS-00364: loop index variable 'CURS' use is invalid
2424/11  PL/SQL: Statement ignored

Changes

 

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