Skip to main content

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

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

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!

 

Thank you both for this! 

Reply


Terms & ConditionsCookie settings