OZF_RESALE_HEADERS_ALL_DRT_V Is Invalid Because Of SECURITY_GROUP_ID

(Doc ID 2413083.1)

Last updated on JUNE 22, 2018

Applies to:

Oracle Trade Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Patch Application Issues

EBS_DRT_PKG is invalid because the REMOVE_TCS_PARTY procedure is invalid. That procedure is invalid because the OZF_RESALE_HEADERS_ALL_DRT_V is invalid

OZF_RESALE_HEADERS_ALL_DRT_V is invalid because it is looking for SECURITY_GROUP_ID column in the OZF_RESALE_HEADERS_ALL table, and it doesn't exist.

 
ERROR
-----------------------

Errors for PACKAGE BODY EBS_DRT_PKG:

LINE/COL ERROR
-------- -----------------------------------------------------------------
2709/6 PL/SQL: Statement ignored
2709/6 PLS-00905: object APPS.REMOVE_TCA_PARTY is invalid
2714/6 PL/SQL: Statement ignored
2714/6 PLS-00201: identifier 'REMOVE_FND_USER' must be declared
SQL>
SQL>
SQL> alter procedure REMOVE_TCA_PARTY compile;

Warning: Procedure altered with compilation errors.

SQL> show error
Errors for PROCEDURE REMOVE_TCA_PARTY:

LINE/COL ERROR
-------- -----------------------------------------------------------------
1028/1 PL/SQL: SQL Statement ignored
1028/8 PL/SQL: ORA-04063: view "APPS.OZF_RESALE_HEADERS_ALL_DRT_V" has
  errors



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Follow Oracle E-Business Suite Person Data Removal Tool (PDRT) Release Notes (Doc ID 2388237.1)


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