My Oracle Support Banner

R12: Unable To Compile Package FV_FEDERAL_PAYMENT_FIELDS_PKG Due To Error "Component 'SPS_SDP' Must Be Declared" (Doc ID 2857130.1)

Last updated on APRIL 21, 2023

Applies to:

Oracle U.S. Federal Financials - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Issue

-------

After application of US Federal patch 31156678, the following package became invalid APPS.FV_FEDERAL_PAYMENT_FIELDS_PKG

While recompiling the package manually, receive below error

LINE/COL ERROR
-------- -----------------------------------------------------------------
641/2    PL/SQL: Statement ignored
641/117  PLS-00302: component 'SPS_SDP' must be declared

 

Steos to reproduce

------------------

  1. Apply the US Federal patch 31156678.
  2. Check the list of invalids
  3. Package FV_FEDERAL_PAYMENT_FIELDS_PKG appears to be invalid.

Changes

Patch 29335047 was applied recently

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.