My Oracle Support Banner

EAR 9.2: After Applying 9.2.31 There Are SQLs In SQL-06 Audit For AE's SQL No Longer Associated To The AE (Doc ID 2550566.1)

Last updated on DECEMBER 26, 2019

Applies to:

PeopleSoft Enterprise FIN Receivables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

On : 9.2 PUM 31 version, Upgrade

ACTUAL BEHAVIOR
---------------
After applying 9.2.31 to our TST instance there are SQLs in SQL-06 Audit for AE's SQL no longer associated to the AE. When we applied the same to our DEV instance these SQL objects were removed. I can't find anything in the project that would have deleted these SQL objects, so is there another method in change assistant that would have removed these SQL objects?

AR_AUTOMNT CURRENCYCONVERT S
AR_EMAIL_ADVPMTLOOP Step01 H
AR_PGG_SERV MNTRATE MNTIP H
AR_REV_EST MASSAGE BUDGETDTH
EOCM_Q_APRVEMAIN UPDTPVERS
IN_ITMCHANGEData_srcStep02 S


EXPECTED BEHAVIOR
-----------------------
There should not be any orphan objects after the upgrade.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.Apply PUM 31.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
There are orphan objects in system which takes disk space.

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.