My Oracle Support Banner

E-DAM: 'Selective Restoring Queries' Not Working For 'Remove From History' - PSARCHIVE GENERATING INCORRECT SQL ON SELECTIVE RESTORE (Doc ID 2404390.1)

Last updated on MAY 29, 2018

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.55 and later
Information in this document applies to any platform.

Symptoms

ENVIRONMENT:
================
PeopleTools: 8.55.11
Application: FSCM 9.2 PUM 21 + a few fixes



ACTUAL BEHAVIOR
================
Non-base objects are not working as expected when using 'Selective Restoring Queries' for 'Remove from history'.
PSARCHIVE is generating incorrect SQL statements on Selective Restore.


EXPECTED BEHAVIOR
================
Non-base objects should work as expected when using 'Selective Restoring Queries' for 'Remove from history'.
PSARCHIVE should generate correct SQL statements on Selective Restore.


STEPS
================
The issue can be reproduced at will with the following steps:
1. Add multiple related Archive objects to an Archive Template
2. Use 'Selective Restoring Queries' for 'Remove from history'.
3. The above situation is encountered

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue customer cannot use 'Selective Restoring Queries' for 'Remove from history'.

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!

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