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 FEBRUARY 08, 2019

Applies to:

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'.

Cause

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