PeopleSoft Fluid - Components, Pages, Content Reference and Security

 

Oracle has rolled out PeopleSoft Fluid User Interface with People Tools 8.54 and improved many features over the period. 

When I was working on PeopleSoft PUM or release upgrade, I always wondered how can I get a list of delivered PeopleSoft fluid functionality and access it. So I did some research ended up with some discussions on Oracle community and Oracle Support which are as below.

1.  How to find out page if its classic or fluid
2.  E-FLUID: PT 8.56, How To Identify What All Pages Are Classic Plus Enabled? (Doc ID 2327561.1)
3. E-FLUID: How to Find a List of Fluid Enabled Pages in PeopleTools 8.54 and above? (Doc ID 2022878.1)

Based on this information, I have written below SQL's which can be used to identify fluid pages, components, content reference and security. 

Fluid Components: - 

 Fluid Pages: -

Fluid Content Reference: -

Fluid Component Security: -

Fluid Components without any Security: -

Fluid Components linked to Permission List but not role: -

Fluid Content references and Navigations: -