Question

Solution Manager and System Info blank

  • 31 March 2023
  • 3 replies
  • 88 views
T
Rank
Badge +3
  • Tim
  • Sidekick (Customer)
  • 9 replies

We don’t seem to be able to get System Info from IFS (APPS 9) or use the Debug tool, when in Admin-type screens - for instance Solution Manager > Security > Users > Create User

Is there  a way to “switch this on”?  It works in other screens.

 

As a by-product of this, does anyone know which table the Base Profile and Personal Profile is held?

 

Thanks in advance

3 replies

K
Rank
Userlevel 5
Badge +15

Hi

For ifswin window type System Info is not available.

Debug console is much powerful but You have to set Framwork option:

 

Profile tables:

FNDRR_CLIENT_PROFILE_VALUE_TAB

FNDRR_CLIENT_PROFILE_TAB

FNDRR_USER_CLIENT_PROFILE_TAB

Piotr --> https://www.linkedin.com/in/piotr-skowronek-8425aa6/
Charith Epitawatta
Rank
Userlevel 7
Badge +31

Hi @Tim,

System Info is not available for the screens under the Solution Manager because they are Feature Forms(normally these are the forms with address starting with "ifswin:" in the address bar). Due to their architecture, it is not possible to retrieve the information you see under System Info in other Application Forms(address starts with “:ifsapf:”). Therefore, this is a design limitation.

To answer your other question, data related to profiles are stored in following database tables.

  • FNDRR_USER_CLIENT_PROFILE_TAB
  • FNDRR_CLIENT_PROFILE_TAB
  • FNDRR_CLIENT_PROFILE_VALUE_TAB

In FNDRR_USER_CLIENT_PROFILE_TAB, you would ideally see 3 profiles per user and you can identify which is which using the value in ‘ORDINAL’    column. 

  • Ordinal 0 - current personal profile
  • Ordinal 1 - current base profile
  • Ordinal 9 - IFS Standard profile, which is assigned by the system the first time a user logs into the application. 

All available base profiles can be easily identified by running following SQL query on CLIENT_PROFILE view.

select * from CLIENT_PROFILE where owner is null;

 

Hope this helps!

 

Charith - https://charith.xyz
T
Rank
Badge +3

Thank you both for this! 

Reply


Terms & ConditionsCookie settings