E-FLUID: When Fluid Homepage is Deleted, Its Related Language Record Entry from the Table-PSPRUHTABLANG is Not Deleted (Doc ID 2894169.1)

Last updated on SEPTEMBER 05, 2022

Applies to:

Symptoms

When a fluid homepage is deleted, its related language data is not removed and leaving orphan rows in the table PSPRUHTABLANG. Data got deleted from table PSPRUHTAB but not from the table PSPRUHTABLANG.

The issue can be reproduced at will with the following steps:

1. Login with related language (FRA and base language is GER).
2. Go to fluid homepage and do personalize homepage.
3. Add a new homepage with label TEST and save it .
4. Run SQL query and note that rows exist for both base and related language tables.
 
select * from pspruhtab where portal_objname like 'USERDEFINED%' and portal_label = 'TEST';
select * from pspruhtablang where portal_objname like 'USERDEFINED%' and portal_label = 'TEST';

Both tables having one row each.

5. Now go back to personalize Homepage.
6. Select another homepage and delete TEST Homepage by clicking trash box icon and save.
7. Run again above SQL query and note that the base table PSPRUHTAB row has been removed, but the related language table PSPRUHTABLANG still contains a row for the deleted Home page - TEST.

Changes

 Upgraded to PT 8.59

Cause

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